Hi, I'm having some problems with users/connection strings for a SQL Server database though. Right now, I use SQL Enterprise Manager and add the ASPNET user with dbo permission and use a trusted connection and I'm able to access the database. The connection string looks like the following:
<add key="ConnectionString" value="server=localhost;Trusted_Connection=true;database=TASCBenef" /> But the ASPNET user should not have dbo permission (I understand this is a bad thing). But if I get rid of the ASPNET user on my database and create another user and give it dbo permission on my database and use a uid and pwd in my connection string, it doesn't work. Here is the connection string: <add key="ConnectionString" value="server=localhost;uid=healkar;pwd=password;database=TASCBenef" /> The error I'm getting is [SqlException: Login failed for user 'healkar'. Reason: Not associated with a trusted SQL Server connection.] I tried adding Trusted_Connection=true back to the string but then it tries to use the ASPNET user again?! [SqlException: Cannot open database requested in login 'PortalGS'. Login fails. Login failed for user 'HEALEY2002\ASPNET'.] If you can help, please reply. My hosting site requires that I NOT use the ASPNET user for my database access. Karen Healey [EMAIL PROTECTED] (508) 473-1218 You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
