6 deleted 812 characters in body
source | link

I'm currently hosting a database on the server MyComputerName using SQL Server Express 2014.

I want to move the database to another computer, so I installed SQL Server Express 2014 on it but that computer only has the instance ThatComputerName\SQLEXPRESS. When I try to connect to just ThatComputerName it throws the 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: 2)

However, I can't enable remote connections on ThatComputerName because I can't even connect to that instance.

I don't remember what I did on the previous computer to allow me to connect both to MyComputerName and MyComputerName\SQLEXPRESS, how can I create that instance on the new computer? Do I have to reinstall?

Edit:

Further explanation. I have correctly installed SQL Server Express 2014 on both the origin computer and the destination computer. However, on the original computer, I can connect to both MyComputerName and MyComputerName\SQLEXPRESS. See the image below.

enter image description here

On the destination computer, I can connect to ThatComputerName\SQLEXPRESS.

enter image description here

But when I try to connect to just ThatComputerName (and I'm doing this on that computer, not remoting in or anything like that), it throws the error:

enter image description here

I'm currently hosting a database on the server MyComputerName using SQL Server Express 2014.

I want to move the database to another computer, so I installed SQL Server Express 2014 on it but that computer only has the instance ThatComputerName\SQLEXPRESS. When I try to connect to just ThatComputerName it throws the 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: 2)

However, I can't enable remote connections on ThatComputerName because I can't even connect to that instance.

I don't remember what I did on the previous computer to allow me to connect both to MyComputerName and MyComputerName\SQLEXPRESS, how can I create that instance on the new computer? Do I have to reinstall?

Edit:

Further explanation. I have correctly installed SQL Server Express 2014 on both the origin computer and the destination computer. However, on the original computer, I can connect to both MyComputerName and MyComputerName\SQLEXPRESS. See the image below.

enter image description here

On the destination computer, I can connect to ThatComputerName\SQLEXPRESS.

enter image description here

But when I try to connect to just ThatComputerName (and I'm doing this on that computer, not remoting in or anything like that), it throws the error:

enter image description here

I'm currently hosting a database on the server MyComputerName using SQL Server Express 2014.

I want to move the database to another computer, so I installed SQL Server Express 2014 on it but that computer only has the instance ThatComputerName\SQLEXPRESS. When I try to connect to just ThatComputerName it throws the 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: 2)

However, I can't enable remote connections on ThatComputerName because I can't even connect to that instance.

I don't remember what I did on the previous computer to allow me to connect both to MyComputerName and MyComputerName\SQLEXPRESS, how can I create that instance on the new computer? Do I have to reinstall?

    Tweeted twitter.com/StackDBAs/status/671918025839239168
5 added 41 characters in body
source | link

I'm currently hosting a database on the server MyComputerName using SQL Server Express 2014.

I want to move the database to another computer, so I installed SQL Server Express 2014 on it but that computer only has the instance ThatComputerName\SQLEXPRESS. When I try to connect to just ThatComputerName it throws the 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: 2)

However, I can't enable remote connections on ThatComputerName because I can't even connect to that instance.

I don't remember what I did on the previous computer to allow me to connect both to MyComputerName and MyComputerName\SQLEXPRESS, how can I create that instance on the new computer? Do I have to reinstall?

Edit:

Further explanation. I have correctly installed SQL Server Express 2014 on both the origin computer and the destination computer. However, on the original computer, I can connect to both MyComputerName and MyComputerName\SQLEXPRESS. See the image below.

enter image description here

On the destination computer, I can connect to ThatComputerName\SQLEXPRESS.

enter image description here

But when I try to connect to just ThatComputerName (and I'm doing this on that computer, not remoting in or anything like that), it throws the error:

enter image description here

I'm currently hosting a database on the server MyComputerName using SQL Server Express 2014.

I want to move the database to another computer, so I installed SQL Server Express 2014 on it but that computer only has the instance ThatComputerName\SQLEXPRESS. When I try to connect to just ThatComputerName it throws the 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: 2)

However, I can't enable remote connections on ThatComputerName because I can't even connect to that instance.

I don't remember what I did on the previous computer to allow me to connect both to MyComputerName and MyComputerName\SQLEXPRESS, how can I create that instance on the new computer? Do I have to reinstall?

