Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Connecting to SQL DB - SP Generator

Created: 07 May 2014 • Updated: 08 May 2014 | 3 comments
This issue has been solved. See solution.

Hello,

I am having issues connecting to our DB from within workflow designer.  I verified connectivity by creating an ODBC connection in windows, but from designer it is failing.  Here is a screenshot of the error.

sp_screen.jpg

Operating Systems:

Comments 3 CommentsJump to latest comment

reecardo's picture

Try not putting parens around your DB name (I've only ever seen this type of syntax used with the local (local) instance of SQL)

jdeleon7010's picture

Thank you this worked.  Now for some reason my SQL server will not authenticate the user name.  Although its the exact same account i used to install workflow DB.

reecardo's picture

I'd crack open SQL Server Management Studio and verify the user has a valid login against the DB just to be sure.

SOLUTION