Mono 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.

Mono Support Unable to create database during install 

Viewed 41692 time(s), 7 post(s) 2/18/2011 10:06:05 AMby rikkus
rikkus
1

rikkus 2/18/2011 10:06:06 AM

On the page Installer/SQLInfo.aspx I select my SQL Server instance (FOOL\EIGHT) and enter 'sa' and the password, then on the next page enter 'monox' for the database name and ask for a blank database.

After pressing 'Finish', the log states: "Cannot open database "monox" requested by the login. The login failed. Login failed for user 'sa'."

I tried creating a 'monox' user for SQL server, gave it password 'monox' and checked that login worked using osql.

Again, after pressing 'Finish', I get: "Cannot open database "monox" requested by the login. The login failed. Login failed for user 'mono'."
This content has not been rated yet. 
75 Reputation 2 Total posts
denis
2

denis 2/18/2011 6:28:23 PM

Hi,
You said that you opened a "monox" user, while the error refers to the user "mono" (without x). Is it only a typo? If not, could you please open the SQL Management Studio, click on the Security/Logins - monox user, right click, Properties and click on the User mapping in the popup screen that is opened. Check the db_owner role in the Database role membership for: monox pane. Does it change anything?
This content has not been rated yet. 
7147 Reputation 932 Total posts
rikkus
3

rikkus 2/21/2011 10:25:08 AM

Sorry, yes, it was a typo.

I gave up using that method and used WebMatrix's gallery to install. This seems to have worked fine, thanks.

This content has not been rated yet. 
75 Reputation 2 Total posts
viniccus
4

viniccus 8/23/2011 9:10:42 PM

Hello!

I am trying to create a website on MonoX but I am on little troubles.
So, I have some questions that I believe will solve my problems:

1. In this system, I have a pre-defined user and password (database) to fill the boxes?

If no, I put any passwod and any user, but when I click FINISH, an error shows up.

3. When I choose "select existent database", MonoX runs OK, but stay crashed (do not continue, stay loading...)
4. Hm, that's a nwebie question: in MonoX, it request me to select a database. I need to create it or when I installed MonoX, I have a database in my PC?

Sorry for any troubles in english, I am from Brazil.

THANK YOU FOR ALLLL THE SUPPORT! MAY GOD BLESS YOU!

Bye,
Vinicius
This content has not been rated yet. 
6 Reputation 2 Total posts
denis
5

denis 8/24/2011 11:31:37 AM

Hi,
there are no pre-defined user names and passwords - you have to have enough privileges on your SQL server instance to access it.
The installation process is explained in the user's manual. You need to have the SQL server installed on your machine (or another machine that can be accessed from you machine), create an empty database in it (using the SQL Server management tools), and than run the MonoX install.
Alternativelly, you could use the installation from thje Microsoft Web gallery (click here)
Rated 5.00, 1 vote(s). 
7147 Reputation 932 Total posts
viniccus
6

viniccus 8/24/2011 4:58:47 PM

Hi Denis!

Thank you so much for the support. But, in the box "location of sever database", I need to put what? A folder in my computer?

Thank you!
This content has not been rated yet. 
6 Reputation 2 Total posts
denis
7

denis 8/26/2011 8:55:28 PM

I guess that you are referring to the box in he SQL Server Management Studio, since there is no such box in MonoX installation... in that case, yes, you should enter the folder in which the physical database files (,mdf and .ldf) will be kept.
This content has not been rated yet. 
7147 Reputation 932 Total posts