Post reply

Connecting problem

  • August 5, 2008 at 9:48 pm

    #93695

    hi all,

    I had problem in my sql server.

    In my PC i used different users accounts for my personal purpose. If i gave Admin prermission to Uers they can open SQL server 2000. But other users can't access SQL2000 (not admin permision users cant log to sql2000).

    Can anyone help me to solve HOW TO ACCESS SQL2000 for both kind of users .

    thanks

  • August 6, 2008 at 4:13 am

    #853697

    Did you create Logins in SQL server for the non-admin users?

    Sounds like the admin users can access SQL Server through the Built-IN\Adminstrators group while non-admin users have no login/user account in SQL server.

    [font="Verdana"]Markus Bohse[/font]

  • August 6, 2008 at 6:04 am

    #853743

    hi,

    How i can give permision for non admin users. ???

    Thanks

  • August 6, 2008 at 6:34 am

    #853754

    1) Open Enterprise Manager

    2) Select Security->Logins

    3) Right click on existing and select 'Properties'

    4) Select 'Database Access' if you want to grant them database roles or 'Server Roles' if they need to be granted Server-wide roles.

    That's for logins.

    Login maps to the database user:

    To manage permissions for particular user go to:

    1) Open Enterprise Manager

    2) Select 'Databases'

    3) Select your database

    4) Select 'Users'

    5) Right click on existing and select 'Properties'

    6) Click 'Permissions' and grant appropriate.

    Or check following article for t-sql commands to grant permissions

    http://www.mssqlcity.com/Articles/Adm/manage_users_permissions.htm

    Cheers, Max

    Check-out free open-source utility Sql Server Replication Explorer[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply