Server UID/PWD as well as SQL Server UID/PWD in connection string

[Sypher2]

I have a remote SQL server on the LAN that I would like to connect to. The SQL server itself is password protected. This is no problem for an ADO.NET connection string.

However, the server itself (the box) requires a Windows user name and password. I would like to pass this information so I can get to the SQL server. The connection string doesn't seem to have any property to set this. Using Integrated Security=SSPI doesn't work since we are not using Windows authentication for this box.

How can I get to the SQL server in this situation?

 

[ThatRickGuy]

You'll probrably have top open a connection to the box first. I've never run into this specificly, but there is a NetworkCredentials class. maybe a combination of that and System.IO will let you validate the account.

-Rick

----------------------

http://www.ringdev.com

I believe in killer coding ninja monkeys.