Link to home
Create AccountLog in
Avatar of sfossupport
sfossupportFlag for United States of America

asked on

Problems opening SQL Server Management console

I have both sql server 2005 (wsus) as well as 2008( custom application) installed. When
I try to open SQL Server Management Studio Express console it opens for 1/2 sec then
closes. I run as admin and there are no entries in the logs. I just want to move the wsus
db
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

I would try uninstalling / reinstalling SSMS.  The SQL Servers do not depend on it for anything.
Which OS are you running this on?

Windows 7 or Server?

Any errors in the event log?
Avatar of sfossupport

ASKER

Windows 2008 sbs and there are no entries in the event logs.
To move the WSUS dabatase you do not need SSMS

run this wsusutil /movecontent

Are you moving WSUS to another drive or Server? Above command is for another drive

REad this for another drive
http://technet.microsoft.com/en-us/library/hh328578(WS.10).aspx

Read this to another Server
http://social.technet.microsoft.com/wiki/contents/articles/508.how-to-move-wsus-from-one-server-to-another.aspx
wsutil is good for moving the content folder and I have already done this. But it does not handle moving the database(susdb) which is what I need ssms for. What I need to do is move the datbase(susdb) to a new location ( detach and then re-attach ). If I could script it
that would be great.
ASKER CERTIFIED SOLUTION
Avatar of Member_2_6492660_1
Member_2_6492660_1
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks Still wish I could get the console to work or generate an error