Home Forums SQL Server 2008 SQL Server 2008 - General Changing Authentication mode of connecting to Integration Services RE: Changing Authentication mode of connecting to Integration Services

  • October 26, 2009 at 8:32 am

    #1070728

    Aspet Golestanian Namagerdi (10/25/2009)

    In Managment studio(SQL SERVER 2008),I am trying to connect to Integration Services.But it is always in windows Authetication and I can not chnage it to SQL authentication .My login is sysadmin, but when I am trying to connect in window Authentication it says access denied.

    1-How is it possible to change the authentication mode to SQL Authentication of cnnecting to SQL SERVER 2008 Intgration Services?

    2-why my login (sysadmin) can not access to Integration Services and How can I give this permission to my user?

    Thanks

    If your SQL Server is Windows authentication you cannot change authentication at the point of connection, you must configure mixed authentication before trying to connect. In SQL Server at the top right click and go to server properties under security change to both SQL Server and Windows authentication and you can use SQL authentication to connect to SSIS.

    Kind regards,
    Gift Peddie