I am trying to launch a SSIS package remotely, and found this article http://technet.microsoft.com/en-us/library/ms403355.aspx#agent
however, i cannot add a reference to Microsoft.SqlServer.DTS.Runtime ? My Visual Studio 2005 interface does not show that as a possible reference when using "Add Reference"
I'm trying to run a piece of code in BOL and it imports the dts.runtime class. The problem is when I do the import statement in my form, I get the green line. It can't find the class. The only class found inside SqlServer is Server.
Can anyone tell me why the DTS class isn't there. The box I'm working on has visual studio 2005, and Yukon sp2. And I think I'm running v.3 of the framework, so I should be good all the way around.
It states pretty clearly in the documentation for the Microsoft.SqlServer.Dts.Runtime.Wrapper namespace that "This assembly is a Primary Interop Assembly (PIA) for the namespace Microsoft.SqlServer.Dts.Runtime, which is the assembly Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll). The classes in this namespace should not be instantiated. Instead, use the classes found in the Microsoft.SqlServer.Dts.Runtime. "
And yet as I have found out earlier today and talked about here, sometimes it is absolutely necassary to use Microsoft.SqlServer.Dts.Runtime.Wrapper. Why is this? Why is there no class in Microsoft.SqlServer.Dts.Runtime that allows me to access the specific connection managers rather than using the generic ConnectionManager class?
I have an ASP.NET web form that calls out to a component which includes the following code which leverages the Application and Package classes in the Microsoft.SqlServer.Dts.Runtime namespace:
Microsoft.SqlServer.Dts.Runtime.DTSExecResult result = package.Execute();
I am logged in to the app as DomainMe.
I have Windows Integrated Authentication configured in IIS and am using Windows Authentication in ASP.NET. I am using impersonation to impersonate a fixed identity, say DomainBob. This has the following effect:
WindowIdentity.GetCurrent() returns DomainBob as expected since the process is being impersonated by DomainBob.
Thread.CurrentPrincipal.Identity.Name returns DomainMe as expected since the ASP.NET application is using Windows Authentication.
The id variable successfuly is initialized to the GUID of the package, proving that the package name is resolving, however, from the ASP.NET application, the package fails.
Issuing the ? package.Errors[0] command at the command window provides the following information:
{Microsoft.SqlServer.Dts.Runtime.DtsError} base {Microsoft.SqlServer.Dts.Runtime.DtsObject}: {Microsoft.SqlServer.Dts.Runtime.DtsError} Description: "An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Shared Memory Provider: I/O Error detected in read/write operation [4]. ". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'MyMachine\ASPNET'.". " ErrorCode: -1071636471 HelpContext: 0 HelpFile: null IDOfInterfaceWithError: "{8BDFE898-E9D8-4D23-9739-DA807BCDC2AC}" Source: "Packages MyPackage" SubComponent: "Connection manager "DataMart"" TimeStamp: {12/21/2006 2:18:55 PM}
For some reason, the ASPNET process account is being passed to the package!
This makes no sense, because clearly, DomainBob is impersonating the worker process and all downstream resources should be accessed via DomainBob. This includes SQL Server Database Engine and I would imagine SSIS as well. ASPNET should not come into play at all since I am impersonating.
I also tried using regular (non-fixed identity) impersonation (<identity impersonate="true" />), but again, SSIS is trying to authenticate ASPNET, instead of DomainMe as would be expected.
This is definetely isolated to ASP.NET applications, because making the same call from within a unit test succeeds. It would seem that this is a definete issue because the behavior is inconsistent with ASP.NET security principles.
Has anyone else seen this problem?
Any direction or suggestions very much appreciated.
I am struggling in calling an SSIS package programatically using the Microsoft.SqlServer.Dts.Runtime namespace.
I am succesfuly connecting to the package insofar as I am able to retrieve the package ID (GUID), but when I call package.Execute I get a 'login failed for user' error, which indicates a security problem.
My ASP.NET app is running as a domain user which has temporary 'SA' rights on the server where the package is hosted. In addition, I have set the protection level on the package to 'DontSaveSensitive'.
What am I missing to be able to execute the package remotely?
I am executing an SSIS package from VB.NET code. Works great in design mode. When I publish it (using Click-Once), it works great on development computer but fails on a customer computer:
Microsoft.SqlServer.Dts.Runtime.DtsPipelineException: Retrieving the COM class factory for component with CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} failed due to the following error: 80040154. ---> System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} failed due to the following error: 80040154. at Microsoft.SqlServer.Dts.Runtime.Package..ctor() --- End of inner exception stack trace --- at Microsoft.SqlServer.Dts.Runtime.Package..ctor()
My project references Microsoft.SQLServer.ManagedDTS.
The error occurs on the following line:
Dim objPackage As New Microsoft.SqlServer.Dts.Runtime.Package
Looking at various forum threads, it would appear that it's because either (1) DLL(s) are not registered on the customer machine, or (2) DLL(s) are missing from the customer machine. The first explanation doesn't seem right -- even though Microsoft.SQLServer.ManagedDTS is a COM dll, doesn't .NET provide a wrapper when it references it? I downloaded Process Explorer from Sysinternals.com to compare loaded DLLs on my dev box to those on the customer's box and while several dlls are loaded when the line is successfully loaded, all of them exist on the customer box.
I´m wondering how to make a connection to a file in differents machines, FTP, excel file, HTTP, WebService instead of OLDDB, where can I find a reference for the constants that must be used in each case.
I have a very small project written in VB.Net 2005 using the SQL Server 2005 SSiS DTSx package.
I migrated a SLQ 2000 DTS package using the SQL 2005 Legacy tools and saved the package as a local .DTSx package on our file server.
I need to run the package from a clients PC.
I added the reference Microsoft.SqlServer.ManagedDTS so I could then use the Microsoft.SqlServer.Dts.Runtime so I can execute the commands:
Dim oApp As New Application Dim oPkg As New Package oPkg = oApp.LoadPackage(g_DTSx_Directory & "AOC copy Generic1 CSV to AOC_verify_file_1.dtsx", Nothing) Dim oResults As DTSExecResult oResults = oPkg.Execute
Ok. That works fine and is basically the entire app. It executes without a hitch in debug and as a compiled exe on my PC, but I have all the tools. So now I try and create a setup project for this and I use the setup wizard.
During the creation of the setup project I get a message that states: The following files may have dependencies that cannot be determined automatically. Please confirm that all dependencies have been added to the project. C:windowssystem32msxml6.dll
OK. The dll is part of the reference I mentioned above and I have no idea what other dependencies it may have.
How do I find this out?
Has anyone else created a project like this and experenced the same?
I am on a clean build running WinXP Pro with SP2 - VS2005 with SP1 and the SQL Server 2005 tools.
Hello, I got an exception when I try to load/run a SSIS Package programmatically on the server using remoting. The client machine has no SQL Server 2005 component installed..
This is the error I get from my exe application:
Microsoft.SqlServer.Dts.Runtime.DtsPipelineException: Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154. ---> System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154. at Microsoft.SqlServer.Dts.Runtime.Application..ctor()
And this the Remote component:
<Serializable()> Public Class SSISComponent
Inherits MarshalByRefObject
Public Function LaunchPackage(ByVal sourceLocation As String, ByVal serverName As String, ByVal packageName As String, ByVal packageVariables As SortedList) As Microsoft.SqlServer.Dts.Runtime.DTSExecResult
Dim packagePath As String Dim myPackage As Package Dim integrationServices As New Application ' Combine path and filename. packagePath = Path.Combine(sourceLocation, packageName) Try If integrationServices.ExistsOnDtsServer(packagePath, serverName) Then myPackage = integrationServices.LoadFromDtsServer(packagePath, serverName, Nothing) Else Throw New ApplicationException( "Invalid package name or location: " & packagePath) End If If Not packageVariables Is Nothing Then For Each de As DictionaryEntry In packageVariables myPackage.Variables(de.Key).Value = de.Value Next End If LaunchPackage = myPackage.Execute() Catch ex As Exception Throw End Try End Function End Class
This is the code that call the remote component to run the package on the Server: Public Class Test Private Function LoadAndRunPackageRemotly(ByVal PackageName As String, ByVal PackageVariables As SortedList) As Boolean
Dim launchPackageService As New SSISComponent Dim packageResult As Microsoft.SqlServer.Dts.Runtime.DTSExecResult Try packageResult = launchPackageService.LaunchPackage(Me.SSISPackageLocation, Me.SSISServerName, PackageName, PackageVariables) If packageResult = DTSExecResult.Success Then LoadAndRunPackageRemotly = True Else LoadAndRunPackageRemotly = False End If Catch ex As Exception Throw End Try End Function End Class
I would like to inform that everything run inside a thread because the Package do a lot of things... When I build up the setup for the exe inside the Detected Dependencies there are several DLL related to SQL Server (Microsoft.SQLServer.DTSRuntimeWrap.dll etc..etc..) that I don't register .. Tis could be the problem? If yes, somebody can tell me which one I have to register ? as COM or COMRelativePath? Some other hints?
This error could be also caused by wrong permissions on the ssis? Thank you very much for any help... p.s. To use sql server agent will be my last option!! Marina b.
I have ran into the same problem ... Importing from Access into SQL 2005 using SSIS and get the error:
[Connection manager "SourceConnectionOLEDB"] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
We scheduled lot of SSIS packages on 64 bit server and most of the time they are running fine. Some times we are getting below error message on any random package. When we re-run its working fine to success. This is repeating once in a week on different packages.
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK_TblObject'. Cannot insert duplicate key in object 'dbo.tblObject'."
I am running Windows Server 2003 R2 Enterprise Edition SP 2
I have created an integration package in VS 2005 which extracts data from Access 2000 and imports it into a table on SQL server 2005 running on this server.
The package runs ok in Visual Studio 2005, but when i schedule it as a step in 2005 SQL Agent to execute as a SQL Server Integration package using SQL Agent Service Account it comes with the following error - I did a bit of research which suggests this is due to SQL 64 bit and Windows 64b bit, however I am running 32 bit !! also the sql server agent is a domain admin user...can you gurus please help ?
Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:07:42 AM Error: 2007-10-31 10:09:13.85 Code: 0xC0202009 Source: Copy all Data to Reporting Prod Connection manager "Access Allocations.mdb" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2007-10-31 10:09:13.85 Code: 0xC020801C Source: 5_Copy vw_Allocations 5_Access Allocations [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Access Allocations.mdb" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2007-10-31 10:09:13.85 Code: 0xC0047017 Source: 5_Copy vw_Allocations DTS.Pipeline Description: component "5_Access Allocations" (1) failed validation and returned error code 0xC020801C. End Error Error: 2007-10-31 10:09:13.85 Code: 0xC004700C Source: 5_Copy vw_Allocations DTS.Pipeline Description: One or more component failed validation. End Error Error: 2007-10-31 10:09:13.85 Code: 0xC0024107 Source: 5_Copy vw_Allocations Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:07:42 AM Finished: 10:09:13 AM Elapsed: 91.422 second
This is when i try to submit a new database item in Dreamweaver. The DB I am using is SQL Server 2005.
My code is as follows:
Dim equipspec__urlid equipspec__urlid = "1" If (QueryString("ID") <> "") Then equipspec__urlid = QueryString("ID") End If %> <% Dim equipspec Dim equipspec_numRows
Hello All,I am getting the following error when attemping to open a table inSQL2kSP3a.________________________________________SQL Server Enterprise ManagerDatabase Server: Microsoft SQL ServerVersion: 08.00.0760Runtime Error: [Microsoft][ODBC SQL Server Driver]Invalid time format_________________________________________I cannot find it in sysmessages, or on the web.Any ideas about how to resolve this? And how it occured...Thanks,TGru*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
I'm running packages from C# code and thus I need to create an instance of SqlServer.DTS.Runtime.Application. In my maching, creating the application instance doesn't even take 1 sec but when the application was deployed to our QA server creating the instance took 30 secs (always ... every single time with no exception).
this single code is taking the 30 secs:
Application integrationService = New Application();
Does anyone have any idea what I need to check or configure to make this faster?
I am looking for a way to script out all tables within a SQL Server 2005 database using VB.NET. I am writing a backup utility and have been able to do stored procedures, the data within the tables, but am now stuck on scripting out the tables with their primary keys, indexes, etc. Sure, I could hard-code some stuff like "CREATE TABLE dbo" & strTable, but I am pretty sure there is a way to do it within VB.NET using SMO. So, any help that someone could offer is greatly appreciated. Thanks
Stupid question. I'm trying to reference Microsoft.SqlServer.ManagedDTS, which allegedly is to be found in Program FilesMicrosoft SQL Server90SDKAssemblies. Except it isn't. Nor is it anywhere on the machine. I know that Integration Services is installed and running - my packages run just fine out of BIDS and via dtexec. Yet I can't find the stupid dll. Clearly I've missed something. Any ideas?
I can't seem to do a lot of things. Like... backup the database through the SQL agent.
I'm catching flak from the client who was told by a microsoft rep that SQL 2005 works like a charm....
It's too late to move away from SQL 2005, we've already migrated systems over to it, and now I'm stuck.
This error happens when trying to export to a flat file using Export Wizard(right click database and choose export):
===================================
An error occurred which the SQL Server Integration Services Wizard was not prepared to handle. (SQL Server Import and Export Wizard)
===================================
Exception has been thrown by the target of an invocation. (mscorlib)
------------------------------ Program Location:
at System.RuntimeMethodHandle._InvokeConstructor(Object[] args, SignatureStruct& signature, IntPtr declaringType) at System.RuntimeMethodHandle.InvokeConstructor(Object[] args, SignatureStruct signature, RuntimeTypeHandle declaringType) at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at Microsoft.SqlServer.Dts.DtsWizard.Step2.DataSourceComboBox_SelectedIndexChanged(Object sender, EventArgs e) at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e) at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m) at System.Windows.Forms.ComboBox.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
===================================
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
------------------------------ Program Location:
at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties() at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerUtils.GetLocaleID(ConnectionManager connectionManager) at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.LoadState(ConnectionManager connManager) at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.set_ConnectionManager(ConnectionManager value) at Microsoft.SqlServer.Dts.DtsWizard.FlatFileDestForm..ctor(DataSourceInfo info, Boolean bDest, WizardInputs inputs, WizardPage page)
===================================
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
------------------------------ Program Location:
at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPropertiesProvider90.get_Properties() at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
Reinstalled SqlServer 2005 and SP2. Reinstalled VS2005 and SP1. I add a reference to Microsoft.SqlServer.Dts.DtsClient. It automatically adds a line to web.config
I am thinking a config file or something is missing/corrupt somewhere to prevent me from being able to correctly reference this dll. Can anyone help please?
I am using Component Script to do - Transforming Comma-delimited list row data to column
and I want to use MessageBox to see the value
Dim DataPnts As String
DataPnts = Row.DataPnts.ToString() -- this is my input column (data type = text in Source table and I put as Unicode string [DT_WSTR] in Output column)
I am trying to run a SSIS package first time through vb.net console application. As the first step, i was trying to add the reference for Microsoft.SqlServer.ManagedDTS assembly but it was not in the available assemblies list box in visual studio 2003!
Please guide what i am supposed to do to get it, or if there any other alternative.
I have a SSIS project that has one parent package and three child packages. When I run the project on my development machine in debug mode it works fine. Also if i run the packages using dtexec on my development machine it still works fine. However the problem comes in when I try and run the project using dtexec on the staging server i get the following error:
Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException: The value is too large to fit in the column data area of the buffer.
when i create a new database in microsoft sql server management studio,following error message is occurred;
===================================
Cannot show requested dialog.
===================================
The specified module could not be found. (Exception from HRESULT: 0x8007007E) (Microsoft.SqlServer.ConnectionInfo)
------------------------------ Program Location:
at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand) at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseGeneral.Microsoft.SqlServer.Management.Sql Mgmt.IPanelForm.OnSelection(TreeNode node) at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.DynamicallyEmbedUserControl(ViewI nfo vi, TreeNode node) at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SetView(Int32 index, TreeNode node) at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SelectCurrentNode() at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.InitializeUI(ViewSwitcherTreeView treeView, ISqlControlCollection viewsHolder, Panel rightPane) at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control) at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(ISe rviceProvider sp, XmlDocument doc) at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartTh read()
----------end of error message-------------------------- Microsoft.SqlServer.Management.Common package is situated in Microsoft.VisualStudio.vspConnectionInfo.dll. This dll also exist in the same folder path(D:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDE ) with SqlWb.exe(SQL Server Management Studio). i assume that dll can't be known by exe. how can i make exe know dll. or, is my assumption wrong? if so, how can i make it work?
I need a library for Microsoft.SqlServer.Dts.Tasks.ScriptTask. How do I go about getting this.
Basically I am trying to execute the following code to verify my SSIS ran correctly.
using System; using System.Collections.Generic; using System.Text; using Microsoft.SqlServer.Dts.Runtime; using Microsoft.SqlServer.Dts.Tasks.ScriptTask;
namespace Package_API { class Program { static void Main(string[] args) { Package p = new Package(); p.InteractiveMode = true; p.OfflineMode = true;
// Add a Script Task to the package. TaskHost taskH = (TaskHost)p.Executables.Add("STOCK : ScriptTask"); // Run the package. p.Execute(); // Review the results of the run. if (taskH.ExecutionResult == DTSExecResult.Failure || taskH.ExecutionStatus == DTSExecStatus.Abend) Console.WriteLine("Task failed or abended"); else Console.WriteLine("Task ran successfully"); } } }
Hello All, kindly help me resolving following error. Earlier it was working fine with SQL server 2000, we want to migrate to sql server 2005. I am using websphere 6.0 with following jdbc_registry.properties contents. The driver file is copied under E:Program FilesIBMWebSphereAppServerlibext ***************************************************************************** driver.class=com.microsoft.sqlserver.jdbc.SQLServerDriver connection.url=jdbc: sqlserver://MyDBServer:1433;DatabaseName=abc;user=a; password=a user=a password=a ******************************************************************************
I am using sqljdbc_1.2.2828.100_enu drivers to connect to sql server 2005. following is the exception trace from my IDE.
************ Start Display Current Environment ************ WebSphere Platform 6.0 [BASE 6.0.2.13 cf130631.22] running with process name onschedule5Node01Cellonschedule5Node01server1 and process id 244 Host Operating System is Windows 2003, version 5.2 Java version = J2RE 1.4.2 IBM Windows 32 build cn142-20050609 (JIT enabled: jitc), Java Compiler = jitc, Java VM name = Classic VM was.install.root = E:Program FilesIBMWebSphereAppServer user.install.root = E:Program FilesIBMWebSphereAppServer/profiles/default Java Home = E:Program FilesIBMWebSphereAppServerjavajre ws.ext.dirs = E:Program FilesIBMWebSphereAppServer/java/lib;E:Program FilesIBMWebSphereAppServer/profiles/default/classes;E:Program FilesIBMWebSphereAppServer/classes;E:Program FilesIBMWebSphereAppServer/lib;E:Program FilesIBMWebSphereAppServer/installedChannels;E:Program FilesIBMWebSphereAppServer/lib/ext;E:Program FilesIBMWebSphereAppServer/web/help;E:Program FilesIBMWebSphereAppServer/deploytool/itp/plugins/com.ibm.etools.ejbdeploy/runtime Classpath = E:Program FilesIBMWebSphereAppServer/profiles/default/properties;E:Program FilesIBMWebSphereAppServer/properties;E:Program FilesIBMWebSphereAppServer/lib/bootstrap.jar;E:Program FilesIBMWebSphereAppServer/lib/j2ee.jar;E:Program FilesIBMWebSphereAppServer/lib/lmproxy.jar;E:Program FilesIBMWebSphereAppServer/lib/urlprotocols.jar Java Library path = E:Program FilesIBMWebSphereAppServerjavain;.;C:WINDOWSsystem32;C:WINDOWS;E:Program FilesIBMWebSphereAppServerin;E:Program FilesIBMWebSphereAppServerjavain;E:Program FilesIBMWebSphereAppServerjavajrein;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;E:Program FilesIBMWebSphereAppServerjavain ************* End Display Current Environment ************* [3/20/08 7:15:44:188 EST] 0000000a ManagerAdmin I TRAS0028I: The trace output is stored in the circular memory buffer, holding 8192 message objects. [3/20/08 7:15:44:531 EST] 0000000a ManagerAdmin I TRAS0017I: The startup trace state is *=info. [3/20/08 7:15:44:531 EST] 0000000a ManagerAdmin A TRAS0007I: Logging to the service log is disabled [3/20/08 7:15:44:719 EST] 0000000a AdminInitiali A ADMN0015I: The administration service is initialized. [3/20/08 7:15:49:109 EST] 0000000a SystemOut O PLGC0057I: Plug-in configuration service is started successfully. [3/20/08 7:15:49:188 EST] 0000000a PMIImpl A PMON1001I: PMI is enabled [3/20/08 7:15:49:750 EST] 0000000a SibMessage I [:] CWSIU0000I: Release: WAS602.SIB Level: o0625.16 [3/20/08 7:15:49:766 EST] 0000000a SecurityDM I SECJ0231I: The Security component's FFDC Diagnostic Module com.ibm.ws.security.core.SecurityDM registered successfully: true. [3/20/08 7:15:49:875 EST] 0000000a AuditServiceI A SECJ6004I: Security Auditing is disabled. [3/20/08 7:15:49:938 EST] 0000000a distSecurityC I SECJ0309I: Java 2 Security is disabled. [3/20/08 7:15:50:000 EST] 0000000a Configuration A SECJ0215I: Successfully set JAAS login provider configuration class to com.ibm.ws.security.auth.login.Configuration. [3/20/08 7:15:50:016 EST] 0000000a distSecurityC I SECJ0212I: WCCM JAAS configuration information successfully pushed to login provider class. [3/20/08 7:15:50:031 EST] 0000000a distSecurityC I SECJ0240I: Security service initialization completed successfully [3/20/08 7:15:50:297 EST] 0000000a ObjectPoolSer I OBPL0007I: Object Pool Manager service is disabled. [3/20/08 7:15:50:328 EST] 0000000a J2EEServiceMa I ASYN0059I: Work Manager service initialized successfully. [3/20/08 7:15:50:391 EST] 0000000a CScopeCompone I CSCP0002I: Compensation service is disabled. [3/20/08 7:15:50:531 EST] 0000000a SibMessage I [:] CWSID0006I: The SIB service was not enabled and will not be started. [3/20/08 7:15:50:531 EST] 0000000a ActivitySessi I WACS0045I: ActivitySession service is disabled. [3/20/08 7:15:50:562 EST] 0000000a SOAPContainer I WSWS1062I: SOAP Container Service has been initialized. [3/20/08 7:15:50:641 EST] 0000000a SchedulerServ I SCHD0036I: The Scheduler Service is initializing. [3/20/08 7:15:50:688 EST] 0000000a SchedulerServ I SCHD0037I: The Scheduler Service has been initialized. [3/20/08 7:15:50:875 EST] 0000000a StartUpServic I STUP0008I: The Startup Beans service is disabled. [3/20/08 7:15:50:891 EST] 0000000a I18nService I I18N0010I: The Internationalization service is created on server1. [3/20/08 7:15:50:891 EST] 0000000a I18nServiceSe I I18N0010I: The Internationalization service is disabled on server1. [3/20/08 7:15:51:406 EST] 0000000a SASRas A JSAS0001I: Security configuration initialized. [3/20/08 7:15:51:859 EST] 0000000a SASRas A JSAS0002I: Authentication protocol: CSIV2/IBM [3/20/08 7:15:51:859 EST] 0000000a SASRas A JSAS0003I: Authentication mechanism: SWAM [3/20/08 7:15:51:875 EST] 0000000a SASRas A JSAS0004I: Principal name: OnProjectRealm/wsadmin [3/20/08 7:15:51:891 EST] 0000000a SASRas A JSAS0005I: SecurityCurrent registered. [3/20/08 7:15:52:047 EST] 0000000a SASRas A JSAS0006I: Security connection interceptor initialized. [3/20/08 7:15:52:078 EST] 0000000a SASRas A JSAS0007I: Client request interceptor registered. [3/20/08 7:15:52:156 EST] 0000000a SASRas A JSAS0008I: Server request interceptor registered. [3/20/08 7:15:52:172 EST] 0000000a SASRas A JSAS0009I: IOR interceptor registered. [3/20/08 7:15:53:031 EST] 0000000a CoordinatorIm I HMGR0206I: The Coordinator is an Active Coordinator for core group DefaultCoreGroup. [3/20/08 7:15:53:062 EST] 0000000a DCSPluginSing I HMGR0005I: The Single Server DCS Core Stack transport has been started for core group DefaultCoreGroup. [3/20/08 7:15:53:344 EST] 0000000a NameServerImp A NMSV0018I: Name server available on bootstrap port 2809. [3/20/08 7:15:54:078 EST] 0000000a TreeBuilder W ODCF0002E: Exception: E:Program FilesIBMWebSphereAppServerprofilesdefaultconfigcellsonschedule5Node01Cellodeswebserver1_nodevariables.xml (The system cannot find the file specified). [3/20/08 7:15:54:203 EST] 0000000a UserRegistryI A SECJ0136I: Custom Registry:com.onproject.security.registry.JdbcRegistry has been initialized [3/20/08 7:15:54:344 EST] 0000000a distContextMa E SECJ0270E: Failed to get actual credentials. The exception is java.lang.SecurityException: class "com.microsoft.sqlserver.jdbc.SQLServerConnection"'s signer information does not match signer information of other classes in the same package at java.lang.ClassLoader.checkCerts(ClassLoader.java(Compiled Code)) at java.lang.ClassLoader.defineClass(ClassLoader.java(Compiled Code)) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java(Compiled Code)) at java.net.URLClassLoader.defineClass(URLClassLoader.java:475) at java.net.URLClassLoader.access$500(URLClassLoader.java:109) at java.net.URLClassLoader$ClassFinder.run(URLClassLoader.java:848) at java.security.AccessController.doPrivileged1(Native Method) at java.security.AccessController.doPrivileged(AccessController.java:389) at java.net.URLClassLoader.findClass(URLClassLoader.java:371) at com.ibm.ws.bootstrap.ExtClassLoader.findClass(ExtClassLoader.java:113) at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code)) at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code)) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at com.onproject.security.registry.JdbcRegistry.getConnection(JdbcRegistry.java:188) at com.onproject.security.registry.JdbcRegistry.checkPassword(JdbcRegistry.java:225) at com.ibm.ws.security.registry.UserRegistryImpl.checkPassword(UserRegistryImpl.java:296) at com.ibm.ws.security.server.lm.swamLoginModule.login(swamLoginModule.java:429) at com.ibm.ws.security.common.auth.module.proxy.WSLoginModuleProxy.login(WSLoginModuleProxy.java:122) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60) at java.lang.reflect.Method.invoke(Method.java:391) at javax.security.auth.login.LoginContext.invoke(LoginContext.java:699) at javax.security.auth.login.LoginContext.access$000(LoginContext.java:151) at javax.security.auth.login.LoginContext$4.run(LoginContext.java:634) at java.security.AccessController.doPrivileged1(Native Method) at java.security.AccessController.doPrivileged(AccessController.java:351) at javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:631) at javax.security.auth.login.LoginContext.login(LoginContext.java:557) at com.ibm.ws.security.auth.JaasLoginHelper.jaas_login(JaasLoginHelper.java:376) at com.ibm.ws.security.auth.distContextManagerImpl.login(distContextManagerImpl.java:1050) at com.ibm.ws.security.auth.distContextManagerImpl.login(distContextManagerImpl.java:890) at com.ibm.ws.security.auth.distContextManagerImpl.login(distContextManagerImpl.java:881) at com.ibm.ws.security.auth.distContextManagerImpl.getServerSubjectInternal(distContextManagerImpl.java:2167) at com.ibm.ws.security.core.distSecurityComponentImpl.initializeServerSubject(distSecurityComponentImpl.java:1928) at com.ibm.ws.security.core.distSecurityComponentImpl.initialize(distSecurityComponentImpl.java:341) at com.ibm.ws.security.core.distSecurityComponentImpl.startSecurity(distSecurityComponentImpl.java:298) at com.ibm.ws.security.core.SecurityComponentImpl.startSecurity(SecurityComponentImpl.java:101) at com.ibm.ws.security.core.ServerSecurityComponentImpl.start(ServerSecurityComponentImpl.java:279) at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:820) at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:649) at com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerImpl.java:149) at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:820) at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:649) at com.ibm.ws.runtime.component.ServerImpl.start(ServerImpl.java:408) at com.ibm.ws.runtime.WsServerImpl.bootServerContainer(WsServerImpl.java:187) at com.ibm.ws.runtime.WsServerImpl.start(WsServerImpl.java:133) at com.ibm.ws.runtime.WsServerImpl.main(WsServerImpl.java:387) at com.ibm.ws.runtime.WsServer.main(WsServer.java:53) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60) at java.lang.reflect.Method.invoke(Method.java:391) at com.ibm.ws.bootstrap.WSLauncher.run(WSLauncher.java:219) at java.lang.Thread.run(Thread.java:568) . [3/20/08 7:15:54:359 EST] 0000000a distSecurityC E SECJ0208E: An unexpected exception occurred when attempting to authenticate the server's id during security initialization. The exception is java.lang.SecurityException: class "com.microsoft.sqlserver.jdbc.SQLServerConnection"'s signer information does not match signer information of other classes in the same package at java.lang.ClassLoader.checkCerts(ClassLoader.java(Compiled Code)) at java.lang.ClassLoader.defineClass(ClassLoader.java(Compiled Code)) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java(Compiled Code)) at java.net.URLClassLoader.defineClass(URLClassLoader.java:475) at java.net.URLClassLoader.access$500(URLClassLoader.java:109) at java.net.URLClassLoader$ClassFinder.run(URLClassLoader.java:848) at java.security.AccessController.doPrivileged1(Native Method) at java.security.AccessController.doPrivileged(AccessController.java:389) at java.net.URLClassLoader.findClass(URLClassLoader.java:371) at com.ibm.ws.bootstrap.ExtClassLoader.findClass(ExtClassLoader.java:113) at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code)) at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code)) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at com.onproject.security.registry.JdbcRegistry.getConnection(JdbcRegistry.java:188) at com.onproject.security.registry.JdbcRegistry.checkPassword(JdbcRegistry.java:225) at com.ibm.ws.security.registry.UserRegistryImpl.checkPassword(UserRegistryImpl.java:296) at com.ibm.ws.security.server.lm.swamLoginModule.login(swamLoginModule.java:429) at com.ibm.ws.security.common.auth.module.proxy.WSLoginModuleProxy.login(WSLoginModuleProxy.java:122) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60) at java.lang.reflect.Method.invoke(Method.java:391) at javax.security.auth.login.LoginContext.invoke(LoginContext.java:699) at javax.security.auth.login.LoginContext.access$000(LoginContext.java:151) at javax.security.auth.login.LoginContext$4.run(LoginContext.java:634) at java.security.AccessController.doPrivileged1(Native Method) at java.security.AccessController.doPrivileged(AccessController.java:351) at javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:631) at javax.security.auth.login.LoginContext.login(LoginContext.java:557) at com.ibm.ws.security.auth.JaasLoginHelper.jaas_login(JaasLoginHelper.java:376) at com.ibm.ws.security.auth.distContextManagerImpl.login(distContextManagerImpl.java:1050) at com.ibm.ws.security.auth.distContextManagerImpl.login(distContextManagerImpl.java:890) at com.ibm.ws.security.auth.distContextManagerImpl.login(distContextManagerImpl.java:881) at com.ibm.ws.security.auth.distContextManagerImpl.getServerSubjectInternal(distContextManagerImpl.java:2167) at com.ibm.ws.security.core.distSecurityComponentImpl.initializeServerSubject(distSecurityComponentImpl.java:1928) at com.ibm.ws.security.core.distSecurityComponentImpl.initialize(distSecurityComponentImpl.java:341) at com.ibm.ws.security.core.distSecurityComponentImpl.startSecurity(distSecurityComponentImpl.java:298) at com.ibm.ws.security.core.SecurityComponentImpl.startSecurity(SecurityComponentImpl.java:101) at com.ibm.ws.security.core.ServerSecurityComponentImpl.start(ServerSecurityComponentImpl.java:279) at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:820) at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:649) at com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerImpl.java:149) at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:820) at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:649) at com.ibm.ws.runtime.component.ServerImpl.start(ServerImpl.java:408) at com.ibm.ws.runtime.WsServerImpl.bootServerContainer(WsServerImpl.java:187) at com.ibm.ws.runtime.WsServerImpl.start(WsServerImpl.java:133) at com.ibm.ws.runtime.WsServerImpl.main(WsServerImpl.java:387) at com.ibm.ws.runtime.WsServer.main(WsServer.java:53) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60) at java.lang.reflect.Method.invoke(Method.java:391) at com.ibm.ws.bootstrap.WSLauncher.run(WSLauncher.java:219) at java.lang.Thread.run(Thread.java:568) . [3/20/08 7:15:54:391 EST] 0000000a distSecurityC E SECJ0007E: Error during security initialization. The exception is java.lang.SecurityException: class "com.microsoft.sqlserver.jdbc.SQLServerConnection"'s signer information does not match signer information of other classes in the same package at java.lang.ClassLoader.checkCerts(ClassLoader.java(Compiled Code)) at java.lang.ClassLoader.defineClass(ClassLoader.java(Compiled Code)) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java(Compiled Code)) at java.net.URLClassLoader.defineClass(URLClassLoader.java:475) at java.net.URLClassLoader.access$500(URLClassLoader.java:109) at java.net.URLClassLoader$ClassFinder.run(URLClassLoader.java:848) at java.security.AccessController.doPrivileged1(Native Method) at java.security.AccessController.doPrivileged(AccessController.java:389) at java.net.URLClassLoader.findClass(URLClassLoader.java:371) at com.ibm.ws.bootstrap.ExtClassLoader.findClass(ExtClassLoader.java:113) at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code)) at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code)) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at com.onproject.security.registry.JdbcRegistry.getConnection(JdbcRegistry.java:188) at com.onproject.security.registry.JdbcRegistry.checkPassword(JdbcRegistry.java:225) at com.ibm.ws.security.registry.UserRegistryImpl.checkPassword(UserRegistryImpl.java:296) at com.ibm.ws.security.server.lm.swamLoginModule.login(swamLoginModule.java:429) at com.ibm.ws.security.common.auth.module.proxy.WSLoginModuleProxy.login(WSLoginModuleProxy.java:122) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60) at java.lang.reflect.Method.invoke(Method.java:391) at javax.security.auth.login.LoginContext.invoke(LoginContext.java:699) at javax.security.auth.login.LoginContext.access$000(LoginContext.java:151) at javax.security.auth.login.LoginContext$4.run(LoginContext.java:634) at java.security.AccessController.doPrivileged1(Native Method) at java.security.AccessController.doPrivileged(AccessController.java:351) at javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:631) at javax.security.auth.login.LoginContext.login(LoginContext.java:557) at com.ibm.ws.security.auth.JaasLoginHelper.jaas_login(JaasLoginHelper.java:376) at com.ibm.ws.security.auth.distContextManagerImpl.login(distContextManagerImpl.java:1050) at com.ibm.ws.security.auth.distContextManagerImpl.login(distContextManagerImpl.java:890) at com.ibm.ws.security.auth.distContextManagerImpl.login(distContextManagerImpl.java:881) at com.ibm.ws.security.auth.distContextManagerImpl.getServerSubjectInternal(distContextManagerImpl.java:2167) at com.ibm.ws.security.core.distSecurityComponentImpl.initializeServerSubject(distSecurityComponentImpl.java:1928) at com.ibm.ws.security.core.distSecurityComponentImpl.initialize(distSecurityComponentImpl.java:341) at com.ibm.ws.security.core.distSecurityComponentImpl.startSecurity(distSecurityComponentImpl.java:298) at com.ibm.ws.security.core.SecurityComponentImpl.startSecurity(SecurityComponentImpl.java:101) at com.ibm.ws.security.core.ServerSecurityComponentImpl.start(ServerSecurityComponentImpl.java:279) at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:820) at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:649) at com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerImpl.java:149) at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:820) at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:649) at com.ibm.ws.runtime.component.ServerImpl.start(ServerImpl.java:408) at com.ibm.ws.runtime.WsServerImpl.bootServerContainer(WsServerImpl.java:187) at com.ibm.ws.runtime.WsServerImpl.start(WsServerImpl.java:133) at com.ibm.ws.runtime.WsServerImpl.main(WsServerImpl.java:387) at com.ibm.ws.runtime.WsServer.main(WsServer.java:53) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60) at java.lang.reflect.Method.invoke(Method.java:391) at com.ibm.ws.bootstrap.WSLauncher.run(WSLauncher.java:219) at java.lang.Thread.run(Thread.java:568) . [3/20/08 7:15:59:406 EST] 0000000a SchedulerServ I SCHD0040I: The Scheduler Service is stopping. [3/20/08 7:15:59:422 EST] 0000000a SchedulerServ I SCHD0002I: The Scheduler Service has stopped. [3/20/08 7:15:59:438 EST] 0000000a AppProfileCom I ACIN0009I: The application profiling service is stopping. [3/20/08 7:15:59:438 EST] 0000000a ActivitySessi I WACS0049I: The ActivitySession service is stopping. [3/20/08 7:15:59:547 EST] 0000000a WsServerImpl E WSVR0009E: Error occurred during startup META-INF/ws-server-components.xml [3/20/08 7:15:59:562 EST] 0000000a WsServerImpl E WSVR0009E: Error occurred during startup com.ibm.ws.exception.RuntimeError: com.ibm.ws.exception.RuntimeError: class "com.microsoft.sqlserver.jdbc.SQLServerConnection"'s signer information does not match signer information of other classes in the same package at com.ibm.ws.runtime.WsServerImpl.bootServerContainer(WsServerImpl.java:194) at com.ibm.ws.runtime.WsServerImpl.start(WsServerImpl.java:133) at com.ibm.ws.runtime.WsServerImpl.main(WsServerImpl.java:387) at com.ibm.ws.runtime.WsServer.main(WsServer.java:53) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60) at java.lang.reflect.Method.invoke(Method.java:391) at com.ibm.ws.bootstrap.WSLauncher.run(WSLauncher.java:219) at java.lang.Thread.run(Thread.java:568) Caused by: com.ibm.ws.exception.RuntimeError: class "com.microsoft.sqlserver.jdbc.SQLServerConnection"'s signer information does not match signer information of other classes in the same package at com.ibm.ws.security.core.ServerSecurityComponentImpl.start(ServerSecurityComponentImpl.java:322) at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:820) at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:649) at com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerImpl.java:149) at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:820) at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:649) at com.ibm.ws.runtime.component.ServerImpl.start(ServerImpl.java:408) at com.ibm.ws.runtime.WsServerImpl.bootServerContainer(WsServerImpl.java:187) ... 10 more Caused by: com.ibm.websphere.security.WSSecurityException: class "com.microsoft.sqlserver.jdbc.SQLServerConnection"'s signer information does not match signer information of other classes in the same package at com.ibm.ws.security.auth.distContextManagerImpl.getServerSubjectInternal(distContextManagerImpl.java:2187) at com.ibm.ws.security.core.distSecurityComponentImpl.initializeServerSubject(distSecurityComponentImpl.java:1928) at com.ibm.ws.security.core.distSecurityComponentImpl.initialize(distSecurityComponentImpl.java:341) at com.ibm.ws.security.core.distSecurityComponentImpl.startSecurity(distSecurityComponentImpl.java:298) at com.ibm.ws.security.core.SecurityComponentImpl.startSecurity(SecurityComponentImpl.java:101) at com.ibm.ws.security.core.ServerSecurityComponentImpl.start(ServerSecurityComponentImpl.java:279) ... 17 more Caused by: com.ibm.websphere.security.auth.WSLoginFailedException: class "com.microsoft.sqlserver.jdbc.SQLServerConnection"'s signer information does not match signer information of other classes in the same package at com.ibm.ws.security.server.lm.swamLoginModule.login(swamLoginModule.java:435) at com.ibm.ws.security.common.auth.module.proxy.WSLoginModuleProxy.login(WSLoginModuleProxy.java:122) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60) at java.lang.reflect.Method.invoke(Method.java:391) at javax.security.auth.login.LoginContext.invoke(LoginContext.java:699) at javax.security.auth.login.LoginContext.access$000(LoginContext.java:151) at javax.security.auth.login.LoginContext$4.run(LoginContext.java:634) at java.security.AccessController.doPrivileged1(Native Method) at java.security.AccessController.doPrivileged(AccessController.java:351) at javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:631) at javax.security.auth.login.LoginContext.login(LoginContext.java:557) at com.ibm.ws.security.auth.JaasLoginHelper.jaas_login(JaasLoginHelper.java:376) at com.ibm.ws.security.auth.distContextManagerImpl.login(distContextManagerImpl.java:1050) at com.ibm.ws.security.auth.distContextManagerImpl.login(distContextManagerImpl.java:890) at com.ibm.ws.security.auth.distContextManagerImpl.login(distContextManagerImpl.java:881) at com.ibm.ws.security.auth.distContextManagerImpl.getServerSubjectInternal(distContextManagerImpl.java:2167) ... 22 more Caused by: java.lang.SecurityException: class "com.microsoft.sqlserver.jdbc.SQLServerConnection"'s signer information does not match signer information of other classes in the same package at java.lang.ClassLoader.checkCerts(ClassLoader.java(Compiled Code)) at java.lang.ClassLoader.defineClass(ClassLoader.java(Compiled Code)) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java(Compiled Code)) at java.net.URLClassLoader.defineClass(URLClassLoader.java:475) at java.net.URLClassLoader.access$500(URLClassLoader.java:109) at java.net.URLClassLoader$ClassFinder.run(URLClassLoader.java:848) at java.security.AccessController.doPrivileged1(Native Method) at java.security.AccessController.doPrivileged(AccessController.java:389) at java.net.URLClassLoader.findClass(URLClassLoader.java:371) at com.ibm.ws.bootstrap.ExtClassLoader.findClass(ExtClassLoader.java:113) at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code)) at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code)) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at com.onproject.security.registry.JdbcRegistry.getConnection(JdbcRegistry.java:188) at com.onproject.security.registry.JdbcRegistry.checkPassword(JdbcRegistry.java:225) at com.ibm.ws.security.registry.UserRegistryImpl.checkPassword(UserRegistryImpl.java:296) at com.ibm.ws.security.server.lm.swamLoginModule.login(swamLoginModule.java:429) ... 40 more
Where can I find the reference to Microsoft.SqlServer.Management.Smo in SQL Server 2005?
I currently have Microsoft SQL Server 2005, Microsoft SQL Native Client and Server VSS writer installed. (and ran the Service Pack 2 installer, but it doesn't want to update 'Database Services')
I have written a shell script that connects to a SQL Server 2005 database from Linux in order to monitor various areas of SQL.
One of the databases that are being monitored is mirrored, which is no problem in itself as I use the failoverPartner property in my connection string before I pass the TSQL. Unfortunately when the principal/mirror status changes, I get a constant stream of Failure Audit (Login failure) messages in the Mirror server Windows event log even though the failoverPartner property works and redirects to the partner, returning the correct information.
Here is a trace of the connection:
------
22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.Util parseUrl FINE: Property : serverName Value:SERVER1 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.Util parseUrl FINE: Property:databaseNameValue:TESTDATABASE 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.Util parseUrl FINE: Property:failoverPartnerValue:SERVER2 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.Util parseUrl FINE: Property:integratedSecurityValue:false 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.Util parseUrl FINE: Property:loginTimeoutValue:3 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection connect FINE: Calling securityManager.checkConnect(SERVER1,1433) 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection connect FINE: securityManager.checkConnect succeeded. 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection loginWithFailover FINE: Start time: 1172160120083 Time out time: 1172160123083 Timeout Unit Interval: 240 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection loginWithFailover FINE: This attempt server name: SERVER1 port: 1433 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection loginWithFailover FINE: This attempt endtime: 1172160120323 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection loginWithFailover FINE: This attempt No: 0 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection connectHelper FINE: Connecting with server: SERVER1 port: 1433 Timeout slice: 232 Timeout Full: 3 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerException logException FINE: *** SQLException:[Thread[main,5,main], IO:5571e, Dbc:a8327] com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "TESTDATABASE" requested by the login. The login failed. Msg 4060, Level 11, State 1, Cannot open database "TESTDATABASE" requested by the login. The login failed. 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection loginWithFailover FINE: This attempt server name: SERVER2 port: 1433 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection loginWithFailover FINE: This attempt endtime: 1172160120369 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection loginWithFailover FINE: This attempt No: 1 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection connectHelper FINE: Connecting with server: SERVER2 port: 1433 Timeout slice: 237 Timeout Full: 3 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection loginWithFailover FINE: adding new failover info server: SERVER1 instance: null database: TESTDATABASE server provided failover: SERVER1 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.FailoverInfo failoverAdd FINE: Failover detected. failover partner=SERVER1 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.FailoverMapSingleton putFailoverInfo FINE: Failover map add server: SERVER1; database:TESTDATABASE; Mirror:SERVER1 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection connect FINE: End of connect 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerStatement <init> FINE: Statement properties ID:0 Connection:1 Result type:1003 (2003) Concurrency:1007 Fetchsize:128 bIsClosed:false tdsVersion:com.microsoft.sqlserver.jdbc.TDSVersion@15fea60 bCp1252:false useLastUpdateCount:true isServerSideCursor:false 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerStatement doExecuteStatement FINE: Executing (not server cursor) USE TESTDATABASE SELECT "TESTCOLUMN" FROM TEST_TABLE ORDER BY DateTime 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection close FINE: Closing connection ID:1 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.Util parseUrl FINE: Property : serverName Value:SERVER1 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.Util parseUrl FINE: Property:databaseNameValue:TESTDATABASE 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.Util parseUrl FINE: Property:failoverPartnerValue:SERVER2 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.Util parseUrl FINE: Property:integratedSecurityValue:false 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.Util parseUrl FINE: Property:loginTimeoutValue:3 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection connect FINE: Calling securityManager.checkConnect(SERVER1,1433) 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection connect FINE: securityManager.checkConnect succeeded. 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection loginWithFailover FINE: Start time: 1172160120736 Time out time: 1172160123736 Timeout Unit Interval: 240 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection loginWithFailover FINE: This attempt server name: SERVER1 port: 1433 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection loginWithFailover FINE: This attempt endtime: 1172160120976 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection loginWithFailover FINE: This attempt No: 0 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection connectHelper FINE: Connecting with server: SERVER1 port: 1433 Timeout slice: 233 Timeout Full: 3 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerException logException FINE: *** SQLException:[Thread[main,5,main], IO:5571e, Dbc:a8327] com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "TESTDATABASE" requested by the login. The login failed. Msg 4060, Level 11, State 1, Cannot open database "TESTDATABASE" requested by the login. The login failed. 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection loginWithFailover FINE: This attempt server name: SERVER2 port: 1433 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection loginWithFailover FINE: This attempt endtime: 1172160121031 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection loginWithFailover FINE: This attempt No: 1 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection connectHelper FINE: Connecting with server: SERVER2 port: 1433 Timeout slice: 236 Timeout Full: 3 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection loginWithFailover FINE: adding new failover info server: SERVER1 instance: null database: TESTDATABASE server provided failover: SERVER1 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.FailoverInfo failoverAdd FINE: Failover detected. failover partner=SERVER1 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.FailoverMapSingleton putFailoverInfo FINE: Failover map add server: SERVER1; database:TESTDATABASE; Mirror:SERVER1 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerConnection connect FINE: End of connect 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerStatement <init> FINE: Statement properties ID:0 Connection:1 Result type:1003 (2003) Concurrency:1007 Fetchsize:128 bIsClosed:false tdsVersion:com.microsoft.sqlserver.jdbc.TDSVersion@15fea60 bCp1252:false useLastUpdateCount:true isServerSideCursor:false 22-Feb-2007 16:02:00 com.microsoft.sqlserver.jdbc.SQLServerStatement doExecuteStatement FINE: Executing (not server cursor) USE TESTDATABASE SELECT DATEDIFF(SECOND, DATETIME, GETDATE()) FROM TEST_TABLE 22-Feb-2007 16:02:01 com.microsoft.sqlserver.jdbc.SQLServerConnection close FINE: Closing connection ID:1
I cant supply a native database in the connection string (i.e Master) and then switch to the mirrored database in TSQL because the failoverPartner property does not apply to the session, only to the initial connection.
