August 13, 2019 at 2:47 am
I think my original login was DESKTOP-8J18OSS\micha which appears in the folder Security > Logins. Then I changed the computer name to Virginia. The top most value of the Object Explorer says:
VIRGINIA\SQLEXPRESS2017 (SQL Server 14.0.2027 - VIRGINIA\Michael)
Isn’t VIRGINIA\Michael the login name? If so why doesn’t it appear in the Security > Logins folder?
Under the properties window I noticed that the connection is named VIRGINIA\Michael.
What is the value VIRGINIA\Michael? Is it a login or a connection or both?
August 13, 2019 at 2:53 am
This was removed by the editor as SPAM
August 13, 2019 at 2:13 pm
August 14, 2019 at 12:22 am
It is the login used by the connection to the instance. Renaming computers with SQL installed can require multiple steps to ensure that SQL is "synched" with the name change.
Interesting. I didn't know that a connection itself would need to use a login. Thank you for the info.
August 21, 2019 at 7:57 pm
If you haven't already done so, you may want to read through this and follow any instructions: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/rename-a-computer-that-hosts-a-stand-alone-instance-of-sql-server?view=sql-server-2017
August 31, 2019 at 12:47 am
Blake,
I started reading that link.
sp_dropserver <old_name\instancename>;
GO
sp_addserver <new_name\instancename>, local;
GO
I just have a few issues.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply