___ ___ erkimt permission to create database denied by the database 'master' ______ qstntxt ___

I'm trying to migrate the database created automatically by Identity to control user authentication and this error appears:

%pre%

My connection string looks like this:

%pre%

With this same user (sa - who is the owner of the master database) and password I can create database normally through Management Studio, however when I try to create it through the migration of Visual Studio it gives this error. The user and password are correct, the user "sa" is allowed to everything in SQL Server. What can it be?

    
______ azszpr34984 ___

I was able to create. The error was in my connection string, in the Secutity User parameter. I changed it this way and it worked:

%pre%     
___

3

I'm trying to migrate the database created automatically by Identity to control user authentication and this error appears:

CREATE DATABASE permission denied in database 'master'.

My connection string looks like this:

<add name="DefaultConnection" connectionString="Data Source=LPG-11;Initial Catalog=LPGPonto.Models.LPGPontoContext;Integrated Security=True;user id=sa;password=xxxxxx" providerName="System.Data.SqlClient" />

With this same user (sa - who is the owner of the master database) and password I can create database normally through Management Studio, however when I try to create it through the migration of Visual Studio it gives this error. The user and password are correct, the user "sa" is allowed to everything in SQL Server. What can it be?

    
asked by anonymous 06.10.2014 / 14:52

1 answer

1

I was able to create. The error was in my connection string, in the Secutity User parameter. I changed it this way and it worked:

<add name="DefaultConnection" connectionString="Data Source=LPG-11;Initial Catalog=LPGPonto.Models.LPGPontoContext;Integrated Security=False;user id=sa;password=xxxxxx" providerName="System.Data.SqlClient" />
    
06.10.2014 / 15:08