Hello,

I moved my website to my server (w2k with asp.net v2 and sqlexpress)

Now I connected the personal.mdf and aspnetdb.mdf to the sqlexpress.
Created a website in IIS and pointed it to the website folder.

I now get invalid value for key 'attachdbfilename'.

Any idea ?

Did you set the application you created in IIS to use ASP.NET 2.0 from the ASP.NET tab?

Also, can you post the connectionStrings section from your web.config without user names or passwords? In addition, what is the name of your database file (.mdf)?

In the meantime I did a lot of actions found on the internet to fix the problem.

Now I have following message when building the site (F5) from VisualWebdeveloper and when running it from the IIS at 127.0.0.1:

Login failed for user ''. The user is not associated with a trusted SQL Server connection

These are my connectionstrings:

Both connection strings should only be pointing to personal.mdf if you created the membership tables in that database. Did you run the aspnet_regsql utility on your personal.mdf or aspnetdb.mdf?

I run the aspnet_regsql util on the aspnetdb now and changed the connectionstrings to:

<remove name="LocalSqlServer" />

<add name="LocalSqlServer"connectionString="Data Source=K\SQLEXPRESS; User Instance=True; Initial Catalog=aspnetdb;Integrated Security=True" providerName="System.Data.SqlClient"/>

<add name="Personal" connectionString="Data Source=K\SQLExpress; User Instance=True; AttachDBFilename=|DataDirectory|personal.mdf"providerName="System.Data.SqlClient" />

Ok?,

I clearly messed up the connectionstrings by modding it for almost 20 hours

I changed them back to:

<add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS; Integrated Security=SSPI;
AttachDBFilename=|DataDirectory|aspnetdb.mdf; User Instance=true" providerName="System.Data.SqlClient" />

<add name="Personal"connectionString="data source=.\SQLEXPRESS; Integrated Security=SSPI;
AttachDBFilename=|DataDirectory|personal.mdf; User Instance=true" providerName="System.Data.SqlClient" />

And whoohoo, I have my asp.net configuration panel back now.

but when running the app...: User does not have permission to perform this action
Up to the next ...

Hi jwadsworth,

We have Windows 2003 server and IIS 6.0. We are successfully running ASP.NET 1.1433 but recently upgraded to ASP.NET 2.0 It installed successfully and it also shows up in the services but how do we find out that ASP.NET 2.0 is running as we don't see any 2.0 configuration tools under Administrative tools.

Any suggestions, tips or hints would help.

Thanks

Snehal Rana

If you right click on one of your virtual directories or websites and select properties, there should be a tab labeled ASP.NET. On this tab you can choose what version of ASP.NET to use for that site or virtual directory.

Hi jwadsworth,

We finally figured it out how to configure ASP.NET 2.0 for any site. We appreciate your quick response. Now we have another problem for converting our database from SQL express to SQL 2000. We have posteed this as a seperate question.

Let me know if you know the steps to do this.

Thanks much for your response. Keep up good work.

Snehal Rana

Snehal,

I have looked into this a little and I just don't know enough about database management to accomplish this. I believe that it can be done. I'm sure it is a matter of attaching the SQL Express database to SQL Server 2005 Management Studio and scripting all the necessary objects. Then running those scripts on a new SQL 2000 database. Next you would need to script the data and apply that to the SQL 2000 db. I just haven't done any of this because I've always had a DB Admin to do it. If you find a solution online to this issue, please post a link here. I have had others email this same request to me.

Paggy4u,

I have emailed you a link with the script I attempted to create.