SQL Server Question

SQL Server Question

Post by NavEE » Wed, 25 Aug 2004 09:55:40


Good Day all, sorry for cross posting, but I didn't know which group would
be the approprate to post to.

I an running a 2 PC lan. 1 PC is my SQL server DB and hosts my website. I
am writing asp applications with MS .net.

The problem I am having is that when I run my application locally, it does
not see my sqlserver. When I push it in production, on the SQL server box
the app sees the database fine. I can connect using query analyser from the
other PC on the lan, and I can see the tables in the server in the server
explorer in .net.

Just wondering, am I missing some sort of simple setting to allow me to see
the SQL server on my LAN through the dot net app?

Here's the connection string I'm building in .net...
sqlconn.ConnectionString = "server=SQLSRV;database=PATRICKTESTDB;user
id=pdtest;pwd=pdtest"

Any help would be appreciated.

Thanks.

Patrick W. Dalton - XXXX@XXXXX.COM