January 10, 2006 at 5:20 am
guys, im not sure if this is doable. i did read that this is possible with dot net 2.0, but we're still stuck on .NET 1.1.4322 -
anyway, the question. i have a vb.net application that connects to three separate sql server instances on form load and returns some results.
now my boss wants to expand that. well, no problem except, the new sql server instances are on a different domain. Still in the same Intranet, but different domain.
is this possible? with an application in one domain using a connection string that would attempt to access an instance on another domain?
any help is appreciated. heck, i thought i was doing good to access three at a time, but you know how management is. constantly pushing the envelope.
thanks again for any help or reference to this
rik
January 10, 2006 at 7:09 am
Yes, it's possible. If there is a trust relationship such that the new domain trusts your domain, you can do so using Windows authentication. The connection string would be no different than what you're already used, just specifying the appropriate server name and initial database as appropriate. If the trust relationship is not in place, so long as the new SQL Servers are set up for Mixed Mode authentication and you can use SQL Server logins, you can make a connection in that manner.
K. Brian Kelley
@kbriankelley
January 10, 2006 at 8:03 am
wow. that's perfect. yes, we do use windows authentication - so this should work out great. thanks again for the help Brian.
rik
January 10, 2006 at 8:18 am
If you use Windows auth, get with your Windows/domain administrators and verify that the trust relationship is in place and in the "right direction." If so, access can be granted on the new SQL Servers to allow those Windows logins in. Then you are home free.
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply