October 5, 2018 at 9:59 am
I installed 2017 on a new server yesterday and all was fine. Someone was kind enough to change the server name on me today and none of my tools will now work remotely. SSMS, Toad for SQL Server, Spotlight for SQL Server. Any suggestions?
October 5, 2018 at 10:13 am
keanyukas - Friday, October 5, 2018 9:59 AMI installed 2017 on a new server yesterday and all was fine. Someone was kind enough to change the server name on me today and none of my tools will now work remotely. SSMS, Toad for SQL Server, Spotlight for SQL Server. Any suggestions?
Change the connection info in your tools? Not really sure what you are looking for an answer here. The connection information changed, you have to change your connections.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 5, 2018 at 10:17 am
Did that already and did not work. I may uninstall and reinstall SQL
October 5, 2018 at 10:52 am
keanyukas - Friday, October 5, 2018 10:17 AMDid that already and did not work. I may uninstall and reinstall SQL
It needs to be updated in SQL Server. You need to execute the following after renaming a server and restart the service after the change: sp_dropserver 'old_name'
go
sp_addserver 'new_name', 'local'
go
Sue
October 5, 2018 at 11:04 am
awesome thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply