Column problems after installing vs10

Source: Internet
Author: User

Remember: During the 08 installation, You need to customize an instance, for example, mysql2008 (you cannot use the default instance)

When installing SQL server 2008 express, the system prompts "An error occurred while restarting the computer ."
Delete the Registry key HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Session Manager \ PendingFileRenameOperations and try again.

You cannot call Invoke or BeginInvoke on the control before creating a window handle.

Turn on the process and turn off all SQL Processes

[Error message]
The creden provided for the SQL Server proxy service are invalid. To continue, provide a valid account and password for the SQL Server proxy service.

You need to set a password for the account you use. For example, you can set a password for ADMINISTRATOR.

SQL Server 2005 Express tool. To continue, delete the SQL Server 2005 Express tool.

Modify the Registry: HKLM \ Software \ Microsoft SQL Server \ 90 \ Tools \ ShellSEM. Rename ShellSEM.

---------------------

After the installation is complete, change the following in the Registry: ShellSEM

Over

Because I don't know how to install sql08, so does vs05.

Now sql05 08 vs 05 08 10 are available.

1. sql05 cannot be used directly (it means that the connection fails when the SQL window of 05 is used). If you want to use the database of sql05 to open the interface of 08, you can connect to the instance of 05 before, for example. (server name: Your computer name \ SQLEXPRESS

Note: At this time, your database was in

2. You want to use the sql08 instance. Server Name :.

Note: This is empty. Only the built-in database is available.

-------------------------

Result: now we can use the 08 interface to use the 05 instance and the 08 instance .. 08 powerful features .. what are the word prompts? What .... it's a blessing.

Sql2000 2005 2008 co-exist in order 00--05--08 00 with default instance 05 and 08 with the name of the Instance (of course the name is different) so that there will be no overwrite to coexist

Related Article

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.