Enable remote access to Microsoft SQL Desktop Engine 2000
Tuesday, 26 August 2008

If you use Microsoft SQL Server Desktop Engine 2000 for any projects, which is free and comes with the most important features of SQL Server like views, stored procedures, backup etc. - there are some limitations in terms of performance when there are many parallel queries but that is not a problem for small projects.

The only thing that is annoying is that by default it cannot be administered from remote.

Here's how to enable remote access and administration of MSDE:

Click Start, Run

Enter svrnetcn.exe too run the "SQL Server Network Utility"

Select "TCP/IP" from the Disabled protocols and click "Enable >>“ (as below):

Active Image

 

Or if you prefer to do it by editing the registry directly, import these registry settings:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib]
"ProtocolList"=hex(7):74,00,63,00,70,00,00,00,00,00



[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp]
"TcpHideFlag"=dword:00000000
"TcpDynamicPorts"=""
"TcpPort"="1433"

You can now access MSDE remotely with SQL Server Enterprise Manager, Microsoft Access or one of the free tools like MSDE Query Tool

 

 
< Prev   Next >
Advertisement
© d-PIT, 2007-2010.

Site Disclaimer