SMS 2003 SQL 2005 Master Database restore, 2ndary MP not working correctly now

Hi, I had an issue on my SQL 2005 server which is local to the SMS
primary site server. I had to restore the Master database from a SQL
backup, ever since the restore my Secondary Site management points
cannot connect.

It is not IIS related and the secondary computer accounts are in the
SMS_SiteSystemToSQLConnection_site, I am pretty sure it is SQL
security related.

The site is in advanced security mode but the SQL server is now in
Mixed authentication mode.

I think what has happened is when I have restored the Master database
the security has got mixed up. Also the problem seems to be that
rather than the computer account being used to access the database, it
is trying to use NT AUTHORITY\ANONYMOUS LOGON. I can get this working
by granting NT AUTHORITY\ANONYMOUS LOGON sysadmin on the server but
this is obviously a security risk.

The SQL logs showed

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT:
ipaddress]
Error: 18456, Severity: 14, State: 16.

But as sysadmin I get

Login succeeded for user 'NT AUTHORITY\ANONYMOUS LOGON'. Connection:
trusted. [CLIENT: ipaddress]

However this should be authenticating as the secondary site computer
account.

Anyone any ideas?

.

Relevant Pages

  • Re: Restoring SharePoint Portal 2003 & SQL
    ... running with two WFE servers, one index and one SQL Server. ... re-assign the server roles, restore the shared services portals, then ... please use the backup and restore tool that ships with SPS03. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Migration ?
    ... Moving the Master and MSDB database, what if the old server where those ... Will a restore on the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: SBS Sharepoint (CompanyWeb) DR restore process
    ... If your site does not contain any custom web parts (which have to be installed on the new server) the move should be straight forward. ... Copy the backup file from the old server to the new. ... the process to perform a backup and restore of the sharepoint component of SBS. ... However, most of the documentation I've found refers to scenario's involving MSDE ONLY, and specifically mention the process is not identical for scenario's where full SQL is installed. ...
    (microsoft.public.windows.server.sbs)
  • SPS 2003 Restore with SQL 2005
    ... Currently we are trying out the backup and restore procedure. ... "SQL Server restore failed. ... 00000E5C Connected to SQL Server ABCSPSDC ... 000131A3 UNK ...
    (microsoft.public.sharepoint.portalserver)
  • Re: SQL 2000 server TCP bind problem
    ... If so then some other service grabbed port 1433 before SQL ... Server did. ... You can restore a backup of the master database if needed. ... There is also a utility to rebuild the master database ...
    (microsoft.public.sqlserver.connect)