November 16, 2009 at 2:46 pm
Guys,
I see the following error in the event viewer and sql server logs every min
Login failed for user 'NT-DOMAIN\services'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]
This is to the master database.
SQL runs under NT-DOMAIN\services.
I was able to login into SSMS with the 'NT-DOMAIN\services' and query the master database without any issue. I am not sure why I am seeing this errors in the event viewer and sql logs.
Any suggestions/inputs would help.
Thanks
November 16, 2009 at 4:26 pm
am-244616 (11/16/2009)
Guys,I see the following error in the event viewer and sql server logs every min
Login failed for user 'NT-DOMAIN\services'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]
This is to the master database.
SQL runs under NT-DOMAIN\services.
I was able to login into SSMS with the 'NT-DOMAIN\services' and query the master database without any issue. I am not sure why I am seeing this errors in the event viewer and sql logs.
Any suggestions/inputs would help.
Thanks
Is master database set as default for this login?
November 16, 2009 at 4:58 pm
AlexSQLForums (11/16/2009)
am-244616 (11/16/2009)
Guys,I see the following error in the event viewer and sql server logs every min
Login failed for user 'NT-DOMAIN\services'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]
This is to the master database.
SQL runs under NT-DOMAIN\services.
I was able to login into SSMS with the 'NT-DOMAIN\services' and query the master database without any issue. I am not sure why I am seeing this errors in the event viewer and sql logs.
Any suggestions/inputs would help.
Thanks
Is master database set as default for this login?
This is sometimes related to vendor software that comes with an instance connecting to that instance through the Master and in some cases running some code in the Master. You may need to call the vendor to send you new config file and making manual changes to connection information.
Kind regards,
Gift Peddie
November 16, 2009 at 8:49 pm
Master database is the default database for this login.
November 16, 2009 at 9:19 pm
am-244616 (11/16/2009)
Master database is the default database for this login.
The Master database is one of the system databases there should be no default login to it because system admin role can access it to do all that is needed to keep the system running.
Kind regards,
Gift Peddie
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply