MS SQL Server Data Saource setup error

Disabled

Published 12 years ago

Hi,

Trying to create an SQL data source. I have SQL 2008 and while "Test Server" is successful, "Test Database" comes back with the error..

"Unable able to connect to the database!"

"Invalid object name 'Connections'."

Colleague of mine seems to think it has something to do with the schemas.
edited by jctp on 8/26/2014

All Comments (3)

Stéfane Lavergne

Published 12 years ago

Go-to File -> My Data Sources -> find your data source -> Edit -> Upgrade (tab) -> click on create and/or upgrade buttons.

Regards,

Stéfane Lavergne

jctp

Published 12 years ago

Upgrade worked! I was going to try and convince you that I have already tried those options with no success but realized that would just be silly at this point.

thanks!

Stéfane Lavergne

Published 12 years ago

Thanks for the update.

I've logged an enhancement request to get that cleaned up. There is not reason you should get an error when you click "Test Database" we can detect that the schema is missing and prompt you create it.

Best regards,

Stéfane Lavergne