ERROR Connecting to a server in with SQL Server Management Studio Express 2005?
When I try connecting to a server in SQL Server Management Studio Express 2005 with Server Name as PC-Name\\MSSMLBIZ\\SQLEXPRESS or ./SQLEXPRESS and Windows Authentication it shows that required instance is not found and I opened my SQL Server Configuration Manager It had just two instance or name (MSSMLBIZ and SQL Server Browser) and it had no SQLEXPRESS which may the problem why I was not able connect. How do I get my SQLEXPRESS running I want to compile my queries?? HELP !!
It seems that your SQL Instance name is "***MSSMLBIZ***" so you can try to connect SQL database using PC-Name\\MSSMLBIZ You can also cross check your instance name under windows services; it looks "***SQL SERVER(MSSQLSERVER)***" for default SQL Server Instance. Also check service is running or not.
You may experience problems when you use SQL Server Management Studio in SQL Server 2005 to connect to an instance of SQL Server 2008 and also check. Under Configuration Manager and Network Configuration and Protocols for your instance is TCP/IP Enabled? That could be the problem