SQL Server Performance

Error when try to connect from SSMS

Discussion in 'SQL Server 2005 Integration Services' started by dineshasanka, Nov 20, 2006.

  1. dineshasanka Moderator

    I am getting following error when I tried to connect to SSIS from SSMS. my SQL Server 2005 is not the default instance. is that the reason? all the services are running

    The SQL server specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer. For more information, see the topic "Configuring the Integration Services Service" in Server 2005 Books Online.

    Client unable to establish connection
    Encryption not supported on SQL Server. (MsDtsSrvr)

    Contributing Editor, Writer & Forums Moderator

    Visit my Blog at
  2. dineshasanka Moderator

Share This Page