November 10, 2010 at 11:54 am
I am trying to conncet to SQL 2008 server from SQL 2005 but getting the following error
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: 5)
I tried all recommendation provided like TCP\IP port 1433,allowed remote connections but still failing, any clue?
November 10, 2010 at 12:07 pm
How is remote connection configured on the SQL 2008 instance?
If it's Express edition, keep in mind that the default is shared memory connections only, and you have to turn on TCP/IP connections in the SQL Service manager.
- 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
November 10, 2010 at 12:46 pm
its an enterprise edition and TCP\IP is Enabled
November 10, 2010 at 1:40 pm
Can you ping from one to the other?
- 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
November 10, 2010 at 2:00 pm
yes i can ping to 2008 server, its not just with this server all my sql servers(2005) can not connect to 2008 database engine but i can not the other way(from 2008 to any 2005 servers)
November 10, 2010 at 2:04 pm
Silly question, but what are you trying to connect the '05 to the '08 with?
Linked server? SSMS '05 looking at '08 registered servers? SSIS?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 10, 2010 at 2:46 pm
This problem could arise if you are using SSMS 2005. Please try to use SSMS 2008 client tool
Thank You,
Best Regards,
SQLBuddy
November 10, 2010 at 2:46 pm
Craig
Its not the link server connection, I am trying to connect to 2008 database engine from the sql 2005 interface.
November 10, 2010 at 3:04 pm
Tara-1044200 (11/10/2010)
CraigIts not the link server connection, I am trying to connect to 2008 database engine from the sql 2005 interface.
Check this post out:
You need to use SSMS SP2 CU5 or SP3 to be able to connect SSMS 2005 to the 2k8 engine.
Or, you need to install the MSSQL 2k8 SSMS from here (This is to the Express, which is free, and will connect to higher servers):
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply