Basics - Admin can log in but user cannot

Issue: Local user is unable to open Basics but the domain Admin can.

Option One:

1.Uninstall SQL Express and Basics.

2.Temporarily assign the user to the Administrator group in Windows.

3.Install SQL Express and Basics.

4.Verify that the software will open.

5.Move the user back to the Standard or Other group.

Option Two:

Open the program click on Start > Programs > Microsoft SQL Server 2005 > Configuration tools > SQL Server Configuration Manager  >  SQL Server 2005 Services > Right click on SQL Server (SQLEXPRESS), Properties  (see below)

Admin_Works_but_User_fails1.jpg 

 

From the Properties window click the drop down arrow next to Network Service and you have two options:

See these options on the next page…

  • If running the software as a Server-Client, select Network Service > OK.
  • If running the software as a Standalone, select Local Service > This Account > Browse.

Admin_Works_but_User_Fails2.jpg 

When the Select User or Group screen opens, click Advanced.

Admin_works_but_usere_fails3.png 

From the next screen click Find Now from this screen browse for and highlight the local user’s name and click OK

Admin_works_but_user_fails4.png 

When the Select User or Group screen reopens, the name will be indicated. Click OK.

Admin_works_but_user_fails5.jpg 

When the next screen opens, enter the password that the user uses to log into his/her workstation. Reenter it again to confirm it and click OK. Log out as the admin and log in as the user. You should be able to open the program without any problems.

Admin_works_but_usere_fails6.jpg

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.