Click here to Skip to main content
14,983,344 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a piece of C# code that I used to query a database. Today I used the same code (few minor changes db names, columnNames...etc) to query the SSISDB but failed as the SSISDB cannot be opened as requested by the login. so I tried the following:
1. run the query against the SSISDB from within SSM studio-worked fine
2. Then using the command osql -Usa -Ppassword
>sp_helpdb: This returns all DBs including SSISDB
but when I type
>use SSIDB
>go
an error display that SSIDB does not exist
I used both windows authentication and the "SA"
So what is going on with SSISDB???
any help is greatly appreciated
Posted
Comments
Wendelius 1-Aug-15 1:29am
   
What are the exact error messages you get when trying to connect to the database in different ways?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900