• Aspet Golestanian Namagerdi (10/26/2009)


    Thx for reply,But the SQL Server is on "SQL SERVER and Windows Authentication mode",but still I can chnage it during connecting to Integration Services.

    If SQL Server is in both Windows and SQL Server mode you should be able to use SQL Server authentication if you cannot use it then the system admin account is disabled when you installed SQL Server with Windows authentication so you need to enable it. Check the links below for details and how to enable it.

    http://msdn.microsoft.com/en-us/library/ms188670.aspx

    http://blog.sqlauthority.com/2008/12/24/sql-server-disable-and-enable-user-sa/

    Kind regards,
    Gift Peddie