SQL connection error

This error is almost always resolved by dropping and recreating the user logins in the Tessitura Security module.  If the problem affects only specific users, you can drop and recreate only the affected logins.

Bob

Hello I ran an update script that reset securecheck and the master database key.  Now I get the following error:

A system error has occurred Please contact your system administrator and provide the following information:

Windowmenu: F_get_nextid

Object: F_get_nextid

Objectevent: F_get_nextid

Line: 10

Error Code 20

Error Text: Database command not successfully prepared at line 10 in function f_get_nextid of object f_get_nextid.

Thanks

John

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jeff Averitt
Sent: Thursday, February 23, 2012 1:08 PM
To: John Brandt
Subject: Re: [Tessitura Technical Forum] SQL connection error

When I get that problem, I run the relogin script and that seems to fix the problem. Let me know if you need that.

Hello,

We have refreshed our virtual instance of our test db.  When we attempt to launch the Tessitura client we get the following error:

SQLSTATE=42000

Microsoft OLE DB Provider for SQL Server

Cannot open database "Impressario" requested by the login.  The Login failed. 

All of our .ini files are valid and I reran the securecheck sql script.  Is this a master db access issue?

Thanks

John

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!

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 error is almost always resolved by dropping and recreating the user logins in the Tessitura Security module.  If the problem affects only specific users, you can drop and recreate only the affected logins.

Bob

Hello I ran an update script that reset securecheck and the master database key.  Now I get the following error:

A system error has occurred Please contact your system administrator and provide the following information:

Windowmenu: F_get_nextid

Object: F_get_nextid

Objectevent: F_get_nextid

Line: 10

Error Code 20

Error Text: Database command not successfully prepared at line 10 in function f_get_nextid of object f_get_nextid.

Thanks

John

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jeff Averitt
Sent: Thursday, February 23, 2012 1:08 PM
To: John Brandt
Subject: Re: [Tessitura Technical Forum] SQL connection error

When I get that problem, I run the relogin script and that seems to fix the problem. Let me know if you need that.

Hello,

We have refreshed our virtual instance of our test db.  When we attempt to launch the Tessitura client we get the following error:

SQLSTATE=42000

Microsoft OLE DB Provider for SQL Server

Cannot open database "Impressario" requested by the login.  The Login failed. 

All of our .ini files are valid and I reran the securecheck sql script.  Is this a master db access issue?

Thanks

John

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!

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!