EMERGENCY!!!!!!! )ODBC - connection cross domain 1

[moolie]

Hi guys I hope you can help

Monday morning is fast approaching and I have a dillema.

New server with new domain went online today - 2003 standard on two servers in one domain. all machines in the office are members of this domain. SQL server is running on one server and AD/DC etc running on the other. All good in house.

We also have this old terminal server machine serving up our app to remote users (this machine will be upgraded in a couple of weeks). It is on its own domain and manages its own AD/DC etc services for terminal server.

Because the terminal server and the sql server are now on different domains - my client applications hosted on terminal server can no longer connect to the sql server using ODBC.

I can ping the sql server from TS machine as well as create network drives to other shared resources, but ODBC will not go.

HELP

 

[SQLBill]

Why not? I have users accessing my SQL Server instance from other domains and they use ODBC.

What type of authentication is your SQL Server using? It should be mixed (SQL Server and Windows authentication). Even if you can PING the SQL Server from the app box, that doesn't mean it's a TRUSTED system.

Are there any error messages in the SQL Server Error logs, how about the Windows Event Viewer logs?

Is there a firewall between the two networks? Is it blocking the app system?

-SQLBill

 

[SQLBill]

One other thing to try....have you updated the MDAC on the app server? The latest version is 2.8 and you can download it from Microsoft's website.

-SQLBill

 

[moolie]

Now that the smoke has settled...

Thank you soooooo much SQLBill - I have both MDAC 2.8 and sa username and password applied on mixed mode for the SQL server. I feared this may cause some app problems with the in house app installations but our programmer foresaw the use of mixed mode and coded the app for full odbc resolution from within the app soooo everything is now working as it should. Gold Star For You

Moolie

 

[SQLBill]

Glad I could help and thanks for the star!

-SQLBill