asp.net - Web Platform installer and sql express database setup -


I tried to install an amplifier with a web platform installer today.

When I have database setup, I have to fill some information such as "DB Admin User / Password" and user user name / password.

Using SQL Express I do not have a username / password (neither administrator nor user). How should I be able to install applications with WPI and SQL Express 2008?

Actually I had this error while trying to install the log:

  DownloadManager error: 0: MS deployment exception: Microsoft.Web.Deployment.DeploymentClientServerException: Database 'AmpliFeederDB' could not be created. --- & gt; System.Data.SqlClient.SqlException: User failed to login for 'sa' User is not associated with a trusted SQL Server connection.  

I finally got it through command line and regd fix.

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

Login Mode should be

Restart SQL Server Express Service.

Then: In the command line:

  sqlcmd -E -S. \ SQLEXPRESS (will login with window authentication mode) 1) Change password with password = '& lt; New_password & gt; 2) Go 1) Enable logging later 2) Go  

After this, you should try to install the application.


Comments

Popular posts from this blog

sql - dynamically varied number of conditions in the 'where' statement using LINQ -

asp.net mvc - Dynamically Generated Ajax.BeginForm -

Debug on symbian -