SQL 2008 Remote

SQL Server 2008 Remote Connections

Saturday, April 16th, 2011

Before connecting BizproEZ Business Software to a host version of SQL Server 2008, you must allow remote connections to SQL Server 2008.

1. Open: Start -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager

2. Right click SQL Server Browser (on the right) and select Properties
5

3. Local Services should be selected from the list under the tab Log On
6

3. Click the Services tab and change the Start Mode to Automatic then click OK
7

4. Right click SQL Server Browser and select Start
8

5. Under SQL Server Network Configuration, select Protocols for SQL Express (notice: you may have to click the arrow to expand the SQL Server Network Configuration)
9

6. Right click TCP/IP and select Enable10

Return to setup