Web Platform installer and sql express database setup

Question

I tried to install Amplifeeder today with the Web Platform Installer.

When I arrived at the database setup I had to fill out some informations like "db admin user/password" and user username/password.

Using SQL Express I do not have any username/password (neither admin or user). How should I be able to install applications with the WPI and SQL Express 2008 ?

Basically I had this error while trying to install in the logs :

DownloadManager Error: 0 : MS Deploy exception: Microsoft.Web.Deployment.DeploymentClientServerException: The database 'AmpliFeederDB' could not be created. ---> System.Data.SqlClient.SqlException: Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.

Answer 1

When you install SQL Server Express for the first time, you would have had option to select authentication mode, where you would select MIXED mode authentication and provide admin authentication details.

Answer 2

I finally achieved this by command line and reg fixes.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQLServer

LoginName must be 2

restart SQL Server Express service.

Then : In command line :

sqlcmd -E -S .\SQLEXPRESS (will login with windows authentication mode)

1) ALTER LOGIN sa WITH PASSWORD = '<new_password>'
2) GO
1) ALTER LOGIN sa ENABLE
2) GO

It should do the trick to install the applications after.

Answer 3

Well, the SQL Server Management Studio Express provides a more sustainable solution. See this link, without having to fiddle with registry keys & running commands:

http://www.knowledgesutra.com/forums/topic/61695-resolving-cant-login-to-sqlexpress-using-sa-account/