Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lynn Furlong
Starting Member
2 Posts |
 Posted - 2011-09-23 : 07:44:58
|
| I use SQL Server Management Studio to connect to a SQL 2005 database from my PC, but now I get the following error messageLogin failed for user ", The user is not associated with a trusetd SQL server connection Error 18452I got this message the other day and restarted the server and all was ok, but this has not fixed the issue today.If I log onto a different PC with my windows credentials, I have no problem accessing the database. If I log on to my PC with another users credentials, I cannot access the database. This means it is my PC that has the issue. So I deleted the ODBC connection with the intention of re-creating it but when I try to do so I get the following errorSQL State: 28000SQL Server error: 18452Login failed for user ", The user is not associated with a trusetd SQL server connection Error 18452It seems the link from my PC to the database is messed up somehow but I have no idea why or how. No changes have been made to my PC or the server recently. Has anyone come across this issue before? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-23 : 07:47:04
|
| Using a system DSN or user DSN? |
 |
|
|
Lynn Furlong
Starting Member
2 Posts |
Posted - 2011-09-27 : 08:16:30
|
| I was using a System DSN. This turned out to be a Group Policy setting which effected my connection to the SQL server |
|
|
|
|
|
|
ODBC - Login failed for user "