Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-06 : 08:47:39
|
| Le Duc An writes "Hi all!I have a system that accesses SQL Server database. All client machine run in a domain, but SQL Server run on a machine outsite that domain. So, i catch exception when client try to connect to SQL server: "SQL Server does not exist or access dined". The connection string inplemented bellow: string connection = Integrated Security=SSPI;data source=192.168.100.81;persist security info=false;initial catalog=MarsData Or string connection = server=192.168.100.81;database = MarsData;uid= sa;pwd= sa; Connect Timeout=10Could you help me solve thi problemRegard," |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-04-06 : 08:54:10
|
| Can you ping the machine from the clients?Is the sql server definitely running? Can you attach to the sql server if you are on the server itself?You will have difficulty with integrated security if there is no trust between the domains. In fact, you may have difficulty even if there is a trust. Why is your server in a different domain to the clients?-------Moo. :) |
 |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-06 : 10:53:20
|
| Do you have DNS server on the network? |
|
|
|
|
|
|
Connect to SQL Server outsite domain