SQL Server 2005 -Trouble Shooting Client To Server Connection

Applies on :  SQL Server 2005 and above

Tested on : SQL Server 2005

1). Check Server Property:

1.1 Right Click On Server—>Properties—>Connections—>Select Allow remote Connections to

Server

If Problem Still Exists Then

1.2 Right Click on Server–>Properties–>Security–>Select SQL Server and Windows

Authentication Mode.

2). Security:

Check the Login (Server level Permission) and User (Database Level Permission)  Access.

3). SQL Server Configuration:

3.1  Click on Start–>All Programs–>SQL Server 2005 –> Configuration Tools–> Select

SQL Server  Configuration Manager–>Check for Services running and for SQL Browser running.

3.2  Click on Start–>All Programs–>SQL Server 2005 –> Configuration Tools–> Select

SQL Server  Configuration Manager–>Select SQL Server Network Configuration

–>Click on Protocols. For Instance:-

* TCP/IP — Enabled

* IP Address — Server Address

* TCP/IP Port — 1433

4). Firewall Configuration:

Run Firewall. Cpl–>Click on Exception Tab

4.1 Add SQL Server Port

Click on Add Port–>Add Name as SQL Server–>Add Port as 1433

 4.2 Add SQL Server Program

Click on Add Program–>  Browse C:\Program Files\Microsoft SQL

Server\90\Shared\sqlbrowser.exe

4.3 Add SQL Server Program

Click on Add Program–>Browse C:\Program Files\Microsoft SQL

Server\MSSQL\MSSQL\Bin\sqlservr.exe

One comment

  1. I’m still learning from you, as I’m making my way to the top as well. I certainly liked reading everything that is posted on your site.Keep the information coming. I liked it!

Leave a Reply

Your email address will not be published. Required fields are marked *