Few basic problems :(

[kicken18]

Hi,

I am not sure weather I should ask this in asp or .NET but I am using ASP.net 2.0 so I belive I should ask in here.

At the risk of anoying some people, due to my shear "nub-ness" I am having a few fundermental problems with my web application, which I think, once I have solved will mean my dev work can continue quicker. I am making an app and teaching my self the languge. I come from a PHP background, and I always try and think, php does it this way, but ASP seams to use VERY different ways, as I'm sure you all know.

So, I am creating a login page and have created this

<form id="loginform" method="post" runat="server">
<asp:Login
id="username"
runat="server"
DestinationPageUrl="AdminHome.aspx"
PasswordRecoveryText="Forget Your Password?"
PasswordRecoveryUrl="login.aspx" BackColor="Silver" BorderColor="Maroon" BorderPadding="4" BorderStyle="Solid" BorderWidth="1px" Font-Names="Verdana" Font-Size="0.8em" ForeColor="#333333" TextLayout="TextOnTop" Width="219px">
<TitleTextStyle BackColor="#990000" Font-Bold="True" Font-Size="11px" ForeColor="White" />
<InstructionTextStyle Font-Italic="True" ForeColor="Black" />
<TextBoxStyle Font-Size="11px" />
<LoginButtonStyle BackColor="White" BorderColor="#CC9966" BorderStyle="Solid" BorderWidth="1px"
Font-Names="Verdana" Font-Size="11px" ForeColor="#990000" />

</asp:Login>


and I see it, then I try loggin in, and I get:

An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 1802 and the SqlException message is: CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:\INETPUB\WWWROOT\WHO\APP_DATA\ASPNETDB_TMP.MDF'.
Creating the ASPNETDB_39df9275d5324993a9570cdd2329e6df database...


I am using MSSQL and IIS 6 and in my web.config


<connectionStrings>
<add name="WhoGetsWhatConnectionString1" connectionString="Data Source=DC\SQLEXPRESS;Initial Catalog=WhoGetsWhat;Persist Security Info=True;User ID=sql;Password=mypass"
providerName="System.Data.SqlClient" />
</connectionStrings>


Now, my login is correct, I use it everyday to login to my SQL server, but it doesn't want to create my login DB, I am very unfimilular with the whole web.config idea, I mean in php we have none of this its all mysql_connect then like get username get password verify, if correct adminhome.php if not correct login.php?failed something along those lines.

I hope I make my self clear, thank you for anyone that gives there time

Chris

[kicken18]

Ok, I managed to get my login page to create my ASPNETDB.MDF databse in the app_data folder BUT only by giving my DOMAINNAME\Users account full control access, not exactly secure lol.

Problem, when I logged in and it created my DB, I used my admin account administrator password thinking it would add this to the DB, but nothing I try, works.

Also, I tried opening the mdb database in SQL managment studio but says it cannoy read an mdf file, what do I use to read it to add users? Soo lost, I remember reading something about some .NET 2.0 web admin page, but I dont have that web admin page in my web site directory, how do I get that??

Thanks
Chris