Sqlserver Client/Server Architecture

Posted by Lokeshbasana under Sql Server on 3/29/2009 | Views : 2092 | Status : [Member] | Replies : 1
In client/server systems, more developers PCs connected to a same SQL Server database Pc using TCP/IP

how to give this connectivity

Asp.net application is availiable in Internet web server PC
sqlserver 2005 is availiable in another local pc in networking with Internet web server

how to access sqlserver 2005 local database PC in Internet web server PC.

I searched for this topic and i tried using sqlserver Surface area configuration but no solution.

Please send me the solution
how to give connection between database server pc to internet webserver pc.



Posted by: Majith on: 3/30/2009 [Member] Starter


Well you can connect your local database with Internet website.

you have to mention the web machine Ip Address into stateconnection string and as well as sqlconnection string.

<sessionState stateConnectionString="tcpip=" sqlConnectionString="data source=245.356.12.0; >

Lokeshbasana, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response