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 |
|
pradeep_iete
Yak Posting Veteran
84 Posts |
 Posted - 2010-11-22 : 07:51:48
|
| I have threemachines with sql server express at one and sql server standard at other.ExSqlServer(Machine 1) Standard = 172.16.3.3 SQLServer(Machine 2) Express = 172.16.3.11SQLServer (Machine 3) Express = 172.16.3.7Now from machine 1 i am trying to connect machine 2 and 3 from sql server management studio . But connection to machine 3 is successfully done and connection to machine 2 is failure.What could be the reason as i have verified that all three machines has similar configuration values.error says that instance does not exits or may be sql server is not configured to accept remote connections .Thanks |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2010-11-22 : 08:01:22
|
Machine 2 is likely not configured to accept remote connections. Double check that machine's configurations. Does your authentication ID have access to Machine 2? if not, you would get the "does not exist" error.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
|
|
|
Not able to connect SQL through SSMS