Problem with new Sql Login Creation in an ADP project

[HowardIsHigh]

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

 

[edwilli]

Do you have the latest service pack installed for Office? The initial release of Office 2000 was kind of buggy when it came to identifying objects off a SQL Server. It kept telling me my objects didn't exist. Installing the service pack fixed this problem.

 

[cmmrfrds]

Just use permissions on the database you want the user to work with. I believe sql server needs to write information to it's own database/system tables for all logged in users so don't take away that permission. Somehow you have taken away the permission of sql server to write to the master database for that login. You can restrict the new role by giving only read permissions on the objects i.e. tables, stored procedures, views, etc...