Profile Error 17055

I applied a service pack to a third party application and
as of now I keep receiving the following in the sql
server log and application log every 1 minute or so.
How can I use the profiler on this to find out what's
happening?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17055
Date: 12/28/2003
Time: 11:54:26 AM
User: N/A
Computer: SERVERP01
Description:
18456 :
Login failed for user 'TRACK'.
Data:
0000: 18 48 00 00 0e 00 00 00 .H.....
0008: 0f 00 00 00 4a 00 52 00 ...J.R.
0010: 41 00 59 00 44 00 55 00 A.Y.D.U.
0018: 42 00 49 00 53 00 51 00 B.I.S.Q.
0020: 4c 00 50 00 30 00 31 00 L.P.0.1.
0028: 00 00 07 00 00 00 6d 00 .....m.
0030: 61 00 73 00 74 00 65 00 a.s.t.e.
0038: 72 00 00 00 r...
Thanks,
ShonetYou can use profiler to log connection attempts...Someone is trying to log
in using the login TRACK, which is a failed attempt... Watching this in
profiler will get you the name of the workstation, and name of the program
they are using... then you can track them down..
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Shonet" <anonymous@.discussions.microsoft.com> wrote in message
news:02bc01c3cd17$897e17f0$a601280a@.phx.gbl...
> I applied a service pack to a third party application and
> as of now I keep receiving the following in the sql
> server log and application log every 1 minute or so.
> How can I use the profiler on this to find out what's
> happening?
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (4)
> Event ID: 17055
> Date: 12/28/2003
> Time: 11:54:26 AM
> User: N/A
> Computer: SERVERP01
> Description:
> 18456 :
> Login failed for user 'TRACK'.
> Data:
> 0000: 18 48 00 00 0e 00 00 00 .H.....
> 0008: 0f 00 00 00 4a 00 52 00 ...J.R.
> 0010: 41 00 59 00 44 00 55 00 A.Y.D.U.
> 0018: 42 00 49 00 53 00 51 00 B.I.S.Q.
> 0020: 4c 00 50 00 30 00 31 00 L.P.0.1.
> 0028: 00 00 07 00 00 00 6d 00 .....m.
> 0030: 61 00 73 00 74 00 65 00 a.s.t.e.
> 0038: 72 00 00 00 r...
>
> Thanks,
> Shonet|||I managed to work this one out, but I'm please to see
what I came up with is was the same as your solution.
Excellent.
Thanks!!
Shonet
>--Original Message--
>You can use profiler to log connection
attempts...Someone is trying to log
>in using the login TRACK, which is a failed attempt...
Watching this in
>profiler will get you the name of the workstation, and
name of the program
>they are using... then you can track them down..
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Computer Education Services Corporation (CESC),
Charlotte, NC
>www.computeredservices.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>
>"Shonet" <anonymous@.discussions.microsoft.com> wrote in
message
>news:02bc01c3cd17$897e17f0$a601280a@.phx.gbl...
>> I applied a service pack to a third party application
and
>> as of now I keep receiving the following in the sql
>> server log and application log every 1 minute or so.
>> How can I use the profiler on this to find out what's
>> happening?
>> Event Type: Information
>> Event Source: MSSQLSERVER
>> Event Category: (4)
>> Event ID: 17055
>> Date: 12/28/2003
>> Time: 11:54:26 AM
>> User: N/A
>> Computer: SERVERP01
>> Description:
>> 18456 :
>> Login failed for user 'TRACK'.
>> Data:
>> 0000: 18 48 00 00 0e 00 00 00 .H.....
>> 0008: 0f 00 00 00 4a 00 52 00 ...J.R.
>> 0010: 41 00 59 00 44 00 55 00 A.Y.D.U.
>> 0018: 42 00 49 00 53 00 51 00 B.I.S.Q.
>> 0020: 4c 00 50 00 30 00 31 00 L.P.0.1.
>> 0028: 00 00 07 00 00 00 6d 00 .....m.
>> 0030: 61 00 73 00 74 00 65 00 a.s.t.e.
>> 0038: 72 00 00 00 r...
>>
>> Thanks,
>> Shonet
>
>.
>

Production SQL server down!

Someone attempted to change the partition layout of our SQL cluster, then we
recieved an error:
"Could not start the MSSQLSERVER service on local computer. The service did
not return an error. This could be an internal Windows error or an internal
service error. . . ."
in event log, we have two repetitive errors (application), and errors in
system log:
Application:
Event ID #17052
Error: 17826, Severity: 18, State: 1
Could not set up Net-Library 'SSNETLIB'.
and
Event ID#17055
17120 :
SQL Server could not spawn FRunCM thread.
System:
Event ID#1069
Cluster resource 'SQL Server' failed.
Any ideas? I've been "googling" all morning
If your production SQL Server is down then I would suggest opening a case with Microsoft Product Support Services (PSS).
Newsgroups doesn't work well for critical situations that needs to be resolved asap.
The error messages that you mentioned could have many causes and a thourough diagnoses is required to find root
cause. One has to review the SQL Server Errorlogs, NT Event Logs, Cluster logs for a start. One may also need to review
the Cluster hive and other cluster related registry keys.
Here are some ideas:
What error messages do you see in SQL Server Errorlog?
Along with the errors that you mentioned are you also getting the following message
Encryption requested but no valid certificate was found. SQL Server terminating
Has somebody turned on the Force Protocol Encryption option in Server Network Utility ?
BUG: Turning On the 'Force Protocol Encryption' Option Is Irreversible If There Is No Certificate
http://support.microsoft.com/?id=319349
Since SQL Server is not coming online, you will not be able to open Server Network Utility. I will check the following registry
key :
For default instance
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\SuperSocketNetLib
For named instance
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<Instance Name>\MSSQLServer
\SuperSocketNetLib
See if it has the 'Encrypt' key. It will be present and set to 1 if Force Protocol Encryption is enabled. If it does not exist, it will
indicate that the encryption was never set.
If encryption is not set then the reason may be something different.
One more thing that comes to miind now is to check the Parameters key in the CLUSTER hive in the registry.
-- Locate the SQL Server Resource in the Cluster Hive under the Resources Key. Then drill down to the Parameters key
under the SQL Server Resource.
We should see the following two values under the Parameters Key.
(HKLM\Cluster\Resources\{GUID for Resource}\Parameters\)
Default Instance
Name: InstanceName Type: Reg_SZ Data: MSSQLSERVER
Name: VirtualServerName Type: Reg_SZ Data: Virtual SQL Server Name
Named Instance
Name: InstanceName Type: Reg_SZ Data: Instance Name of the SQL Server
Name: VirtualServerName Type: Reg_SZ Data: Virtual SQL Server Name
If these are missing then add them and see if you can bring SQL Server resource online. If you have another (working)
cluster, you may want to see the values under Parameter Key first and then make the changes on the problem cluster.
HTH,
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
|||Another point to consider:
If it turns out that the Parameters key is empty (and based on the
description of what happened, I believe this is it) then verirfy that the
following key exists:
HKLM\Cluster\Resources\{GUID for Resource}\RegSync.
If not, then this key will have to be recreated and the checkpoint files
for SQL Server may need to be recreated. You will probably want to open a
case with Microsoft Product Support Services (PSS) to help recreate the
checkpoint files.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Production server error

