CORRECTION: SQL Database Problem

Former Member
Former Member $organization

I have been working to build a new Tessitura Live server with version 10.1.0 so that we can begin our migration to version 11, but I have run into a big snag.  When I attached the impresario databases in the Live server, for some reason they ended up set as Read Only.  The error seems to point to the F:LOGS and G:DATA folders/files as being inaccessible.  I did not have this trouble when I built our new Test server (that one is running successfully), and as far as I can see, the folder security permissions are identical on both servers.  I have looked up options on the internet, but have not been able to find a resolution to the problem.  Has anyone seen this before or have any ideas to make the databases editable because at this point I’m at a standstill and can’t proceed with the installation.

 

Thanks in advance,

 

 

Penny Tabor

IT Manager

Midland Center for the Arts

Midland, MI 48640    

                                     Description: Comptia                                              

 

 

 

 



--
View this message online at http://www.tessituranetwork.com/Community/forums/p/8223/25720.aspx#25720 or reply to this message
--
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Parents
  • Former Member
    Former Member $organization

    Two things…

     

    When you go to the properties of the mdf file, do you see a button that says Blocked? If so, uncheck that. Windows will do that for any files that were copied from a different location.

     

    Two…have you thought about restoring the database from the live backup? That’s the way I do it.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Penny Tabor
    Sent: Tuesday, October 02, 2012 11:32 AM
    To: Gloria Ormsby
    Subject: [Tessitura Technical Forum] CORRECTION: SQL Database Problem

     

    I have been working to build a new Tessitura Live server with version 10.1.0 so that we can begin our migration to version 11, but I have run into a big snag.  When I attached the impresario databases in the Live server, for some reason they ended up set as Read Only.  The error seems to point to the F:LOGS and G:DATA folders/files as being inaccessible.  I did not have this trouble when I built our new Test server (that one is running successfully), and as far as I can see, the folder security permissions are identical on both servers.  I have looked up options on the internet, but have not been able to find a resolution to the problem.  Has anyone seen this before or have any ideas to make the databases editable because at this point I’m at a standstill and can’t proceed with the installation.

     

    Thanks in advance,

     

     

    Penny Tabor

    IT Manager

    Midland Center for the Arts

    Midland, MI 48640    

                                         Description: Comptia                                              

     

     

     

     



    --
    View this message online at http://www.tessituranetwork.com/Community/forums/p/8223/25720.aspx#25720 or reply to this message
    --
    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • Former Member
    Former Member $organization

    Two things…

     

    When you go to the properties of the mdf file, do you see a button that says Blocked? If so, uncheck that. Windows will do that for any files that were copied from a different location.

     

    Two…have you thought about restoring the database from the live backup? That’s the way I do it.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Penny Tabor
    Sent: Tuesday, October 02, 2012 11:32 AM
    To: Gloria Ormsby
    Subject: [Tessitura Technical Forum] CORRECTION: SQL Database Problem

     

    I have been working to build a new Tessitura Live server with version 10.1.0 so that we can begin our migration to version 11, but I have run into a big snag.  When I attached the impresario databases in the Live server, for some reason they ended up set as Read Only.  The error seems to point to the F:LOGS and G:DATA folders/files as being inaccessible.  I did not have this trouble when I built our new Test server (that one is running successfully), and as far as I can see, the folder security permissions are identical on both servers.  I have looked up options on the internet, but have not been able to find a resolution to the problem.  Has anyone seen this before or have any ideas to make the databases editable because at this point I’m at a standstill and can’t proceed with the installation.

     

    Thanks in advance,

     

     

    Penny Tabor

    IT Manager

    Midland Center for the Arts

    Midland, MI 48640    

                                         Description: Comptia                                              

     

     

     

     



    --
    View this message online at http://www.tessituranetwork.com/Community/forums/p/8223/25720.aspx#25720 or reply to this message
    --
    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data