Is it possible to change Instance Name of a SQL server after its being installed?????
Database
2
Posts
2
Posters
0
Views
1
Watching
-
if yes then tell me the procedure to change it?? Thanks in advance.
-
if yes then tell me the procedure to change it?? Thanks in advance.
First collect the current SQL Server instance name select @@servername Execute the below queries to change the SQL Server instance name sp_dropserver ‘old_name’ go sp_addserver ‘new_name’,‘local’ go Restart the SQL Server service, to run the below commands: net stop mssqlserver net start mssqlserver