Server refusing ODBC Connection

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Server refusing ODBC Connection

Author

Topic

mattt
Posting Yak Master

194 Posts

Posted - 2006-08-24 : 07:27:40

Hi,

I'm attempting to setup an ODBC connection between two installtions of SQL server on different boxes. Both exist outside the DMZ and so have no firewall between them. You can ping from one box to another, successfully, using box names rather than IP addresses.

When setting up the ODBC connection, when presing "next" from the screen where it asks for a SQL username and password (enterted correctly) I get the following error codes when trying to locate the server using it's box name:

SQLState: '01000'
SQL Server Error: 10061

SQLState: '08001'
SQL Server Error: 17

However, when trying the same thing but using the server IP instead of a name, I get slightly different codes:

SQLState: '01000'
SQL Server Error: 1326

SQLState: '08001'
SQL Server Error: 17

Any idea what's going on here?
Cheers,
Matt

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-24 : 07:30:18

Please let us know if this help http://support.microsoft.com/default.aspx?scid=kb;en-us;884012

Peter Larsson
Helsingborg, Sweden

mattt
Posting Yak Master

194 Posts

Posted - 2006-08-24 : 08:10:15

Oho, that's interesting.

Could well be the source of the problem. We're on Win2003, SQL2000 SP1.

I'll have to dig out the upgrade disks and have a play.

Thanks very much for the info!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources