.net ==> Connecting to a remote sql server??

Question

This is the 2nd time I'm asking this.
please RRRREEEEAAAADDDD the question carefully before u touch the keyboard.
I'm trying to connect to a remote database. The database has windows authentication.(DATABASE HAS NO USERNAME AND PASSWORD)
However, the windows server that the sql is installed on, has a username and password(THIS USER AND PASS IS NOT FOR THE SQL SERVER)
How can i connect to this database? where does the username and password go? how is the connections string going to look like?

Thank You

Answer 1

If the SQL Server you are connecting to is setup to only do Windows authentication, then you cannot pass a username/password in the connection string. In this case the connection will be made with the identity of the person who is running the application, or in the case of the web app, the account the web server is running the page under.



The username/password on the sever itself is not important, the SQL Server security is the only thing that is important from the connection standpoint.



I believe there are way to setup impersonation so the the app can appear to run as someone other then the person who is logged into the computer.

Answer 2

sure, a sort of workstations could probable host the database - yet make certain it has a DHCP reservation, and as a consequence a static IP, set up indoors the router. i could even confirm the gadget advice superhighway internet hosting the database is saved on a astounding style of the time. the threat is, you will could re-write the authentication, as homestead abode windows Authentication will place self perception interior the energetic itemizing, which demands a homestead abode windows Server. i could in all risk write code for authentication and shop the guy records indoors the database - to encrypt the passwords, i could use an MD5 Hash.

Answer 3

The connection string depends on which database it is.



http://connectionstrings.com/ has most of them - find the one you need.