dbTalk Databases Forums  

Enterprise Manager/DSN Issue

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss Enterprise Manager/DSN Issue in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
DomitianX
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.