Vs10 Some column problems after installation _mssql

Source: Internet
Author: User
Remember: When 08 is installed, you need to customize an instance such as: mysql2008 (cannot use the default instance)

SQL Server 2008 Express installation Prompt "reboot computer failed
Remove the registry key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations, and then try again.

You cannot invoke invoke or BeginInvoke on a control until you create a window handle

Open process turn off all SQL processes

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

The account to be used to set the password, such as the administrator set a password, so fill it up on the

SQL Server, Express tool. To continue, remove the SQL Server Express tool.

Modify the registry: HKLM\Software\Microsoft\Microsoft SQL Server\90\tools\shellsem, rename the Shellsem.

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

After the installation is completed, change the registration form to this: Shellsem

Over

Because when we install SQL08, I don't know what's going on vs05.

So now it's sql05 vs 05 08 10.

1.SQL05 is not directly used (refers to the 05 SQL window connection will fail) to use the SQL05 database to open 08 of the interface before the 05 of the instance can be for example. (server name:) Your computer name \SQLExpress

Note: At this time, your database is at 05.

2. Want to use the example of sql08. Server name:.

Note: This is empty only the system has its own database

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

Results: Now you can use the 08 interface for 05 instances and 08 of the examples how wonderful it is. 08 function is very powerful. What words hint ah what what .... A blessing in disguise.

SQL2000 2005 2008 Coexistence in order 00--05--08 00 with the default instance 05 and 08 with a named instance (name of course not the same) so that there is no overwrite will be able to coexist

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.