The problem that the create database permission is denied in the database 'master'

Today, we use LINQ to SQL to determine whether a database exists. If no database exists, it is automatically created.

Public partial class cms_dbdatacontext
{
Partial void oncreated ()
{
// Create a database if the database does not exist
If (! This. databaseexists ())
{
This. createdatabase ();
}
}
}

The following error occurs: the create database permission is denied in the 'master' database.

After reading the relevant information, we know that to run the SQL Server database, you must create a database under the instance. Whether it is directly created, appended, or restored, you must create a database under the instance.

Therefore, modify the connection string,

<Add name = "se_dbconnectionstring" connectionstring = "Data Source =. \ sqlexpress; initial catalog = se_db; Integrated Security = true; pooling = false; user instance = true "providername =" system. data. sqlclient "/>

After adding user instance = true, you can use the instance to successfully create a database.

Solution 2:

Assign the database administrator role to the user who logs on to the database. This error can also be solved. For example, in ASP. NET, a network service user accesses the database and can set the database role of this user as the database administrator. In short, ensure that the login user has the right to create, modify or delete the database.