I am setting up a web application, where the application needs to access a
database. I have created the user (which is the application) and it can log in to
the SQL 2005 Sp2 server, but when I try to open the required database using
Server Management Studio, it says "The database [name] is not accessible.
How do I make a database accessible to a login, using Server Management
Can you see the database in the mgr studio underneath server\databases\ ?