asked on

User rights for Microsoft SQL Server 2005 Express Edition

I'm having difficulties accessing one (or more) databases within Microsoft SQL Server 2005 Express Edition. The application that is connecting with the database uses the [SQL-DMO] features, and therefor (so i have reed) the users must be sysadmin?

If i run the application under the administrator account the application is not having these difficulties. What other privileges should i give the users so they have the same privileges as the administrator without making them administrator!?

SOLUTION

tigin44

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Hemantgiri S. Goswami

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jrits

ASKER

I know how to create a user within SQL and how to grant them rights. The only thing is that even if i grant these user sysadmin rights the [SQL-DMO] error keeps comming. With the administrator account i do not have this issue. The administrator itself is bound to the group Administrators which is added to SQL by default, this group has been granted sysadmin right and nothing further.

If the users have the same privileges as the administrators, why do i still receive an error within the application saying i do not have sufficient rights? what else could i grant the users account besides sysadmin what gives them more access?

EugeneZ

you need to post the error..

..it maybe your application logic related feature (e.g. to check if user is 'sa' role member)

jrits

ASKER

there is no 'sa' role?

the available roles are:

bulkadmin
dbcreator
diskadmin
processadmin
securityadmin
serveradmin
setupadmin
sysadmin

however there is a sa user account but i cannot add a goup to an user account...

Unfortantly i do not have a specific error but i have attached the screenshot of the error
error.JPG

jrits

ASKER

Someone?

EugeneZ

sysadmin role <=> sa role

run the system proc below to see all logins (sa will be there):
exec sp_helplogins

ASKER CERTIFIED SOLUTION

EugeneZ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jrits

ASKER

Thanks for all the help! I'm sorry to tell that it did not solve the problem because the problem lies within the software itself. the software developer has brought out a new version which now works fine..

therefore i want to thank you by deviding points based on solutions and efforts.