Invalid object name 'catalog.folders'

[expectopatronum]

When I open the dashbord in my browser I get this error:

ProgrammingError: ('42S02', "[42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'catalog.folders'. (208) (SQLExecDirectW)") With this stacktrace:

File "C:\Python27\lib\site-packages\flask\app.py", line 1836, in __call__
return self.wsgi_app(environ, start_response)
File "C:\Python27\lib\site-packages\flask\app.py", line 1820, in wsgi_app
response = self.make_response(self.handle_exception(e))
File "C:\Python27\lib\site-packages\flask\app.py", line 1403, in handle_exception
reraise(exc_type, exc_value, tb)
File "C:\Python27\lib\site-packages\flask\app.py", line 1817, in wsgi_app
response = self.full_dispatch_request()
File "C:\Python27\lib\site-packages\flask\app.py", line 1477, in full_dispatch_request
rv = self.handle_user_exception(e)
File "C:\Python27\lib\site-packages\flask\app.py", line 1381, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "C:\Python27\lib\site-packages\flask\app.py", line 1475, in full_dispatch_request
rv = self.dispatch_request()
File "C:\Python27\lib\site-packages\flask\app.py", line 1461, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "C:\Users\Verena\Downloads\ssis-dashboard-master\ssis-dashboard-master\routes.py", line 15, in all
return package()
File "C:\Users\Verena\Downloads\ssis-dashboard-master\ssis-dashboard-master\routes.py", line 50, in package
engine_folders = m.get_engine_folders()
File "C:\Users\Verena\Downloads\ssis-dashboard-master\ssis-dashboard-master\ssis.py", line 39, in get_engine_folders
result = self.__execute_query('engine-folders.sql', False)
File "C:\Users\Verena\Downloads\ssis-dashboard-master\ssis-dashboard-master\ssis.py", line 138, in __execute_query

I have Python 2.7.

I use this config.py:

AZURE = False
DEBUG = True
#<<<<<<< HEAD
#CONNECTION_STRING = "DRIVER={SQL Server};SERVER=myServer;DATABASE=myDB;UID=;PWD="
#HOUR_SPAN = 72
#=======
CONNECTION_STRING = {
                    "main": "DRIVER={SQL Server};SERVER=myServer;DATABASE=myDB;UID=;PWD="
                    }
HOUR_SPAN = 720
#>>>>>>> refs/remotes/origin/development

Check out the other issue I created about the merge conflict.

Is something wrong with my config? Do I need username or password (I use Windows Authentication on the database).

[yorek]

Hi which version of SQL Server you're using? The solution needs at least SQL Server 2012 (and thus Integration Services 2012) to run

[expectopatronum]

I run SQL Server 2012 SP2. And also the catalogue has the same version (the exact number is 11.0.5058) -> http://sqlserverbuilds.blogspot.co.at/

[yorek]

Can you please post the connection string you're using (just remove the password), please?

[expectopatronum]

CONNECTION_STRING = {
                    "main": "DRIVER={SQL Server};SERVER=Felix;DATABASE=MeasDB;UID=;PWD="
                    }
HOUR_SPAN = 720

As I mentioned in my last sentence I'm using Windows Authentication on the database and therefore don't have username and password - or should I just plug in my Windows user there? Or is this only possible with a database user?

[yorek]

So, just to be 100% sure, the database created by SSIS has been named MeasDB, instead of the more usual SSISDB, right? Using Windows Authentication is fine. To be sure you're using Windows Authentication, I would use the following connection string

CONNECTION_STRING = {
                    "main": "DRIVER={SQL Server};SERVER=Felix;DATABASE=MeasDB;Trusted_Connection=yes;"
                    }
HOUR_SPAN = 720

[expectopatronum]

Aaah, sorry. Of course it's SSISDB. I wrongly took the name of the database I'm usually connecting too. It's working now! Thanks again.

[yorek]

:) You're welcome :)