Hello,
I have reports that have embedded code from a custom assembly.
In design, they work fine. When I deploy them and run them via the
Report Manager on production I get the following error in the cells
where I have this code running:
"Error in method xxxxxx - Request for the permission of type
System.Data.SqlClient.SqlClientPermission, System.Data,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed."
I have followed all previous articles, made changes to .config files,
etc., etc. Given the assembly full trust, etc. Still no luck.
Has ANYONE actually got this to work? Crystal reports was a pain, but
at least it worked!
Thanks for any help with this.
FabioIt sounds like you did not explicitly assert permissions to open a database
connection. Unless you assert (!) the permission explicitly, it will fail
with a security exception. Example for opening a connection to a SQL Server
in custom code / custom assemblies:
...
SqlClientPermission permission = new
SqlClientPermission(Permission­State.Unrestricted);
try
{
permission.Assert(); // Assert security permission !!!
SqlConnection conn = new SqlConnection("...");
conn.Open();
...
}
BTW: you don't need FullTrust for using the SqlClient in a custom assembly,
because the SqlClient is enabled for partial trust scenarios. Just check the
MSDN documentation on the SqlClientPermission class.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
<fassmann@.gmail.com> wrote in message
news:1124303487.138374.35130@.g43g2000cwa.googlegroups.com...
> Hello,
> I have reports that have embedded code from a custom assembly.
> In design, they work fine. When I deploy them and run them via the
> Report Manager on production I get the following error in the cells
> where I have this code running:
> "Error in method xxxxxx - Request for the permission of type
> System.Data.SqlClient.SqlClientPermission, System.Data,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
> failed."
> I have followed all previous articles, made changes to .config files,
> etc., etc. Given the assembly full trust, etc. Still no luck.
> Has ANYONE actually got this to work? Crystal reports was a pain, but
> at least it worked!
> Thanks for any help with this.
> Fabio
>|||Thanks Robert.
I am explicity asserting permissions. Here's the code I'm using. Am I
missing something?
Try
Dim permission As New
SqlClientPermission(Security.Permissions.PermissionState.Unrestricted)
permission.Assert()
'Use the MS data access app block to get the data reader
dr = _myDBAccess.ExecuteReader(_myConn,
CommandType.StoredProcedure, "Trader_GetTransByAssetID", New
SqlParameter("@.AssetID", nAssetID))
'Loop thru all transactions to build arraylist of
transaction objects
While (dr.Read())
objTrans = New Transaction(dr.GetInt32(COL_TRANSID),
dr.GetDateTime(COL_TRADEDATE), dr.GetSqlMoney(COL_DOLLARS).ToDouble,
sShareClass, 0.0, dr.GetSqlDecimal(COL_SHARES).ToDouble,
dr.GetSqlDecimal(COL_PRICE).ToDouble,
CType(dr.GetSqlInt16(COL_CALCSHAREBALANCE).ToString, Integer),
CType(dr.GetSqlInt16(COL_CALCCOSTBASIS).ToString, Integer))
arlTrans.Add(objTrans)
End While
Catch ex As Exception
_myErrorMessage += " Error in method
CDSC.BuildTransArray - " & ex.Message
Finally
'Clean Up
If Not (IsNothing(dr)) Then
dr.Close()
End If
End Try
Thanks for your help.|||OK, got it fixed.
You have to explicitly open the connection everywhere you use this. So,
we've got it added to every function/procedure within our assembly.
So not oly are we using the ExecuteReader, but we're opening the
connection each time as well.|||I have a similar problem, could you please give some example on this. when
you say
> So not oly are we using the ExecuteReader, but we're opening the
> connection each time as well.
do you mean you declare explicitly
Dim cn as sqlconnection = new sqlconnection(connectionstring)
after sqlclientpermission
From your example,
Try
Dim permission As New
SqlClientPermission(Security.Permissions.PermissionState.Unrestricted)
permission.Assert()
-----
' Dim _myConn as sqlconnection = new sqlconnection(connectionstring)
(adding this solved your issue?)
----
'Use the MS data access app block to get the data reader
dr = _myDBAccess.ExecuteReader(_myConn,
CommandType.StoredProcedure, "Trader_GetTransByAssetID", New
SqlParameter("@.AssetID", nAssetID
Appreciate your help on this.
--
kvs
"fassmann@.gmail.com" wrote:
> OK, got it fixed.
> You have to explicitly open the connection everywhere you use this. So,
> we've got it added to every function/procedure within our assembly.
> So not oly are we using the ExecuteReader, but we're opening the
> connection each time as well.
>|||Ok, here is what I tried but still getting error. Could you please tell me
what am I doing wrong or missing?
Dim permission As New
SqlClientPermission(Security.Permissions.PermissionState.Unrestricted)
permission.Assert()
'open connection explicitly
Dim cn As SqlConnection = New SqlConnection(cns)
cn.Open()
Try
Return SqlDataAccess.ExecuteDataSet(cn, sql, arp)
Finally
cn.Dispose()
End Try
--
Thanks.
kvs
"kvs" wrote:
> I have a similar problem, could you please give some example on this. when
> you say
> > So not oly are we using the ExecuteReader, but we're opening the
> > connection each time as well.
> do you mean you declare explicitly
> Dim cn as sqlconnection = new sqlconnection(connectionstring)
> after sqlclientpermission
> From your example,
> Try
> Dim permission As New
> SqlClientPermission(Security.Permissions.PermissionState.Unrestricted)
> permission.Assert()
> -----
> ' Dim _myConn as sqlconnection = new sqlconnection(connectionstring)
> (adding this solved your issue?)
> ----
> 'Use the MS data access app block to get the data reader
> dr = _myDBAccess.ExecuteReader(_myConn,
> CommandType.StoredProcedure, "Trader_GetTransByAssetID", New
> SqlParameter("@.AssetID", nAssetID
>
> Appreciate your help on this.
> --
> kvs
>
> "fassmann@.gmail.com" wrote:
> > OK, got it fixed.
> >
> > You have to explicitly open the connection everywhere you use this. So,
> > we've got it added to every function/procedure within our assembly.
> >
> > So not oly are we using the ExecuteReader, but we're opening the
> > connection each time as well.
> >
> >sql

Production error: "The schema script [...] could not be propagated to the subscriber"

Hi,
A member of my team recently made a few minor changes to our database.
Several (not all) subscribers are now failing to replicate with the
following error:
The schema script 'exec sp_repldropcolumn
'[dbo].[IP_Application_Updates]', 'update_id', 1' could not be
propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
------
A column was added to or dropped from the replicated table.
(Source: l07052 (Agent); Error number: 27160)
------
' because it is a primary key column.
(Source: l07052 (Data source); Error number: 21264)
------
This was a problem a few months ago but seemed to have been resolved.
In particular, nothing at all has changed recently in the
IP_Application_Updates table. I'm very happy for that table to remain
exactly as it is.
Can anyone suggest a way to fix this? I've got a bunch of users who
are unable to replicate their database and they'll turn nasty shortly.
In the absence of an elegant fix I'll cheerfully go with a way to
change the offending script to something innocuous, but I don't know
where or why the script exists or why the subscribers are trying to run
it. I will be very grateful if anyone can help me to get my
subscribers past this error.
Many thanks
Alex
Whenever the Merge Agent runs, it first makes sure that the schema [any
change as a result of DDL] is in sync, before the
data could be replicated. All the schema changes in the publisher are stored
in sysmergeschemachange table on the
publisher database. You can take a look at this table and see the schema
changes that have been executed at the publisher.
I believe the Merge Agent is trying to drop the column at the subscriber,
but unable to do it because it is the primary key column.
One work around would be to remove the primary key constraint at the
subscriber, if you don't need that column any more.
<WombatDeath@.gmail.com> wrote in message
news:1169249897.423772.218970@.l53g2000cwa.googlegr oups.com...
> Hi,
> A member of my team recently made a few minor changes to our database.
> Several (not all) subscribers are now failing to replicate with the
> following error:
> The schema script 'exec sp_repldropcolumn
> '[dbo].[IP_Application_Updates]', 'update_id', 1' could not be
> propagated to the subscriber.
> (Source: Merge Replication Provider (Agent); Error number: -2147201001)
> ------
> A column was added to or dropped from the replicated table.
> (Source: l07052 (Agent); Error number: 27160)
> ------
> ' because it is a primary key column.
> (Source: l07052 (Data source); Error number: 21264)
> ------
> This was a problem a few months ago but seemed to have been resolved.
> In particular, nothing at all has changed recently in the
> IP_Application_Updates table. I'm very happy for that table to remain
> exactly as it is.
> Can anyone suggest a way to fix this? I've got a bunch of users who
> are unable to replicate their database and they'll turn nasty shortly.
> In the absence of an elegant fix I'll cheerfully go with a way to
> change the offending script to something innocuous, but I don't know
> where or why the script exists or why the subscribers are trying to run
> it. I will be very grateful if anyone can help me to get my
> subscribers past this error.
> Many thanks
> Alex
>
|||Hi Gayathri
Thank you for replying so quickly. The problem I have is that the
table in question is in use, and the column in question should be the
PK of that table.
We have a scheduled job which recreates the snapshot once a week, on
Saturday. I've just taken a look and most tables have three records in
sysmergeschemachange, but the IP_Application_Updates table has an
additional four:
exec sp_repldropcolumn '[dbo].[IP_Application_Updates]', 'update_id', 1
alter table [dbo].[IP_Application_Updates] drop column update_id
exec sp_repladdcolumn '[dbo].[IP_Application_Updates]','update_id',[int
IDENTITY (1, 1) NOT NULL], '%', 1
alter table [dbo].[IP_Application_Updates] add update_id int IDENTITY
(1, 1) NOT NULL
This is presumably what's causing the problem. I could perhaps "fix"
it by just deleting those four records from the system table but I can
just imagine causing all manner of havoc with my ignorant tinkering.
Assuming that nobody in my team has had any reason whatsoever to make
any alterations to this table in recent months, is it possible to
hazard a guess as to why the merge agent is attempting to recreate the
update_id column? And is there any way to make it stop?
Thanks
Alex
|||Hi,
The only reason I see a DDL row in 'sysmergeschemachange' table is because
of a user action after
the intial snapshot has been taken.
Trying to delete the rows from the system table could pop up some more
issues.
You could do two things:
1. drop the primary key constraint at the failing subscriber. This should
probably allow
the merge agent to complete succesfully [if this is the only problem].
2. Else, you might have to re-initalize the failing subscribers ...
Hope this helps.
-- Gayathri TK
<WombatDeath@.gmail.com> wrote in message
news:1169255444.925914.213970@.11g2000cwr.googlegro ups.com...
> Hi Gayathri
> Thank you for replying so quickly. The problem I have is that the
> table in question is in use, and the column in question should be the
> PK of that table.
> We have a scheduled job which recreates the snapshot once a week, on
> Saturday. I've just taken a look and most tables have three records in
> sysmergeschemachange, but the IP_Application_Updates table has an
> additional four:
> exec sp_repldropcolumn '[dbo].[IP_Application_Updates]', 'update_id', 1
> alter table [dbo].[IP_Application_Updates] drop column update_id
> exec sp_repladdcolumn '[dbo].[IP_Application_Updates]','update_id',[int
> IDENTITY (1, 1) NOT NULL], '%', 1
> alter table [dbo].[IP_Application_Updates] add update_id int IDENTITY
> (1, 1) NOT NULL
> This is presumably what's causing the problem. I could perhaps "fix"
> it by just deleting those four records from the system table but I can
> just imagine causing all manner of havoc with my ignorant tinkering.
> Assuming that nobody in my team has had any reason whatsoever to make
> any alterations to this table in recent months, is it possible to
> hazard a guess as to why the merge agent is attempting to recreate the
> update_id column? And is there any way to make it stop?
> Thanks
> Alex
>
|||Hi Gayathri
Thanks very much; we'll try dropping the PK constraint and see what
happens.
Thanks again for your help,
Alex

Production Database Marked as Suspect (SQL Server 2000)

Hello,
Our production database was marked as suspect due to a
possible hardware error. Hardware error has been resolved
but when SQL server was restarted the production database
was marked as suspect. After the sp_resetstatus and tried
to recover the status is still suspect with the following
error message in the errorlog :
2004-01-07 12:02:47.66 spid13 Error: 3456, Severity:
21, State: 1
2004-01-07 12:02:47.66 spid13 Could not redo log record
(26822:23441:10), for transaction ID (0:21782102), on page
(1:3042), database 'FS84PRD' (9). Page: LSN = (26817:26440:2), type = 1. Log: OpCode = 2, context 2,
PrevPageLSN: (26822:23351:7)..
2004-01-07 12:02:47.66 spid13 ex_raise2: Exception
raised, major=34, minor=56, severity=25, attempting to
create symptom dump
2004-01-07 12:02:47.68 spid13 Using 'dbghelp.dll'
version '4.0.5'
2004-01-07 12:02:47.94 spid13 Error: 3313, Severity:
21, State: 2
2004-01-07 12:02:47.94 spid13 Error while redoing
logged operation in database 'FS84PRD'. Error at log
record ID (26822:23441:10)..
2004-01-07 12:02:57.19 spid13 Error: 3414, Severity:
21, State: 1
2004-01-07 12:02:57.19 spid13 Database 'FS84PRD'
(database ID 9) could not recover. Contact Technical
Support..
2004-01-07 12:03:17.24 spid3 Recovery complete.
2004-01-07 12:03:17.40 spid3 SQL Server is terminating
due to 'stop' request from Service Control Manager.
Is there any way to recover this or is my only option to
restore from the backup ? If the only solution is the
latter, will I be able to perform a normal restore using
enterprise manager ?
Thanks for everyone's help in advance !
WillyHi,
Try to start the database in emergency mode and try out.
update sysdatabases
set status=32768
where name='FS84PRD'
Now probably you will be able to access the database.
Thanks
Hari
MCDBA
"Willy Ong" <anonymous@.discussions.microsoft.com> wrote in message
news:08ef01c3d516$bbadeb40$a601280a@.phx.gbl...
> Hello,
> Our production database was marked as suspect due to a
> possible hardware error. Hardware error has been resolved
> but when SQL server was restarted the production database
> was marked as suspect. After the sp_resetstatus and tried
> to recover the status is still suspect with the following
> error message in the errorlog :
> 2004-01-07 12:02:47.66 spid13 Error: 3456, Severity:
> 21, State: 1
> 2004-01-07 12:02:47.66 spid13 Could not redo log record
> (26822:23441:10), for transaction ID (0:21782102), on page
> (1:3042), database 'FS84PRD' (9). Page: LSN => (26817:26440:2), type = 1. Log: OpCode = 2, context 2,
> PrevPageLSN: (26822:23351:7)..
> 2004-01-07 12:02:47.66 spid13 ex_raise2: Exception
> raised, major=34, minor=56, severity=25, attempting to
> create symptom dump
> 2004-01-07 12:02:47.68 spid13 Using 'dbghelp.dll'
> version '4.0.5'
> 2004-01-07 12:02:47.94 spid13 Error: 3313, Severity:
> 21, State: 2
> 2004-01-07 12:02:47.94 spid13 Error while redoing
> logged operation in database 'FS84PRD'. Error at log
> record ID (26822:23441:10)..
> 2004-01-07 12:02:57.19 spid13 Error: 3414, Severity:
> 21, State: 1
> 2004-01-07 12:02:57.19 spid13 Database 'FS84PRD'
> (database ID 9) could not recover. Contact Technical
> Support..
> 2004-01-07 12:03:17.24 spid3 Recovery complete.
> 2004-01-07 12:03:17.40 spid3 SQL Server is terminating
> due to 'stop' request from Service Control Manager.
> Is there any way to recover this or is my only option to
> restore from the backup ? If the only solution is the
> latter, will I be able to perform a normal restore using
> enterprise manager ?
> Thanks for everyone's help in advance !
> Willy|||Your best option is to restore from backup. Database integrity is
questionable when recovery is not performed.
Yes, you can perform a normal restore using EM or Query Analyzer.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Willy Ong" <anonymous@.discussions.microsoft.com> wrote in message
news:08ef01c3d516$bbadeb40$a601280a@.phx.gbl...
> Hello,
> Our production database was marked as suspect due to a
> possible hardware error. Hardware error has been resolved
> but when SQL server was restarted the production database
> was marked as suspect. After the sp_resetstatus and tried
> to recover the status is still suspect with the following
> error message in the errorlog :
> 2004-01-07 12:02:47.66 spid13 Error: 3456, Severity:
> 21, State: 1
> 2004-01-07 12:02:47.66 spid13 Could not redo log record
> (26822:23441:10), for transaction ID (0:21782102), on page
> (1:3042), database 'FS84PRD' (9). Page: LSN => (26817:26440:2), type = 1. Log: OpCode = 2, context 2,
> PrevPageLSN: (26822:23351:7)..
> 2004-01-07 12:02:47.66 spid13 ex_raise2: Exception
> raised, major=34, minor=56, severity=25, attempting to
> create symptom dump
> 2004-01-07 12:02:47.68 spid13 Using 'dbghelp.dll'
> version '4.0.5'
> 2004-01-07 12:02:47.94 spid13 Error: 3313, Severity:
> 21, State: 2
> 2004-01-07 12:02:47.94 spid13 Error while redoing
> logged operation in database 'FS84PRD'. Error at log
> record ID (26822:23441:10)..
> 2004-01-07 12:02:57.19 spid13 Error: 3414, Severity:
> 21, State: 1
> 2004-01-07 12:02:57.19 spid13 Database 'FS84PRD'
> (database ID 9) could not recover. Contact Technical
> Support..
> 2004-01-07 12:03:17.24 spid3 Recovery complete.
> 2004-01-07 12:03:17.40 spid3 SQL Server is terminating
> due to 'stop' request from Service Control Manager.
> Is there any way to recover this or is my only option to
> restore from the backup ? If the only solution is the
> latter, will I be able to perform a normal restore using
> enterprise manager ?
> Thanks for everyone's help in advance !
> Willy

Product level is insufficient error

Configuration: Windows XP Pro with SQL 2005 Workgroup Sp2

Hi, we have a package that runs fine in BI Studio but fails with the following error when executing it using DTExec.

Code: 0xC00470FE
Source: Data Flow Task DTS.Pipeline
Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Derived Column" (10660).

The package imports a CSV into a table mapping some columns. The MSDN article at http://msdn2.microsoft.com/en-us/library/ms143761.aspx describes features supported by different versions.

The article says OLE DB source/destination adapters are supported in WG edition but a couple of lines later seems to imply that all source/destination adapters are not supported in WG.

Could you clarify whether stuff like import of a csv into a table with some column mappings should work in WG edition? Also if we have a legacy SQL 2K package doing the same thing, will that work in WG edition? Thx.

Features/Integration Services Enhancements EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit) SE (32-bit) WG (32-bit) SSE (32-bit) SSEA (32-bit) SE (64-bit)

SQL Server Import and Export Wizard and supporting connections, source and destination adapters, and tasks

Yes

Yes

Yes

No

Yes

Execute SQL Task

Yes

Yes

Yes

No

Yes

OLE DB Source and Destination Adapters

Yes

Yes

Yes

No

Yes

SSIS command prompt tools

Yes

Yes

Yes

No

Yes

SSIS Package Designer

Yes

Yes

Yes

No

Yes

Legacy support for DTS packages

Yes

Yes

Yes

Yes

Yes

SSIS Service

Yes

Yes

No

No

Yes

All other source and destination adapters, tasks, and transformations, except for those listed below

Yes

Yes

No

No

Yes

You might want to be sure that you have actually installed the full SSIS client.|||

As Phil wrote, most likely you've only Workstation components installed and need to install full SSIS.

See Books Online and my blog for details:

http://msdn2.microsoft.com/en-US/library/aa337371.aspx

http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx

Product Level is Insufficient

I am receiving the following error when I try to execute an SSIS package that is saved to a structured file. I am using DTExec to execute the package.

Description: The task "Initialize Variables" cannot run on this edition of Integration Services. It requires a higher level edition.

After some research, I was able to find a supporting article in SQL Server 2005 BOL at http://msdn2.microsoft.com/en-us/library/aa337371.aspx

The issue was resolved by installing the Enterprise Edition of SQL Server Integration Services (Windows Service) on the local server (server where the package is saved and executed from). However, this goes against my original anticipation that the SSIS Windows Service would only need to be installed on a machine where I needed to store packages and/or monitor package execution. Not if I wanted to execute packages.

Unfortunately, my package is using advanced options (as identified in the BOL article previously referenced).

Am I missing something?

Sincerely,

Sean Fitzgerald

You are trying to execute these packages from a remote machine (such as your desktop and not the SQL Server), correct? You need to have a matching edition of the SSIS client tools loaded on your desktop to be able to run those packages remotely.|||You do need the SSIS installed where the packages runs.
It does not matter where the package is stored.

See my blog entries about this:
http://blogs.msdn.com/michen/archive/2006/08/11/package-exec-location.aspx
http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx

Product Level Insufficient

I am trying to run dtexec on some DTSC packages I created using SSIS. I keep getting the error "The product level is insufficient for the component". Anybody know what this means?

Thanks,

Michael D. Fox

If you do a search of this forum you will find many threads that discuss the usual cause and the usual solution to this problem.

Thanks,

Matt

|||

I did look through the other replies. But I DO have SSIS installed. I am using the evaluation version of SQL Server 2005. Does this have any bearing on it?

Thanks,

Michael D. Fox

|||

Did you actually install SSIS or just the tools (i.e. do you have the SSIS service installed on the box you are trying to run the package on)? If the service is not installed then you will get this message. Which edition is the evaluation version (std, enterprise, etc) and which component is giving you the message (different components are available in different editions)?

Thanks,

Matt

|||

Thanks Matt,

I just went back and reinstalled, checking everything in sight, and it works now.

Thanks again,

Michael D. Fox

sql

Product error installs

I have a couple third part applications that I'm trying to install that
install SQL databases. However I get similar errors during both for the
install.
I'll end up w/ an Error 11001 in the app event log and the contents of the
error common to both is: Error 1001.Setup failed. --> Windows NT user or
group 'NT AUTHORITY\domain users' not found. Check the name again.
Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
name again.
User or role 'NT AUTHORITY\domain users' does not exist in this database.
User or role 'NT AUTHORITY\domain users' does not exist in this database.,
(NULL), (NULL), (NULL).
I've talked to a couple other users and they haven't experienced the same
issues. My server is set to mixed mode and the SA account does have a
password. I've tried installing using the SA account as well as a domain
admin account and neither worked.
Is the NT account you are using to install a member of the local server
Administrator group?
Brad Feaker
Ex nihilo, nihil fit
"Mike" wrote:

> I have a couple third part applications that I'm trying to install that
> install SQL databases. However I get similar errors during both for the
> install.
> I'll end up w/ an Error 11001 in the app event log and the contents of the
> error common to both is: Error 1001.Setup failed. --> Windows NT user or
> group 'NT AUTHORITY\domain users' not found. Check the name again.
> Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> name again.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> (NULL), (NULL), (NULL).
>
> I've talked to a couple other users and they haven't experienced the same
> issues. My server is set to mixed mode and the SA account does have a
> password. I've tried installing using the SA account as well as a domain
> admin account and neither worked.
|||Yes
"Brad Feaker" wrote:
[vbcol=seagreen]
> Is the NT account you are using to install a member of the local server
> Administrator group?
> Brad Feaker
> Ex nihilo, nihil fit
> "Mike" wrote:
|||Try installing using a local system account and then changing the service
accounts after the install is complete.
Brad
"Mike" wrote:
[vbcol=seagreen]
> Yes
> "Brad Feaker" wrote:
|||Tried using the Administrator account on the local machine. Same problem.
"Brad Feaker" wrote:
[vbcol=seagreen]
> Try installing using a local system account and then changing the service
> accounts after the install is complete.
> Brad
> "Mike" wrote:
|||Instead of using a windows account at all, choose the 'Local System Account'
option during the install.
Brad
"Mike" wrote:
[vbcol=seagreen]
> Tried using the Administrator account on the local machine. Same problem.
> "Brad Feaker" wrote:
|||this is an interactive application that i'm trying to install so I'm not sure
there is a way to do what your asking. i'm assuming it comes to this error
some point where it's creating the db in sql. it's funny though the the db
and tables appear to be created fine.
"Brad Feaker" wrote:
[vbcol=seagreen]
> Instead of using a windows account at all, choose the 'Local System Account'
> option during the install.
> Brad
> "Mike" wrote:
|||At this point you may want to toss the problem back to the vendor....sorry I
could not be of any assistance...
Brad
"Mike" wrote:
[vbcol=seagreen]
> this is an interactive application that i'm trying to install so I'm not sure
> there is a way to do what your asking. i'm assuming it comes to this error
> some point where it's creating the db in sql. it's funny though the the db
> and tables appear to be created fine.
> "Brad Feaker" wrote:
|||Thanks. I did so Monday. I believe they're stumped.
"Brad Feaker" wrote:
[vbcol=seagreen]
> At this point you may want to toss the problem back to the vendor....sorry I
> could not be of any assistance...
> Brad
> "Mike" wrote:

Product error installs

I have a couple third part applications that I'm trying to install that
install SQL databases. However I get similar errors during both for the
install.
I'll end up w/ an Error 11001 in the app event log and the contents of the
error common to both is: Error 1001.Setup failed. --> Windows NT user or
group 'NT AUTHORITY\domain users' not found. Check the name again.
Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
name again.
User or role 'NT AUTHORITY\domain users' does not exist in this database.
User or role 'NT AUTHORITY\domain users' does not exist in this database.,
(NULL), (NULL), (NULL).
I've talked to a couple other users and they haven't experienced the same
issues. My server is set to mixed mode and the SA account does have a
password. I've tried installing using the SA account as well as a domain
admin account and neither worked.Is the NT account you are using to install a member of the local server
Administrator group?
Brad Feaker
Ex nihilo, nihil fit
"Mike" wrote:
> I have a couple third part applications that I'm trying to install that
> install SQL databases. However I get similar errors during both for the
> install.
> I'll end up w/ an Error 11001 in the app event log and the contents of the
> error common to both is: Error 1001.Setup failed. --> Windows NT user or
> group 'NT AUTHORITY\domain users' not found. Check the name again.
> Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> name again.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> (NULL), (NULL), (NULL).
>
> I've talked to a couple other users and they haven't experienced the same
> issues. My server is set to mixed mode and the SA account does have a
> password. I've tried installing using the SA account as well as a domain
> admin account and neither worked.|||Yes
"Brad Feaker" wrote:
> Is the NT account you are using to install a member of the local server
> Administrator group?
> Brad Feaker
> Ex nihilo, nihil fit
> "Mike" wrote:
> > I have a couple third part applications that I'm trying to install that
> > install SQL databases. However I get similar errors during both for the
> > install.
> >
> > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > name again.
> > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > (NULL), (NULL), (NULL).
> >
> >
> > I've talked to a couple other users and they haven't experienced the same
> > issues. My server is set to mixed mode and the SA account does have a
> > password. I've tried installing using the SA account as well as a domain
> > admin account and neither worked.|||Try installing using a local system account and then changing the service
accounts after the install is complete.
Brad
"Mike" wrote:
> Yes
> "Brad Feaker" wrote:
> > Is the NT account you are using to install a member of the local server
> > Administrator group?
> >
> > Brad Feaker
> > Ex nihilo, nihil fit
> >
> > "Mike" wrote:
> >
> > > I have a couple third part applications that I'm trying to install that
> > > install SQL databases. However I get similar errors during both for the
> > > install.
> > >
> > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > name again.
> > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > (NULL), (NULL), (NULL).
> > >
> > >
> > > I've talked to a couple other users and they haven't experienced the same
> > > issues. My server is set to mixed mode and the SA account does have a
> > > password. I've tried installing using the SA account as well as a domain
> > > admin account and neither worked.|||Tried using the Administrator account on the local machine. Same problem.
"Brad Feaker" wrote:
> Try installing using a local system account and then changing the service
> accounts after the install is complete.
> Brad
> "Mike" wrote:
> > Yes
> >
> > "Brad Feaker" wrote:
> >
> > > Is the NT account you are using to install a member of the local server
> > > Administrator group?
> > >
> > > Brad Feaker
> > > Ex nihilo, nihil fit
> > >
> > > "Mike" wrote:
> > >
> > > > I have a couple third part applications that I'm trying to install that
> > > > install SQL databases. However I get similar errors during both for the
> > > > install.
> > > >
> > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > name again.
> > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > (NULL), (NULL), (NULL).
> > > >
> > > >
> > > > I've talked to a couple other users and they haven't experienced the same
> > > > issues. My server is set to mixed mode and the SA account does have a
> > > > password. I've tried installing using the SA account as well as a domain
> > > > admin account and neither worked.|||Instead of using a windows account at all, choose the 'Local System Account'
option during the install.
Brad
"Mike" wrote:
> Tried using the Administrator account on the local machine. Same problem.
> "Brad Feaker" wrote:
> > Try installing using a local system account and then changing the service
> > accounts after the install is complete.
> >
> > Brad
> >
> > "Mike" wrote:
> >
> > > Yes
> > >
> > > "Brad Feaker" wrote:
> > >
> > > > Is the NT account you are using to install a member of the local server
> > > > Administrator group?
> > > >
> > > > Brad Feaker
> > > > Ex nihilo, nihil fit
> > > >
> > > > "Mike" wrote:
> > > >
> > > > > I have a couple third part applications that I'm trying to install that
> > > > > install SQL databases. However I get similar errors during both for the
> > > > > install.
> > > > >
> > > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > > name again.
> > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > > (NULL), (NULL), (NULL).
> > > > >
> > > > >
> > > > > I've talked to a couple other users and they haven't experienced the same
> > > > > issues. My server is set to mixed mode and the SA account does have a
> > > > > password. I've tried installing using the SA account as well as a domain
> > > > > admin account and neither worked.|||this is an interactive application that i'm trying to install so I'm not sure
there is a way to do what your asking. i'm assuming it comes to this error
some point where it's creating the db in sql. it's funny though the the db
and tables appear to be created fine.
"Brad Feaker" wrote:
> Instead of using a windows account at all, choose the 'Local System Account'
> option during the install.
> Brad
> "Mike" wrote:
> > Tried using the Administrator account on the local machine. Same problem.
> >
> > "Brad Feaker" wrote:
> >
> > > Try installing using a local system account and then changing the service
> > > accounts after the install is complete.
> > >
> > > Brad
> > >
> > > "Mike" wrote:
> > >
> > > > Yes
> > > >
> > > > "Brad Feaker" wrote:
> > > >
> > > > > Is the NT account you are using to install a member of the local server
> > > > > Administrator group?
> > > > >
> > > > > Brad Feaker
> > > > > Ex nihilo, nihil fit
> > > > >
> > > > > "Mike" wrote:
> > > > >
> > > > > > I have a couple third part applications that I'm trying to install that
> > > > > > install SQL databases. However I get similar errors during both for the
> > > > > > install.
> > > > > >
> > > > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > > > name again.
> > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > > > (NULL), (NULL), (NULL).
> > > > > >
> > > > > >
> > > > > > I've talked to a couple other users and they haven't experienced the same
> > > > > > issues. My server is set to mixed mode and the SA account does have a
> > > > > > password. I've tried installing using the SA account as well as a domain
> > > > > > admin account and neither worked.|||At this point you may want to toss the problem back to the vendor....sorry I
could not be of any assistance...
Brad
"Mike" wrote:
> this is an interactive application that i'm trying to install so I'm not sure
> there is a way to do what your asking. i'm assuming it comes to this error
> some point where it's creating the db in sql. it's funny though the the db
> and tables appear to be created fine.
> "Brad Feaker" wrote:
> > Instead of using a windows account at all, choose the 'Local System Account'
> > option during the install.
> >
> > Brad
> >
> > "Mike" wrote:
> >
> > > Tried using the Administrator account on the local machine. Same problem.
> > >
> > > "Brad Feaker" wrote:
> > >
> > > > Try installing using a local system account and then changing the service
> > > > accounts after the install is complete.
> > > >
> > > > Brad
> > > >
> > > > "Mike" wrote:
> > > >
> > > > > Yes
> > > > >
> > > > > "Brad Feaker" wrote:
> > > > >
> > > > > > Is the NT account you are using to install a member of the local server
> > > > > > Administrator group?
> > > > > >
> > > > > > Brad Feaker
> > > > > > Ex nihilo, nihil fit
> > > > > >
> > > > > > "Mike" wrote:
> > > > > >
> > > > > > > I have a couple third part applications that I'm trying to install that
> > > > > > > install SQL databases. However I get similar errors during both for the
> > > > > > > install.
> > > > > > >
> > > > > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > > > > name again.
> > > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > > > > (NULL), (NULL), (NULL).
> > > > > > >
> > > > > > >
> > > > > > > I've talked to a couple other users and they haven't experienced the same
> > > > > > > issues. My server is set to mixed mode and the SA account does have a
> > > > > > > password. I've tried installing using the SA account as well as a domain
> > > > > > > admin account and neither worked.|||Thanks. I did so Monday. I believe they're stumped.
"Brad Feaker" wrote:
> At this point you may want to toss the problem back to the vendor....sorry I
> could not be of any assistance...
> Brad
> "Mike" wrote:
> > this is an interactive application that i'm trying to install so I'm not sure
> > there is a way to do what your asking. i'm assuming it comes to this error
> > some point where it's creating the db in sql. it's funny though the the db
> > and tables appear to be created fine.
> >
> > "Brad Feaker" wrote:
> >
> > > Instead of using a windows account at all, choose the 'Local System Account'
> > > option during the install.
> > >
> > > Brad
> > >
> > > "Mike" wrote:
> > >
> > > > Tried using the Administrator account on the local machine. Same problem.
> > > >
> > > > "Brad Feaker" wrote:
> > > >
> > > > > Try installing using a local system account and then changing the service
> > > > > accounts after the install is complete.
> > > > >
> > > > > Brad
> > > > >
> > > > > "Mike" wrote:
> > > > >
> > > > > > Yes
> > > > > >
> > > > > > "Brad Feaker" wrote:
> > > > > >
> > > > > > > Is the NT account you are using to install a member of the local server
> > > > > > > Administrator group?
> > > > > > >
> > > > > > > Brad Feaker
> > > > > > > Ex nihilo, nihil fit
> > > > > > >
> > > > > > > "Mike" wrote:
> > > > > > >
> > > > > > > > I have a couple third part applications that I'm trying to install that
> > > > > > > > install SQL databases. However I get similar errors during both for the
> > > > > > > > install.
> > > > > > > >
> > > > > > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > > > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > > > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > > > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > > > > > name again.
> > > > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > > > > > (NULL), (NULL), (NULL).
> > > > > > > >
> > > > > > > >
> > > > > > > > I've talked to a couple other users and they haven't experienced the same
> > > > > > > > issues. My server is set to mixed mode and the SA account does have a
> > > > > > > > password. I've tried installing using the SA account as well as a domain
> > > > > > > > admin account and neither worked.sql

Product error installs

I have a couple third part applications that I'm trying to install that
install SQL databases. However I get similar errors during both for the
install.
I'll end up w/ an Error 11001 in the app event log and the contents of the
error common to both is: Error 1001.Setup failed. --> Windows NT user or
group 'NT AUTHORITY\domain users' not found. Check the name again.
Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
name again.
User or role 'NT AUTHORITY\domain users' does not exist in this database.
User or role 'NT AUTHORITY\domain users' does not exist in this database.,
(NULL), (NULL), (NULL).
I've talked to a couple other users and they haven't experienced the same
issues. My server is set to mixed mode and the SA account does have a
password. I've tried installing using the SA account as well as a domain
admin account and neither worked.Is the NT account you are using to install a member of the local server
Administrator group?
Brad Feaker
Ex nihilo, nihil fit
"Mike" wrote:

> I have a couple third part applications that I'm trying to install that
> install SQL databases. However I get similar errors during both for the
> install.
> I'll end up w/ an Error 11001 in the app event log and the contents of the
> error common to both is: Error 1001.Setup failed. --> Windows NT user or
> group 'NT AUTHORITY\domain users' not found. Check the name again.
> Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> name again.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> (NULL), (NULL), (NULL).
>
> I've talked to a couple other users and they haven't experienced the same
> issues. My server is set to mixed mode and the SA account does have a
> password. I've tried installing using the SA account as well as a domain
> admin account and neither worked.|||Yes
"Brad Feaker" wrote:
[vbcol=seagreen]
> Is the NT account you are using to install a member of the local server
> Administrator group?
> Brad Feaker
> Ex nihilo, nihil fit
> "Mike" wrote:
>|||Try installing using a local system account and then changing the service
accounts after the install is complete.
Brad
"Mike" wrote:
[vbcol=seagreen]
> Yes
> "Brad Feaker" wrote:
>|||Tried using the Administrator account on the local machine. Same problem.
"Brad Feaker" wrote:
[vbcol=seagreen]
> Try installing using a local system account and then changing the service
> accounts after the install is complete.
> Brad
> "Mike" wrote:
>|||Instead of using a windows account at all, choose the 'Local System Account'
option during the install.
Brad
"Mike" wrote:
[vbcol=seagreen]
> Tried using the Administrator account on the local machine. Same problem.
> "Brad Feaker" wrote:
>|||this is an interactive application that i'm trying to install so I'm not sur
e
there is a way to do what your asking. i'm assuming it comes to this error
some point where it's creating the db in sql. it's funny though the the db
and tables appear to be created fine.
"Brad Feaker" wrote:
[vbcol=seagreen]
> Instead of using a windows account at all, choose the 'Local System Accoun
t'
> option during the install.
> Brad
> "Mike" wrote:
>|||At this point you may want to toss the problem back to the vendor....sorry
I
could not be of any assistance...
Brad
"Mike" wrote:
[vbcol=seagreen]
> this is an interactive application that i'm trying to install so I'm not s
ure
> there is a way to do what your asking. i'm assuming it comes to this erro
r
> some point where it's creating the db in sql. it's funny though the the d
b
> and tables appear to be created fine.
> "Brad Feaker" wrote:
>|||Thanks. I did so Monday. I believe they're stumped.
"Brad Feaker" wrote:
[vbcol=seagreen]
> At this point you may want to toss the problem back to the vendor....sorr
y I
> could not be of any assistance...
> Brad
> "Mike" wrote:
>

processing has been canceled by the user ?

hi all,
sometimes i am seeing a error , when i am trying to gegerate a report
please help .........
---
Reporting Services Error
----
Report processing has been canceled by the user. (rsProcessingAborted) Get
Online HelpOn Jan 18, 8:53 am, "jelzi" <je...@.discussions.microsoft.com> wrote:
> hi all,
> sometimes i am seeing a error , when i am trying to gegerate a report
> please help .........
> ---
> Reporting Services Error
> ----
> Report processing has been canceled by the user. (rsProcessingAborted) Get
> Online Help
You will most likely want to increase your timeout value in the site
settings. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||hi Enrique,
where is this setting ?
regards
jelzi
>> hi all,
>> sometimes i am seeing a error , when i am trying to gegerate a report
>> please help .........
>> ---
>> Reporting Services Error
>> ----
>> Report processing has been canceled by the user. (rsProcessingAborted)
>> Get
>> Online Help
>
> You will most likely want to increase your timeout value in the site
> settings. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant

Processing error

Hi all,

This came up and I have never see it before, I have tried logging in as sa and by using Windows Authentication and both give the same error. The error below occurred while using sa and the password. I get the same thing when I use WA (I am sysadmin).

Anyone have any ideas about what could be causing this?

Thanks,

Roy

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Parallel>

<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<Object>

<DatabaseID>Pipeline Cube</DatabaseID>

<DimensionID>Tbl Pipeline Date</DimensionID>

</Object>

<Type>ProcessFull</Type>

<WriteBackTableCreation>UseExisting</WriteBackTableCreation>

</Process>

</Parallel>

</Batch>

Processing Dimension 'Tbl Pipeline Date' completed successfully.

Start time: 2/24/2006 9:01:52 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:05

Processing Dimension Attribute '(All)' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:53 AM; Duration: 0:00:00

Processing Dimension Attribute 'DYear' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'Quarter' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'MonthNumber' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'ActualDate' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'WeekNumber' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'DayOfWeek' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'DayOfMonth' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Processing Dimension Attribute 'MonthName' completed successfully.

Start time: 2/24/2006 9:01:53 AM; End time: 2/24/2006 9:01:57 AM; Duration: 0:00:04

Errors and Warnings from Response

The following system error occurred: Logon failure: unknown user name or bad password. .

Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works', Name of 'Adventure Works'.

Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Tbl Pipeline Date', Name of 'Tbl Pipeline Date' was being processed.

Errors in the OLAP storage engine: An error occurred while the 'Quarter' attribute of the 'Tbl Pipeline Date' dimension from the 'Pipeline Cube' database was being processed.

Have you configured your data source to use the service account credentials? Analysis Services only supports that setting.

_-_-_ Dave

|||

Dave,

You are correct. I had forgotten all about using the service account credentials.

Thanks,

Roy

Processing cube from SSAS - OLE DB error

I have made a new dimension and setup the reference in dimension usage. Every time I process the cube i got the following message

Error 1 OLE DB error: OLE DB or ODBC error: Invalid column name 'PReference'.; 42S22. 0 0

The value in this column is 0,1 or 2. I have set the value in all rows to 1 and still get the same error.

I have tried to create a new column - updated value to 1 and refreshed the datasource and changed the dimension and dimension usage and I still got the same error processing the cube.

I have tried to use another integer field in dimension usage and this works fine.

Maybe it is something on the table - i have tried almost all but I can't solve this problem.

Leo Pedersen

The error message "Invalid column name 'PReference'" is saying that an invalid column name was specified in the SQL query that AS generated. Run Profiler on the AS server and capture the SQL query. It should point you to the problem.

Processing Cube error message?

Sorry about this "too stupid to live" type question, but I'm processing my first cube and I get the following error message: MdxScript(Manufacturing DM) (18,5) Parser: The syntax for "," is incorrect.

Dimensions are processed, it is working on a fact table. Where do I go to find a file that I might look for a bad comma?

(SQL Svr 2005 32bit w/sp 2, Vista Ultimate 32bit, Visual Studio w/ sp1)

Sorry, posted too soon....found my problem.....error in calculation code.....D'oh!!!

Processing cube error

Hi,
I have a small problem when trying to process the cubes in AS. We have a
datawarehouse and have done couple of cubes also. In the beginning the cubes
processed fine, but after a while I have begin to get lots of errors. The
error message is "The attribute key cannot be foun. The record was skipped
because the attribute key was not found". Its a clear message, but the
problem is that the key it gives can be found and exists in the database...
Could there be other reasons for this message?
Any ideas? Thanks in advance!are you processing your dimensions?
"beatmasta" <beatmasta@.discussions.microsoft.com> wrote in message
news:2731F26C-2DB8-40D0-B791-A4478D9F0813@.microsoft.com...
> Hi,
> I have a small problem when trying to process the cubes in AS. We have a
> datawarehouse and have done couple of cubes also. In the beginning the
> cubes
> processed fine, but after a while I have begin to get lots of errors. The
> error message is "The attribute key cannot be foun. The record was skipped
> because the attribute key was not found". Its a clear message, but the
> problem is that the key it gives can be found and exists in the
> database...
> Could there be other reasons for this message?
> Any ideas? Thanks in advance!|||Nope...
And yes, that was the problem! Thanks a lot for helping the noobie!

Processing Cube

Hi,

Everyday I have a schedule job to processing the cubes, but I always receive the same error and then the Analysis Service will be stop. Here is the error msg from the Event Viewer:

Event Type: Error
Event Source: MSSQLServerOLAPService
Event Category: (256)
Event ID: 22
Date: 9/18/2007
Time: 5:03:38 AM
User: N/A
Computer: HODB04
Description:
The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: File system error: The following error occurred during a file operation: The process cannot access the file because it is being used by another process. . (\\?\z:\OLAP\data\DM_POS_V2.0.db\POS DM.558.cub\Fact Sales.591.det\FACT SALES F2008 P2.7.prt\55.agg.flex.data)..

Thanks,

I would reccomend you to investigate the storage subsystem (RAID).

I have almost the same problem - the source of it was in the configurationof the RAID controller.

|||

What modifications did you made to the raid config to make it run? Whe are just running two mirrored disks on a HP so there's not much to modify.

Processing a cube dimension

I am trying to process a time dimension on a cube and get the following error. Can some one please help. How can I fix this error?

Error 1 Errors related to feature availability and configuration: Exceeded the maximum number of partitions in a measure group. The installed server editions allows not more than 3 partitions and not more than 1 writeback partition. 0 0

That is the error if you try to use Standard Edition and partitioning.

Partitioning is an EE-only feature.

_-_-_ Dave

Process ID 65 attempting to unlock unowned resource

Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
I am getting the above error in the event log for my website.
Can someone help me and tell me what this means?
thansk in Advance. Kim
Hi
See if this applies:
http://support.microsoft.com/?kbid=814654
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kim" <kim@.xxx.com> wrote in message
news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net. ..
> Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
> I am getting the above error in the event log for my website.
> Can someone help me and tell me what this means?
> thansk in Advance. Kim
>
|||Hi,
It looks to be the exact problem - except we are running with service pak 4
here's the version info
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer
Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
> Hi
> See if this applies:
> http://support.microsoft.com/?kbid=814654
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kim" <kim@.xxx.com> wrote in message
> news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net. ..
>
|||Hi
You are running Windows SP4, but SQL Server SP3 (8.00.760)
The problem was fixed in build 765 which was after SP3.
You can do one of the following:
Download the Security Hotfix Rollup that will take you build to 818
(http://www.microsoft.com/downloads/d...displaylang=en)
Download build 878,
http://support.microsoft.com/default...b;en-us;838166
Or apply SP4 for SQL Server. If you are going to apply SP4, make sure that
your server is not using AWE or PAE as there is a known issue with it and
SP4. http://www.microsoft.com/sql/downloads/2000/sp4.asp and
http://msmvps.com/epprecht/archive/2.../14/46940.aspx
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kim" <kim@.xxx.com> wrote in message
news:LY0ie.14211$7A2.2550@.bignews6.bellsouth.net.. .
> Hi,
> It looks to be the exact problem - except we are running with service pak
> 4
> here's the version info
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer
> Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
>
|||Hi,
Thanks for your help.
I will pass this on to the guy who will do the updates.
Kim
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:eoxzWthWFHA.2976@.TK2MSFTNGP10.phx.gbl...
> Hi
> You are running Windows SP4, but SQL Server SP3 (8.00.760)
> The problem was fixed in build 765 which was after SP3.
> You can do one of the following:
> Download the Security Hotfix Rollup that will take you build to 818
>
(http://www.microsoft.com/downloads/d...ae9d-bd44-40c5
-add3-b8c99618e68d&displaylang=en)[vbcol=seagreen]
> Download build 878,
> http://support.microsoft.com/default...b;en-us;838166
> Or apply SP4 for SQL Server. If you are going to apply SP4, make sure that
> your server is not using AWE or PAE as there is a known issue with it and
> SP4. http://www.microsoft.com/sql/downloads/2000/sp4.asp and
> http://msmvps.com/epprecht/archive/2.../14/46940.aspx
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kim" <kim@.xxx.com> wrote in message
> news:LY0ie.14211$7A2.2550@.bignews6.bellsouth.net.. .
pak
>

Process ID 65 attempting to unlock unowned resource

Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
I am getting the above error in the event log for my website.
Can someone help me and tell me what this means?
thansk in Advance. KimHi
See if this applies:
http://support.microsoft.com/?kbid=814654
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kim" <kim@.xxx.com> wrote in message
news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net...
> Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
> I am getting the above error in the event log for my website.
> Can someone help me and tell me what this means?
> thansk in Advance. Kim
>|||Hi,
It looks to be the exact problem - except we are running with service pak 4
here's the version info
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer
Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
> Hi
> See if this applies:
> http://support.microsoft.com/?kbid=814654
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kim" <kim@.xxx.com> wrote in message
> news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net...
> > Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
> >
> > I am getting the above error in the event log for my website.
> > Can someone help me and tell me what this means?
> >
> > thansk in Advance. Kim
> >
> >
>|||Hi
You are running Windows SP4, but SQL Server SP3 (8.00.760)
The problem was fixed in build 765 which was after SP3.
You can do one of the following:
Download the Security Hotfix Rollup that will take you build to 818
(http://www.microsoft.com/downloads/details.aspx?FamilyID=9814ae9d-bd44-40c5-add3-b8c99618e68d&displaylang=en)
Download build 878,
http://support.microsoft.com/default.aspx?scid=kb;en-us;838166
Or apply SP4 for SQL Server. If you are going to apply SP4, make sure that
your server is not using AWE or PAE as there is a known issue with it and
SP4. http://www.microsoft.com/sql/downloads/2000/sp4.asp and
http://msmvps.com/epprecht/archive/2005/05/14/46940.aspx
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kim" <kim@.xxx.com> wrote in message
news:LY0ie.14211$7A2.2550@.bignews6.bellsouth.net...
> Hi,
> It looks to be the exact problem - except we are running with service pak
> 4
> here's the version info
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer
> Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
>> Hi
>> See if this applies:
>> http://support.microsoft.com/?kbid=814654
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "Kim" <kim@.xxx.com> wrote in message
>> news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net...
>> > Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
>> >
>> > I am getting the above error in the event log for my website.
>> > Can someone help me and tell me what this means?
>> >
>> > thansk in Advance. Kim
>> >
>> >
>>
>|||Hi,
Thanks for your help.
I will pass this on to the guy who will do the updates.
Kim
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:eoxzWthWFHA.2976@.TK2MSFTNGP10.phx.gbl...
> Hi
> You are running Windows SP4, but SQL Server SP3 (8.00.760)
> The problem was fixed in build 765 which was after SP3.
> You can do one of the following:
> Download the Security Hotfix Rollup that will take you build to 818
>
(http://www.microsoft.com/downloads/details.aspx?FamilyID=9814ae9d-bd44-40c5
-add3-b8c99618e68d&displaylang=en)
> Download build 878,
> http://support.microsoft.com/default.aspx?scid=kb;en-us;838166
> Or apply SP4 for SQL Server. If you are going to apply SP4, make sure that
> your server is not using AWE or PAE as there is a known issue with it and
> SP4. http://www.microsoft.com/sql/downloads/2000/sp4.asp and
> http://msmvps.com/epprecht/archive/2005/05/14/46940.aspx
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kim" <kim@.xxx.com> wrote in message
> news:LY0ie.14211$7A2.2550@.bignews6.bellsouth.net...
> > Hi,
> > It looks to be the exact problem - except we are running with service
pak
> > 4
> > here's the version info
> >
> > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > Copyright (c) 1988-2003 Microsoft Corporation Developer
> > Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> >
> >
> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> > news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
> >> Hi
> >>
> >> See if this applies:
> >>
> >> http://support.microsoft.com/?kbid=814654
> >>
> >> Regards
> >> --
> >> Mike Epprecht, Microsoft SQL Server MVP
> >> Zurich, Switzerland
> >>
> >> IM: mike@.epprecht.net
> >>
> >> MVP Program: http://www.microsoft.com/mvp
> >>
> >> Blog: http://www.msmvps.com/epprecht/
> >>
> >> "Kim" <kim@.xxx.com> wrote in message
> >> news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net...
> >> > Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
> >> >
> >> > I am getting the above error in the event log for my website.
> >> > Can someone help me and tell me what this means?
> >> >
> >> > thansk in Advance. Kim
> >> >
> >> >
> >>
> >>
> >
> >
>