Registering Servers - SQL Server Express 2005
Configuring SQL Express and connecting with
Aqua Data Studio.
Connecting to SQL Server Express 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 Express using
the hostname and instance name in the Host: parameter.
|
SQL Server Express Surface Area
1. Launching 'SQL Server Surface Area Configuration' tool: First step is to launch the SQL Server surface area configuration tool
that is installed with SQL Server Express.
|
Remote Surface Area Configuration
2. Configuring TCP/IP Remote Connections: Select 'Surface Area Configuration and Services and Connections' option
and then select 'Remote Connections' in the tree browser. Choose the 'Using TCP/IP Only' or 'Using both TCP/IP and named pipes',
the click on 'Ok' or 'Apply'.
|
 Register 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.
|
