I've been using NT authentication to access my MSDE without any problem, but when I try to login using an account with SQL Server username and password it returns
"Login failed for user 'testuser'. Reason: Not associated with a trusted SQL Server Connection."
I tried with Visual Studio, Query Analyzer and ODBC, they all return the same error.
Is this a limitation of MSDE or are there configurations that I'm not aware of?
Thanks!
WillIndeed, you should make sure MSDE is installed the right way to allow it to use SQL authentication as well. Just take a look at theMSDE website to find out more about how to configure and install it in the right way. The limitations are listed on this website as well...|||Maybe the next URL can be of interest as well:
http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1.
It describes how to setup MSDE in mixed mode (both Windows and SQL authentication).|||The only thing that was left out in the above link is that the username is sa. It took me a while to figure that one out :-)
Is there a way to add other users?
No comments:
Post a Comment