My apologies, I have just re-read your original post.
If the server is on another domain, you have two choices: (a) you can use
SQL security - a bit of a pain as you need another username/password
combination or (b) you could try assigning a trust between the two domains
and then set up the second domain to access the server as well.
SQL security is ideal if you are allowing access from multiple external
domains, but make sure you have all the latest service packs before you
enable this as there was a nasty virus last year that expolited a hole in
the SQL security. If these are internal domains then the trust would be much
better.
Martin.
"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!