Data World

SQL Server 2005 -Trouble Shooting Client To Server Connection

Posted by Pramod Singla on February 23, 2012


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

Advertisements

One Response to “SQL Server 2005 -Trouble Shooting Client To Server Connection”

  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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: