Take the 2-minute tour ×  I am using SQL server 2008 R2. I have
a live database, and a replicated copy of that live database on
a different server.  It is using Transactional Publication
replication.  When I take our software and point it at the
replicated copy it doesn't work. At first it seemed like the
database didn't have the correct logins under security.  BUT -
that doesn't seem to be the problem. It is more likely that the
database is locked down somehow because of the replication? Can
someone please point me to some info to confirm that.  In
management studio on the server when I am logged in as a local
administrator, when I click one of the replicated databases it
just gives me the error,  'The database blah is not accessible'
How can I check that the replication is working? Will I be able
to back up the database and restore it somewhere else, any other
suggestions welcome.  share|improve this question
permissions?.... –  Mitch Wheat Nov 29 '11 at 1:37 yeah I think
it might be permissions, but I can