Deploying database to azure error SQL72014

Question

I try to deploy a database to Microsoft Azure it generates this error .

Error SQL72014: .Net SqlClient Data Provider: Msg 40548, Level 16, State 1, Line 1 Granting CONNECT permission to the guest user in database 'ACS Database' is not permitted.

Although the guest user has connect permission.

Any help?

Do you use SQL Azure or SQL Server on VM?

Alex Belotserkovskiy
– Alex Belotserkovskiy

2016-05-10 18:05:11 +00:00
Commented May 10, 2016 at 18:05 — Alex Belotserkovskiy
– Alex Belotserkovskiy, Commented May 10, 2016 at 18:05

Dan Rediske · Accepted Answer · 2016-05-11 23:06:09Z

3

The situation you described is fairly vague- so I cannot be sure why you're seeing this error or what circumstances could be causing you to see it.

However, you should avoid using the guest user for user databases as a best practice; you should instead Grant permissions explicitly to avoid the situation where every user that logs into your database has access (and any other permission guest has) to this database.

edited May 11, 2016 at 23:06

answered May 11, 2016 at 23:00

Dan Rediske

8524 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Deploying database to azure error SQL72014

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related