Management studio disappears

Question

Management studio disappears

SkyBVI

SSCoach

Points: 15128
More actions
November 15, 2010 at 8:05 am

#142623

The sql server was working fine until one day, the management studio, analysis services disappeared.
I can see only configuration tools.
I went into it and checked sql 2005 services.
it shows, ssis, mssql server, sql agent, reporting service, anaysis service ALL are RUNNING.
Why cant i see management studio then and other services.
Also, when i try to log into managment studio it says sa user password is incorrect, which I am 100% sure is correct.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

could you be trying to connect with a lower version of SSMS, for example the Express Version that comes with Advanced Services?

That limited, express version does not let you connect to anything except the database engine.

for the sa password thing, i'm sure you already made sure it's the right instance/password? noone changed it by chance?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Adiga One Orange Chip Points: 27284 More actions · Answer 2

The sql server was working fine until one day, the management studio, analysis services disappeared.
I can see only configuration tools.
I went into it and checked sql 2005 services.
it shows, ssis, mssql server, sql agent, reporting service, anaysis service ALL are RUNNING.
Why cant i see management studio then and other services.
Also, when i try to log into managment studio it says sa user password is incorrect, which I am 100% sure is correct.

I am not able to understand the problem that you are facing. Line #1, you say SSMS is missing. Line #6, you are using SSMS to connect to the instance.

"Why cant i see management studio then and other services."

Management studio is not a service. By "other services" you are referring to which service?

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 3

You don't log into management studio. It is just an application that connects to SQL Server. The password depends on which instance you are connecting to.

The version of SSMS v the version of SQL Server you connect to can affect what appears.

SkyBVI SSCoach Points: 15128 More actions · Answer 4

@ pradeep

SSMS is not there on the server where sql server is installed.

I am trying to log into SSMS on my local pc.

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP

SkyBVI SSCoach Points: 15128 More actions · Answer 5

@ pradeep

by other services , I mean reporting service, anaysis service , tutorials etc

When i log into remote server where sql server is installed.

I can see only configuration tools in the microsoft sql server 2005 icon in programs.

i cant see management studio, reporting service, anlyssis service, tutorials, books online.

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP

Adiga One Orange Chip Points: 27284 More actions · Answer 6

Check if Client components got uninstalled by chance. If so, you reinstall Client Tools by launching SQL Server setup and selecting "Client Components".

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

@SQLFRNDZ SSCrazy Eights Points: 9095 More actions · Answer 7

try Run--> ssms and windows authentication.

[font="Tahoma"]
--SQLFRNDZ[/url]
[/font]

Adiga One Orange Chip Points: 27284 More actions · Answer 8

pavan_srirangam (11/15/2010)
try Run--> ssms and windows authentication.

Since this is SQL Server 2005, it would be Run --> sqlwb

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

SkyBVI SSCoach Points: 15128 More actions · Answer 9

it says "Windows cant find sqlwb, make sure you typed it correctly and try again"

I think i have to run setup.exe again and then install client components.

Let me try that.

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP

@SQLFRNDZ SSCrazy Eights Points: 9095 More actions · Answer 10

Have you tries with run-->ssms

[font="Tahoma"]
--SQLFRNDZ[/url]
[/font]

SkyBVI SSCoach Points: 15128 More actions · Answer 11

yes pavan

Both giving same error ...

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP

SkyBVI SSCoach Points: 15128 More actions · Answer 12

I installed the client components from the setup.exe and everything was back into place.

I then logged into SSMS( windows authentication) and then changed the sa password.

Thanks all

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP