My SQL Server's instance name is SQLEXPRESS and SQL Server Service Name looks like MSSQL$SQLEXPRESS. Is there any relation between instance name and service name? I'm trying to check SQL Server Service Status by name and I wonder can SQL Server Service name be different on another computers?
SQL Server – Relation Between Service Name and Instance Name
sql-server-2008
Related Solutions
first you must identify the spid
look up
sp_who2 'active' ---> look for the spesific session_id
SELECT * FROM sys.dm_exec_sessions WHERE session_id = 60 SELECT command,percent_complete FROM sys.dm_exec_requests WHERE session_id = 60
There is no way to change the instance name without re-installing, sorry.....
Update: OK, seems there are a few ways of doing this - not sure how well these work, though. I have not ever heard of anyone doing this successfully, though :-( The easiest way to do this is re-installing with the correct name. Especially with the SQL Server Express versions, it's really no big deal to reinstall - done in a breeze, and you can of course backup and restore your data - so no loss there, either....
Also, it seems that method is limited to SQL Server 2000 only - when searching for the appropriate topics for SQL Server 2008 (sp_dropserver, sp_addserver), it seems those are used for renaming a server (computer) to a new name - not changing the SQL Server instance name, in my opinion. There's no more mention of renaming an installed SQL Server instance with that method.
Best Answer
Yes, the service name is always
MSSQL$<Instance Name>for a named instance andMSSQLSERVERfor a default instance. I don't believe either can be altered or overridden, nor can I think of any reason why you'd want to.You can enumerate the installed instances on a server via the registry, using Powershell for example: