• Replies 3 replies
  • Subscribers 336 subscribers
  • Views 52 views
  • Users 0 members are here
Related

Failed logon: SQL Error

Mark Kurosky
$organization

On a previously functioning machine we receive the following SQL logon error:

"Security check Not Done... SQLstate=08001... Connection Open... Connection Invalid"

Different user logons on the same PC return the same error... Advice apprecitated.

 

Parents
  • Former Member
    Former Member $organization

    Hi Mark,

    That error is a SQL login error. The login for the securecheck user or whatever sql login you use to communicate between Tessitura and the impresario database.

    I find that if I drop and recreate that user everything works fine.

    Naomi

Reply
  • Former Member
    Former Member $organization

    Hi Mark,

    That error is a SQL login error. The login for the securecheck user or whatever sql login you use to communicate between Tessitura and the impresario database.

    I find that if I drop and recreate that user everything works fine.

    Naomi

Children
  • $organization in reply to Former Member

    Hello, Naomi…

     

    The logon in question is functional on a different PC, so it seems the issue is with that machine and not the logon.

     

    Also tried to overlay the INI files which made no difference.

     

    Mark Kurosky 

    Information Technology Associate

    Ruth Eckerd Hall

    1111 N. McMullen Booth Rd.  l  Clearwater, FL 33759

    727.712.2783   l   Fax: 727.791.5976

    mkurosky@rutheckerdhall.net

    Tickets to all of our great shows are on sale now at RuthEckerdHall.com

    Sesame_street

     

    From: Naomi Williams [mailto:bounce-naomiwilliams9587@tessituranetwork.com]
    Sent: Friday, August 14, 2009 3:00 PM
    To: Mark Kurosky
    Subject: Re: [Tessitura Technical Forum] Failed logon: SQL Error

     

    Hi Mark,

    That error is a SQL login error. The login for the securecheck user or whatever sql login you use to communicate between Tessitura and the impresario database.

    I find that if I drop and recreate that user everything works fine.

    Naomi

    From: Mark Kurosky <bounce-markkurosky3439@tessituranetwork.com>
    Sent: 8/14/2009 1:47:24 PM

    On a previously functioning machine we receive the following SQL logon error:

    "Security check Not Done... SQLstate=08001... Connection Open... Connection Invalid"

    Different user logons on the same PC return the same error... Advice apprecitated.

     




    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!

  • $organization in reply to Mark Kurosky

    Here are a couple of ideas:

    • Search the machine for sqloledb.dll.  Make sure that this file exists on the workstation.
    • Make sure that the shortcut is pointing to the correct local .ini file and that that local .ini file is pointing to the correct master .ini file.
    • Make sure the user has access to the local .ini file and the T: drive (or whatever drive contains your Tessitura deployment files.
    If none of these help resolve the problem, please open a help ticket on TASK Online.