sql-serverssissql-agent
SSISDB not found and can not create New catalog in SQL Server 2012
I just installed SQL Server 2012, I want to create a catalog in Integration Services Catalog in order to obtain SSISDB database but I got the following error
Any help would be most appreciated.
Solution
This seems to be a common problem with using the standalone SSMS version (v 2017) against an older SQL version (in this example 2012)
If you using a later standalone download version of SSMS then this may occur -
So instead use the SSMS that is installed as part of the SQL installation ad try again
- Unrecognized column name that I define
- How to merge 2 or more rows and SUM a column in an UPDATE without a primary key?
- What are the advantages of running SQL Server in a Docker container?
- How do I get the MAX of two values in SQL Server?
- How can I split a single, very long string into separate columns and rows delimited by commas and semicolons in SQL Server?
- Why can't I use table names of aliased tables in WHERE clause?
- Function vs. Stored Procedure in SQL Server
- How to correctly join two tables that each have Start Date and Stop Date columns?
- How to run sql script using SQL Server Management Studio?
- SQL copying data with new foreign keys
- SQL Server truncates decimal points of a newly created field in a view
- SQL Grouping and Nested Concatenation
- How to pull width & height out of string?
- The locale identifier (LCID) 8192 is not supported by SQL Server
- SQL Server Initial database connection timeout in 30 seconds
- Why use a READ UNCOMMITTED isolation level?
- Recursive CTE and how to overcome circular reference error
- Select min or max based on where duplicate value exists
- Converting accented characters in varchar() to XML causing "illegal XML character"
- Incorrect syntax near '1'. Expecting ID, QUOTED_ID, or '.' Error with SQL Pivot
- Update SQL table using selection from another table
- Clarification on joins
- Foreign key constraint may cause cycles or multiple cascade paths?
- pyodbc cursor.fetchall() is returning "strange" values
- T-SQL Get File Extension Name from a Column
- How to do a cross-database-query join in SQLAlchemy?
- Return the contents of an EXEC from a stored procedure
- How to transform "Types" a List<string> foo class property into a SQL Server table [Types](FooID int, name nvarchar) with Entity Framework Core
- List the queries running on SQL Server
- Recordset Closed After Stored Procedure Execution