Paul Clancy


I've been completely unsuccessful so far in getting the SSIS service to start under normal circumstances.

I've got the SQL 2005 RTM DVD and a clean, brand-new installation of Windows 2000 Server (Service Pack 4). All system requirements have been met according to the SQL installer. I choose to install just the Database Engine, SSIS and the Workstation components, all other installation options are defaults except Services, which are set to use a Domain User account.

The install completes without problems and the SQL Server & SS Agent services start suceessfully, but the SSIS service refuses to start (timeout). If I change the service to use LocalSystem, the same happens. If I make the Domain User (DOMAIN\MisterSQL) account a member of Local Admins on the server, the service still won't start.

If, however, I use a Domain Admin account, the service does start, so it appears to be a security issue, but how can I configure the service to start with fewer privileges

This problem has appeared on each machine I've tried this on, four to date, so it's not related to the particular setup of this server. I've searched the web for weeks for a solution with no success; any help would be greatly appreciated.



Re: SSIS Service won't start

Jamie Thomson


This is a complete guess but you could try it anyway...

There is a file called MsDtsSrvr.ini.xml that defines the SQL Server instance to which the SSIS Service is "attached" (for want of a better word).

Perhaps your domain admin account has permissions to connect to SQL Server but the  domain user acocunt does not.

Just a guess but try it anyway.

 

-Jamie

 







Re: SSIS Service won't start

Paul Clancy

Thanks very much for your prompt response, Jamie.

No, both the Domain User & the Domain Admin accounts are members of sysadmin in SQL so that shouldn't be the problem.

I've tried editing the XML file but that doesn't help. It seems a bit unlikely that this could be the fix in any case; would MS bury such an important config setting like this, or am I just being naive

I should also point out that I'm using named SQL instances, not the default instance. This shouldn't make any difference to SSIS, though, right It's independent of the database engine installs and only gets installed and configured once per Windows server irrespective of how many SQL Server instances are present. Or am I assuming too much






Re: SSIS Service won't start

Jamie Thomson

AHA. Yes, you're assuming too much. You have to tell SSIS Service which SQL Server instance it is "attached" to. Look in the XML file that I pointed you to before....you'll find an entry for server name which you should change to contain the named instance.

On my machine the XML file is located at C:\Program Files\Microsoft SQL Server\90\DTS\Binn

Kirk has a post on this here: http://sqljunkies.com/WebLog/knight_reign/archive/2005/06/08/15765.aspx

-Jamie

 

 






Re: SSIS Service won't start

Paul Clancy

Thanks again for your help, I really appreciate the time you're putting into this.

Unfortunately, though, this hasn't helped. I've edited this file (using both the .\InstanceName and the ServerName\InstanceName syntax) without success.

In any case, like I said in my first posting, the service does start with Domain Admin privileges regardless of the Server Name setting in the XML file you mentioned. Also, the fix listed in the web page in your link applied to side-by-side SQL 2000/SQL 2005 installations. I've got a brand-new clean Windows 2000 server with one clean SQL 2005 install.

I'm completely puzzled at this point; this ought to be a fairly easy, everyday routine install, but instead I've got a major product feature which Just Won't Start.






Re: SSIS Service won't start

Paul Clancy

Additional info (from http://msdn2.microsoft.com/en-us/library/ms143504.aspx):

Identifying Instance-Unaware Services

Instance-unaware services are shared among all installed SQL Server instances; they are not associated with a specific instance, are installed only once, and cannot be installed side-by-side. Instance-unaware services in SQL Server 2005 include:

  • Notification Services
  • Integration Services
  • SQL Server Browser
  • SQL Server Active Directory Helper
  • SQL Writer




Re: SSIS Service won't start

Rachel J

Paul

Did you get to the bottom of this problem I ask because we are experiencing exactly the same thing here.

Thanks

Rachel





Re: SSIS Service won't start

AustinH100

Hi,

Just want to share my experience. I modified xml file (C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml) then reboot server. It works. The other way is enable name pipe. It works, too.

Austin H





Re: SSIS Service won't start

kgause

what change did you make to the msdtssrvr.ini.xml file






Re: SSIS Service won't start

kgause

The solution to my issue was to reinstall the service pack 2.