How do I make SQL Server database accessible to PC's on the LAN? We are using Microsoft SQL Server 2008 R2 Express on server machine with instance name abc12. This instance contains two databases:


alarm
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
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.