Installation of mssql2008 and start-up problems and solutions

Source: Internet
Author: User
Tags management studio sql server management sql server management studio

(i) Error when installing SQL Server 2008: An earlier version of Microsoft Visual Studio 2008 was installed on this computer. Please upgrade VS2008 to SP1 before installing SQL Server 2008.  This error is still indicated after downloading the VS2008 SP1 installed. Workaround: Modify the registry: Run the registry, locate the directory hkeylocalmachine/software/microsoft/devdiv, and rename the DevDiv. After the SQL installation is complete, remember to restore the directory you just renamed to avoid affecting other programs.  You will then find the DevDiv directory that existed after the SQL installation is complete, rename it again, and restore the first rename to DevDiv. After the installation is complete, nothing is done ...
Open SQL Server Management Studio, (ii) If you enter the server name using ".", "127.0.0.1", "localhost", using Windows Authentication, cannot log on. First confirm that the database SQL Server service started properly, if you can not log on to the server name to [computer name \SQLExpress] (choose "Browse more" selection) will be able to log on. :) (c) Import the local server registration file that was exported before, and the result is wrong to import the times. Each subsequent boot is an error. System.Security.Cryptography.CryptographicException: This item is not suitable for use in a specified state.

If you click Continue, SQL server Management Studio 2008 can run, but the Registered Servers tab does not show anything and cannot do anything.

After searching the Internet, the simplest solution is:

Found: \ c user \[user name]\appdate\roaming\microsoft\microsoft SQL server\100\tools\shell\

2. Rename Regsrvr.xml to Regsrvr.back

3. Restart SQL Server Management Studio 2008 and the error message will no longer appear.

I installed on the win 7 system.

Reference:

http://blog.csdn.net/eric88/article/details/8947558

Http://blog.sina.com.cn/s/blog_43c38d4f01018rwx.html

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.