we are currently running on sql 2008 and will be moving to sql 2008 r2 on a new server. I'm trying to restore and master database on the new server but can't get connected (started in single user mode) in management studio.
Any ideas? There shouldn't be any other connections. I'm remoted into the actual server and the instance name is correct. I'm getting the following message:
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:
SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
View Complete Post