Last post Feb 19, 2006 04:39 PM by jwadsworth
Feb 11, 2006 05:17 PM|Zolex|LINK
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 ?
Feb 11, 2006 09:34 PM|jwadsworth|LINK
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)?
Feb 12, 2006 08:35 AM|Zolex|LINK
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:
BTW: It seems you already helped me a lot last week, thank you for that. [:D]
Feb 12, 2006 11:37 AM|jwadsworth|LINK
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?
Feb 12, 2006 12:30 PM|Zolex|LINK
I run the aspnet_regsql util on the aspnetdb now and changed the connectionstrings to:
Source=K\SQLEXPRESS; User Instance=True; Initial Catalog=aspnetdb;Integrated Security=True"
connectionString="Data Source=K\SQLExpress; User Instance=True; AttachDBFilename=|DataDirectory|personal.mdf"providerName="System.Data.SqlClient"
But still no work, although the error changed to:
Cannot open database "aspnetdb" requested by the login. The login failed.
Login failed for user 'K\ASPNET'
Brrrrr, already 20 hours on this, I could have learned Chinese within this time [:)]
Feb 12, 2006 12:59 PM|Zolex|LINK
I clearly messed up the connectionstrings by modding it for almost 20 hours [:$]
I changed them back to:
connectionString="data source=.\SQLEXPRESS; Integrated Security=SSPI;
AttachDBFilename=|DataDirectory|aspnetdb.mdf; User Instance=true"
source=.\SQLEXPRESS; Integrated Security=SSPI;
AttachDBFilename=|DataDirectory|personal.mdf; User Instance=true"
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 ...
Feb 12, 2006 09:57 PM|jwadsworth|LINK
Feb 17, 2006 12:40 PM|snehalrana|LINK
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.
Feb 17, 2006 04:22 PM|jwadsworth|LINK
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.
Feb 18, 2006 01:10 PM|snehalrana|LINK
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
Let me know if you know the steps to do this.
Thanks much for your response. Keep up good work.
Feb 19, 2006 12:40 AM|jwadsworth|LINK
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.
Feb 19, 2006 06:57 AM|paggy4u|LINK
Feb 19, 2006 04:39 PM|jwadsworth|LINK
I have emailed you a link with the script I attempted to create.