Cannot Connect to SQL 2000 on Win2k3 Server

I am having great difficulty connecting to my sql box, I
vpn'd in from work and connected via remote desktop,
setup the SQL connection locally, and connected fine,
which I am wondering if it was cause I was VPN'd in, but
I disconnected from remote desktop and was still able to
hit my sql server in enterprise manager. Then when I got
home tonight, logged on my XP machine and I cannot get my
sql registration to connect.
SQL Server does not exist or access denied ConnectionOpen
(Connect()
I have no idea what this means...I am just learning SQL
so this is all new to me...please help...I am on a home
network behind a linksys router, both my XP box and the
Win2k3 box are behind the router which has a dynamic ip
for the XP box, and a static one for the 2k3 box.On Windows 2003, if there are any instances of SQL Server installed that
are not on SP3 or higher, TCP will be disabled (there will be messages in
the event logs indicating this). In that case remote connections would fail
because by default clients try to connect with TCP. Upgrade all instances
on the box to SP3 then retry connecting. You can also try to connect from
the remote machines using named pipes (add np: before the machine\instance
in your connection string).
328306 INF: Potential Causes of the "SQL Server Does Not Exist or Access
http://support.microsoft.com/?id=328306
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Cannot connect to AdventureWorks db

All,

I am running SQL05 Dev with AdventureWorks on my desktop with local admin rights. I also have it configured to connect locally since it's a DEV version of SQL.

When I use either of the connection strings below I get the error message at the end of this post.

Thanks,

>Scott

Here are the strings:

Data source=(local); initial catalog=AdventureWorks or Data source=(SQLDEV05); initial catalog=AdventureWorks

Here is the error message:

TITLE: Microsoft Report Designer

A connection cannot be made to the database.
Set and test the connection string.

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

Although it should work if you are connecting locally, you may want to try enabling TCP/IP and Named Pipes connections (which are off by default) just to see if that solves the problem. You can do this through SQL Server Surface Area Configuration tool. Let us know if that works, if not, it may be a different issue.

|||

Hi:

According to the connection string you posted, please try the following changes and see if any of them works for you:

Origional: "Data source=(local); initial catalog=AdventureWorks"

Modified: "Data source=(local); initial catalog=AdventureWorks; Integrated Security=true"

or

Origional: "Data source=(SQLDEV05); initial catalog=AdventureWorks;"

Modified: "Data source=SQLDEV05; initial catalog=AdventureWorks; Integrated Security=true"

For more information about connection string, please use the following link for references.

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx

Hope this helps. :-)

Thanks.