Hi all!

in an ADP project i struggle to manage security.
I want to create a new Sql Server login that would only have the right to read data on a specific database, and nothing more.
So, in the security section of the project (connected with sa) i created a new login with no server role. I gave to the login the public + db_datareader roles on the specific database.
But when i test the new connection, i have the following error :
"Test connection failed because of an error in initializing provider. Autorisation CREATE DATABASE refused, database 'master', owner 'dbo'".

Any tips would be appreciated...

Regards