By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,943 Members | 1,411 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,943 IT Pros & Developers. It's quick & easy.

MS SQL Management Studio-error at startup

P: 1
Good day!

I downloaded and installed MS SQL Server Express (Advanced) x64 on Windows Server 2008 R2 SP1 x64. When you try to start MS SQL Management Studio, you receive the following error: "the operation could not be completed"

After the installation was complete, the message indicated that all components were installed successfully.

Please help in solving this problem.
May 18 '18 #1
Share this Question
Share on Google+
1 Reply

P: 1
Download and install MS SQL Server Management Studio Express for the version of the MS SQL database installed with the product.

2. After installation, open the application from Start > Programs > Microsoft SQL Server 2005/2008 > SQL Server Management Studio Express.

3. Log into the database using Windows Authentication

4. Expand Databases, then right-click on wt_sched and choose "Properties."

5. Select "Options" and scroll to the bottom in the pane on the right.

6. Change "Restrict Access" to "SINGLE_USER."

7. Select OK and repeat the above steps for the wtMaster section of the database.

8. Select "New Query" from the toolbar, and in the query pane that opens, paste in the following commands:

dbcc checkdb('wtMaster',REPAIR_REBUILD)
dbcc checkdb('wt_sched',REPAIR_REBUILD)

9. Select the "Execute" button to repair the database.

10. Perform the steps outlined in 4-6 above and change the databases back to "MULTI_USER" from "SINGLE_USER."

Note: Changing the database back to MULTI_USER mode may require logging out and logging back in using SQL Server Management Studio Express in order to change both parts back to their original settings. Attempting to make these changes may result in an error saying there are too many connections. Closing Management Studio and then re-opening it again will allow these changes to take effect.
May 28 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.