access aspnetdb.mdf with user aspnet

[bbxrider]

can somebody please help with permissions hell needed to access the vstudio generated db, aspnetdb.mdf by the aspnet user. I have invested over 8 hours into this.

i followed these procedures,

http://msdn.microsoft.com/en-us/library/e2t54ss5.aspx

and copied the db from the vstudio app_data folder to the IIS app_data folder (and the .ldf)

this app is a vstudio generated login control, it works OK in the vs environment. i get this error after moving the app and the db to IIS, Login failed for user 'myPC\ASPNET'.

this is a testing environment, i need to get this working before I move the app to a production server, where the user will be IIS IUSR_MACHINEID

 

[NoCoolHandle]

wrong forum.. this should be posted to aspnet..


1st question. Is sqlexpress installed on the server?
2nd q.. what does your connection string look like.

 

[bbxrider]

1st question. Is sqlexpress installed on the server? yes, that is how the procedures in the post link were done

2nd q.. what does your connection string look like. evidently the connection string is not the problem, see below for solution but here it is anyway
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=C:\Inetpub\

http://wwwroot\App_Data\aspnetdb.mdf;User

Instance=true"
providerName="System.Data.SqlClient" />

after way too many hours to find the solution, this is one that works anyway, run the script below after user aspnet has been added to the server instance and the db itself, it created. it addes roles permission for aspnet_roles_basicAccess + fullAccess + reportingAccess


use [master]
go
grant connect sql to [pcName\ASPNET]
go

 

[JoeAtWork]

evidently the connection string is not the problem

Well actually it is since it specifies to use integrated security, so that means the account that the process is running under (ASPNET) needs to be given permission to the database. The way to do that is as you described in your solution.