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
Post a Comment