search

NullDesk / ticketdesk

TicketDesk - A simple and effective Issue Tracker for Help Desks
Microsoft Public License
258 stars 189 forks source link

Login failed #179

Closed ganniaiuei closed 5 years ago

ganniaiuei commented 5 years ago

After deployed the application on Azure, using a SQL Azure, I receive a "login failed" message using a user with db_owner rights on single database. (No database_creation rights) If I swap to a server administrator, the application works.

It seems the current user wants to access the master database. I've already created a database and so there is no need to access the master database.

ganniaiuei commented 5 years ago

The connection string should include Persiste Security Info = True and Trust Server Certificate = true to be able to connect to an Azure SQL with the sql client