Webconfig settings & aspnet_regsql.exe

[Dave]

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?

 

[Nicholas Paldino [.NET/C# MVP]]

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.

 

[Dave]

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?
--
L. A. Jones

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.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

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?