Setting SQL Server 2000 access permissions / System.Data.SqlClient.SqlException
Posted on 2006-05-12
I'm getting a "Login failed for user 'yadda'" while stepping through my code. It breaks when I try to open a connection to the DB. I've double and triple-checked my connection string (which is initializing, no problem there I don't think) and my permission settings in my DB.
Here's my connection string:
<add key="conn" value="Persist Security Info=False;Initial Catalog=Nurse Education Modules;Data Source=(local);User Id=Nurse;password=nurse;" />
In SQL Server, under Logins the Security folder, I created a login called "Nurse".
I checked SQL Server Authentication and entered a password (as reflected in my connection string). I also specified the proper DB to be used. In the "Database Access" tab, I checked 'Permit' beside the relevant DB.
After created the Login, I went to 'Users' in the DB itself. Under 'Database role membership' I checked 'public', 'db_datareader' and 'db_datawriter'. Then, I clicked on the Permissions button and ensured that SELECT, INSERT, UPDATE and DELETE were checked for the tables I have.
So far, I'm still running into problems.
Thanks in advance for any help,