Enable remote connection of Microsoft Sql Express database server.

Configuration for remote connection of SQL Server(in this example database server instance name is SQLEXPRESS )

Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area configuration.

 

 

 

On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.

 

On the Surface Area Configuration for Services and Connections page, expand Database Engine. click Remote Connections.

click Local and remote connections, click the  Using both TCP/IP and named pipes, and then click Apply.

 

Note Click OK when you receive the following message:

Changes to Connection Settings will not take effect until you restart the Database Engine service 

 

 

 

 

1. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.

 

 

On the Surface Area Configuration for Services and Connections page, click SQL Server Browser, click Automatic for Startup type, and then click Apply.

 

Create exceptions in Windows Firewall

Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manage

 

In SQL Server Configuration Manager, click the SQL Server (MYSENIORCENTER) service in the right pane, right-click the instance name in the main window, and then click Properties

On the SQL Server (MYSENIORCENTER) Properties page, click the Service tab, locate the binary path, and then click OK

 

 

On the SQL Server Browser Properties page, click the Service tab, locate the binary path, and then click OK 

 

Open windows Firewall from Control Panel

 

Click on add program

Do the following process

 

 

Creating ODBC data source on Windows XP System