SSIS login error

Hot Topic

Reporting services access problem !!!!!!!
Error:rsErrorReadingNextDataRow
Restricting number of records
join table udf question
SMTP configuration for RS
SQL 2005 CTP up to RTM
HTTP ERROR 401.1 - Unauthorized
Need to reset page count or use distinct count on new Grouping
SQL Server Agent Issues
Annoying behavior in report designer

SQL Server

SQL Server Express fails to install
Is only "shared memory" connection with "SQL Server Management Studio Express" supported?
transfer access DB to SQL 2005 PRO
diploying reports on browser with custom assembly
SQL Server Reporting Services
To Boost Performance
Clustered Index or NonClustered Index
Help with Parent Package Variables ...
how to connect sql server 2005 cube using visual studio 2005
Development Procedures

SSIS login error

i gave a non admin user access to SSIS. He is able to log in to SSIS without any problem.

But when he expands the MSDB folder, he gets the following error:

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.

Login failed for user 'XYZ'. (MsDtsSrvr)

Does anyone know how to fix this

Thanks.

Answer this question

SSIS login error

  • Bill Henning

    The default configuration file works for default SQL Server installation (i.e. SQL is not installed as named instance). If you've installed named instance, substitute "." with instance name.

    Note that SSIS only supports Integrated Security to connect to SQL storage.

  • MarkLuo

    This is what i have in the file:

    Does anything have to be changed

    < xml version="1.0" encoding="utf-8" >

    - <DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>
    - <TopLevelFolders>
    - <Folder xsi:type="SqlServerFolder">
    <Name>MSDB</Name>
    <ServerName>.</ServerName>
    </Folder>
    - <Folder xsi:type="FileSystemFolder">
    <Name>File System</Name>
    <StorePath>..\Packages</StorePath>
    </Folder>
    </TopLevelFolders>
    </DtsServiceConfiguration>

  • Eligible

    Look in C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml

    Check the server name is correct.

    -Jamie



  • esjr

    It is not a named instance.

    However, i was able to fix this by giving the user access to MSDB database with the dts_admin role. The user is now able to connect and browse the packages but when he clicks run, he gets the following error message:

    Error: An error occured while trying to get set the table list to transfer "An exception occured while executing a Transact SQL statement or batch"

    Any ideas how to fix


  • SSIS login error
Answer this question