Registering
Servers - SQL Server 2000 MSDE (Desktop Edition)
Configuring MSDE and connecting with Aqua Data Studio.
Connecting to SQL Server 2000 MSDE with Aqua Data Studio requires
that you have remote connections enabled accepting TCP/IP
connections. Once you have TCP/IP network connections enabled, you
can connect to SQL Server MSDE using the hostname and instance name
in the Host: parameter. |
1. Installing
MSDE with Network Connections enabled: First step is to
install MSDE with network connections enabled. By default, MSDE is
installed with network connections disabled. To install MSDE with
with network connections, you must run the setup.exe from the
command prompt and specifying the DISABLENETWORKPROTOCOLS=0. As
described in the MSDE installation docs ...
Setup Parameters
Installation docs:
MSDE Installation Instructions |
|
MSDE
SupeSocketNetLib Registry
MSDE TCP
Registry
2. Verifing TCP/IP Remote Connections: To verify that your
MSDE installation has remote connections enabled you may run
"regedit" to view your registry settings. Verify the following keys
...
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\
MSDE\MSSQLServer\SuperSocketNetLib\ProtocolList=[tcp np]
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\
MSDE\MSSQLServer\SuperSocketNetLib\Tcp\TcpPort=[Port]
|
|
Registration
- SQL Server
3. Register Connections: Now, register a server
connection in Aqua Data Studio using
’Hostname\SQLEXPRESS’ as the hostname parameter, where
Hostname is the hostname or ip address of the SQL Server and
SQLEXPRESS is the instance name.
|
