{"id":115,"date":"2012-02-23T11:24:59","date_gmt":"2012-02-23T05:54:59","guid":{"rendered":"http:\/\/pramodsingla.wordpress.com\/?p=115"},"modified":"2012-02-23T11:24:59","modified_gmt":"2012-02-23T05:54:59","slug":"sql-server-2005-trouble-shooting-client-to-server-connection","status":"publish","type":"post","link":"https:\/\/pramodsingla.com\/?p=115","title":{"rendered":"SQL Server 2005 -Trouble Shooting Client To Server Connection"},"content":{"rendered":"

Applies on<\/span><\/strong> : \u00a0SQL Server 2005 and above<\/p>\n

Tested on<\/span><\/strong> : SQL Server 2005<\/p>\n

1). Check Server Property:<\/strong><\/span><\/h4>\n

1.1<\/strong> Right Click On Server—>Properties—>Connections—>Select Allow remote Connections to<\/p>\n

Server<\/p>\n

If Problem Still Exists Then<\/p>\n

1.2\u00a0<\/strong>Right Click on Server–>Properties–>Security–>Select SQL Server and Windows<\/p>\n

Authentication\u00a0Mode.<\/p>\n

2).<\/strong> Security:<\/strong><\/span><\/h4>\n

Check the Login (Server level Permission) and User (Database Level Permission)\u00a0\u00a0Access.<\/p>\n

3).<\/strong> SQL Server Configuration:<\/strong><\/span><\/h4>\n

3.1<\/strong> \u00a0Click on Start–>All Programs–>SQL Server 2005 –> Configuration Tools–> Select<\/p>\n

SQL Server\u00a0\u00a0Configuration Manager–>Check for Services running and for SQL Browser running.<\/p>\n

3.2<\/strong> \u00a0Click on Start–>All Programs–>SQL Server 2005 –> Configuration Tools–> Select<\/p>\n

SQL Server\u00a0\u00a0Configuration Manager–>Select SQL Server Network Configuration<\/p>\n

–>Click on\u00a0Protocols. For Instance:-<\/p>\n

*<\/strong> TCP\/IP — Enabled<\/p>\n

*<\/strong> IP Address — Server Address<\/p>\n

*<\/strong> TCP\/IP Port — 1433<\/p>\n

4). Firewall Configuration:<\/strong><\/span><\/h4>\n

Run Firewall. Cpl–>Click on Exception Tab<\/p>\n

4.1\u00a0<\/strong>Add SQL Server Port<\/p>\n

Click on Add Port–>Add Name as SQL Server–>Add Port as 1433<\/p>\n

\u00a04.2\u00a0<\/strong>Add SQL Server Program<\/p>\n

Click on Add Program–>\u00a0\u00a0Browse\u00a0C:\\Program Files\\Microsoft SQL<\/p>\n

Server\\90\\Shared\\sqlbrowser.exe<\/p>\n

4.3\u00a0<\/strong>Add SQL Server Program<\/p>\n

Click on Add Program–>Browse\u00a0C:\\Program Files\\Microsoft SQL<\/p>\n

Server\\MSSQL\\MSSQL\\Bin\\sqlservr.exe<\/p>\n","protected":false},"excerpt":{"rendered":"

Applies on : \u00a0SQL Server 2005 and above Tested on : SQL Server 2005 1). Check Server Property: 1.1 Right[…]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[1],"tags":[62,147,159,179],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts\/115"}],"collection":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=115"}],"version-history":[{"count":0,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts\/115\/revisions"}],"wp:attachment":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}