MonoX support board

Start the conversation, ask questions and share tips and solutions with fellow developers.

Non-registered users can only browse through our support boards. Please register now if you want to post your questions. It takes a second and it is completely free. Alternatively, you can log in without registration using your credentials at major sites such as Google, Microsoft Live, OpenId, Facebook, LinkedIn or Yahoo.

Problem installing MonoX in Webmatrix : Database login fails  (Mono Support )

Viewed 10185 time(s), 2 post(s) 4/17/2011 5:38:09 AMby unnamedfeelin
unnamedfeelin

unnamedfeelin

4/17/2011 5:38:36 AM
Hi,
I have MS SQL Server 2008 R2 installed and I created a new empty database there. Then I downloaded MonoX from web matrix and tried to install it but failed.
MonoX couldnt log in to amy database. It says.... database log in failed for user 'abc...' !

I'm attaching my log file. Check it and suggst me...what should i do...n how to configure my MS SQL Server.
This content has not been rated yet. 
16 Reputation 1 Total posts
khorvat

khorvat

4/18/2011 7:39:53 AM
Hi,

as we can see from your log it seems that you have tried to create a database with Webmatrix and the user you specified didn't have the permission to create a database.

The database 'Coolschool' could not be created. ---> System.Data.SqlClient.SqlException: Login failed for user 'tanvir'.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

Creating empty database for MonoX is required only when you are installing via MonoX Web installer. When you try to install MonoX with Webmatrix or WPI then they try to create a database for you and therefor the sql user needs to have the proper permissions.

Can you please check that permissions for the specified user and get back to us with the result ?

Regards

The database 'Coolschool' could not be created. ---> System.Data.SqlClient.SqlException: Login failed for user 'tanvir'.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

The database 'Coolschool' could not be created. ---> System.Data.SqlClient.SqlException: Login failed for user 'tanvir'.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

This content has not been rated yet. 
15993 Reputation 2214 Total posts