Connecting (ODBC) to SQL 2005 Express from different domain with trust

Hi!

I am trying to establish connection from different domain using ODBC driver with no luck!

I am able to do it within my domain from any place, but it fails from outside. I have two-ways trust established between domains. Users are able to see and use resources both ways.

When I create ODBC it doesn't matter if I use SQL or Windows NT authenctication, I am getting error:

Connection Failed:

SQLState: '01000'

SQLServer Error: 11004

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open (getbyhostname()() )

Connectio Failed:

SQLState: '08001'

SQL Server Error: 11

I tried to set it with TCP Static Port or Dynamic. No difference.

What should I look into?

Any ideas? Any help?

Thanks.

Did you try using the ip address ? Maybe the name cannot be resolved ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Yes I tried. Does SQl 2005 Express have any limitations as far as Connections from other domains?

Any other ideas.

|||

No, it don′t has such things. Is the server pingable ? SQL Server uses a dynamic port not he standard port. The SQL Server browser service will redirect incoming request to the appripiate dynamic port. Therefore the service has to be started on the server system. Did you check that ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

I am able to ping server, able to access files on server using UNC.

SQL Server browser is running on my server. Everything is in place, yet I can't logon.

I tried setting up ODBC Data Source with both Windows NT and SQL account authentication with no luck.

SQL actually is letting me create login using user name from other domain. I can do Find and discover users from other domain.

When it gets to making connection with server from their side it just dont see it.

Is that possible that because server is installed as a named instance I am having that problem?

|||

There has to be a firewall in between which block the traffic (bit not ICMP). Make sure you configured the firewall to let the appropiate ports open for connecting.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||Apparently I had to change port in All IP to 1433. Leaving it default dynamic was the problem. I changed all settings to listen to 1433 and here we go. Thank you for your help.