Enterprise Manager/DSN Issue -
04-14-2010
, 03:22 PM
I have a bit of a weird one here. I am trying to setup a System DSN on a
computer and it keeps telling me the server does not exist or access denied.
I am logged on as the local administrator, I use the sa user name and
password that works just fine on a different computer and it still fails the
test with the error above.
I used the odbcping utility to verify that I can talk to the SQL server and
it works fine.
C:\>odbcping /S fqdn.something.com/U sa /P password
CONNECTED TO SQL SERVER
ODBC SQL Server Driver Version: 03.85.1132
SQL Server Version: Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Any ideas on what might be preventing it from creating the DSN? I am at my
wits end with this one. I have never had this much trouble getting a DSN
setup. I also tried install EM and registering the server in question and
that fails with the same error.
comcheck verifies that it is MDAC 2.8 SP1
The weird part is that I can register a different SQL server on the network
just fine in EM.
The other thing I tried is to give this new computer the same IP information
and plug it into the same jack as my main computer and that didnt work either. |