sql 2005 windows authentication vs sql auth.
-
I'm having a problem pulling data from sql 2005 on my local machine in an asp.net 2 project. I've set up sql with windows authentication, and i've tried adding logins with sql authorization and rights etc. but to no avail. The connection finds the server, db etc. but gives an security/auth error when executing the query. Do I have to reinstall sql or what??? Regards, Tintin
-
I'm having a problem pulling data from sql 2005 on my local machine in an asp.net 2 project. I've set up sql with windows authentication, and i've tried adding logins with sql authorization and rights etc. but to no avail. The connection finds the server, db etc. but gives an security/auth error when executing the query. Do I have to reinstall sql or what??? Regards, Tintin
Hi! You have to set your SQL 2005 service to mixed mode authentication (do that in the property window of your server in management studio: Right-click your server in object explorer, Properties, Security, SQL Server and Windows Authentication mode). If you do not change to mixed mode you cannot use sql authentication. Regards, Rainer. Rainer Stropek Visit my blog at http://www.cubido.at/rainers