I have just setup my first Transactional replication between twoservers. Next I needed to test what would happen if the live serverwent down.
I disconnected the live server and connected it to the backup server(doing all the ip setup bits as well). Then I tried running my web app.
The web app ran great. I can look at the data that was replicated. Myproblem is that I cannot seem to add any data. Ever time I try to run astored procedure, the web app crashes with 'sa' account login failed. Itried running the stored procedures through SQL Query Analyzer, and itsays the same thing.
I know there is no problem with the sa account, as I can view the datausing this. There are no permissions set on any of the objects in thedatabase. The only thing I can think of is that the replication hassomehow disabled the ability to add data to the replicated database.
Can anyone point out what is happening?
Foundan MSDN article which explains why this is happening. Solve the problem.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment