Post reply

Integration Services

  • September 10, 2008 at 11:56 am

    #124560

    How can I tell if Integration Services is installed?

    SQL 2005

    Thanks,

    Terry

    A great day starts with a great attitude

  • September 10, 2008 at 12:32 pm

    #869893

    Look for the services or open surface area configuration in the SQL 2005 start menu.

  • September 10, 2008 at 12:45 pm

    #869904

    OK, it's installed. Thanks

    I ran the SQL Baseline Security Analyzer and it returned the following issue. Any ideas?

    Issue

    SSIS Roles

    Result

    No permissions to access database

    Thanks,

    Terry

    A great day starts with a great attitude

  • September 10, 2008 at 12:51 pm

    #869909

    Did you change anything with the service accounts after installing MSSQL and SSIS? I would recommend you go into the "SQL Server Configuration Manager" and change the service account for SSIS to "Built-in account" / "Network Service" or if it is already set to this, change it to another account and then change it back. Doing this will get the configuration manager to try to fix group and account permissions as well as some DCOM settings.

    Make sure your local administrators (or at least the builtin setwork service account) has sysadmin permissions on the local MSSQL server, and if this is a cluster, make sure the XML configuration for SSIS has the cluster machine name rather than "." for the local MSSSQL server name.

  • September 10, 2008 at 12:52 pm

    #869911

    Oh - if you did not know, always use "SQL Server Configuration Manager" to change service account information rather than directly in the services. The configuration manager does some other stuff in addition to just changing the services.

  • September 10, 2008 at 1:09 pm

    #869924

    Nothing changed since the initial install.

    The service account was set to Builtin\NetworkService. I just now changed it to a domain account which is the same account used for the SQL Server service. This account has local admin privileges to the server and is a member of sysadmin.

    I ran the Baseline Security Analyzer again and got the same error.

    I set the Integration Service service account back to Builtin\NetworkService. I ran the Baseline Security Analyzer again and got the same error.

    Any more ideas?

    Thanks for the replies!

    Terry

    A great day starts with a great attitude

  • September 10, 2008 at 1:23 pm

    #869932

    BTW - I get the same error on two servers. One that was upgraded from SQL 2000 and the other that was a fresh install.

    Both are SQL 2005 Ent

    A great day starts with a great attitude

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply