MBR IT/.NET 247 : Need help with SQL Server and the ASPNET user on ASPFriends.com 'ngfx-sqlclient' list

Need help with SQL Server and the ASPNET user

Messages

Related Types

This message was discovered on ASPFriends.com 'ngfx-sqlclient' list.

Karen Healey

Hi,

I'm having some problems with users/connection strings for a SQL Server database. 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
Click here to reveal e-mail address
(508) 473-1218

Reply to this message...

Tim Musschoot

Hi,

I'm having some problems with users/connection strings for a SQL Server database. 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
Click here to reveal e-mail address
(508) 473-1218

Reply to this message...

Bill Swartz

Hi,

I'm having some problems with users/connection strings for a SQL Server database. 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
Click here to reveal e-mail address
(508) 473-1218

Reply to this message...

System.Data.SqlClient.SqlException

Ad

MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

	Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
	Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com