Connecting to a remote database using Visual studio
I have domain , database name, database user and password
I want to connect to my database remotely using visual studio 2010, How can I do this ?
thanks in advance
2 Solutions collect form web for “Connecting to a remote database using Visual studio”
there are many diffrent ways to do it depending on the database type your using
if you are looking for a wizer like way you can use visual studio toolbox and add a datasource.
it easier to do it with connection string but in order to achive this when you want to open add new sql server connection either with server explorer or just by writing the connection string since server ui still creates the connection sttring you need to know
Data Source=SERVER the ip adress of the server where sql server is istalled
Replace Integrated Security with User ID and Password if you are using