SQL Manage Studio Express 2005/2012
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?
On your SSMS create a user/login. Then set the permissions
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)