11 reputation
2
bio website
location
age
visits member for 4 years, 11 months
seen Jan 14 '10 at 20:10

May
30
awarded  Popular Question
May
24
awarded  Student
Jan
14
comment Can not access SQLServer database
When I access the database, I get a "Can not generate SSPI context" error and up pops the Login dialog. I have to manually uncheck the "Use Trusted Connection" dialog, then enter the username and password for the SQL Server login. The query or whatever I'm doing then goes through. Unfortunately, the next time I do something like run a query, I have to go through the same process again. Is there no way to cache the credentials or something? Having to reenter your username/password every time you do something is not going to work.
Jan
14
comment Can not access SQLServer database
Well, I've made progress. I tracked down the logs and the error codes for the failed logins, which turned out to be "invalid user." I had added the windows login to the database and given it permissions, which allowed a locally logged in user to access the database. But logging in remotely, I was apparently unable to authenticate through the Windows login. I added a new login to SQL Server and am now able to access the database remotely - sort of. See next comment.
Jan
14
asked Can not access SQLServer database