I have done this procedure dozens of time on different machines, but now I am getting  “ Login failed for user 'jkirkman'” when I try to browse to the localhost installation of my live web site. The SQL Express 2008 log file says

Login failed for user 'jkirkman'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: ]

I have spent three days trying to get this to work, could anyone help me.

Thanks,
Johon

Sure.

This is a message about DotNetNuke's attempt to connect to the database. The connection string is in your web.config file.

You connection string specifies a username and password to be used to log into the database server. The message says that the database server is configured "for Windows authentication only." That means, it's not going to take a username/password.

The solution is to configure your database server for "Mixed-Mode Authentication." Here is a link:

http://www.hostmysite.com/support/v...mixedmode/

Joe,

Thank you very much for your reply. I am just  about to pull my hair out..whats left!

I am still having trouble connecting to the database. 

I have change to mixed modes on SQL Express and am receiving the following error messages:

'http://localhost/fumcparistxorg/Install/UnderConstruction.htm" target="_blank" rel="nofollow">http://localhost/fumcparistxorg/Ins...uction.htm

This Site is currently unavailable

"http://localhost/fumcparistxorg/

Login failed for user 'jkirkman'.

The latest steps I have done:
1. Deleted everything from local machine including database from SQL Express and ISS
2. Backed up live site and data base
3. Followed tutorial exactally in the order presented
4. Actually used your sample web.config file changing database, user and password. Also had to comment out HTML sections.
5. Same errors: either Site unavailable or failed to log on.

I am sure it is something very simple, but I have not clue where to  go.

I really appreciate your help.

John

 

Make sure that you can login with SQL Server Management Studio Express.

Also, if your live site is using SQL Server and your localhost is using SQL Server Express, you will need to use a different connection string.

Joe,

I can log in with SQL Management with no problems. This is my current connection string.

John

<connectionStrings>

<!-- NOTE: HERE IS AN EXAMPLE CONNECTION STRING FOR THE LOCAL WEBSITE USING SQL SERVER EXPRESS 2005, AFTER ATTACHING THE DATABASE

TO SQL SERVER EXPRESS -->

<!-- Connection String for SQL Server 2005 Express -->

<add

name="SiteSqlServer"

connectionString="Data Source=.\SQLExpress;Initial Catalog=DNNFUMC2;User ID=jkirkman;Password=flower"

providerName="System.Data.SqlClient" />

<!-- Connection String for SQL Server 2000/2005 -->

<!-- -->

connectionStrings>

<appSettings>

<!-- NOTE: HERE IS AN EXAMPLE CONNECTION STRING FOR THE LOCAL WEBSITE USING SQL SERVER EXPRESS 2005, AFTER ATTACHING THE DATABASE

TO SQL SERVER EXPRESS -->

<add key="SiteSqlServer" value="Data Source=.\SQLExpress;Initial Catalog=DNNFUMC2;User ID=jkirkman;Password=flower"/>

<!-- -->

Something I do when I transfer a live site to a localhost installation which you may want to try:

When you create the database using the backup of your live database, also create a new user for accessing the database (only in your local SQL Server)

Give the new user full database owner privileges to the dnn database

Then adjust your connection strings in your web.config file to use this new user that you have created.

This can get around problems when restoring a backup database and the user not having correct permissions to access the database.

Thanks,

PS. I would also recommend if you are running DotNetNuke on your local computer that you use virtual PC:

How to setup and use Microsoft Virtual PC 2007

This can save a lot of headaches as you can setup with just the programs you need for running DotNetNuke.

Gentlemen,

I have heard you reference a 3rd-party module now available that will seemlessly synchronize local and live installs on a scheduled or as requested basis. Did I just dream of this or would you please point me in the right direction. (Redgate is cost prohibitive for our small operation.)

Many thanks,

Christian

I'm not aware of suchna module. There is an Enterprise Version of DotNetNuke that does content staging, but that is a more expensive option.