Change name of SQL Server's Service
I already have SQLServerPro 2008. I just installed SQL Server 2008 R2 with
instance name sqlserverr2. Now, I want to change the name of the service
also. I could change name of the server.
select @@SERVICENAME, @@SERVERNAME
It outputs -
SQLEXPRESSR2, HOME\SQLEXPRESS
Means service name is not changed. Only servername changed. Even I cannot
use .\sqlexpress to connect from Managment Studio.
No comments:
Post a Comment