Wednesday, March 7, 2012

Registry for SQL Server Express Instance

I notice that the following registries:
HKLM\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.2\MSSQLServer\SuperSocketNeLib
HKLM\SOFTWARE\Microsoft\Microsoft SQL
Server\SQLEXPRESS\MSSQLServer\SuperSocke
tNeLib
They seem to be for the same instance. But the first one has very detail
information which match what you will see the SQL Server Configuration
Manager. What is the purpose for having 2 registry for the same instance?Did you make sure that this is for the same instance ? I think this is from
another instance running on your computer. Do you only have SQL Server
Express installed or any other instances running ? Did you try to change a
value in the supersocket area, like the listened port to see if it will be
also reflected in the other area ? Also make sure if the TCP settings do not
differ, because a port can only be aquired by ONE service at a time.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
--
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:02B46A81-22E7-4DAA-9FC1-7FA978C027FE@.microsoft.com...
>I notice that the following registries:
> HKLM\SOFTWARE\Microsoft\Microsoft SQL
> Server\MSSQL.2\MSSQLServer\SuperSocketNeLib
> HKLM\SOFTWARE\Microsoft\Microsoft SQL
> Server\SQLEXPRESS\MSSQLServer\SuperSocke
tNeLib
> They seem to be for the same instance. But the first one has very detail
> information which match what you will see the SQL Server Configuration
> Manager. What is the purpose for having 2 registry for the same
> instance?
>

No comments:

Post a Comment