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 |
|
Kev01
Starting Member
3 Posts |
 Posted - 2011-02-18 : 04:46:42
|
| Hi, I'm getting a “cannot connect to ‘server’ – login failed for user ...….” error message. I'm trying to connect to the default instance of sql server. The error log is stating: 2011-02-18 09:04:53.46 Logon Error: 18456, Severity: 14, State: 38.2011-02-18 09:04:53.46 Logon Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]But this is with windows authentication. I should be able to login should'nt I. I'm stumped, any help would be welcome!It's SQL server 2008 hosted on a 2008 r2 server...Thanks.... |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-02-18 : 06:48:23
|
| Looks like the the default database associated with your login is missing.Is there any other user login by which you can login into the server and checked whether the your default database is present ?PBUH |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-02-18 : 10:50:57
|
| change default database to master and try again. |
|
|
|
Kev01
Starting Member
3 Posts |
Posted - 2011-02-18 : 17:40:19
|
| The person who setup this SQL server is no longer around so can't get anyone to login to check the default database...but i'm fairly sure db have been deleted from this server...@Peter, this may be a simple question but how do i change the default db to master??Thanks! |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-02-18 : 20:28:56
|
| If you select the options on the connection dialog box in SSMS - you have the option to select the database you want to log into. Try that and see if you can get logged into the system.Once logged in, if you have the necessary rights on the server you can change your default database. If you do not have the necessary rights, you will need to find someone who has sysadmin rights to change it for you.Jeff |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-02-19 : 01:56:54
|
| Just go and check physically whether the data files are present .PBUH |
|
|
|
Kev01
Starting Member
3 Posts |
Posted - 2011-02-21 : 09:10:27
|
| tried to use the browse function in options to select the db however it tried to connect to the server to allow me to select the db..I physically checked to see if the db files are present, they are. Anything else I can try, thanks for the support so far! |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-02-21 : 15:45:54
|
| Don't use the Browse option - just type in the database you want to use. |
|
|
|
|
|
|
cannot connect to ‘server’ – login failed for user