Please help connecting to SQL !

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Please help connecting to SQL !

Please help connecting to SQL !

Rate Topic

Display Mode

Topic Options

Author

Message

ericb1

Posted Thursday, September 20, 2012 7:58 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 1:36 PM
Points: 92, Visits: 296

First time I encountered this: I have a SQL2008 express instance on a remote server that I connect to from my local server, which is a SQL2008 standard 32 bit. I can connect no problem.

Now I have a new server, and it's a SQL 2008 r2 x64 bit, and it will not connect to the remote SQL2008 express instance. On the server itself, I can use the ODBC connection manager to connect to it, but I'm assuming that it's using some 32bit driver to connect, and the SQL 2008 r2 is using some native x64 bit driver that doesn't work?

Any suggestions on how to connect is greatly appreciated, thanks!

Post #1361995

GSquared

Posted Thursday, September 20, 2012 8:16 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:45 PM
Points: 15,442, Visits: 9,572

Do you get an error message when you try to connect?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #1362009

Ignacio A. Salom Rangel

Posted Thursday, September 20, 2012 10:15 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 5:05 PM
Points: 3,051, Visits: 1,364

Please answer GSquared's question.

My blog

Post #1362130

ericb1

Posted Thursday, September 20, 2012 10:56 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 1:36 PM
Points: 92, Visits: 296

thanks for the reply, the error is below. However, I CAN connect from a different SQL 2008 server

TITLE: Connect to Server
------------------------------

Cannot connect to 207.245.109.91.

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

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=1326&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Post #1362159

GSquared

Posted Thursday, September 20, 2012 10:59 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:45 PM
Points: 15,442, Visits: 9,572

Is it on a different network, or different subnet? Try pinging the IP address you are using, from the server that can't connect. See if you get a reply.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #1362165

ericb1

Posted Thursday, September 20, 2012 11:02 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 1:36 PM
Points: 92, Visits: 296

It's a completely different network, connecting over the internet, not internally. Ping is turned off though, b/c I cannot ping even from the SQL server that works. Again, odbc connections also work, but native SQL 10 connections from the x64 server do not, which is what led me to think it's a x32 vs. x64 driver issue that the 2008r2 version is using.

Post #1362170

ericb1

Posted Thursday, September 20, 2012 2:55 PM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 1:36 PM
Points: 92, Visits: 296

From the same server, I can go to the ODBC connections window and make an ODBC connection to the remote server no problem. But I just can't do it from SQL Server management studio. So I think the management studio is using a different driver that can't connect to SQL 2008 express?

It can connect to other instances of SQL 2008.

any help is greatly appreciated, thanks!

Post #1362330

GSquared

Posted Monday, September 24, 2012 6:35 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:45 PM
Points: 15,442, Visits: 9,572

The error message you're getting says that Named Pipes may not be enabled on the server you're trying to connect to. Is it? (SQL Server Configuration Manager allows you to check and control this.)

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #1363454

ericb1

Posted Monday, September 24, 2012 7:09 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 1:36 PM
Points: 92, Visits: 296

Just in case anyone runs into this issue, it is definitely a SQL 2008 r2 issue with the default driver. I compared the registry values and matched it to my older SQL 2008 x86 server, and low and behold it can now connect no problem.

thanks for everyones assistance!

Post #1363469

« Prev Topic | Next Topic »

Permissions