Learner
Learner

Reputation: 563

SQL Server 2008 R2 full version installed but Management Studio is Express

I installed Microsoft SQL Server 2008 R2 Full Package(64bit).BUT after that i see SQL Server Management Studio express installed(database Engine is SQL Server Express).In the other services such as intergration,Analysis,Reporting services are Full version.

So.. whats the error ? Can anyone direct me to install SQL Server Management Studio 2008 Full version

EDIT : In this first picture shows you normally my SQL Server Management Studio connects.(Only Connect using EXPRESS Version) Login with SQL SERVER Management Studio Express 2008

In the second picture shows you the error.

enter image description here

But When i connect to INtergration services and other service i can login to full version using CHATHU-2 Server Instance

Upvotes: 0

Views: 6873

Answers (3)

TechGuy
TechGuy

Reputation: 4560

Stop your SQL Server Instance.SQL Server(SQLEXPRESS) & Start SQL Server(MSSQLSERVER) go there services.msc

Upvotes: 0

PMC
PMC

Reputation: 4756

It looks as though you only have to remove the \SQLEXPRESS from the server name textbox or click on it's drop down arrow, browse for servers and see what is there.

You could also run services.msc, look for SQL Server services and see what is there, named instances are normally in brackets.

Upvotes: 1

Michéle Johl
Michéle Johl

Reputation: 101

Management Studio is a stand alone application, so it does not matter that it states Express. Did you Install anything prior to SQL like SharePoint or Visual Studio? If you did that would be why you see express. SharePoint and Visual Studio install SQL Express upon their install.

Upvotes: 1

Related Questions