Hi there,
I'm getting a "Login failed for user 'yadda'" while stepping through my ASP.NET code; it breaks when I try to open a connection to SQL Server. 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:
Code:
<appSettings>
<add key="conn" value="Persist Security Info=False;Initial Catalog=Nurse Education Modules;Data Source=(local);User Id=Nurse;password=nurse;" />
</appSettings>
Here's how I configured the Login account: Under Logins in the Security folder I created a login called "Nurse".
I chose 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 creating 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.
Does anyone have any idea what's going wrong??
Thanks,
J
Setting SQL Server 2000 access permissions / Syste
