SQL Server Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: NavEEd (naveed010_at_hotmail.com)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 00:55:40 GMT

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 - naveed010@hotmail.com

Relevant Pages

  • Re: Installation OK, but cant connect
    ... > Does that mean that it has to be on my specific lan? ... on your lan the server name is YourComputerName, while on my lan the server ... instance of SQL Server we are using... ... SQL Server's login for each user to whom grant login privilege to SQL ...
    (microsoft.public.sqlserver.msde)
  • Re: The SA Mess
    ... At least if a script is trying to log in and returned user unknown then they ... That info has to come from SQL Server. ... > This problem is not restricted to access via the Internet - the problem ... since LAN speed is typically 100 Mbps and Internet ...
    (microsoft.public.sqlserver.security)
  • SQL Server Question
    ... be the approprate to post to. ... I an running a 2 PC lan. ... PC is my SQL server DB and hosts my website. ... the SQL server on my LAN through the dot net app? ...
    (microsoft.public.sqlserver.setup)
  • Re: Publish Sql on the internet
    ... What you need to do is NOT allow connections into your LAN. ... Create a DMZ ... Do not allow SQL Server to connect to anything else on your network. ...
    (microsoft.public.sqlserver.server)