|
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): 
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
|