Login
Back to all discussion topics

Mono Support Unable to create database during install 

Viewed 104796 time(s), 7 post(s), 2/18/2011 10:06:05 AM - by rikkus

Related topics

rikkus
rikkus
2/18/2011 10:06:06 AM
75 Reputation 2 Total posts

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'."

1
denis
denis
2/18/2011 6:28:23 PM
7207 Reputation 956 Total posts

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?

2
rikkus
rikkus
2/21/2011 10:25:08 AM
75 Reputation 2 Total posts

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.

3
viniccus
viniccus
8/23/2011 9:10:42 PM
6 Reputation 2 Total posts

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

4
denis
denis
8/24/2011 11:31:37 AM
7207 Reputation 956 Total posts

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)

5
viniccus
viniccus
8/24/2011 4:58:47 PM
6 Reputation 2 Total posts

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!

6
denis
denis
8/26/2011 8:55:28 PM
7207 Reputation 956 Total posts

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.

7
This is a demo site for MonoX. Please visit Mono Software for more info.