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
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!