SQL2008 restoring the database cannot restore the problem

SQL2008 Restore the backup of the SQL2008. bak file will be an error, most of the reason is because the current login version is 2005, so you can not restore data backed up with SQL2008, the outcome is to remove the login name of the server after the suffix sqlexpress, login SQL2008, but directly login You may also see the following issue: Provide named pipe provider, ERROR40 error 2. This time is often due to the inability to start the Sqlserve service, enter the command line, enter services.msc into service management to find SQL services such as:

Right click here directly to start the service, if the start of the service is successful, you can directly use the above method to log in to SQL2008, if you do not directly start the SQL2008 service here, do the following:

(1) Open Configuration Manager in SQL2008 Configuration management tool:

It is possible that the TCP port number is empty, causing TCP/IP to not listen to port 1433, causing the database engine service to fail to start, this time only to change the TCP port number directly to 1433 is good, as follows:

If this is not possible, it may be because the VIA protocol is enabled because the VIA protocol also listens on port 1433, causing the data engine to fail to start, as long as the VIA protocol is disabled. As follows:

SQL2008 restoring the database cannot restore the problem