connect sql server from another domain

[C#User]

hi,
For the local sql server, the connection string is like:
Data Source=(local);Integrated Security=SSPI;Connection
Timeout=5;DataBase=northwind

But for another sql server on another domain, what the connection string
should look like??

i appreciate your help!

[Martin Robins]

Data Source=MyServer;Integrated Security=SSPI; ...

Assuming that the server is on the same domain as the workstation and that
you are authorised to access the database on the server, all you need to
change are the name of the "Data Source" to the name of the server you wish
to access (and possibly the database if it does not have the same name).
"C#User" <so*****@yahoo.com> wrote in message
news:Oq**************@TK2MSFTNGP11.phx.gbl...

hi,
For the local sql server, the connection string is like:
Data Source=(local);Integrated Security=SSPI;Connection
Timeout=5;DataBase=northwind

But for another sql server on another domain, what the connection string
should look like??

i appreciate your help!

[Steven Cheng[MSFT]]

Hi,

In addtion to Martin's suggestion, here are some other web resources on
connecting sqlserver via ADO.NET
http://www.connectionstrings.com/
# OpenLink .NET Data Providers Connect String Attributes
http://www.openlinksw.com/info/docs/...etconnstr.html

Also, I think drag a "DataAdapter" component onto form and generate the
connectionstring via it is more convenient. Thanks.
Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Get Preview at ASP.NET whidbey
http://msdn.microsoft.com/asp.net/whidbey/default.aspx