CODEWITHSUNDEEP
sqlssissql-server-2016
RichardE
RichardE

Reputation: 21

Unable to browse Integration Services on SQL 2016

I've installed SQL Server 2016 (Standard Edition) on a Windows Server 2016, selecting Integration Services to be installed too. I've also installed SSMS and SSDT from the same installation media.

I am running SSMS as administrator and can connect to the local Database engine.

My user is a Windows and SQL Server admin.

However I cannot connect (explicitly using the server name) or even browse to the local Integration Services?

Receiving the following error.

SSIS not browsable and can't connect

Having already searched for an answer to this problem, many suggest checking that the service is running etc. which can be seen in the Services and SQL Configuration Manager.

Services shown as running

I've also tried turning off the Windows Firewall to establish if that is the cause of the problem but it had no effect.

Anyone got any ideas what might be preventing it from being accessible?

Upvotes: 2

Views: 3746

Answers (3)

BV_Data
BV_Data

Reputation: 65

I have had the same problem and the solution was to install the old interface on top of the existing one (SQL Server Management Studio 2016). Here's link to the installation file. After having installed this, I can now connect to the integration services. You will have to set it up of course and give yourself Rights

Upvotes: 0

Tequila
Tequila

Reputation: 864

The later SSMS versions (16.x and 17.x) will only connect to their respective versions SQL 2016 and SQL 2017. Microsoft is planning to retire the older method in favor of the SSISDB, which is more secure.

Link to the official statement from Microsoft (in the note box).

Upvotes: 0

Henrique
Henrique

Reputation: 11

I've had this problem last month. In my case I had to install the 32-bit version of access database engine (on my 64 bit windows).

Sql data tools works with 32-bit

https://www.microsoft.com/en-us/download/details.aspx?id=54920

Upvotes: 0

Related Questions