I try to configure the sql server I do the ff:
1. I open the SQL Server Management Studio Express
2. I connect using Windows Authentication
3. Under Databases folder where my database was there.
4. I click the plus sign on Databases
5. Then my dbtest was appearing and I click the plus sign.
6. On Security folder I click the plus sign
7. Then the Users folder was appear
8. I right click on the DOMAIN\SQLServer2005MSSQLUser$COMPUTERNAME$SQLEXPRESS.
9. On the General Tab-> Ownded Schemas I try to check the db_accessadmin and also I accidentall check the checkbox of db_owner and db_securityadmin. And Role Members I check also the db_accessadmin.
After that I reboot the server.
Then i run again my webpage.
And the result is:
Cannot select DB
Before I configure my sql server the output of my codes is:
MSSQL error.The several principal "[domain name]\IUSR_[computer name]" is not able to access the databse "database name" under the current security context.
After that I configure again my sql server to uncheck the checkboxes that I checked before. And I don't know why on the Owned Schema the checkboxex that I check was hiding so I can edit it, but on the Role members I uncheck the db_accessadmin.
I don't have any idea to fix my error: I really needed to fix it but I don't know what to do and I'm a little bit scared to configure the sql server, because I am new user of it.
:(
