November 16, 2017 at 10:12 am
We recently migrated a 2008 sql server to a 2012 server using 2012 windows. Now when I select the properties of a user login under securables, the old server name is still present. I created a new test logon and it has the same issue. Can someone help?
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
November 16, 2017 at 10:37 am
fizzleme - Thursday, November 16, 2017 10:12 AMWe recently migrated a 2008 sql server to a 2012 server using 2012 windows. Now when I select the properties of a user login under securables, the old server name is still present. I created a new test logon and it has the same issue. Can someone help?
Not sure where you are seeing this - maybe on the Connection Info on the bottom left? Was the old server renamed to become the new server?
If you execute: SELECT @@SERVERNAME
and it displays the old name then you likely need to rename the SQL Server server name that is stored in SQL Server. You can double check to make sure it's using the old name using: SELECT name
FROM sys.servers
WHERE server_id = 0
You can change to the new name using: sp_dropserver 'old_name'
go
sp_addserver 'new_name', 'local'
go
Sue
November 16, 2017 at 10:44 am
I can't believe it. The old server name is still present. But the new server name is present when connecting. Confusing. Nice to get this resolved.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply