Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Why Do I Need Microsoft.SqlServer.Dts.Runtime.Wrapper Namespace


Hi,

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?

-Jamie

 

 

 

 


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Error: 'Dts' Does Not Exist In The Namespace 'Microsoft.Sqlserver'
I tried to create a package from a C# program, and I copied this from SQL server online book:

View Replies !   View Related
Where Can I Find Microsoft.SqlServer.Management.Smo Namespace?
Hello,
 
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')
 
 
Thanks in advance,
 
Ruben Pieters

View Replies !   View Related
Problem Sending 32KB Message Using ServiceBrokerInterface Example From Microsoft.Samples.SqlServer Namespace.
I have been using the ServiceBrokerInterface example for a project of mine and so far it has been very successfull. However , I recently attempted to use it to send a large-ish message (32K xml file from MS Word) to SQL. The message is recieved but the Body member of the message is null when I try to retrieve the data from within my stored procedure CLR method.

The only differences I can see between the message that does not work and those that do are that the one that doesn't is large and it is XML data that I read from a .xml file produced by MS Word as opposed to internally generated strings in the other working messages.

Does anybody have any suggestions as to why the body of the message is not being sent in this case?
Is there something about the example code that precludes sending this type of message?


This is the code that sends the message (extracted from Conversation.cs in ServiceBrokerExample)

            string query = "SEND ON CONVERSATION @ch MESSAGE TYPE @mt ";
            param = cmd.Parameters.Add("@ch", SqlDbType.UniqueIdentifier);
            param.Value = m_handle;
            param = cmd.Parameters.Add("@mt", SqlDbType.NVarChar, 255);
            param.Value = message.Type;

            if (message.Body != null)
            {
                query += " (@msg)";
                param = cmd.Parameters.Add("@msg", SqlDbType.VarBinary);
                param.Value = new SqlBytes(message.Body);
                param.Size = -1;
            }
            cmd.CommandText = query;
            cmd.ExecuteNonQuery();




This is the code that reads the message from the SQL queue (extracted from Message.cs in ServiceBrokerExample)

            m_reader = reader;
            m_convGroupId = reader.GetGuid(0);
            m_conv = new Conversation(service, reader.GetGuid(1));
            m_sequenceNumber = reader.GetInt64(2);
            m_serviceName = reader.GetString(3);
            m_contractName = reader.GetString(4);
            m_type = reader.GetString(5);
            m_validation = reader.GetString(6);
            if (!reader.IsDBNull(7))
            {
                SqlBytes sb = reader.GetSqlBytes(7);
                Body = sb.Stream;
            }
            else
                Body = null;




This is the MESSAGE TYPE used by this message.

CREATE MESSAGE TYPE CreateReport_Command VALIDATION = None;




Here is the code where msgReceived.Body == null in the SQL CLR method invoked by this message.

    [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Design", "CA1062:ValidateArgumentsOfPublicMethods"), System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Performance", "CA1822:MarkMembersAsStatic"), BrokerMethod("AssessmentContract", "CreateReport_Command")]
    public void CreateReport_Command(
        Message msgReceived,
        SqlConnection connection,
        SqlTransaction transaction)
    {
        StreamReader reader = null;

        try
        {
            reader = new StreamReader(msgReceived.Body);




And finally here is the code snippet that creates the stream that gets loaded into the message to be sent.

            if (Report != null && ReportName != null)
            {
                MemoryStream ReportBody = new MemoryStream();

                if (ReportID == null)
                {
                    ReportID = Guid.NewGuid().ToString();
                }

                ReportBody.Write(Encoding.ASCII.GetBytes(ReportID), 0, ReportID.Length);
                ReportBody.Write(Encoding.ASCII.GetBytes("|".ToCharArray()), 0, 1);
                ReportBody.Write(Encoding.ASCII.GetBytes(ReportName), 0, ReportName.Length);
                ReportBody.Write(Encoding.ASCII.GetBytes("|".ToCharArray()), 0, 1);
                ReportBody.Write(Encoding.ASCII.GetBytes(Report), 0, Report.Length);

                Microsoft.Samples.SqlServer.Message request = new Microsoft.Samples.SqlServer.Message("CreateAssessmentReport_Command", ReportBody);

                // Send the message to the service
                dialog.Send(request, conn, tran);

View Replies !   View Related
The Type Or Namespace Name 'SqlServer' Does Not Exist In The Namespace 'System.Data'
Hi,
I have created a .net class library and i include the namespace :
using System.Data.SqlServer
but when i build my .net class library i get the folowing error:
The type or namespace name 'SqlServer' does not exist in the namespace 'System.Data' (are you missing an assembly reference?) 
 
your help is highly appreciated
Best regards

View Replies !   View Related
Microsoft.SqlServer.DTS.Runtime
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"
 
How can I fix that?
 
Thanks

View Replies !   View Related
Microsoft.SqlServer.Dts.Runtime
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.
 
Thx.

View Replies !   View Related
Microsoft.SqlServer.Dts.Runtime && ASP.NET Identity Problem
Greetings,

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:

Application application = new Application();

Package package = application.LoadFromDtsServer(@"File SystemMyPackagesMyPackage", "MyMachine", null);



string id = package.ID;

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.

Thanks,

Rick

View Replies !   View Related
Microsoft.SqlServer.Dts.Runtime ASP.NET Security Issue
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?
 
TIA,
 
Rick

View Replies !   View Related
Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException HResult -2146233088
i get  the following exception  HResult -2146233088

  [Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException] {"No description found"} Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException

 when i try to use this following code snippet

 

try

{

ConnectionManager objOLEDBConnection;

Microsoft.SqlServer.Dts.Runtime.Package objPackage = new Microsoft.SqlServer.Dts.Runtime.Package();

 

 

objOLEDBConnection = objPackage.Connections.Add("OLEDB");

}

catch(Exception ex)

{

ex.Message ;

}


could you please help me out with this ?

View Replies !   View Related
Data Flow Task Is What In Microsoft.sqlserver.dts.runtime
when using the microsoft.sqlserver.dts.runtime to create packages programatically....

what object represents a data flow task?

View Replies !   View Related
Error 80040154 Using Microsoft.SqlServer.Dts.Runtime.Package
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.
 
Any help would be greatly appreciated.
 

View Replies !   View Related
VB.Net 2005 Setup Creation Gets Error Using Microsoft.SqlServer.Dts.Runtime
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.

View Replies !   View Related
About Adding Connections In Microsoft.SqlServer.Dts.Runtime Package Class
Hi,
 
I have de following code:

ConnectionManager adventureWorks = package.Connections.Add("OLEDB");

 
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.
 
thanks.  
 

View Replies !   View Related
Execute() In Class Microsoft.SqlServer.Dts.RunTime.Package Has Memory Leak
The Execute method in Microsoft.SqlServer.Dts.RunTime.Package class has memory leak after each invokation. This following code demonstrates it.

Output from the program:

Allocated memory after 1 iteration(s) = 476316
Allocated memory after 2 iteration(s) = 546448
Allocated memory after 3 iteration(s) = 555008
Allocated memory after 4 iteration(s) = 563632
Allocated memory after 5 iteration(s) = 572232
Allocated memory after 6 iteration(s) = 580856
Allocated memory after 7 iteration(s) = 589480
Allocated memory after 8 iteration(s) = 598240
Allocated memory after 9 iteration(s) = 606816
Allocated memory after 10 iteration(s) = 615424
Allocated memory after 11 iteration(s) = 624000
Allocated memory after 12 iteration(s) = 632576
Allocated memory after 13 iteration(s) = 641152
Allocated memory after 14 iteration(s) = 649728
Allocated memory after 15 iteration(s) = 658352
Allocated memory after 16 iteration(s) = 666948
Allocated memory after 17 iteration(s) = 675760
Allocated memory after 18 iteration(s) = 684380
Allocated memory after 19 iteration(s) = 693008
Allocated memory after 20 iteration(s) = 701532

 

//-----------------------------------------------------------------------------

// The Execute method in Microsoft.SqlServer.Dts.RunTime.Package has memory

// leak. This program demonstrates it. The package invoked by this program has

// only a single 'Script Task' that does nothing.

//

// To compile, add referece to Microsoft.SQLServer.ManagedDTS.dll.

//

// csc /r:"C:Program FilesMicrosoft SQL Server90SDKAssembliesMicrosoft.SQLServer.ManagedDTS.dll" ExecPackage.cs

//

//-----------------------------------------------------------------------------

using System;

using System.Diagnostics;

using Microsoft.SqlServer.Dts.Runtime;

namespace Misc

{

/// <summary>

/// Programmatically executes SSIS package, then displays memeory usage

/// after each execution. The memeory usage goes up after each

/// Package.Execute() call, which indicates memory leak!

/// </summary>

static class ExecPackage

{

static void DisplayUsage()

{

Console.WriteLine(@"Usage: ExecPackage <pkgName>");

Console.WriteLine(@" Package <pkgName> resides in Package Store on localhost under File System");

}

static void Main(string[] args)

{

// Parse command line arguments.

if (args.Length != 1)

{

DisplayUsage();

return;

}

string pkgName = @"File System" + args[0];

// Programmatically execute the package several times.

Application app = new Application();

for (int i = 1; i <= 20; i++)

{

Package pkg = app.LoadFromDtsServer(pkgName, "localhost", null);

pkg.Execute(); // comment out this line, then allocated memory does not increase

// Process.Start("dtexec.exe", "/dts "" + pkgName + """);

pkg.Dispose();

pkg = null;

// Do garbage collection, then display memory usage

GC.Collect();

Console.WriteLine("Allocated memory after {0} iteration(s) = {1}",

i, GC.GetTotalMemory(true));

}

}

}

}

View Replies !   View Related
Unable To Reference Dts.Runtime.Wrapper From Script Task
Hi,

 

I am currently trying to create a Script Task which reads in a file containing meta-data which then dynamically creates a Flat File Connection Manager and configures it using this meta data.  After perusing various newsgroups and articles, it seems that I need to be able to reference the Dts.Runtime.Wrapper to do this.  I have tried using the Add Reference dialog, but it does not contain a reference to this namespace.  I can reference this namespace from a "Script Component" but I am unable to reference it from a "Script Task".  Is this a known issue or am I just not doing something correctly?  If anyone could give me any pointers it would be greatly appreciated.  Thanks!

 

Michael 

View Replies !   View Related
Load/Run SSIS Packages On The Server From A .net Exe Exception:Microsoft.SqlServer.Dts.Runtime.DtsPipelineException: Retrieving.
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.

View Replies !   View Related
Microsoft VBScript Runtime Error
Hello,

I am currently getting the following error:

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'QueryString'

/admin/equipment/addequipment.asp, line 128

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

Set equipspec = Server.CreateObject("ADODB.Recordset")
equipspec.ActiveConnection = MM_intranet_STRING
equipspec.Source = "SELECT * FROM EquipSpec WHERE " + Replace(equipspec__urlid, "'", "''") + " = EquipSpec.ID"
equipspec.CursorType = 0
equipspec.CursorLocation = 2
equipspec.LockType = 1
equipspec.Open()

Would be greatful if anybody could help, let me know if you need more info.

Many thanks.

View Replies !   View Related
Creating Instance Of SqlServer.Dts.Runtime.Application Takes 30 Seconds
 

Hi guys, need help again.
 
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?

View Replies !   View Related
Runtime Error: [Microsoft][ODBC SQL Server Driver]Invalid Time Format
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!

View Replies !   View Related
Microsoft.SqlServer.Management
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

View Replies !   View Related
Looking For Microsoft.SqlServer.ManagedDTS
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?

View Replies !   View Related
Cannot Fine Microsoft.SqlServer.ConnectionInfo.dll
The files

Microsoft.SqlServer.Smo.dll
MicrosoftSqlServer.ConnectionInfo.dll
Microsoft.SqlServer.SmoEnum.dll

should be found in the C:Program FilesMicrosoft SQL Server90SDKAssemblies directory. However, they are not there. Any ideas why?
Thanks
Bill

View Replies !   View Related
Error Using Microsoft.SqlServer.ManagedDTS.dll
Hi,

 

I  picked the Microsoft.SQLServer.ManagedDTS.dll from following folder:

 

C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ManagedDTS9.0.242.0__89845dcd8080cc91>

 

Similarly picked Microsoft.SqlServer.DTSRuntimeWrap.dll also.

 

I added it as reference in my .NET application.

 

When I execute the program I get below error:

 

Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154.

 

Any Clue?

 

Application executes from a machine where SQL Server 2005 is not installed.

How to get the RunningPackages information back to a client PC?

 

HV

View Replies !   View Related
Microsoft.SqlServer.Dts.Pipeline.BlobColumn
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)

 

MessageBox.Show(DataPnts, "DataPoints1", MessageBoxButtons.OK)  

 

 ---and why can't I see it. It gives me some message with Microsoft.SqlServer.Dts.Pipeline.BlobColumn. Why?

 

Values = DataPnts.Split(CChar(","))

 

Please point me to more info on how to do transform Comma-delimited list row data to column.

 

Thanks.

View Replies !   View Related
Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException
Hi

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.

 

does anyone have any idea how to fix this please?

thanks

G

View Replies !   View Related
Missing Microsoft.SqlServer.ManagedDTS
Hi

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.

 

Thanks in advance

Utsav

View Replies !   View Related
Cannot Reference Microsoft.SqlServer.Dts.DtsClient??
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

 

<add assembly="Microsoft.SqlServer.Dts.DtsClient, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>

 

I still cannot do

 

using Microsoft.SqlServer.Dts.DtsClient;

 

I can do

 

using Microsoft.SqlServer.Server;

 

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?

View Replies !   View Related
0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
64 bit Server 2003 with Sql 2005 64-bit

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()

View Replies !   View Related
Enabling Microsoft EFS In A SQLServer 2000 Cluster
I am trying to encrypt data in a SQLServer 2000 Cluster using MicrosoftEFS. I have successfully encrypted a standalone DB but we are havingdifficulty with the Cluster. I am only encrypting the datafile.mdf.Has anyone implemented Microsoft EFS in a SQL Server 2000 cluster (allservers run Win2003EntEd)?All the Microsoft documentation describes how to enable EFS for a FileShare Resource in the cluster. However, for a sqlserver cluster thereis no File Share Resource, there is the SQLServer resources (networkname, ip, server), the Disk Resource, Cluster resources (network name,ip) plus some irrelevant others.Thank you for your help.

View Replies !   View Related
MSSMS (Microsoft.SqlServer.ConnectionInfo) Module
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?

Thanks in advance,

View Replies !   View Related
Com.microsoft.sqlserver.jdbc.SQLServerConnection Exception
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


thanks in advance
Nirav
 

View Replies !   View Related
I Need A Library For Microsoft.SqlServer.Dts.Tasks.ScriptTask;
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");
}
}
}

View Replies !   View Related
Imports Microsoft.sqlserver.dts.pipeline Does Not Work
I have been trying to follow/implement the examples in the following help topics (thanks to Jamie for these links).
 
Building Packages Programmatically
(http://msdn2.microsoft.com/en-us/library/ms345167.aspx)
Connecting Data Flow Components Programmatically
(http://msdn2.microsoft.com/en-us/library/ms136086.aspx)
 
The problem I am having is that MainPipe is not recognized as a valid type in my Script task, even though I have the imports statements that are listed in the example.  I get the message "Error 30002: Type 'MainPipe' is not defined".  The other and related problem is that when I type "imports microsoft.sqlserver.dts", the intellisense offers only two choices: {}Runtime and {}Tasks.  I don't see any choice for Pipeline.  Can anyone tell what I am missing?  It seems to be some kind of configuration/installation issue, but I have no idea how to resolve it.  I have tried this on 3 different machines, with both the RTM SQL 2005 standard edition, and with SP2 installed, all with the same result.  Any help is appreciated
 
Here is my code:
 

' Microsoft SQL Server Integration Services Script Task

' Write scripts using Microsoft Visual Basic

' The ScriptMain class is the entry point of the Script Task.

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports Microsoft.SqlServer.Dts.Pipeline

Imports Microsoft.SqlServer.Dts.Pipeline.wrapper

Imports Microsoft.SqlServer.Dts.

 

Public Class ScriptMain

Public Sub Main()

'

Dim package As Microsoft.SqlServer.Dts.Runtime.Package = _

   New Microsoft.SqlServer.Dts.Runtime.Package()

Dim e As Executable = package.Executables.Add("DTS.Pipeline.1")

Dim thMainPipe As Microsoft.SqlServer.Dts.Runtime.TaskHost = _

   CType(e, Microsoft.SqlServer.Dts.Runtime.TaskHost)

Dim dataFlowTask As MainPipe = CType(thMainPipe.InnerObject, MainPipe)

 
Dts.TaskResult = Dts.Results.Success

End Sub

End Class
 

View Replies !   View Related
Com.microsoft.sqlserver.jdbc.SQLServerConnection LoginWithFailover
Hi all

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

------

Connect string:

java -classpath /conf/javasql/sqljdbc_1.1/enu/sqljdbc.jar:/conf/javasql/jisql/lib/jisql.jar com.xigole.util
.sql.Jisql -user SOMEUSER -password SOMEPASSWORD -driver com.microsoft.sqlserver.jdbc.SQLServerDriver -input $QUERYFILE -cstring jdbc:sqlserver://SERVER1;DataBaseName=TESTDATABASE;failoverPartner=SERVER2;loginTimeout=3

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.

Has anyone got any suggestions?

 

Thanks

View Replies !   View Related
Property Login Was Not Set. (Microsoft.SqlServer.Express.ConnectionInfo)
Hi, having a bit of a problem - I'm trying to attach a database in MS SQL Server Management Studio Express. When I try in Windows Authentication I can't see any of my databases when I try to browse, so I had a look around on Google a saw mentioned that I should maybe use SQL Server Authentication. Only I don't know my user name and password, where can I configure this? I remember when I was setting up entering a password, but not a user name. Any ideas? thanksmander 

View Replies !   View Related
Microsoft SqlServer Desktop Engine Connection Problem
i installed the MSDE2000A on server and i tried to connect from client machine through vb Application using connection string. Server anad client are in LAN. but Some systems able to connect and some systems are unable to connect.

i am getting the error:

"SqlServer does not exist or access denied "

for non connected machines.

the server is listening from these machines. but not connecting to MSDE.

can anyone give me solution what may be the cause.

View Replies !   View Related
Microsoft.SqlServer.Management.Smo Backup And Restore Classes
Hi,

Hopefully someone out there will be able to help me with this question. I'm trying to setup my C# program to use the Backup and Restore classes to perform backups and restores on an SQL Express 2005 database.

From the documentation I've read... it seems that when you go to restore the database, it's a good idea to backup the current transaction log. But when I do this using the Backup.SqlBackup method I get an error saying that no database backup is detected so a log backup can't occur. I'm not sure if this has something to do with the fact that I moved my backup files from the default SQL Express/Server Backup folder to a different location. Shouldn't it know I've already performed a backup though?

And does anyone know how to set a parameter to backup to a different file location than the default? I've been doing a backup then a file move. Works the same, but it would be nice to have everything together in the Backup object.

Thanks!

View Replies !   View Related
Microsoft.SQLServer.ManagedDTS.dll Reference Error In VB.Net 2002
I am using VB.NET 2002 and we have set up a test environment running SQL Server 2005.

I am trying to add a reference to Microsoft.SQLServer.ManagedDTS.dll which is required to run a DTS/SSIS package from VB.NET.

However the dll does not show in my add reference listing so when I select BROWSE and select the actual DLL I get a rather long error message telling me that only 'dll' and COM components can be referenced.

The exact message is:

A reference to 'C:Programs FilesMicrosoft SQL Server90SDKAssembliesMicrosoft.SQLServer.ManagedDTS.dll' could not be added.  This is not a valid assembly or COM component.  Only assemblies with extension 'dll' and COM components can be referenced.  Please make sure that the file is accessible, and that it is a valid assembly or COM component.

 

Any suggestions?

thanks

View Replies !   View Related
Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer Column Ordinal From Name?
Hi,

I need to access columns from a data flow by ordinal position in a script transformation (I'm parsing an excel file which has several rowsets across the page). The first problem I encountered is the generated BufferWrapper does not expose the columns collection (i.e. Input0Buffer(0) does not work) but I got around that by implementing my own ProcessInputs(InputId, Buffer) method instead of using the wrapper.

My problem now is that the column ordinals are in some random order (i.e. Column "F1" is ordinal 1 but Column "F2" is 243). Where in the object model can I map between the name and the ordinal - it's not jumping out at me?

Dave

 

PS Why is the script editor modal, it's frustrating having to switch between the Visual Studio environment and the VSA one.

View Replies !   View Related
'Log' Is Not A Member Of 'Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptObjectModel'.
I have been developing a large SSIS project and it uses scripts extensively.

During development, i encountered no problems.

However, when i tried executing them on a server (windows server 2003), i was given this error for all the scripts:

Here is a brief log:

PackageStart,servername,networklogin,PkgName,{A6778813-1F3A-4133-A00C-6F02AC8CC8B1},{EA6E6337-8C07-428D-9E3B-CEEB4F95A185},3/10/2006 5:24:26 PM,3/10/2006 5:24:26 PM,0,0x,Beginning of package execution.

OnError,servername,networklogin,PkgName,Rename Error Files,{8d38e1b7-44e8-419e-963e-c689edd0be2c},{EA6E6337-8C07-428D-9E3B-CEEB4F95A185},3/10/2006 5:24:30 PM,3/10/2006 5:24:30 PM,7,0x,Error 30456: 'Variables' is not a member of 'Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptObjectModel'.
Line 26 Columns 51-63
Line Text:         Dim DaysToKeepErrorFile As Integer = CInt(Dts.Variables("vDaysToKeepErrorFiles").Value.ToString)

OnError,servername,networklogin,PkgName,Rename Error Files,{8d38e1b7-44e8-419e-963e-c689edd0be2c},{EA6E6337-8C07-428D-9E3B-CEEB4F95A185},3/10/2006 5:24:30 PM,3/10/2006 5:24:30 PM,7,0x,Error 30456: 'Log' is not a member of 'Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptObjectModel'.
Line 49 Columns 25-31
Line Text:                         Dts.Log(MaintenanceMsg, 0, ZeroByte)

OnError,servername,networklogin,PkgName,Rename Error Files,{8d38e1b7-44e8-419e-963e-c689edd0be2c},{EA6E6337-8C07-428D-9E3B-CEEB4F95A185},3/10/2006 5:24:30 PM,3/10/2006 5:24:30 PM,7,0x,Error 30456: 'Log' is not a member of 'Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptObjectModel'.
Line 55 Columns 17-23
Line Text:                 Dts.Log("Script Error:" + ex.Message, 0, ZeroByte)

OnError,servername,networklogin,PkgName,Rename Error Files,{8d38e1b7-44e8-419e-963e-c689edd0be2c},{EA6E6337-8C07-428D-9E3B-CEEB4F95A185},3/10/2006 5:24:30 PM,3/10/2006 5:24:30 PM,5,0x,The script files failed to load.
PackageEnd,servername,networklogin,PkgName,{A6778813-1F3A-4133-A00C-6F02AC8CC8B1},{EA6E6337-8C07-428D-9E3B-CEEB4F95A185},3/10/2006 5:24:30 PM,3/10/2006 5:24:30 PM,1,0x,End of package execution.

I've been using the same scripts for months in development and testing. Both dev and test server has SQL 2005 and SSIS installed.

What causes this?

View Replies !   View Related
Where Can I Find The Infamous Microsoft.SQLServer.Broker Download?
I've been trying to find examples on how to work with the broker using ADO.Net and haven't found much. 

View Replies !   View Related
The Machine Could Not Be Found (Microsoft.SqlServer.Management.UI.RSClient)
We are getting this error when we try and log on to a Reporting Services connection  Via SQL Server Management Studio on a client Machine. It works fine if we are on the Server.   

We can logon to the Database Engine just fine (from the Client) and the Web version of the Report manager Works fine too.

Any help would be appreciated!!!1

 






 

Code Snippet

The machine could not be found (Microsoft.SqlServer.Management.UI.RSClient)

 

Edit:

W've gotten a little farther.  We have determined that The users who are in the "BuiltinAdministrators" Group can Connect to the Report Server from a client machine but the users that we are  trying to fix are not in that Group, But they are in a Group that we added to the SQL Security. We have that group setup like the Admin group, but we still can't get them to Connect

 

 

View Replies !   View Related
HTTP 400: Bad Request (Microsoft.SqlServer.Management.UI.RSClient)
Hi all,

 

I need your help on the following:

 

I can't connect to Reporting Services from SQL Server Management Studio. I get the following error message:
"No connection can be made with SERVER. Additional information: Error at request with HTTP-Status 400: Bad Request (Microsoft.SqlServer.Management.UI.RSClient)"

 

What is wrong?? I'm running SQL Server 2005 SP2 on Windows Server 2003 hosting on an internet server.

 

Thanks in advanced!!

 

CarRoussel

View Replies !   View Related
Status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)
We are in the process of setting up a test server for reporting services in which the reporting server is on a seperate IIS server as the SQL Database.  I was able to resolve a previous error I was receiving when connecting to reporting services using SQL server management studio and within SQL Surface Area Configuration (HTTP Status 404: Not Found. ((Microsoft.SqlServer.Management.UI.RSClient)) by editing the URLRoot in the rsreportserver.config file.  But now whenever we try to connect using SQL Management Tool from other than on the server we receive this new error:
 
TITLE: Connect to Server
------------------------------
 
------------------------------
ADDITIONAL INFORMATION:
The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
BUTTONS:
OK
------------------------------

 
Any Thoughts?

View Replies !   View Related
Does 64-bit Version Of SQLServer Compact In Microsoft's Develop Schedule?
 

I am looking forward to a native 64-bit file-based database solution on Microsoft Windows platform. And I don't know why Microsoft didn't release the native 64-bit solution for JET engine (MDB file).
 
So, before I using this light-weight and file-based version of SQL Server, I will like to ask the question that the 64-bit version has been put into develop schedule?
 
Thanks.
Alva

View Replies !   View Related
Unable To Install Or Run The Application (Microsoft.SqlServer.PipelineHost)
I updated a windows application. It runs great on my development box.

We then published it to a web site. When they run the application it prompts them to update. The process begins and then they get the following message.

 

Unable to install or run the application.  The application requires that assembly Microsoft.SqlServer.PipelineHost Version 9.0.242.0 be installed in the Global Assembly Cache (GAC) first.  Please contact your system administrator.

 

 

Any ideas?
 

View Replies !   View Related
[Microsoft][SQLServer 2000 Driver For JDBC]Statement(s) Could Not Be Prepared
When we are using the Microsoft SQL Server 2000 thin driver,
we get the following error.

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Statement(s) could not be prepared.
at com.microsoft.jdbc.base.BaseExceptions.createExcep tion(Unknown Source
)
at com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sErrorToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sReplyToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest .processReplyToken(
Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.getRow (Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplResultSe t.positionCursor(Un
known Source)
at com.microsoft.jdbc.base.BaseResultSet.next(Unknown Source)
at DBConnection.main(DBConnection.java:56)


The Query due to which this error was occuring is given below.

SELECT CP_CD,COMPANY_NAME_J,COUNTRY_NAME_J,CP_NAME,CP_NAM E_J, (CASE RESIDENT WHEN 'Y' THEN '‹??Z' WHEN 'N' THEN '”ñ‹??Z' END ), (CASE BANK WHEN 'Y' THEN '‹â?s?i‹à—Z‹@ŠÖ?j' WHEN 'N' THEN '‚»‚Ì‘¼' END ), (CASE RISK_BCD WHEN '1' THEN '‹â?s' WHEN '2' THEN '?ØŒ”' WHEN '3' THEN '?¶•Û?E‘¹•Û' WHEN '4' THEN 'Ž–‹Æ–@?l' WHEN '5' THEN 'ŠO?‘?_•{' WHEN '0' THEN '‚»‚Ì‘¼' END ), (CASE RISK_ACD WHEN '1' THEN '’†‰›?_•{‚¨‚æ‚Ñ’†‰›‹â?s' WHEN '2' THEN 'Ž©?s—a‹à“™’S•Û' WHEN '3' THEN '?‘?Â’S•Û' WHEN '4' THEN '?‘?ÛŠJ”_‹â?s' WHEN '5' THEN '–¢Žg—p' WHEN '6' THEN '–{–MŒö‹¤•”–å' WHEN '7' THEN '–{–M‹â?s‹y‚Ñ–{–M?ØŒ”‰ïŽÐ'WHEN '8' THEN 'OECD?”?‘‹â?s‹y‚ÑOECD?”?‘?ØŒ”‰ïŽÐ?A‚Ü‚½‚Í‚»‚Ì‘¼‚Ì‹ â?s‚Ì’ZŠú?–±' WHEN '9' THEN 'OECD?”?‘‹â?sˆÈŠO‚Ì‹â?s‚Ì’·Šú?–±' WHEN '11' THEN '’n•ûŒö‹¤’c‘Ì' WHEN '10' THEN '‚»‚Ì‘¼' END ) , (CASE RISK_CLASS WHEN '1' THEN '–{–M' WHEN '2' THEN 'OECD?”?‘' WHEN '0' THEN '‚»‚Ì‘¼' END ), (CASE SUBSIDIARY WHEN '1' THEN 'Œ»’n–@?l' WHEN '2' THEN 'ŠCŠO“X' WHEN '0' THEN '‚»‚Ì‘¼' END )FROM CP LEFT OUTER JOIN COUNTRY ON CP.COUNTRY_CD = COUNTRY.COUNTRY_CD LEFT OUTER JOIN COMPANY ON CP.COMPANY_CD = COMPANY.COMPANY_CD ORDER BY CP_CD ASC

Note :
====

The Same Query when run in SQL Server 2000 Query Analyser is working fine and also in ORACLE 9i.

Please tell us where is the problem ?

View Replies !   View Related
Issue Doing Integrated Services Programming Using Microsoft.SqlServer.ManagedDTS.dll
Hi,

 

I am writing an installer code in C# to deploy the SSIS package.

I want to use Microsoft.SqlServer.ManagedDTS.dll for it.

It is mentioned in few articles available online that Microsoft.SqlServer.ManagedDTS.dll ships with SQL Server 2005.

I searched on our database server but could not get it.

 

Anyone having idea on this please help.

 

HV

 

View Replies !   View Related
Failed To Retrieve Data For This Request. (Microsoft.SqlServer.SmoEnum)
After getting an RPC error when trying to login to my server via either consol or Terminal services, then rebooting, I can no longer connect to SSIS

 
 
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
 
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
 
------------------------------
 
Connect to SSIS Service on machine "BG-22SQL" failed:
 The service did not respond to the start or control request in a timely fashion.
.
 
 
------------------------------
 
Connect to SSIS Service on machine "BG-22SQL" failed:
 The service did not respond to the start or control request in a timely fashion.
.
 

 

View Replies !   View Related
Failed To Retrieve Data For This Request. (Microsoft.SqlServer.SmoEnum)
hi,
 
I´m trying to connect to a integration service hosted in a different machine, but I recive the following message:
 
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) : access denied

I verified and the service that machine is running, maybe could be the user, I´m using windows authentication, I have no problems when I log in in the databse engine.
 
Can somebody help me?? 
 
 
 
 
 
 
 
 
 
 
 
 

View Replies !   View Related
Create Failed For Login 'NT AUTHORITYNetwork Service' (Microsoft.Sqlserver.Smo)
I'm installing Windows Small Business Server 2003 R2 Premium. I am at the stage where I am installing the Premium Technologies.  Specifically, I am trying to configure permissions for the new SHAREPOINT instance of SQL Server 2005. When I try to create the new login NT AuthorityNetwork Service, typing it exactly as specified in the instructions, I get the following error:
 
Create failed for Login 'NT AUTHORITYNetwork Service' (Microsoft.Sqlserver.Smo)
 

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Windows NT user or group 'NT AUTHORITYNetwork Service' not found. Check the name again. (Microsoft SQL Server, Error: 15401)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15401&LinkId=20476

------------------------------

BUTTONS:

OK

------------------------------

 
The following links yielded nothing:
 
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates
 
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15401&LinkId=20476
 
Does anyone know what's causing this? I've done a few installs of SBS R2 Premium and this is the first time I encountered this.
 

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved