Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Can't connect to SQL Server 2008 after P2V migration

Posted on 2014-02-24
6
Medium Priority
?
921 Views
Last Modified: 2014-02-24
Our server was migrated from a physical server to a virtual server and now we can't connect to SQL Server. We keep getting this 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 the SQL Server is configured to allow remote connections. (Provider (TCP Provider, error: 0 - Only one usage of each socket address (protocol/network address/port) is permitted.) (Microsoft SQL Server, error 10048)

I checked and TCPIP is enable and the SQL Server process is running.
I can login to the server but I can't connect to SQL Server either using Windows authentication or database authentication.

What is missing here?

TIA!
0
Comment
Question by:data_bits
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 11

Expert Comment

by:David Kroll
ID: 39882539
0
 
LVL 8

Assisted Solution

by:Jeff Perry
Jeff Perry earned 2000 total points
ID: 39882551
Have you tried changing the port?

Something seems to have happened during the conversion that is telling SQL that the default port is in use.
0
 
LVL 19

Expert Comment

by:Miguel Angel Perez Muñoz
ID: 39882557
Maybe is bind to older IP?
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 

Author Comment

by:data_bits
ID: 39882663
This just in, apparently it was not migrated to a VM. There are two servers with very similar names, one of which was migrated. This one that we're getting the 10048 error on, was not migrated.

However, it is suspicious that this one started to have problems after the other one was migrated.

Could a duplicate IP# cause this behaviour?
0
 
LVL 8

Accepted Solution

by:
Jeff Perry earned 2000 total points
ID: 39882678
The 10048 error is a port in use error.

Something on the SQL server is already using the port that SQL is trying to start on.
0
 

Author Comment

by:data_bits
ID: 39882743
The decision was made to reboot the server since it had been up for a while.

When it came back up, everything was accessible.

Thanks everyone for the input.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question