|
|
Configuring SQL 2005 to Accept Remote Connections
-
Open the SQL Server Configuration Manager.
-
If SQL Server Browser has a red square next to it, then you will need to change it to start automatically. Right click on "SQL Server Browser".
-
Select the "Service" tab, then make sure that "Start Mode" is set to "Automatic".
-
Click to apply this change and OK until you get back to the Configuration Manager.
-
Expand "SQL Server 2005 Network Configuration" and then select "Protocols for SQLEXPRESS".
-
Make sure that all protocols are enabled, if they are not, right-click and select enable.
-
Restart your server and sql browser to finish.
Created by
cj
Last modified
2006-09-28 04:00 PM
|
