May 25, 2007 at 10:52 am
Hi, having a weird problem with a particular database instance.
We have a db server with several db instances. I can connect to all db instances from most client machines. However recently one client was rebuilt (with XP sp2) and now can only connect to the default instance on the db server.
When trying to connect to other instances I get a 'server not found or access denied' error. All instances (including the default instance) are running SQL2000 SP4.
Can anyone assist with this?
May 25, 2007 at 11:23 am
What are you connecting with? Query Analyzer, Enterprise Manager, Other Application with ODBC, etc? What protocols (TCP, Named Pipes, etc) are you using on the server?
James.
May 25, 2007 at 12:18 pm
Can't connect with any of the above - have tried Query Analyzer, Enterprise Manager, ODBC DSN, and System.Data.SqlClient.
Named Pipes and TCP/IP are both enabled.
May 25, 2007 at 12:29 pm
Hmm, what is the security setting, SQL Server and Windows or Windows Only?
Just so I'm clear, you can connect to the instance in question from "other" client workstations, just not one specific workstation?
Unfortunately it doesn't sound like an obvious problem and I'm shooting in the dark. Anything unusual about the workstation in question (not part of the domain, outside the firewall, etc). It almost sounds like the workstation doesn't want to talk on the non-default port. That could indicate a firewall problem, is windows firewall enabled?
James.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply