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

1

3 Answers 3

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.

3
  • sir what is ssms?
    – user38523
    May 31, 2014 at 8:48
  • 1
    SSMS = SQL Server Management Studio. What are you using now to connect to the instance, when you're observing you don't see the report database? Jun 1, 2014 at 0:23
  • Odd - I didn't see the comment until now. Blaž is right, I meant the application you're using to connect. It doesn't even have to be SSMS, it could be whatever application is being used.
    – Rob Farley
    Jun 1, 2014 at 4:32
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.

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.