sql-serverssisetlsql-server-data-toolsbids
Where is the msdb database for standalone SSIS Servers
I am working on a DWH application. The server I was granted access to only has SSIS installed with no database engine. I am getting errors like:
The EXECUTE permission was denied on the object 'sp_ssis_listfolders', database 'msdb', schema 'dbo'.
I need to verify the permissions on the database engine and on the msdb. Is there a way how to find which server is configured to host the msdb database?
Solution
Found it!
It is hidden in a configuration file in the installation folder of SSIS. Browse to C:\Program Files\Microsoft SQL Server\120\DTS\Binn then look for the file called MsDtsSrvr.ini.xml. The server name is just sitting there, and can be changed as you wish.
- migrate data from MS SQL to PostgreSQL?
- Sqoop Import HBase - SQL Database
- How important is the order of columns in indexes?
- Connect to SQL Server running on Windows host from a WSL 2/Ubuntu sqlcmd
- SQL Server, to normalize this much or not?
- Strange behavior of symfony doctrine during phpunit test - field becomes null in database
- How do I make it to where my login will accept either an email or username in the username field
- Adding column to select statement in SQL causes timeout
- SQL Server: Clustered index on datetime, ASC or DESC
- SQL Pivot on Conditional Count
- SQL Server indexes - ascending or descending, what difference does it make?
- Query to concatenate row data in each group
- Combine 2 SQL Statements
- Converting SQL server timestamp to an epoch timestamp
- Change Date format from yyyy-mm-dd to mm/dd/yyyy Derived Column
- How do you send email with TSQL using a Agent Operator instead of an email address?
- Spark sending LIMIT to SQL Server on display function
- How can I manage Azure SQL user/login/credentials
- Can't add members to SSAS role through Visual Studio
- How to use Charindex for one or the other character
- SQL want to calculate time hours and mints of each emp
- Incorrect Syntax near ',' in SQL query execution in Spring JPA but executes successfully in database
- How to make multiple select into on the same table?
- Invoking a stored procedure with all combinations of values stored in multiple single-column tables
- Get Value From Json object contain table column using SQL Query
- Compute count(*) of unique occurrences into new column without group by in a single select query
- Is there any better option to apply pagination without applying OFFSET in SQL Server?
- How to get a list of tables with composite primary key in SQL Server?
- Calculating churn rate in SQL: how can I display both churned and not churned customer in % in a single query?
- How can you tell what Tables are taking up the most space in a SQL Server 2005 Database?