Solved

Can't connect to SQL Server 2008 after P2V migration

Posted on 2014-02-24
6
857 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 500 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
Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

 

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 500 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
find SQL job run average duration 24 56
Need help with another query 10 38
Database-Scoped Permissions 2 16
SQL 2012 Instance Problem 3 58
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

749 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