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 |
|
sanjayadsure
Starting Member
3 Posts |
 Posted - 2009-04-17 : 06:15:32
|
| Hi All, I have one XP machine & one Server 2008 machine. Both are having SQL server 2005 installed. Now I want to access each others DB. I have done all the things mentioned here on both machines for allowing remote connection.http://support.microsoft.com/kb/914277Now when I go to XP machine's SQL Server & access Server 2008 machine's DB it's accessible. But when I go from Server 2008 machine to XP machine I am getting error as*********************************************************************TITLE: Connect to Server------------------------------Cannot connect to MachineName\SQLEXPRESS.------------------------------ADDITIONAL INFORMATION:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)*********************************************************************Could you please tell me how to cope with this? Is there something which I am missing?Thanks,SanjaySanjay |
|
|
|
|
|
Remote Connection issue in SQL Server 2005