How to connect to a remote SQL Server using servername, username & password

How开发者_如何学运维 to connect to a remote SQL Server using servername, username & password in SQL Server 2005 ?

I'm going to assume that you're talking exactly about what your question asks, how to connect to a remote MSSQL instance inside SQL Server, rather than through SQL Server Management Studio because 1) you don't mention SSMS and 2) it's pretty obvious how to connect with SSMS (I mean, the connect box is right there when you start it).

To connect to one MSSQL instance from another you can use linked servers. You can query data from linked servers, and if they are configured for RPC Out you can also execute SQL against them.

If the server is configured for integrated security, there is no way of doing it without changing the security option.

Check out the ConnectionStrings website - it shows you how to build a connection string that will allow you to connect from your machine to a remote SQL Server instance.

That connection string will typically look something like:

server=YourServerHere;database=YourDatabase;User ID=YourUser;Password=Top$ecret

But there are lots of options and additional things you can specify - the ConnectionStrings.com web site shows and explains them all!