Post reply

Can't connect from SQL Server A to SQL Server B after a password change

  • June 14, 2010 at 9:29 am

    #225605

    A domain administrator account's password has been changed in our environment. Since then, I cannot connect from SQL Server A to SQL Server B through SSMS using Windows Authentication while logged on as the domain administrator in which the password was changed.

    Both Server A and Server B have the Server Authentication set to "SQL Server and Windows Authentication mode."

    When trying to connect in SSMS, I get the message "Login failed for user ''. The user is not associated with a trusted SQL Server connection, (Microsoft SQL Server, Error: 18452).

    **It is interesting the user is listed as '' rather than the domain account.

    I can connect from Server A to Server B using SQL Server Authentication.

    Any help please?

    Thanks

  • June 17, 2010 at 11:51 am

    #1181763

    We had this issue on some of our SQL Server 2000 servers when the service accounts were change. we had to run setspn to fix the service priniciple name. Here is the link we used.

    http://msdn.microsoft.com/en-us/library/aa905162(SQL.80).aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply