Error when running SQL Job

I get an Event ID: 40961 when running a job in SQL the error message is as follows;
The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
The job is run on another server and is trying to hit the server listed above.
There are a few related knowledge base articles and several
reasons for the error listed at this site:
http://www.eventid.net/display.asp?e...aS rv&phase=1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:

>I get an Event ID: 40961 when running a job in SQL the error message is as follows;
>The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
>The job is run on another server and is trying to hit the server listed above.

Error when running SQL Job

I get an Event ID: 40961 when running a job in SQL the error message is as f
ollows;
The Security System could not establish a secured connection with the server
MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was availab
le.
The job is run on another server and is trying to hit the server listed abov
e.There are a few related knowledge base articles and several
reasons for the error listed at this site:
1" target="_blank">http://www.eventid.net/display.asp?...phase=
1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I get an Event ID: 40961 when running a job in SQL the error message is as
follows;
>The Security System could not establish a secured connection with the serve
r MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was availa
ble.
>The job is run on another server and is trying to hit the server listed above.[/vbc
ol]sql

Error when running SQL Job

I get an Event ID: 40961 when running a job in SQL the error message is as follows
The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available
The job is run on another server and is trying to hit the server listed above.There are a few related knowledge base articles and several
reasons for the error listed at this site:
http://www.eventid.net/display.asp?eventid=40961&eventno=1398&source=LsaSrv&phase=1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:
>I get an Event ID: 40961 when running a job in SQL the error message is as follows;
>The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
>The job is run on another server and is trying to hit the server listed above.

Error When Open Analysis Services From Management Studio

Dear All,

When I want to open Analysis

Services from Management Studio, an

error message appear:

Exception of type

'System.OutOfMemoryException' was thrown.

(Microsoft.SqlServer.SmoEnum)

Can anybody tell me what happen and how to solve that ?

Thanks in advance.

What version of Analysis Services you are running?

Try installing SP1. If that wouldnt help, try installing CTP of SP2.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Dear Edward,

Thanks for your reply. I have installed SP1 + Hotfix so the version of SSAS is 2153. Is it recommended to installed SP2 on Production server yet ? Thanks.|||

I wouldnt recommend installing CTP of SP2 without trying it first on the production machine.

But the problem looks like to be related to the SQL Management studio. Try installing CTP of SP2 on a client machine and then connecting to the server. See if the same error is happening.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Dear Edward,

FYI, I have 4 machine in my environment, one server (A) and the other three is client (B,C,D). I installed SP1 + hotfix on machine A, B, and C. I installed CTP of SP2 on D. A cannot open Analysis Services from management studio on its local, but can open Analysis Services on B and C. B and C can open Analysis Services on their local but cannot open the Analysis Services on A. D can open Analysis Services on its local and other machines (A, B, C). Is there any other solution besides installing CTP of SP2 on client ? Thanks.|||

In SP2 SQL Management studio is more efficient in opening big databases. Looks like that is the way to go.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Dear Edward,

Thanks for your information. Then I guess I have to wait for the release of SP2 to installed it on Production Server.

Error when installing SQL 2000 clustering

See error below
"An error occurred while creating virtual server
resources for clustering. The system cannot find the file
specified."
The failure occured during the creation of the virtual server resources (which this error indicates). You must view Cluster.log (in the WINNT\Cluster folder) or Sqlclstr.log (or both). At this stage, you are past the
unattended setup processes, so you will typically see the "Installation Succeeded" messages in the Sqlstp<N>.log files.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Error when create a Server object using SMO

Please help: I got this error and can't figure out what went wrong.

The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. on the line that create Server object.

This is the code (Visual C# 2005 - SQL Server 2000 - Windows Active Directory)

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

using Microsoft.SqlServer.Management.Smo;

using Microsoft.SqlServer.Management.Common;

namespace SSMO

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void Form1_Load(object sender, EventArgs e)

{

Server oSvr = new Server("myServer");

foreach (Database oDB in oSvr.Databases)

{

cboDatabases.Items.Add(oDB.Name.ToString());

}

}

}

I guess there should be additionally some inner exceptions which should clarify th error in detail.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

This is the error:

System.TypeInitializationException was unhandled
Message="The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception."
Source="System.Data"
TypeName="System.Data.SqlClient.SqlConnection"
StackTrace:
at System.Data.SqlClient.SqlConnection..ctor()
at Microsoft.SqlServer.Management.Common.ServerConnection..ctor()
at Microsoft.SqlServer.Management.Smo.ExecutionManager..ctor(String name)
at Microsoft.SqlServer.Management.Smo.Server..ctor(String name)
at SSMO.Form1.Form1_Load(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.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.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)
at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
at System.Windows.Forms.Control.set_Visible(Boolean value)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at SSMO.Program.Main()
at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()

|||

As the constructor of the SQLConnection is throwing an error, this might be just a slight misconfiguration problem. As I searched through the Net I found that this could be something based on a misconigured app.config file or the lack of a bad installation where the performance counters of the SQL Connection classes are not fully installed and registered. Never had that, but try to use a more simple command to make sure that this is based on that error:

new
System.Data.SqlClient.SqlConnection()).Dispose();

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Error Type 'System.Xml.XmlTextWriter' is not defined

I use this Code in SSIS Destination Script Transforamtion:
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Imports System.Xml

Public Class ScriptMain
Inherits UserComponent
Dim xWriter As XmlTextWriter
' get this Error: Type 'System.Xml.XmlTextWriter' is not defined

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
End Sub
End Class

Whats wrong ?

I use CTP Sept 2005 on Windows XP German.

Willfried

You need to add a reference to System.Xml in your script component

Go to Project|Add Reference... and select System.xml from the assembly list|||Thanks, i'm a fool |||Don't worry I just spent 30 minutes doing exactly the same thing

Error trying to backup a database

New to SQL Server, have never backed up a database before, in any DB system.
I am following a set of instructions that spell out how to copy a source db
and then copy it to a target db. Steps:
1) log onto server
2) start SQLServer Enterprise Manager
3) select source db and then Tools->Backup Database
Here's where my questions lie - The correct db shows, I have Back-up
Database-Complete selected, and Backup to disk. There is one destination
identified from an earlier backup. I tried creating a new destination, but
when I click OK, I get the error "The volume on device {my new destination
name} is not part of a multiple family media set. BACKUP WITH FORMAT can be
used to form a new media set"
I don't see an option for BACKUP WITH FORMAT.
I thought of trying to use the existing destination, but I'm not sure
whether to append or overwrite it. I am trying to get a full copy to put
into a test db.
Help!Hi,
Best recommendation is to Overwrite the media after taking a copy of exiting
file. If you append the file it will be tough while restoring.
See the BACKUP DATABASE and BACKUP LOG command in books online.
Thanks
hari
SQL Server MVP
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
> New to SQL Server, have never backed up a database before, in any DB
> system.
> I am following a set of instructions that spell out how to copy a source
> db
> and then copy it to a target db. Steps:
> 1) log onto server
> 2) start SQLServer Enterprise Manager
> 3) select source db and then Tools->Backup Database
> Here's where my questions lie - The correct db shows, I have Back-up
> Database-Complete selected, and Backup to disk. There is one destination
> identified from an earlier backup. I tried creating a new destination,
> but
> when I click OK, I get the error "The volume on device {my new destination
> name} is not part of a multiple family media set. BACKUP WITH FORMAT can
> be
> used to form a new media set"
> I don't see an option for BACKUP WITH FORMAT.
> I thought of trying to use the existing destination, but I'm not sure
> whether to append or overwrite it. I am trying to get a full copy to put
> into a test db.
> Help!
>|||Thanks, Hari
Um, where are the online books located?
Joe
"Hari Prasad" wrote:
> Hi,
> Best recommendation is to Overwrite the media after taking a copy of exiting
> file. If you append the file it will be tough while restoring.
> See the BACKUP DATABASE and BACKUP LOG command in books online.
> Thanks
> hari
> SQL Server MVP
>
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
> > New to SQL Server, have never backed up a database before, in any DB
> > system.
> > I am following a set of instructions that spell out how to copy a source
> > db
> > and then copy it to a target db. Steps:
> > 1) log onto server
> > 2) start SQLServer Enterprise Manager
> > 3) select source db and then Tools->Backup Database
> > Here's where my questions lie - The correct db shows, I have Back-up
> > Database-Complete selected, and Backup to disk. There is one destination
> > identified from an earlier backup. I tried creating a new destination,
> > but
> > when I click OK, I get the error "The volume on device {my new destination
> > name} is not part of a multiple family media set. BACKUP WITH FORMAT can
> > be
> > used to form a new media set"
> >
> > I don't see an option for BACKUP WITH FORMAT.
> >
> > I thought of trying to use the existing destination, but I'm not sure
> > whether to append or overwrite it. I am trying to get a full copy to put
> > into a test db.
> >
> > Help!
> >
>
>

Error trying to backup a database

New to SQL Server, have never backed up a database before, in any DB system.
I am following a set of instructions that spell out how to copy a source db
and then copy it to a target db. Steps:
1) log onto server
2) start SQLServer Enterprise Manager
3) select source db and then Tools->Backup Database
Here's where my questions lie - The correct db shows, I have Back-up
Database-Complete selected, and Backup to disk. There is one destination
identified from an earlier backup. I tried creating a new destination, but
when I click OK, I get the error "The volume on device {my new destinat
ion
name} is not part of a multiple family media set. BACKUP WITH FORMAT can be
used to form a new media set"
I don't see an option for BACKUP WITH FORMAT.
I thought of trying to use the existing destination, but I'm not sure
whether to append or overwrite it. I am trying to get a full copy to put
into a test db.
Help!Hi,
Best recommendation is to Overwrite the media after taking a copy of exiting
file. If you append the file it will be tough while restoring.
See the BACKUP DATABASE and BACKUP LOG command in books online.
Thanks
hari
SQL Server MVP
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
> New to SQL Server, have never backed up a database before, in any DB
> system.
> I am following a set of instructions that spell out how to copy a source
> db
> and then copy it to a target db. Steps:
> 1) log onto server
> 2) start SQLServer Enterprise Manager
> 3) select source db and then Tools->Backup Database
> Here's where my questions lie - The correct db shows, I have Back-up
> Database-Complete selected, and Backup to disk. There is one destination
> identified from an earlier backup. I tried creating a new destination,
> but
> when I click OK, I get the error "The volume on device {my new destin
ation
> name} is not part of a multiple family media set. BACKUP WITH FORMAT can
> be
> used to form a new media set"
> I don't see an option for BACKUP WITH FORMAT.
> I thought of trying to use the existing destination, but I'm not sure
> whether to append or overwrite it. I am trying to get a full copy to put
> into a test db.
> Help!
>|||Thanks, Hari
Um, where are the online books located?
Joe
"Hari Prasad" wrote:

> Hi,
> Best recommendation is to Overwrite the media after taking a copy of exiti
ng
> file. If you append the file it will be tough while restoring.
> See the BACKUP DATABASE and BACKUP LOG command in books online.
> Thanks
> hari
> SQL Server MVP
>
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
>
>

Error trying to backup a database

New to SQL Server, have never backed up a database before, in any DB system.
I am following a set of instructions that spell out how to copy a source db
and then copy it to a target db. Steps:
1) log onto server
2) start SQLServer Enterprise Manager
3) select source db and then Tools->Backup Database
Here's where my questions lie - The correct db shows, I have Back-up
Database-Complete selected, and Backup to disk. There is one destination
identified from an earlier backup. I tried creating a new destination, but
when I click OK, I get the error "The volume on device {my new destination
name} is not part of a multiple family media set. BACKUP WITH FORMAT can be
used to form a new media set"
I don't see an option for BACKUP WITH FORMAT.
I thought of trying to use the existing destination, but I'm not sure
whether to append or overwrite it. I am trying to get a full copy to put
into a test db.
Help!
Hi,
Best recommendation is to Overwrite the media after taking a copy of exiting
file. If you append the file it will be tough while restoring.
See the BACKUP DATABASE and BACKUP LOG command in books online.
Thanks
hari
SQL Server MVP
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
> New to SQL Server, have never backed up a database before, in any DB
> system.
> I am following a set of instructions that spell out how to copy a source
> db
> and then copy it to a target db. Steps:
> 1) log onto server
> 2) start SQLServer Enterprise Manager
> 3) select source db and then Tools->Backup Database
> Here's where my questions lie - The correct db shows, I have Back-up
> Database-Complete selected, and Backup to disk. There is one destination
> identified from an earlier backup. I tried creating a new destination,
> but
> when I click OK, I get the error "The volume on device {my new destination
> name} is not part of a multiple family media set. BACKUP WITH FORMAT can
> be
> used to form a new media set"
> I don't see an option for BACKUP WITH FORMAT.
> I thought of trying to use the existing destination, but I'm not sure
> whether to append or overwrite it. I am trying to get a full copy to put
> into a test db.
> Help!
>
|||Thanks, Hari
Um, where are the online books located?
Joe
"Hari Prasad" wrote:

> Hi,
> Best recommendation is to Overwrite the media after taking a copy of exiting
> file. If you append the file it will be tough while restoring.
> See the BACKUP DATABASE and BACKUP LOG command in books online.
> Thanks
> hari
> SQL Server MVP
>
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
>
>

Error to install the SQL server Database services

Hay,

I have a problem to in stall my SQL database services.

I use the Microsoft SQL server 2005 on a Microsoft small business server 2003 system.

My system configuration check is oke and i have no problems to install the other services(Analysis,Reporting,Notification and Intergration).

When i install the SQL database services i have this error:

(Error attempting to read from the source install database,

d:\windows\install\7b027f.msi).

thanks

If you scan your install log files you may find more information to help track down the problem. Here's a brief description of where to look and what to look for, copied from Jeffrey Baker's blog but I would look for more anomalies than just "ue 3":

Please look at the file "%ProgramFiles%\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Summary.txt" which should contain a summary of the
installation and what, if any errors there were. If you see an error,
please copy that section back to this thread. Then open up the Log File for
that failure and do a search for "ue 3" and copy a block of text from 10
lines above "ue 3" to 10 lines below "ue 3" back to this thread.

Error starting Report manager

I am trying to start report manager and get following error
System.Web.Services.Protocols.SoapException: Server was unable to
process request. --> System.InvalidOperationException: Method
ReportingService.SetExecutionOptions can not be reflected. -->
System.IO.FileLoadException: Unknown error - HRESULT 0x80131047
What I can do about it?
Thanks,
ShimonDoes navigating to \\localhost\reportserver work? Do you have .Net 2.0 on
the machine?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shimon Sim" <estshim@.att.net> wrote in message
news:#r$q96qcEHA.1644@.tk2msftngp13.phx.gbl...
> I am trying to start report manager and get following error
>
> System.Web.Services.Protocols.SoapException: Server was unable to
> process request. --> System.InvalidOperationException: Method
> ReportingService.SetExecutionOptions can not be reflected. -->
> System.IO.FileLoadException: Unknown error - HRESULT 0x80131047
>
> What I can do about it?
> Thanks,
> Shimon
>|||I have the same error. Navigating to localhost/ReportServer does work. I DO
have .NET 2.0 on the machine. I have however set the 'Default Web Site' and
'Report' to use ASP.NET 1.1.4322.0. I set one subweb that uses ASP.NET 2.0
components to use ASP.NET 2.0.40607 using IIS Manager. I also tried using
Denis Bauer's ASP.NET Version switching program, but to no avail. It should
be possible to have one website use version 1, and another use version 2,
shouldn't it? If this is not possible, does anyone know if the next version
of Reporting Services will support .NET 2.0?

error- shared memory sql server doesnt........

Hi evryone

I have installed SQL server as local system account and mixmode authorization.

After installing when i try to connect to database using sa account.

it gives error like Microsoft ODBC sql server driver - shared memory- sql server doesnt exist or access denied.

I unistalled sql server and again i installed. but same error facing.

Please reply.

Regards,

What name did you give the SQL Server when you installed it, which SQL Server was it?

If this is SQL Express then the connection string you need ot use is .\sqlexpress