I am using sqla 11.0.01.2584 and it is oem database. The database has the authentication option set and only our main app can make changes to it. I have the authentication key and I am adding another app that will connect to this database, but the problem is that app is making connection from sql server via linked server and I am not sure how I can set this option from sql server stored procedure using linked server to sqla database. Another option we r looking at is dropping the authentication without rebuilding the database, is this posisble? any help would be much appreciated. |
If you are running OEM software, you must authenticate both the connection and the database. If the database is not authenticated and it is running on a OEM engine, there is no grace period - any write operation against the database will result in an -98 Authentication Violation error. If you leave database_authentication set, you are at least getting read-only access to the database, To address this issue, you can use the InitString connection parameter. See Executing the authentication statement for a discussion in the context of authenticated applications. |
Just to add to Chris's answer: In order to work with a MS Linked Server, I guess you will have to
Can I add the intistring to 'add addtitional connection' parameter space under Advance tab on the odbc configuration window. I just wanted to add initstring here and leave all the other params as it is, will that work?
(23 Apr '12, 09:00)
javedrehman
Yes that will work. It does expose the connection_authentication value but authentication is not intended as a security mechanism.
(23 Apr '12, 10:01)
Chris Keating
|