SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Can't Connect to SQL Server 2005


Can't Connect to SQL Server 2005

Author
Message
mrtrich99
mrtrich99
SSC-Enthusiastic
SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)

Group: General Forum Members
Points: 138 Visits: 161
I have a network with two Windows Server boxes. One is a 64bit machine and the other is a 32bit machine. I can ping the 32bit machine while on the 64bit machine and vice versa. My problem is if I'm on the 32bit machine I can't connect to SQL Server 2005 installed on the 64bit machine and vice versa. I have SQL Server 2005 64bit installed on the 64bit machine.

I have SQL Server Browser running on both machines and Windows Firewall turned off. Both are allowing remote connections. I disabled Named Pipes connection on both machines so only TCP/IP is enabled. I tried using SQL Server Authentication to connect to SQL Server but that didn't work either. This is the error I get

"
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 121)
"

I don't know what other troubleshooting should I perform in order to get these two SQL Server Installs to talk to each other. Any help is greatly appreciated.

Thanks
Meet George Jetson
Meet George Jetson
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2943 Visits: 1395
In the off chance the firewall is not completely off, you should add port 1433 to the Windows Firewall.

Have you verified that both SQL Servers "Allow remote connections to this server" is checked in the SQL Server Properties? If this is SQL 2005, this is off by default.

Chris Powell

George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
mrtrich99
mrtrich99
SSC-Enthusiastic
SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)

Group: General Forum Members
Points: 138 Visits: 161
I did have that connection enabled and had no luck.

I was able to resolve this by

1) Going into SQL Server Configuration Manager
2) Go to Protocols for MSSQLSERVER (under SQL Server 2005 Network Configuration)
3) Right click on TCP/IP (make sure status = Enabled)
4) Go to IP Addresses tab
5) Make all IP Addresses Active (made sure that both server IPs are listed on there and are enable and active)

Don't know why i had to turn these IP Addresses on but it was the only way I got it to work since I tried other troubleshooting methods.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search