dashCommerce

Hello ,

In the Installation Page I get this error :

A critical error has occurred: Login failed for user 'MHM'.

I made a database for DashCommerce ,

Created a user with the dbo  schema & the role of db owner

& I filled the information of installation pages with my data

but about password I dont know whether I had to set the password in the previous creation process 

or I am assigning a new password to my database , If I had to do that in the 1st phase

I dont know how could I do that in mssms . 

 

I am not very familiar with Sql Server Administration 

Are my checked Items about User & Security enough or not ?

How about the database password ? 

 

If I had any english problems , pardon me .

Thanks in advance for any help 

You may have added the user to SQL Server but you may not have given that user rights to that database. I presume your using management express. If you go into the database and expand the tree you will see an option for security. Expand security and then expand users, make sure you can see your login. If not right mouse click on users and add. You can also reset the password if you need to by going to security in the main tree branch then clicking on login, if you right mouse click go to properties you can reset the password. Also turn off "enforce password policy" Thanks, Matthew http://skiltzonnet.blogspot.com

Thanks for your advice ,

please consider that I have made 2 users ( MHM1 , MHM2 ) 

1. for MHM1 I set all the  roles ( for Test ) & the Login to : BUILTIN\Administrators
2. for MHM2 , I set the dbo role & the login to  a login that I made inside Database \ Security \ Login

        named MHMLogin with a strong password like k90000; 

 

When I used each of them I got the same error that I mentioned in the 1st post . 

Do I missed any step or isn't the approach right ?

please help me to get through it

Try giving the user DBowner status on your dasCommerce database.

I couldn'd get what exactly you mean by DBOwner Status , 

I gave the dbo role to MHM2 User ,

also the dbo user is under users group of the Database 

and I tested that too , I get the same error ,

I dont know whether I have to give the DB a password before proceding to this step or not ?

if so , How can I set a database password with Management Studio  ?

 thanks

SkyRunner 

 Yeah sorry DBO status is what the user needs.  You don't give the database a password you give the user a password, the password is the same one that you created when you added the user in management studio.

Try logging into management sudio using MHM2 using SQL Authentication not windows.

Thanks,
Matthew

Yes , I have done that , but there are still some problems & doubts :

1 . As I said , MHM2 user uses MHMLogin Login 

    when I want to connect with MHM2 & the password of MHMLogin the login fail ,

    but when I used MHMLogin with its password it seems that it connected with result of another error that I'll tell you in the bottom of this post

    relate to "Full-Text Search".

    If that is right so 2 doubts : a ) Why in the form it is said Database Password while we need a login password

                                            b) Why in the form it is said Database User Name instead of login Name

pardon me , if i'm really far away from the case , but with my understandings , I have problem to deal with these names like we have here

 -----------------------------------------------------------------------------------------------------

When I use login name & password I get this error :

        "    A critical error has occurred: Full-Text Search is not installed, or a full-text component cannot be loaded.    "

 

Mathew , really thanks for guiding me 

Well your database server needs to have full text searching installed.

Database password really means "Database Password for user"

Thanks,
Matthew

 

 Thanks again Mathew ,

Now I'm trying to bring "full text search " capability to my sql server 2005 .