Error encountered while starting the SSIS service

I installed SQL Server 2005 Integration services on Windows XP machine. Then I went to the SQL Server Configuration Manager and tried to Start the SSIS service. The "Log On As" value is "NT AUTHORITY\NetworkService". But I get the follwoing error:

The request failed or the service did not respond in a timely fashion. COnsult the event log or other applicable error logs for details.

Event Log details:
The SQL Server Integration Services service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I tried running the service using the "Local Service" and the "Local System" accounts also, but am still encountering the same error. What do I do...

Are you using SP1? There was a bug in SP1 that stopped the SSIS service from starting under certain conditions.

-Jamie

|||

I dont have any SP installed.

I installed SSIS on another machine and here the service runs successfully under NT AUTHORITY\Network Service. As for the first machine, as of now, I am only able to run it under the current domain account- Is this fine or will it lead to some problems/threats in future.

Error connecting to remote connections...

That's what appears at my client site. I have virtually the exact same
configuration on a handful of servers using the SQL Reporting Services and
the RDLC which is working great. Except this one server has:
"An error has occurred when establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by teh fact that
under the default settings SQL Server does not allow remote connections.
Named Pipes provider, error: 40 - Could not open a connection to the SQL
Server).
I think the IT admin used SQL permissions when he installed. Could that be
the problem?
Thanks in Advance.
ChrisThis link might help,
http://vadivel.blogspot.com/2007/01/error-has-occurred-while-establishing.html.
daw
"Chris Marsh" wrote:
> That's what appears at my client site. I have virtually the exact same
> configuration on a handful of servers using the SQL Reporting Services and
> the RDLC which is working great. Except this one server has:
> "An error has occurred when establishing a connection to the server. When
> connecting to SQL Server 2005, this failure may be caused by teh fact that
> under the default settings SQL Server does not allow remote connections.
> Named Pipes provider, error: 40 - Could not open a connection to the SQL
> Server).
> I think the IT admin used SQL permissions when he installed. Could that be
> the problem?
> Thanks in Advance.
> Chris
>
>|||Sorry, I should have specified this earlier but the SQL DB is SQL 2000 not
2005 which is what is strange. Again, works on multiple other configurations
but not this one.
"daw" <daw@.discussions.microsoft.com> wrote in message
news:D05FF90C-2A0D-43B9-83B4-D348859995E9@.microsoft.com...
> This link might help,
> http://vadivel.blogspot.com/2007/01/error-has-occurred-while-establishing.html.
> daw
> "Chris Marsh" wrote:
>> That's what appears at my client site. I have virtually the exact same
>> configuration on a handful of servers using the SQL Reporting Services
>> and
>> the RDLC which is working great. Except this one server has:
>> "An error has occurred when establishing a connection to the server. When
>> connecting to SQL Server 2005, this failure may be caused by teh fact
>> that
>> under the default settings SQL Server does not allow remote connections.
>> Named Pipes provider, error: 40 - Could not open a connection to the SQL
>> Server).
>> I think the IT admin used SQL permissions when he installed. Could that
>> be
>> the problem?
>> Thanks in Advance.
>> Chris
>>

error configure

Hi every1,

I have problem about configuration in Merge Replication.

First, I configure for SQL Server 2000, expand Replication> Publication>New Publication>Choose Publication Database, I choose pubs>Select Publication Type, choose Merge Replication>Specify Subscribers Type, choose Servers running SQL Server 2000 and Devices running SQL Server CE>Specify article (ex. authors)…>Finish. I configure succeeded (A snapshot of 1 article(s) is generated).

Snapshot folder reference to path: \\server_name\C$\Program Files\Microsoft SQL Server 2005 Mobile Edition\Server\Replication

Next, I configure for SQL Server Mobile Agent, Subscriber Type, choose SQL Server Mobile Edition>Web server, choose Create a new virtual directory>Alias: Replication (reference to the path: C:\Program Files\Microsoft SQL Server 2005 Mobile Edition\Server\Replication)..>Client Authentication, choose Client will connect anonymously….>Snapshot share access, enter \\server_name\Replication =>error: The share '\\server_name\Replication'cannot be accessed. Please specify a new share. Why that?

