September 11, 2014 at 2:45 pm
Hi,
I have one SQL 2012 in one box and the another Sql2008 in another box. I need to create linked server from 2012 to 2008.
Exec master.dbo.sp_addlinkedser @server='2008server', @srvproduct='sql server'
exec master.dbo.sp_addlinkedsrvlogin @rmtsrvname='2008server',
@useself='true', @locallogin=null, @rmtuser=null, @rmtpassword=null.
I do have admin right on both Sql 2008 & Sql 2012.
The linked server is created but when I am testing the linked server, I am getting the error message
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' (Error 18456)
Any ideas please.
Thanks
September 11, 2014 at 2:53 pm
'NT AUTHORITY\ANONYMOUS LOGON' -- Sounds like SPN issue. Did you checked SPN registrations on both the Instances?
September 11, 2014 at 3:21 pm
Please let me know how to check? I read some posts but not clear about that.
September 11, 2014 at 3:26 pm
Should be in Error logs whether SPN has been registered successfully or not. SQL Server will attempt to register SPN each time it starts and records the status in error log...
September 11, 2014 at 3:41 pm
I didn't see any errors under sql server error log
September 11, 2014 at 3:58 pm
Well, It's not an error. It is an Informational Message which will appear during the server startup, not at the time when you are testing your Linked Server.
Try this....open your error log(s) and filter events by "SPN". It should display those entries...
September 12, 2014 at 7:23 am
Yes the spn will fail to register automatically if you are using a domain account for the sql service account and have not explicitly granted it permissions to create SPN. SQL server 2012 best practice is to run the sql service account as a virtual account ie NT SERVICE account. This account does have permissions to register an spn.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply