Is anyone out there using microsoft sql express 2005 with an appian installation

james.franklin over 10 years ago

Is anyone out there using microsoft sql express 2005 with an appian installation of v7.2?
I could use some help or pointers with the ds config. It will not honor the example on the installation docs or the version I had working for 6.7.
Thanks, James...

Discussion posts and replies are publicly visible

Parents

0 Sathya Srinivasan
Appian Employee
over 10 years ago

I've seen this error w.r.t Oracle. I believe it's the same with Sql Server as well. This has to do with providing the correct Grant privileges to the user whome you're connecting as. The SP_ is probably there already but the user probably doesn't have the correct permission to access it. This is not fatal (as far as I've seen) but if this is your local server instance, you may want to Grant the privileges and see if that resolves the issue.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Sathya Srinivasan
Appian Employee
over 10 years ago

I've seen this error w.r.t Oracle. I believe it's the same with Sql Server as well. This has to do with providing the correct Grant privileges to the user whome you're connecting as. The SP_ is probably there already but the user probably doesn't have the correct permission to access it. This is not fatal (as far as I've seen) but if this is your local server instance, you may want to Grant the privileges and see if that resolves the issue.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data