September 13, 2011 at 6:40 am
I renamed a SQL 2008 server from like sql2 to sql. The old box went from sql to sqlold. I dropped the servername and readded. So, @@servername looks ok now. I'm trying to track down what service might need fixing.
SourceLogon
Message
Login failed for user 'my_DOMAIN\sqlold$'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 192.168.1.5]
Message
Error: 18456, Severity: 14, State: 11.
sqlold is the old servername, but the ip is actually the new servers ip. So, is the login occuring from the new machine or the old machine?
Also, any ideas how I can figure out what service it is that's trying to login?
September 13, 2011 at 5:26 pm
Did you use the following method..
EXEC sp_dropserver '<old_name>'
GO
EXEC sp_addserver '<new_name>', 'local'
GO
To find those details run a brief profiler trace to find the machine from which it is coming and its user ID or use the activity monitor.
Thank You,
Best Regards,
SQLBuddy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply