March 15, 2022 at 5:04 pm
I am running SQL 2019 on Windows 2019 server and have come across an issue I have not seen before and cannot find a resolution on the web. I have went through the normal process of changing the Instance name by using the following..
EXEC sp_dropserver '<old_name\instancename>';
GO
EXEC sp_addserver '<new_name\instancename>', local;
GO
I rebooted the server afterward but I have to use the original instance name to actually connect but if I run
Select @@servername it returns the new instance name.. It acts like Windows Server 2019 is blocking the final piece the name change. Anybody seen this and have a fix?
Thanks
Rich
March 16, 2022 at 1:02 pm
I found my answer on this. Thanks
March 16, 2022 at 4:18 pm
I found my answer on this. Thanks
Would you mind sharing what you found to be the answer, please?
--Jeff Moden
Change is inevitable... Change for the better is not.
March 17, 2022 at 7:19 am
Posting your solution would be very much appreciated.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy