Testing Database Access with SQL Server Management Studio Express

< Previous section  |  Table of Contents  |  Index  |  Next section >

If you don't have Microsoft Word on a particular system, you can test database access with SQL Server Management Studio Express, available free for download from Microsoft:

https://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

Follow these steps:

  1. Have a privileged user install SQL Server Management Studio Express on the Remote computer where you wish to test access.
  2. Under your own login name, start Management Studio Express.
  3. When the software asks you to specify a server name, enter the name of the Server computer, followed by a backslash, followed by the SQL Server instance name where MainBoss is running, e.g. MYSERVER\MAINBOSS.
  4. Click Connect.
  5. In the left-hand panel, expand the entry for Databases.
  6. Expand the entry for the MainBoss database.
  7. Expand the entry for Tables.
  8. Expand the entry for dbo._DAccessCode.
  9. Expand the entry for Columns.

If you can see entries for Code and other data fields, SQL Server is allowing you to look at the database. (You don't need to see the actual database values.)

< Previous section  |  Table of Contents  |  Index  |  Next section >