Snapshot isolation transaction failed

Discussion in 'Microsoft Accounting' started by Toluene, Oct 30, 2007.

  1. Toluene

    Toluene Guest

    Accounting 2007 error when one multiuser tried to access from a second
    workstation,

    'Snapshot isoltaion failed accessing database xxx because snapshot isolation
    is not allowed in the database. Use Alter Database to allow snapshot
    isolation."

    I found that the user did not have write access to the folder where the SQL
    database is and will have them try to connect to the company tomorrow. Was
    wondering if there was something else to check into tomorrow?

    Thank you in advance.
     
    Toluene, Oct 30, 2007
    #1
    1. Advertising

  2. Toluene

    Toluene Guest

    Still not able to use Accounting 2007
    Any direction on which way to go to resolve would be helpful.
     
    Toluene, Nov 2, 2007
    #2
    1. Advertising

  3. Hi

    How did you install your SQL? Just using The Office Accounting Setup
    program? or did you install SQL yourself?

    Also does this fail for all machines including the one that contains the
    database? or only when you access the database from another machine?

    --
    Regards

    Jørn Lindhard Mortensen
    http://blogs.msdn.com/jorn/


    "Toluene" <> wrote in message
    news:...
    > Accounting 2007 error when one multiuser tried to access from a second
    > workstation,
    >
    > 'Snapshot isoltaion failed accessing database xxx because snapshot
    > isolation
    > is not allowed in the database. Use Alter Database to allow snapshot
    > isolation."
    >
    > I found that the user did not have write access to the folder where the
    > SQL
    > database is and will have them try to connect to the company tomorrow. Was
    > wondering if there was something else to check into tomorrow?
    >
    > Thank you in advance.
     
    Jorn L M \(MS\), Nov 7, 2007
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. haiz

    RE: Snapshot isolation transcction failed

    haiz, Apr 17, 2007, in forum: Microsoft Accounting
    Replies:
    1
    Views:
    299
    hugeoso
    Apr 18, 2007
  2. Craig

    Another Snapshot Isolation transaction failed error

    Craig, Apr 19, 2007, in forum: Microsoft Accounting
    Replies:
    1
    Views:
    340
    Craig
    Apr 23, 2007
  3. Chow Ming
    Replies:
    0
    Views:
    182
    Chow Ming
    Aug 13, 2004
  4. 2pac
    Replies:
    1
    Views:
    194
    Cal Learner-- MVP
    Nov 5, 2004
  5. BRIJ

    Spending and snapshot on MyMoney Page

    BRIJ, Nov 18, 2004, in forum: Microsoft Money
    Replies:
    0
    Views:
    209
Loading...

Share This Page