x

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 !!
more ▼

asked Nov 04, 2011 at 10:31 AM in Default

garvit184 gravatar image

garvit184
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.
more ▼

answered Nov 06, 2011 at 09:14 PM

Amardeep gravatar image

Amardeep
1.3k 87 88 89

(comments are locked)
10|1200 characters needed characters left

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
more ▼

answered Nov 06, 2011 at 11:23 PM

Sri 1 gravatar image

Sri 1
11 9 9 10

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1948
x53

asked: Nov 04, 2011 at 10:31 AM

Seen: 972 times

Last Updated: Nov 04, 2011 at 05:29 PM