I want to ask u I configure that correctly? If Subscriber is Pocket PC Emulator, what is subscriber ’sproperty of SqlCeReplication (Windows PocketPC Emulator?)?

Plz help me. Thanks so much.

I need your help very much. Please.|||

Firstly you should not use \\server_name\c$\.... By C$ you are assuming that the login that syncs has access to this machine's c$.

You should use a share: \\servername\repl.

Then give this share name created in the Configure virtual directory.

And I do not understand your last question about emulator.

error configure

Hi every1,

I have problem about configuration in Merge Replication.

First, I configure for SQL Server 2000, expand Replication> Publication>New Publication>Choose Publication Database, I choose pubs>Select Publication Type, choose Merge Replication>Specify Subscribers Type, choose Servers running SQL Server 2000 and Devices running SQL Server CE>Specify article (ex. authors)…>Finish. I configure succeeded (A snapshot of 1 article(s) is generated).

Snapshot folder reference to path: \\server_name\C$\Program Files\Microsoft SQL Server 2005 Mobile Edition\Server\Replication

Next, I configure for SQL Server Mobile Agent, Subscriber Type, choose SQL Server Mobile Edition>Web server, choose Create a new virtual directory>Alias: Replication (reference to the path: C:\Program Files\Microsoft SQL Server 2005 Mobile Edition\Server\Replication)..>Client Authentication, choose Client will connect anonymously….>Snapshot share access, enter \\server_name\Replication =>error: The share '\\server_name\Replication'cannot be accessed. Please specify a new share. Why that?

I want to ask u I configure that correctly? If Subscriber is Pocket PC Emulator, what is subscriber ’sproperty of SqlCeReplication (Windows PocketPC Emulator?)?

Plz help me. Thanks so much.

I need your help very much. Please.|||

Firstly you should not use \\server_name\c$\.... By C$ you are assuming that the login that syncs has access to this machine's c$.

You should use a share: \\servername\repl.

Then give this share name created in the Configure virtual directory.

And I do not understand your last question about emulator.

error configuration

I want to use custom error configuration for a single dimension.

When I set the error configuration properties for a single dimension in Visual Studio, process this dimension and process the cube then the custom error configuration settings are ignored.

When I set custom error configuration settings for the cube in Visual Studio these settins are also ignored.

When I set the custom error configuration settings in the Process Cube Window (Change Settings - Dimension Key errors) then these settings are applied to all dimensions.

How can I use custom error configuration for a single dimension and why are my settings in Visual Studio ignored.

Thanks for any reply.

They should not be ignored. Probably you work in the project mode and do not deploy before opening the processing dialog.

When you set it in VS you modify the error configuration only for the local data. If you are in project mode then you need to deploy your changes onto the server so that the changes would be known. Usually the deployment also means processing. If you just click that button to open the processing dialog in VS then it establishes a server connection and processes whatever has been previously deployed, which contains the old error configuration.

If you are in on-line mode then you need to save the object (dimension, cube) once you have changed the error configuration. Saving will propagate the meta data changes onto the server and once you open the processing dialog it will process with the new error configuration.

Saving in project mode will persist your changes on disk and not on the server. This is why in project mode you need deployment.|||

Thanks for your reply.

I have deployed my changes. I have the same behaviour when I am using SQL Server Management Studio on the server. Here I can view the current error configuration of the dimension:

Use default error configuration: disabled

Key error action: Convert To Unknown

Ignore errors

Key not found: Report And Continue

Duplicate key: Ignore Error

Null key converted to unknown: Ignore Error

Null key not allowed: IgnoreError

Error log path: C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log\analyzer.log

When I rightclick on the cube and select Process to open the Process cube window and start processing with the default settings I still get a key not found error (for this dimension with an individual configuration error setting) and processing stops.

When I change the error configuration settings in SQL Server Management Studio for the cube this settings are ignored when I process via the Process Cube window with the default settings.

And when I change the error configuration settings for the process (in the Process Cube window) these settings are taken for all dimensions and the individual settings of the dimensions are ignored.

Do I have to start the process in another way?

Are there any preconditions like schema optimization in AS 2000?

|||

> I still get a key not found error (for this dimension with an individual configuration error setting) and processing stops.

Does the processing dialog box show that the processing failed? Stops could mean it succeeded with errors. Depends how much time it takes to process your cube.

Unless you have a repro, which you could send i will need to model the situation according to your description and get back to you with the results.

|||

try to configure like this..

Click the Cube properties...

Goto Error configuration....and set it to custom...

and then expand it and set the 'Key Error Limit' as -1 save it and process the cubbe.

Hope this helps you.

|||I have made some repro simulation and asked people a question and here what has been found. When you specify Ignore Error ( -1 for KeyErrorLimit ) on a dimension it does not apply to the problems with fact data. It applies to the case when your dimension consists of attributes having sources to different tables - snowflake dimensions. The content in these tables might have referential integrity problems. Specifying -1 KeyErrorLimit will allow processing the dimension.

When you specify -1 KeyErrorLimit for a cube it allows processing when the fact tables do not have corresponding primary key in any of the dimension tables.

It is not possible to declare ignoring referential integrity problems between fact table and only one dimension table. Once it is defined on a cube or partition then referential integrity problems with all the dimensions are ignored.

In my test case i created a simple database, which has 2 dimension tables and one fact table. The fact table contained records with some foreign key values absent in the dimension tables. I created 2 dimensions and one measure group. In order to process successfully i just had to specify -1 KeyErrorLimit in ErrorConfiguration of the cube. Everything processed fine.

Maybe you have 2 types of referential integrity problems at the same time and in order to resolve them you need to specify -1 KeyErrorLimit on the dimension and on the cube.|||

Hi Andrew,

thank you very much for your detailed explanation (and also thanks to rockworld for your hint).

So it was my misunderstanding how to use the custom error configuration on a dimension.

Error After Package Configuration

I have a package that executes succesfully before package is configured.

but when package is configured to use configuration details either from SQL Server configuration table or XML configuration file, gives an error :

[Connection manager "XYZ"] Error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".

Can anyone help me out with this ?

Experts !!! this is my second post, my previous post is still unanswered.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1793362&SiteID=1

Can you share the configuration for connection manager "XYZ"? Also, are there any other error messages?|||

Details for Connection Manager XYZ

Provider: Native OLE DB\Microsoft OLE DB Provider for Oracle

Server Name : Ora_serv

UserName: User1

Pawwword: Password

Execution Result :

[DTS.Pipeline] Information: Validation phase is beginning.
Progress: Validating - 0 percent complete
Progress: Validating - 50 percent complete
[OLE DB Source "PQR" [1]] Error: The AcquireConnection method call to the connection manager "XYZ" failed with error code 0xC0202009.
[DTS.Pipeline] Error: component "OLE DB Source PQR" (1) failed validation and returned error code 0xC020801C.
Progress: Validating - 100 percent complete
[DTS.Pipeline] Error: One or more component failed validation.
Error: There were errors during task validation.
Validation is completed
[Connection manager "XYZ"] Error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
Validation is completed|||I'm curious... Do you have the Oracle client installed by chance? If so (and you need it to be), do you have "Ora_serv" listed in the tnsnames.ora file?|||

Yup !!! i have configured all the settings. After disabling the package configuration, package executes succesfully for the same connections details that are there in dtsConfig file. One thing that i have noticed, SSIS is not saving password in the config file. Even in Connection string SSIS is not saving password for oracle server.

|||SSIS won't save the password in the configuration file on its own. You can edit the configuration file yourself and add it though.|||I have tried that too, but it results in error given above.
Connection string works, but i want to use either SQL Server Table or XML file.

Error Adding Package Configurations After Removing Them

I have a package that used to have package configurations enabled, with a single XML file holding the configuration information. The configuration information was removed from the package (and "Enable Package Configurations" was left checked, although I'm not sure that is creating this problem).

Now trying to add a new configuration to the package. When I open the Package Configurations Organizer dialog box and select "Add...", I get the following error:
TITLE: Microsoft Visual Studio

An error occurred while a new configuration was being added.

ADDITIONAL INFORMATION:
The path is not of a legal form. (mscorlib)

BUTTONS:
OK
Anyone have any ideas what to do about this? I've looked at the XML for the package and can't see any improperly formed nodes or bad attribute settings or anything. Thoughts?

Dave Fackler

Did you ever get to the bottom of this Dave?

-Jamie