1

We are using Microsoft SQL Server 2008 R2 Express on server machine with instance name abc12. This instance contains two databases:

  1. alarm
  2. report

but when we connect to the abc12 instance from other PC's on the local area network, it shows only one database alarm in this instance. It doesn't show the report database.

How do I make that report database accessible to other PC's on the LAN?

Please help me

marc_s
  • 9,052
  • 6
  • 46
  • 52
user38523
  • 11
  • 2

3 Answers3

1

Sounds like you have an issue with permissions - if one database is visible they've clearly connected to the instance. I'd suggest you run SSMS as yourself from the other PC and see what happens.

Rob Farley
  • 16,324
  • 2
  • 39
  • 61
0

In simple word, SQL Server Management Studio(SSMS) is a client to login in SQL Server.

Now to answer you question as it is already mentioned it seems to be a permission issue, You can check with permission given to the user to.

VIEW ANY DATABASE permissions is by default public, you can grant this permission with below query

GRANT VIEW ANY DATABASE TO loginName;

Check GRANT DataBase Permission to assign more permission to user.

vijayp
  • 2,786
  • 1
  • 17
  • 20
0

The quickest way to confirm this being a permissions issue is a/b testing on both your machine and the users. Log in as both users on both machines and you'll have definitive proof.

Mitch Stein
  • 33
  • 4