We help IT Professionals succeed at work.
Get Started
Problem exporting database from SQL Server 2005 to 2014
I am trying to export a database from a SQL Server 2005 to SQL Sever 2014
I use SQL Studio installed on the "2014" machine
The "2005" is on another (production) machine
In Studio, I connect to both server then on the 2005 item, I right click, select Export and fill in the fields.
Then GO, and I get this after a while
Login timeout expired
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Named Pipes Provider: Could not open a connection to SQL Server [2]. (Microsoft SQL Server Native Client 11.0)
I verified the configurations and both server have named pipes enabled
Whatelse shoudl I check ?
I use SQL Studio installed on the "2014" machine
The "2005" is on another (production) machine
In Studio, I connect to both server then on the 2005 item, I right click, select Export and fill in the fields.
Then GO, and I get this after a while
Login timeout expired
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Named Pipes Provider: Could not open a connection to SQL Server [2]. (Microsoft SQL Server Native Client 11.0)
I verified the configurations and both server have named pipes enabled
Whatelse shoudl I check ?
Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE