0

There are plenty of posts about this error but I could not solve my problem with the answers there.

I've made an app to run with SQL Server through Entity Framework. The app is running on my PC with no problem , but when I send it to someone he gets this error

Cannot open database 'StorageDb' requested by the login. the login failed , login failed for user 'DESKTOP-....../User'

I've read that it has something to do with my connection string but I tried to change it and still it does not work. Here it is (in my app.config file):

<add name="Storage.Properties.Settings.StorageDbConnectionString"
     connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=StorageDb;Integrated Security=True"
     providerName="System.Data.SqlClient" />

My DbContext file:

public StorageDbContext() : base("StorageDb")
{
   ....
}

I tried removing the string in the constructor or change it but still it doesn't work.

Stephen Kennedy
  • 20,585
  • 22
  • 95
  • 108
stubborn
  • 180
  • 1
  • 4
  • 14
  • Their user account does not have permission to access the server. Simple as that. Grant the account access. – Dan Wilson Apr 01 '18 at 20:51
  • How do I do that? – stubborn Apr 01 '18 at 20:53
  • Consider creating a database user for the application with db_reader and db_writer permissions. Then change your connectionstring to it; `connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=StorageDb;User Id=myUsername; Password=myPassword;"` – Frank Nielsen Apr 01 '18 at 20:54
  • Check this one out: https://www.youtube.com/watch?v=mwqo7kbUuWQ – Frank Nielsen Apr 01 '18 at 20:58
  • Your context needs to match the connection string name, try this `public StorageDbContext() : base("Storage.Properties.Settings.StorageDbConnectionString")...` – DavidG Apr 01 '18 at 21:03

1 Answers1

1

when you have Integrated Security=True in your connection string the application would use windows identity (of the logged in user) to connect to the database.

<add name="Storage.Properties.Settings.StorageDbConnectionString"
  connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=StorageDb;Integrated Security=True"  providerName="System.Data.SqlClient" />

So to solve the issue, you can either grant permission to the logged in user's account as mentioned in this post. or update your connection string to use sql server mode of authentication. e.g

<add name="MyDbConn" 
        connectionString="Server=MyServer; Database=pubs; User Id=MyUser; password= P@ssw0rd"
        providerName="System.Data.SqlClient" />

please refer this page or other msdn pages for details.

Senthil Kumar Mohan
  • 151
  • 4