Gopakumar Pandarikkal
asked on
I am not able to login to SSIS in SSMS but from visual studio am able to do manage ssisdb
I am a novice in ssis. i installed sqlserver 2016 and visual studio 2015 and ssdt for visual studion 2015 in my machine. but when i log in to ssms choosing ssis it gives errors. i gave machine name and instance name and windows authenication. then it said multi instance is not supported. so i removed instance name and gave machine name only as the server name. then it says it can happen when you try to connect to sql server 2005. i tried giving instance name of ssis. then it said RPC call failed. but you see i have installed sql server 2016 only. I am totally at a lose. but when i deploy project thru visual studio am able to do manage ssisdb and successfully deploy. but i want to create folders and manage ssis though ssms how to do it? am i missing something? last one week I am struggling with this probleem . please help
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Ansari for the prompt response and willingness to help me.
Yes it is version mismatch issue
I got this table from MSDN
PFA
installation of sqlserver,Visual studio and SSDT, and ssms works perfectly for particular combinations of versions
I chose this
sql server 2014 , visual studio 2015, SQL Server Data Tools for Visual Studio 2015, SSMS 2014(installed in this order only )
It worked fine. Now i am able to login to integration services from SSMS. I shouldn't give instance name along with server name.
I installed sql server with Mixed authentication.
Again thanking you. thanking expert exchange
Yes it is version mismatch issue
I got this table from MSDN
PFA
installation of sqlserver,Visual studio and SSDT, and ssms works perfectly for particular combinations of versions
I chose this
sql server 2014 , visual studio 2015, SQL Server Data Tools for Visual Studio 2015, SSMS 2014(installed in this order only )
It worked fine. Now i am able to login to integration services from SSMS. I shouldn't give instance name along with server name.
I installed sql server with Mixed authentication.
Again thanking you. thanking expert exchange
Accept an answer as a solution.
Which ever helped you.
Thanks,
Arif
Which ever helped you.
Thanks,
Arif
ASKER
Thank you Ansari,Thank you pawan
ASKER
ssis.png