April 10, 2014 at 5:44 am
Hi
I´m getting this error in the SQL Server log and can´t find out how to fix it....
Error: 18456, Severity: 14, State: 38.
Login failed for user 'Domain\SERVER$'. Reason: Failed to open the explicitly specified database 'TempDB'.
The SERVER$ is the name of the SQL server...
I´m running SQL server ver 11.0.3401 on a Windows server 2012 R2
I have added the server account to the SQL server but to no help.
Removed the account from the database and added it again - no change...
Made the account dbo on the database - no change ...
Is there anything else that is causing the error and not the server account ??
With regards
Jonas
April 10, 2014 at 6:18 am
Other things are working fine? If server is not starting post the complete error log from start so that someone can help.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 10, 2014 at 6:20 am
Also confirm what is the status of login 'NT AUTHORITY\SYSTEM'?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 10, 2014 at 6:44 am
free_mascot (4/10/2014)
Also confirm what is the status of login 'NT AUTHORITY\SYSTEM'?
Hi
Added 'NT AUTHORITY\SYSTEM' login to the database and it seems to have fixed the problem !!:-D
Thank You !!
It would have been nice if it could said that in the error rmessage 🙂
/Jonas
April 10, 2014 at 7:08 am
Great!!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply