Hi everybody,
I have sql server 2008 express database and using visual studio 2008 to develop the web site and have to use custom membership provider and custom role provider.When I use Website administarion Tool to create the roles and users it gives the following error
Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS2008\MSSQL\DATA\WLDatabase.mdf". Operating system error 5: "5(Access is denied.)". Cannot attach the file 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS2008\MSSQL\DATA\WLDatabase.mdf' as database 'WLDatabase'.
what should I do?
Or shouldn't I use this tool?
How exactly to impliment custom mebership/Role providers ?
Please some body help me.
Thanks,
Shobha
shobhaPosted Jan 7, 2009, 9:56 AM
Thanks...I will try reinstalling........
Thanks again,
Shobha
Manuel BPosted Jan 4, 2009, 6:52 AM
Hi,
I had a similar problem in SQL2005express because I named my instance something different from .\SQLEXPRESS. I was not able to solve this problem except by reinstalling sql2005 express with the default name (no way found to rename instance in express edition....). I think your error is because the connection string and relating permissions for the "users and roles" db are specific and when app starts it cannot find the ASPNETdb in the expected instance/path etc.
I am new to programming and was not able to find other workaround.
This video you might find usefull.....
http://www.asp.net/learn/videos/video-06.aspx
Hope this is better than no answer