SQL Server 2008 - cannot register default instance MSSQLSERVER
Posted
by
Paul Moss
on Stack Overflow
See other posts from Stack Overflow
or by Paul Moss
Published on 2009-12-25T00:46:05Z
Indexed on
2010/12/29
0:54 UTC
Read the original article
Hit count: 302
sql-server-2008
Hello, I have installed SQL Server 2008 Developer on Windows 7 64 bit. In Management Studio I cannot register the default instance MSSQLSERVER, it cannot find it although the service is running. I get the message:
Cannot connect to PHOENIX\MSSQLSERVER.
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: 25 - Connection string is not valid) (Microsoft SQL Server, Error: 87)
However Management Studio does show the SQL Server 2005 Express instance (that was installed with VS 2008 Pro) which appeared as already registered. I an using Windows Authentication as I installed it in mixed mode. Any ideas would be appreciated, many thanks
paul
© Stack Overflow or respective owner