Webconfig settings & aspnet

Webconfig settings & aspnet_regsql.exe

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 20 Jan 2008 14:54 GMT

I am using VS 2005 and SQLSERVER 2005. I had run the aspnet_regsql.exe, to
use a different db from ASPNET.MDF. I have done that without any problem. I
am setting up ASP.NET Configurations. After clicking Web Site -> ASP.NET
Configuration -> Security, I get the error msg:
" Login failed for user ''. The user is not associated with a trusted SQL
Server connection. "
When I click Web Site -> ASP.NET Configuration the Current User Name is
JONESMACH\HP_OWNER.
I have attached my DB (RetailDB.MDF) to Server JONESMACH using MS Mngmt
Studio(MSMS). I know I need to give permission to the user. I have read
several articles. They also talk about adding a Login. I get stuck here
because my computer is not part of a domain. My webconfig is below:
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=JONESMACH;
Integrated Security=false;Initial Catalog=C:\...\RETAILDB; User
Instance=True; " providerName ="System.Data.SqlClient"/>

What am I doing wrong?

Signature

L. A. Jones

Reply to this Message

Nicholas Paldino [.NET/C# MVP] - 20 Jan 2008 16:32 GMT

Dave,

It seems that you do not have the SQL Server set up with a user
associated with the JONESMACH\HP_OWNER user that the website is running
under. You need to configure this user in the security settings for the SQL
Server (and for your database) and it should work.

Signature

- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard.caspershouse.com

>I am using VS 2005 and SQLSERVER 2005. I had run the aspnet_regsql.exe, to
> use a different db from ASPNET.MDF. I have done that without any problem.
[quoted text clipped - 15 lines]
>
> What am I doing wrong?

Reply to this Message

Dave - 20 Jan 2008 18:17 GMT

I've tried to set up SQL Server with a user associated with the
JONESMACH\HP_OWNER unsuccessfully. Could you point me to some resource? Why
does the error not occurring with the default ASPNET.MDF DB? Isn't it running
under JONESMACH\HP_OWNER?

Signature

L. A. Jones

> Dave,
>
[quoted text clipped - 22 lines]
> >
> > What am I doing wrong?

Reply to this Message

Webconfig settings & aspnet_regsql.exe

Free Magazines