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.

Failing to install  (Mono Support )

Viewed 50155 time(s), 15 post(s) 11/29/2011 8:21:45 AMby mattbutler
mattbutler

mattbutler

11/29/2011 8:21:45 AM
Dear MonoX support,

I fail at every attempt to install MonoX from the Microsoft Web Install package with the following message:

Cannot connect to the database ''.
Login failed for user 'sa'

I'm reasonably clueless and need an idiots guide I think. Can you pont me in the right direction?

Many thanks,
Matt
This content has not been rated yet. 
45 Reputation 7 Total posts
khorvat

khorvat

11/29/2011 3:15:02 PM
Hi,

can you please check the version of MonoX that you are installing and get back to us with that. Also you need to be sure that you have created an empty database and that you have gave the "sa" account owner permissions to this database, please confirm this ?

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

mattbutler

11/29/2011 9:58:33 PM
Hi - many thanks. It's been v4.1.2741.40 from the MS Windows Web App Gallery from within Web Developer Express 2010.

I created an empty database and pointed the set up at it (I thought) but problems persist. I really do need an idiots guide as complete newbie - even that term is new to me!

Cheers,
Matt
This content has not been rated yet. 
45 Reputation 7 Total posts
khorvat

khorvat

11/30/2011 8:18:45 AM
Did you allow the "sa" user to access the database with the owner role ?

Note: You can create a new user for this operation as "sa" is system user account and it isn't a best practice to use that account, or maybe you can use Windows Authentication - your windows account.

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

mattbutler

11/30/2011 5:25:53 PM
Hi - many thanks,

The problem is I am a complete idiot. I haven't got a clue what you're talking about. My situation is I am doing this alone on my home PC. I don't need/want to set up any roles or passwords or anything at the moment I just want to see what this software does. I may well be too thick to operate it. I must be using 'windows authentication; because I am using windows 7? When I chose to overwrite an existing database (?) it gave me a user ID od Monox (as in case above) and the log records:

Using connection string: 'server=.\SQLEXPRESS;database=MonoX;uid=Matt;connect timeout=90'
DownloadManager Error: 0 : System.InvalidOperationException: Cannot connect to the database ''.
Login failed for user 'Matt'.

Perhaps I called myself Matt - I don't recall. What am I doing wrong?

Regards,
Matt
This content has not been rated yet. 
45 Reputation 7 Total posts
mzilic

mzilic

12/1/2011 4:49:25 PM
Hello,

Unfortunately due to the way Web Platform Installer works it requires SQL Authentication Mode to be used when performing software installations. The message you receive from the Web Platform Installer means that the actual 'sa' account password and the password you entered in the 'Database Administrator Password' textbox (in the Web Platform Installer Wizard) do not match.

You are also not required to create an empty database for MonoX installation via Web Platform Installer the program does that for you.

Please refer this article how to install MonoX using Web Platform Installer. You will be interested in the 2nd part of the article.

Regards
This content has not been rated yet. 
2218 Reputation 300 Total posts
mattbutler

mattbutler

12/2/2011 8:12:37 AM
Thanks Mzilic. I'm afraid I don't understand SQL Authentication. How do I determine the 'sa' user account so these passwords match please? I have no idea what it is or how to find it out. Did I set it when I installed SQL? Should I re-install? I am doing this on my Windows 7 laptop and there are no other parties in this set up other than me.

Any further help much appreciated,

Regards,
Matt
This content has not been rated yet. 
45 Reputation 7 Total posts
mzilic

mzilic

12/2/2011 9:49:36 AM
Please refer this article how to change Server Authentication Mode and how to change "sa" account password.

Regards
This content has not been rated yet. 
2218 Reputation 300 Total posts
khorvat

khorvat

12/6/2011 1:55:20 PM
Did you manage to install the MonoX ?

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

mattbutler

12/6/2011 10:13:44 PM
Afraid not Khorvat. I have persevered and tried to follow instructions but am stillgetting same message:

Cannot connect to the database ''.

Login failed for user 'sa'

What to do????


Matt
This content has not been rated yet. 
45 Reputation 7 Total posts
1 2