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.