I followed the steps to make a db backup for moving a site. I also entered the changes to web.config and compared my changes with the example file.  When I try to view my localhost site I get this error:

Keyword not supported: 'c:\dotnetnuke sites\dnn_460_pack_site\app_data\database.mdf;user id'.

I can't find any difference in what I entered in web.config and the example that causes this error. Please help.

Thank you,
Steve Easley

If you could post the entire configuration string, that might help.

Something like this:

connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"

Is what you are looking for, assuming that you are using the SQL Express version of SQL Server.

Do you have an update of 22 for Vista users? I cannot see how to specify security permissions for the database. When I recompile I get this message:

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

My webconfig connection reads:

<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Initial Catalog=databasesaicm.dbf; User Id=petersaicm; Password=[pwd];" providerName="System.Data.SqlClient" />

<add key="SiteSqlServer" value="Data Source=.\SQLExpress;Initial Catalog=databasesaicm.dbf; uid=petersaicm; pwd=¨[pwd]" />

Otherwise, the tutorial was marvellously clear.

You have to set the permissions inside of the database, so that doesn't have much of anything to do with Vista.

Do you have SQL Server Management Studio Express? If you don't you can download it from Microsoft's site for free and use it to manage SQL Server Express. You'll need to create a loginuser petersaicm and set the permissions.

Thanks. The message that I get is that the attempt fails because it is not a valid login or I do not have permission: error 15007.

My reason for suggesting an update for Vista was that I could not produce a screen matching your version on specifying security permissions.

Any help you can offer?

You need to create a valid login. To do that, you must have a login with privileges that will let you create additional logins. This is a MSSQL server issue.

ok, I am doing some vids on installing DNN with Vista.

before you attempt to transfer a live DotNetNuke installation to a local host website, I would ensure that you can install a fresh installation of DotNetNuke on your local computer, this will make troubleshooting issues much easier.

Regarding the ASP.NET reference, the security permissions you need to give on the folder are for NETWORK SERVICE.

Also,  rather than set up a virtual directory, you need to select the option of 'add application' - if you have already created a virtual directory you can convert it to an application. - Vista vids will be in the next release, which will walk you through how to install and configure all the software from a fresh installation of Vista.

Thanks,