Edit:

Further explanation. I have correctly installed SQL Server Express 2014 on both the origin computer and the destination computer. However, on the original computer, I can connect to both MyComputerName and MyComputerName\SQLEXPRESS. See the image below.

enter image description here

On the destination computer, I can connect to ThatComputerName\SQLEXPRESS.

enter image description here

But when I try to connect to just ThatComputerName (and I'm doing this on that computer, not remoting in or anything like that), it throws the error:

enter image description here

I'm currently hosting a database on the server MyComputerName using SQL Server Express 2014.

I want to move the database to another computer, so I installed SQL Server Express 2014 on it but that computer only has the instance ThatComputerName\SQLEXPRESS. When I try to connect to just ThatComputerName it throws the 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: 2)

However, I can't enable remote connections on ThatComputerName because I can't even connect to that instance.

I don't remember what I did on the previous computer to allow me to connect both to MyComputerName and MyComputerName\SQLEXPRESS, how can I create that instance on the new computer? Do I have to reinstall?

Edit:

Further explanation. I have correctly installed SQL Server Express 2014 on both the origin computer and the destination computer. However, on the original computer, I can connect to both MyComputerName and MyComputerName\SQLEXPRESS. See the image below.

enter image description here

On the destination computer, I can connect to ThatComputerName\SQLEXPRESS.

enter image description here

But when I try to connect to just ThatComputerName (and I'm doing this on that computer, not remoting in or anything like that), it throws the error:

enter image description here

4 added 103 characters in body
source | link

I'm currently hosting a database on the server MyComputerName using SQL Server Express 2014.

I want to move the database to another computer, so I installed SQL Server Express 2014 on it but that computer only has the instance ThatComputerName\SQLEXPRESS. When I try to connect to just ThatComputerName it throws the 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: 2)

However, I can't enable remote connections on ThatComputerName because I can't even connect to that instance.

I don't remember what I did on the previous computer to allow me to connect both to MyComputerName and MyComputerName\SQLEXPRESS, how can I create that instance on the new computer? Do I have to reinstall?

Edit:

Further explanation. I have correctly installed SQL Server Express 2014 on both the origin computer and the destination computer. However, on the original computer, I can connect to both MyComputerName and MyComputerName\SQLEXPRESS. See the image below.

enter image description here

On the destination computer, I can connect to ThatComputerName\SQLEXPRESS.

enter image description here

But when I try to connect to just ThatComputerName (and I'm doing this on that computer, not remoting in or anything like that), it throws the error:

enter image description here

I'm currently hosting a database on the server MyComputerName using SQL Server Express 2014.

I want to move the database to another computer, so I installed SQL Server Express 2014 on it but that computer only has the instance ThatComputerName\SQLEXPRESS. When I try to connect to just ThatComputerName it throws the 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: 2)

However, I can't enable remote connections on ThatComputerName because I can't even connect to that instance.

I don't remember what I did on the previous computer to allow me to connect both to MyComputerName and MyComputerName\SQLEXPRESS, how can I create that instance on the new computer? Do I have to reinstall?

Edit:

enter image description here

I'm currently hosting a database on the server MyComputerName using SQL Server Express 2014.

I want to move the database to another computer, so I installed SQL Server Express 2014 on it but that computer only has the instance ThatComputerName\SQLEXPRESS. When I try to connect to just ThatComputerName it throws the 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: 2)

However, I can't enable remote connections on ThatComputerName because I can't even connect to that instance.

I don't remember what I did on the previous computer to allow me to connect both to MyComputerName and MyComputerName\SQLEXPRESS, how can I create that instance on the new computer? Do I have to reinstall?

Edit:

Further explanation. I have correctly installed SQL Server Express 2014 on both the origin computer and the destination computer. However, on the original computer, I can connect to both MyComputerName and MyComputerName\SQLEXPRESS. See the image below.

enter image description here

On the destination computer, I can connect to ThatComputerName\SQLEXPRESS.

enter image description here

But when I try to connect to just ThatComputerName (and I'm doing this on that computer, not remoting in or anything like that), it throws the error:

enter image description here

3 added 103 characters in body
source | link
2 added 22 characters in body
source | link
1
source | link