February 15, 2011 at 7:13 am
I have an etended stored procedure I have to install for OBIEE..
I haven't installed an extended stored proc in a very long time...so Im kinda lost..
In the instructions it says:
-- Notes for SQL Administrators:
-- #1. Prior to running this script you must copy the extended stored procedure dll SQLJDBC_XA.dll
-- to the target SQL Server's Binn folder.
-- #2. Permissions to the distributed transaction support procedures for the Microsoft SQL Server
-- JDBC Driver 3.0 are granted through the SQL Server role [SqlJDBCXAUser]. To maintain a secure default
-- configuration, no user is granted access to this role by default.
So do I start by going into master DB, then extended stored pr
-- Notes for SQL Administrators:
-- #1. Prior to running this script you must copy the extended stored procedure dll SQLJDBC_XA.dll
-- to the target SQL Server's Binn folder.
-- #2. Permissions to the distributed transaction support procedures for the Microsoft SQL Server
-- JDBC Driver 3.0 are granted through the SQL Server role [SqlJDBCXAUser]. To maintain a secure default
-- configuration, no user is granted access to this role by default.
then theres a script afterwards...
I don't even know where to start..
February 15, 2011 at 7:56 am
I would follow the instructions. The .dll file is apparently important. Copy it over to the BINN directory before running the XP script. Then run the XP script.
Or did your vendor not include a .dll with the other install information?
February 15, 2011 at 8:35 am
yep they sure did
I think I have it setup
thanks for your help
February 15, 2011 at 8:38 am
You're welcome. Let me know if you need anything else.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply