Several types of database msqlserver and solve the problem that MSSQLServer service can't start

Since 08, after learning SQL Server database, it has been thought that SQL Server only version of the distinction, no type of difference; always think from Sql2000, sql2005 to sql2008, sql2012, Microsoft Export database, only version upgrade, There's nothing else. In fact, the database we use most often is described as follows:

I. SQL Server Express

This database is a fee-based database that we used to manage through the SQL Server Studio management Manager. It creates a database that has two types of files:. MDF database file and. LDF, must be attached to SQL Server Express in order to access it.

Also, each time you start the database manager, you must open the appropriate DB instance service. ：

This service instance is available by default at the time of installation.

Recently encountered a problem in the company: This is the service prompt error. or MSSQLServer service has not been able to start.

My idea of solving this problem is: first check the computer's log, and then according to the log prompt, to Baidu. No matter how to find, there is no solution. However, I operate the application need to use the database, although, I know that there are other databases can also be implemented, such as Access,sqllite, but after all the use of MS SQL Server for many years, said to change a database, it is still a little reluctant. Suddenly found another kind of free database.

Second, LocalDB      

LocalDB is created specifically for developers, it's very easy to install, almost no management, compatible with the T-SQL language, programming interfaces with SQL Server Express indistinguishable.

with LocalDB, developers don't need to install and maintain a large instance of SQL Server on their notebooks. In addition, the LOCALDB is also suitable for small application environments where developers can use it for small production environments or embedded environments.

Discover the reason is, recently looked at VS2012 in the MVC4 example, can register and login directly, and modify account operation. So, the database comes with it. Look up the source code folder, sure enough. Only one of them. MDF file.

However, the direct use of VS built database, after all, not very good management. When I was in Baidu, I found someone to compare it with another lightweight database.

Third, the SQL Compact

I happen to have a problem with the database local service instance, and I don't want to build a test database on the company's server, so I want to build a database directly in SQL Server Management Manager. Because before using LocalDB, met the compact, Baidu a bit. But not much attention, do not know how to use.

This time in order to solve the problem mentioned above, "MSSQLServer service has not been started", I re-use the database installation files, installed a SQL Server R2 version, a new MSSQLServer2 instance, the success of the corresponding service can be started. However, when I connect, the use of either localhost or the. Number is not connected, and the server name is not available. And then the blind thought for a while, found that SQL Server login interface, servers options, there is a "network server" option, point open, after loading, see the new MSSQLServer2 instance, so checked, connected. Haha, it's done.