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.
|
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.
|
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'.
|
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.
|