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 |
|
mykhan
Starting Member
2 Posts |
 Posted - 2007-03-19 : 17:25:59
|
| Hi AllI have been configuring my website with the following:I have my domain residing on a webserver with SQL Server 2005, and the database (an sql server 2000 db) which I am connecting to reside on another web.Now when I try to connect to the to the remote database from SQL Server 2005, it gives me error, something like When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. or maybe 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 the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Any suggestions will be welcomed :)Thanks in AdvanceMykhan |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-20 : 00:27:16
|
| Is remove connections enabled on sql 2005 server?It can be checked through SQL Surface Area Configuration...MohammedU |
 |
|
|
mykhan
Starting Member
2 Posts |
Posted - 2007-03-20 : 02:24:58
|
| Thanks Mohammad for reply.Yes I already did that, allowed the remote connection on 2005. Also allowed an Exception in the 2003 server windows firewall for sqlserver. Still couldnt connect.Also, If I put the whole domain on another test server (a VPS server), which has sqlserver 2000, it will connect to the remote database alright. I think there is some issue with 2005 not connecting to a 2000 remote SQL server.Secondly, (might be a silly question) is an SQL Server Instance on a Computer required (where the website resides), if your website is connecting to a remote database using connection string, the db name, server name, credential etc? |
|
|
|
zawmn
Starting Member
2 Posts |
Posted - 2007-03-22 : 11:04:36
|
| I have an aspx application. When I try to connect to remote SQL server that has installed sql2000, an error occur. But after I installed sql2005 on this same server and try to connect to previous sql2000, connection is success. Is there any effect on sql2000 setting from sql2005 installation?How can I connect to remote sql2000 server without sql2005 installation? |
|
|
|
|
|
|
|
|
connecting to remote sqlserver