May 5, 2004 at 6:23 pm
Hi All,
I seem to have authentication troubles since the application of the sasser patch. The problem seems to be limited only to Windows Authentication and not SQL authentication. The problem has appeared this morning since the application of the patch on our SQL server. Error message is:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
Has anyone experienced this problem?
Regards,
Terry
May 6, 2004 at 5:06 pm
Seems to have come good this morning???
May 7, 2004 at 2:53 am
Hi
The error you are getting is due to the service account not been a member of the domain.and also need to have local admin access to the serverit self
Pls check that the account is not running uning under local system
Also pls check that the 'sa' has ben set in the sql server agent connection tab
cheers
ayoc
May 10, 2004 at 12:58 pm
Make sure that your Windows NT users and groups (both local and global groups) are incorporated into SQL Server as logins. By themselves, Windows users and groups do not normally have authentication rights to SQL Server. The server’s system administrator has to explicitly identify those Windows NT users and groups within SQL Server to give them authentication and thus the ability to login. However, NT users and groups do not require passwords. Instead SQL Server relies on Windows NT’s password validation.
Regards
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply