.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSIS problem on sql server 2005 cluster

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

I have asked one question about the ssis service on sqlserver 2005 cluster.

the content is as belowing:

i installed ssis service on each node,and modify the ssis configuration file on each node also.
here is two format,but i don't know which one is right.\


<?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">
    <Folder xsi:type="SqlServerFolder">
    <Folder xsi:type="FileSystemFolder">
      <Name>File System</Name>

View Complete Post

More Related Resource Links

SQL Server 2005 cluster install with SSRS and SSIS - best approach for installs and migration?


I just installed SQLServer 2005 STD edition SP3 on an active/passive 2 node cluster, Intended to replace a SQLServer 2005 sp3 EE install (not clustered) that is in production now using SSIS and SSRS.  I would need to migrate the databases, reporting, and Integration Services over to the new server cluster.  


1.    Does it make sense to run on a SQL Server 2005 on a cluster if SSIS and SSRS are not cluster aware? This is my 1st time adm

Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint


I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

Any help will be very appreciated!


SQL Server 2005 - Installation in Cluster Environment - "Service SQL Server Browser (SQLBrowser) fai

Windows Server 2003 R2 Enterprise Edition SP2 32-bit All updates and patches installed Two-node cluster environment configured. Cluster functions perfectly. Trying to install SQL Server 2005 Enterprise Edition (32-bit) as a clustered application. Installation proceeds fine until it begins to install the SQL Server Database Services product. Status window says "Starting Services. Service: SQL Server Browser". Error message is presented: "Service 'SQL Server Browser' (SQLBrowser) failed to start. Verify that you have sufficient privileges to start system services". SQL Server Service Account is in the Administrators group on both local systems, and is a domain account. Account used for the installation is in the Administrators group on both local systems, and is a domain account. Have cancelled out of the install and rebooted both servers numerous times. Exact same error continues to occur. Cluster is active and all resources are owned by node #1 - the node where SQL Server Installation is being run. In the event viewer, I see: Event ID: 10 Description: The SQLBrowser service was unable to establish SQL instance and connectivity discovery". I am also seeing errors like: Source: SQLBrowser. The SQL configuration for SQL is inaccessible or invalid. Source: SQLBrowser. The Configuration of the AdminConnection\TCP protocol in the SQL instance xxxxxx i

Sql Server 2005 Cluster on EXS 4.0 VMWARE

Hi, I have this problem, i have sql server on Cluster with two nodes, the nodes are machine vmware, i was exs 3.5 and in december the esx was upgrade to version 4.  Of January the nodes present this problem:The node lost communication with cluster node 'SVRSQLN02' on network 'Servidores'.The node lost communication with cluster node 'SVRSQLN02' on network 'HeartBeat'.What can i do?

SSIS 2005 - Send Mail Task - signature appended to email is garbled - unicode problem?

Hi, I'm pretty new to SSIS so go easy on me. I have a Send Mail Task to notify if a file cannot be imported - the mailbody is created on the previous step by a VB.NET script task to include the name of the file and the path it's been archived to. The problem I'm having is that while the body of the email I've created is displaying fine, our company's Exchange server appends a signature to all emails, and this is coming up as undisplayable characters, presumably due to some kind of unicode encoding problem. I've tried casting the email body in an expression to DT_STR (doesn't work as DT_STR "cannot be converted to a supported type" which seems a bit odd but never mind), DT_WSTR (garbled signature), DT_TEXT/DT_NTEXT (strange error on this one - "Attempted to read or write protected memory") none of those ideas worked, and I'm a bit stumped now. Can anyone help? I'm using SSIS 2005 with SP3

Loading Decimal Number From Excel into SQL Server 2005 using SSIS Package

If you have an excel spreadsheet that displays a number .02 (because it is formated) but internally it is stored as .2654329 and you want to load .2654329 how can you do that in the SSIS package?  When we load the spreadsheet it is loading .02.  Is there some kind of option in the SSIS package to tell the package to load the internal number?lcerni

SSIS 2005 - XML Source no data loading to sql server database destination

Hello I am trying to load data from xml source to sql server destination, but the task executes with no data loaded to destination. i really appreciate any guidance in working and troubleshooting xml sources. Regards Harris

Database connectivity problem (sql server 2005)

I want to connect my database using my windows application. My database is on the server and i my connection string is something like that Data Source=;User ID=myUserID;pwd=MyPwd;Initial Catalog=MyDatabase When i  try to connect in my local network using this connection string this work fine Data Source=MyServerName;User ID=myUserID;pwd=MyPwd;Initial Catalog=MyDatabase These are my server setting Go to "SQL server 2005 Surface Area Configuration" Surface Area Configuration for Services and Connections In Configure Surface Area for localhost (chnage computer) 1)Click (chnage computer) 2)Then Select Computer Window open, Now checked the local computer -> OK View By Instance: 1)Database Engine -> Service Start 2)Database Engine -> Remote Connections -> Local and remote connections -> Using both TCP/IP and named pipes 3)SQL server Browser - > Service Start Apply - OK View By Component: 1)Database Engine -> Service Start 2)Database Engine -> Remote Connections -> Local and remote connections -> Using both TCP/IP and named pipes 3)SQL server Browser - > Service Start Apply - OK Now In SQL server Configuration Manager. Shared Memory   : Enabled TCP/IP   : Enabled Named Pipes : Enabled VIA  : Disabled Select Client Protocols in the left side. In the TCP/IP Properties these are my

Sql server 2005 - rename cluster to an old cluster name

We have a sql 2005 cluster on W2K8 cluster. It is a named instance say SRV1\A. Then I built a new W2K8 (with a diff cluster service name) but the same service account. Then I installed a new sql 2005 cluster say SRV2\A. Now when I bring down the sql server resources on SRV1 and try to rename SRV2\A to SRV1\A through the cluster admin, I get the error the network name already exists. I have tried bringing an old cluster and installing a new cluster with the same name and it works. Why am I not able to rename the name? Any advice would very helpful.Paul - SQL DBA

How to remove deployed SSIS packages to SQL Server 2005?

Hi All I need to find a way of removing all packages deployed to a SQL server - can this be done?   Thanks   Big Gopher

Problem Installing SQL 2005 Enterprise on Server 2008R2 Enterprise???

I am trying to install SQL Server 2005 Enterprise onto a new WinServer Enterprise 2008R2 box.  I am using my MSDN disk that contains the various flavors of SQL Server 2005.  When I select to install Enterprise (64 bit) version all that is available for installation are the client tools, no server tools.  When I install the Standard version, the server tools are available. Is there a problem installing SQL 2005 Enterprise on WinServer Enterprise 2008R2???

SQL Server 2005 Cluster failover issue

Hi All, I'm fequently experience Cluster failover issue. The cluster tries to failover and it fails back. Because of this the SQL server is getting restarted and this is a bugging issue during business hours. The following are the System event logs, Cluster resource 'SQL Server' in Resource Group 'Production' failed. The SQL Server Agent (MSSQLSERVER) service was successfully sent a stop control. The SQL Server Agent (MSSQLSERVER) service entered the stopped state. The SQL Server (MSSQLSERVER) service was successfully sent a stop control. The SQL Server (MSSQLSERVER) service entered the stopped state. The SQL Server (MSSQLSERVER) service was successfully sent a start control. The SQL Server (MSSQLSERVER) service entered the running state. The Cluster Service brought the Resource Group "Production" online.    The following are the application event logs, The client was unable to reuse a session with SPID 131, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message. [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed [sqsrvres] printODBCError: sqlstate = HYT00; native error = 0; message = [Microsoft][SQL Native Client]Query timeout expired [sqsrvres] OnlineThread: QP is not online. The client was unable

SQL Server 2005 installation on windows 2008 cluster error


I am trying to install SqlServer 2005 on windows 2008 cluster with domain controller. Installation fails on the second node while trying to set registry settings for server network libraries. Attached error message and output from error log. Can somebody suggest any solutions.



TITLE: Microsoft SQL Server 2005 Setup

Failed to set registry settings for server network libraries. The action is SetDefaults. The error is 11004 (The requested name is valid, but no data of the requested type was found.


Func Name='LaunchFunction'>
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_SetServerSSNLDefaults
PerfTime Start: Do_SetServerSSNLDefaults : Fri Sep 24 17:45:31 2010
<Func Name='Do_SetServerSSNLDefaults'>
Setting server network settings for instance name MSSQLSERVER, instance id MSSQL.1
Failed to set registry settings for server network libraries. The action: SetDefaults Error: 11004
        Error Code: 0x80072afc (11004)
Windows Error Text: The requested name is valid, but no data of the requested type was found.
  Source File Name: sqlca\nlregca.cpp
Compiler Ti

Substitute for Builtin\administrator....( SQL Server 2005 x86 on a cluster )


Hi Security Experts ,

Receintly , we had a situation where we were not able to login to SQL Server 2005 x86 on a cluster .The reason was that we had removed Builtin/Admin ....We had to add it back to bring the SQL Server resource up and running ...But due to Audit we cant keep Builtin\Admin and will have to remove it ...Is there a way to have a substitute for this ...I am sure there will be ..


Abhay Chaudhary OCP 9i, MCTS/MCITP (SQL Server 2005, 2008, 2005 BI) ms-abhay.blogspot.com/

Microsoft SQL Server 2005 Uninstall remove problem


In trying to install the 2010 Switched On Schoolhouse Home Edition it tries to install the SQL server then comes up with error message that it fails.


Tech support walked me through trying to delete all the SQL titles manually and I came to the last and only application of Microsoft SQL Server 2005 with a log file "80" that will NOT delete.


The IT told me it was corrupt in the registry.


Is there ANY way to delete this??? The new installation has a newer version but I think it is the same one.


Thanks, Ricky

Problem with ISNumeric function in SQL Server 2005


Even though the system function IsNumeric('2,344') returns a true in SQL Server 2005, why does the following throw an error? Is there a special way to cast to numeric types in SQL Server 2005, so the statement below does not throw an error?

          WHEN 1 THEN CAST('2,344' AS INT)
          ELSE NULL

SQL SERVER 2005 - problem with Import Wizard


I am importing some tables from a MS Access to SQL server 2005 and I am using the import wizard but I am not seeing the data mapping tool, I need to have the ability to delete the data from the destination server and allow the identity.  I had done many times in the past, but I just got a new computer and I installed the SQL server 2005 workstation in it.  Is a setting that I need to change? that will allow me to have the data mapping.

Thanks a lot


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend