473,396 Members | 1,915 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

MS SQL Management Studio-error at startup

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
1 2295
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

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

Similar topics

0
by: mia456789 | last post by:
I am trying to setup the mysql clustering , I hv followed the manual to setup it , but when start the management server ( ndb_mgmd ) , it pop the below messages , I didn't add any parameter when...
4
by: John Baker | last post by:
Hi: I know MDM.EXE (Machine debug manager) is important in debugging scripts, and that it is installed with MS office. However does it have to be on the startup menu? That is, does it have to be...
5
by: alex | last post by:
Hi, I want to store user preferences in an inifile and load these at startup. - there may be different users accessing the same applicaton on a pc What is the best way of doing this in vb.net...
1
by: ValK | last post by:
Hello, I’m using a multithreaded windows service to listen a file directory and process TIF documents. For example if user drops 3 files to the directory, “fileSystemWatcher_Created”...
16
by: Pedro Graca | last post by:
I have a file with different ways to write numbers ---- 8< (cut) -------- 0: zero, zilch,, nada, ,,,, empty , void, oh 1: one 7: seven 2: two, too ---- >8 -------------- ...
2
by: traceable1 | last post by:
I installed SQL Server Enterprise 64-bit. The installation seemed to go fine, except the only thing listed under "MicroSoft SQL Server 2005" is "Configuration Tools" in the startup menu. I have...
4
by: =?Utf-8?B?V2FubmFiZQ==?= | last post by:
Is it typical for an 2.0 application take 15 - 20 seconds to start up, after a long period of inactivity? If not, what can I look at to get it to start quicker, the first time it is used?
1
by: erict1689 | last post by:
I am writing this program in which I open up a file and update that information but to a new file. I already have a global variable for it but how do I go about creating an openable file in the...
1
by: hardness | last post by:
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...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.