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 |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2011-08-03 : 01:27:43
|
| Hi All, I have connected to a server remotely but when im trying to connect a db im getting this error can any one let me know where im going wrong, An error has occurred while establishing a connection to the server.when connecting to sql server 2005,this failure may be caused by the fact that under default setting sql server does not allow remote connections.so, now what should i do for this.Thanks In Advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-03 : 01:32:23
|
| is the server where db is present avaiable from the server you're connecying? are they in same domain?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2011-08-03 : 01:48:08
|
| no they are in diff domain |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-03 : 01:53:17
|
| then you wont be able to connect unless your db is exposed to internet.seehttp://msdn.microsoft.com/en-us/library/ms175483(v=SQL.90).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
sql connection