dcsimg
www.webdeveloper.com
Results 1 to 2 of 2

Thread: SQL Manage Studio Express 2005/2012

  1. #1
    Join Date
    Nov 2004
    Location
    Hong Kong, China
    Posts
    15

    Question SQL Manage Studio Express 2005/2012

    Hi all,

    I have a SQL Server 2005 x64 install on a Domain DC,

    And now I need some Windows 7 Client can connect to it see some DataBase Table for development etc using.

    I am new on MS SQL.

    Since I don't want to open the DC admin and pw for this general user.

    How do I

    1. Add a "GENERAL User" account in MSSQL 2005 as read only to some DB with all table under this DB for safe reason.

    2. On client side Windows 7 x64, Do I just install the Express version SQL management Studio 2005, or 2012 for this user is okay for him to connect by above new user account and have a GUI interface to the MS SQL Server 2005?

    Thank you.

  2. #2
    Join Date
    Oct 2009
    Posts
    658
    On your SSMS create a user/login. Then set the permissions

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles