GivenRandy
asked on
Login failed for user 'Randy'. Reason: Not associated with a trusted SQL Server connection.
I have an account Randy with administrative rights. I am using MSDE, not a full-blown version. I have created databases and accessed, or so I thought. Now, I get the error message:
Login failed for user 'Randy'. Reason: Not associated with a trusted SQL Server connection.
My quick search returned some fixes for the full-blown version, but not mine, unless I am missing something.
Login failed for user 'Randy'. Reason: Not associated with a trusted SQL Server connection.
My quick search returned some fixes for the full-blown version, but not mine, unless I am missing something.
...doh! i just realized that i browsed to vb.net from asp.net, and this may not be an asp.net app! sry 'bout that! just the same, if this ISN'T an asp.net app, ensure that the accessing account has rights to the database, and then post your connection string if you're still having troubles.
Hi GivenRandy:
When you say you ahve an account Randy with admin rights, is that Windows integrated rights, or SQL rights?
I had a similar case (SQL admin rights in MSDE), and the reason for the error was that the authentication in MSDE was set to Windows only, (not mixed SQL and Windows)
Dabas
When you say you ahve an account Randy with admin rights, is that Windows integrated rights, or SQL rights?
I had a similar case (SQL admin rights in MSDE), and the reason for the error was that the authentication in MSDE was set to Windows only, (not mixed SQL and Windows)
Dabas
ASKER
That's what I figured from my search results, but I cannot find where to change it in MSDE.
ASKER
As I suspected, since I couldn't find it in my MSDE, the Enterprise Manager is not there (MS page says "Because MSDE 2000 does not include SQL Server Enterprise Manager, you must administer and manage replication by using custom programs").
GivenRandy:
At the time I did an EE search and found a utility that works with MSDE and allowed me to change the setting. The utility has a timebombed freeware period, so it was good enough to me.
Unfortunately that was at work, and now I am at home....
Dabas
At the time I did an EE search and found a utility that works with MSDE and allowed me to change the setting. The utility has a timebombed freeware period, so it was good enough to me.
Unfortunately that was at work, and now I am at home....
Dabas
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, the problem was the authentication mode and that link provided the solution (changing to Mixed Mode after MSDE was already installed). Points to you and also to Dabas for heading me in that direction. Thanks!
http://support.microsoft.com/default.aspx?scid=kb;en-us;872905
...if you have given the appropriate permissions to the aspnet account, then please post your connection string.