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 |
|
mbean
Starting Member
3 Posts |
 Posted - 2010-11-03 : 16:41:09
|
| I just recently migrated one of our production databases from SQL 2000 to SQL 2008 R2 (server b). I transferred all of my logins & passwords from the old instance of SQL 2000 to the new instance of SQL 2008.We have an application that runs from server a, that pulls data from our production server b (the new 2008 server), to yet another server, server c. I am getting the following error on the new server b: Error: 18456, Severity: 14, State: 38.Login failed for user 'domain\username'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]Authentication is working between server a and server c but fails on server b. I have tried to create a new user on the new server but it fails with the same error as well.I have verified that the user account on server b has a default database set to one that the user account has rights to.I am at a loss! Help!Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-11-03 : 17:45:48
|
| find out which database it is trying to connect to, make sure that the login used is mapped to user with permissions on specified db |
 |
|
|
mbean
Starting Member
3 Posts |
Posted - 2010-11-04 : 10:41:19
|
| I have verified which database it is trying to access and the login is mapped to that database with proper permissions. I have also tried deleting the user login and recreating it; I have tried creating & using another network user login; I have tried creating & using a SQL login and all get the same error message. I have tried re-registering using setspn as well and still get the same error message.I am still at a loss as to what is going on.Thanks. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
|
|
mbean
Starting Member
3 Posts |
Posted - 2010-11-04 : 13:39:04
|
| I used the following to transfer my logins:http://support.microsoft.com/kb/246133/ |
|
|
|
|
|
|
Failed to open the explicitly specified database