ERROR: Failure to compile WMI file

I received this error at the end of the "Reporting Services" setup.

I checked WMI process in Services and everything is OK, it's running.

So far I was able to install Designer Tools only (unchecking Report Manager and Report server).

All system components are up to date and SQL Server SP3 is installed.

I would highly appreciate it if somebody could help me out. It's now matter of survival to me.

Thanks in advance,

Confused Virginian

You also need SP3a to install Reporting Services. Hope this helps.|||

Caddre,

Thank you for your help. I already have SP3 installed.

Eventually I found the fix, right there:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/reinstalling_wmi.asp

This article explains how to recreate corrupted WMI repository.

Virginian

Error: Attribute key cannot be found

Helo, I have the following problem

I have one fact-table in my cube
And I have one dimension table

When I process the cube I get the following error:

"Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fbi_analytic_journals, Column: journals_key, Value: 306."

I understand the error, and I know why I get the error, but how can I solve the error

In the fact-table there is a record with key 306, but this key is not found in the dimension table. What I want is that in the cube are all the record that are in the fact-table with a reference in the dimension table, so the record with key 306 must not be in the cube

Anyone an idea ?

Thx

Look at your processing options. On the "Dimension key errors" tab select "Use custom error configuration" and change the setting to "Convert to unknown".

|||

I have this same situation. But where are the processing options found? I don't see it!

thx,

Marilyn

|||found it! thanks.|||

Is there a way to set the "Dimension key errors" to automatically use the 'Use Custom error configuration' without having to set it each time processing is performed?

thx,

-Marilyn

|||

It is also possible to set ErrorConfiguration on the partitoin, measure group or on the cube.

Take a look at the properties dialog for cube or partition in SQL Management Studio, you will find a Error Configuraiton tab there.

In BI Dev Studio look at the properties panel and find ErrorConfiguration property. Once you set it to "Custom", you will be able to set individual error configuration properties.

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

|||

right-click on the cube in the solution explorer pane.

select 'process...'

press the 'change settings' button.

select the 'dimension key errors' tab

select the radio button 'use custom error configuration'

|||

Your settings won't "stick" in the Analysis designer itself for some reason... you must create an Analysis Services Task in BI Studio to run against the cube you've created.

|||

Hello,

I get the same error msg but here's the situation

I create a new project, with a data source and a data source view with only one table

I create a dimension base on this table and try to process it

There's no cube, only a dimension and it failed with attribute key not found error

After many test I discover that the lines causing the error where random and the error line are same as those that work

I understand the reason why this error is thrown when a cube reference to an item that doesn't in the dimension but in my situation I really can't understand what happen !!

Can somebody help me with this one

thank you

Billy

|||make sure you process your dimensions before your CUBE.

Error: Attribute key cannot be found

Helo, I have the following problem

I have one fact-table in my cube
And I have one dimension table

When I process the cube I get the following error:

"Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fbi_analytic_journals, Column: journals_key, Value: 306."

I understand the error, and I know why I get the error, but how can I solve the error

In the fact-table there is a record with key 306, but this key is not found in the dimension table. What I want is that in the cube are all the record that are in the fact-table with a reference in the dimension table, so the record with key 306 must not be in the cube

Anyone an idea ?

Thx

Look at your processing options. On the "Dimension key errors" tab select "Use custom error configuration" and change the setting to "Convert to unknown".

|||

I have this same situation. But where are the processing options found? I don't see it!

thx,

Marilyn

|||found it! thanks.|||

Is there a way to set the "Dimension key errors" to automatically use the 'Use Custom error configuration' without having to set it each time processing is performed?

thx,

-Marilyn

|||

It is also possible to set ErrorConfiguration on the partitoin, measure group or on the cube.

Take a look at the properties dialog for cube or partition in SQL Management Studio, you will find a Error Configuraiton tab there.

In BI Dev Studio look at the properties panel and find ErrorConfiguration property. Once you set it to "Custom", you will be able to set individual error configuration properties.

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

|||

right-click on the cube in the solution explorer pane.

select 'process...'

press the 'change settings' button.

select the 'dimension key errors' tab

select the radio button 'use custom error configuration'

|||

Your settings won't "stick" in the Analysis designer itself for some reason... you must create an Analysis Services Task in BI Studio to run against the cube you've created.

|||

Hello,

I get the same error msg but here's the situation

I create a new project, with a data source and a data source view with only one table

I create a dimension base on this table and try to process it

There's no cube, only a dimension and it failed with attribute key not found error

After many test I discover that the lines causing the error where random and the error line are same as those that work

I understand the reason why this error is thrown when a cube reference to an item that doesn't in the dimension but in my situation I really can't understand what happen !!

Can somebody help me with this one

thank you

Billy

|||make sure you process your dimensions before your CUBE.

Error: Attribute key cannot be found

Helo, I have the following problem

I have one fact-table in my cube
And I have one dimension table

When I process the cube I get the following error:

"Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fbi_analytic_journals, Column: journals_key, Value: 306."

I understand the error, and I know why I get the error, but how can I solve the error

In the fact-table there is a record with key 306, but this key is not found in the dimension table. What I want is that in the cube are all the record that are in the fact-table with a reference in the dimension table, so the record with key 306 must not be in the cube

Anyone an idea ?

Thx

Look at your processing options. On the "Dimension key errors" tab select "Use custom error configuration" and change the setting to "Convert to unknown".

|||

I have this same situation. But where are the processing options found? I don't see it!

thx,

Marilyn

|||found it! thanks.|||

Is there a way to set the "Dimension key errors" to automatically use the 'Use Custom error configuration' without having to set it each time processing is performed?

thx,

-Marilyn

|||

It is also possible to set ErrorConfiguration on the partitoin, measure group or on the cube.

Take a look at the properties dialog for cube or partition in SQL Management Studio, you will find a Error Configuraiton tab there.

In BI Dev Studio look at the properties panel and find ErrorConfiguration property. Once you set it to "Custom", you will be able to set individual error configuration properties.

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

|||

right-click on the cube in the solution explorer pane.

select 'process...'

press the 'change settings' button.

select the 'dimension key errors' tab

select the radio button 'use custom error configuration'

|||

Your settings won't "stick" in the Analysis designer itself for some reason... you must create an Analysis Services Task in BI Studio to run against the cube you've created.

|||

Hello,

I get the same error msg but here's the situation

I create a new project, with a data source and a data source view with only one table

I create a dimension base on this table and try to process it

There's no cube, only a dimension and it failed with attribute key not found error

After many test I discover that the lines causing the error where random and the error line are same as those that work

I understand the reason why this error is thrown when a cube reference to an item that doesn't in the dimension but in my situation I really can't understand what happen !!

Can somebody help me with this one

thank you

Billy

|||make sure you process your dimensions before your CUBE.

Error: Attribute key cannot be found

Helo, I have the following problem

I have one fact-table in my cube
And I have one dimension table

When I process the cube I get the following error:

"Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fbi_analytic_journals, Column: journals_key, Value: 306."

I understand the error, and I know why I get the error, but how can I solve the error

In the fact-table there is a record with key 306, but this key is not found in the dimension table. What I want is that in the cube are all the record that are in the fact-table with a reference in the dimension table, so the record with key 306 must not be in the cube

Anyone an idea ?

Thx

Look at your processing options. On the "Dimension key errors" tab select "Use custom error configuration" and change the setting to "Convert to unknown".

|||

I have this same situation. But where are the processing options found? I don't see it!

thx,

Marilyn

|||found it! thanks.|||

Is there a way to set the "Dimension key errors" to automatically use the 'Use Custom error configuration' without having to set it each time processing is performed?

thx,

-Marilyn

|||

It is also possible to set ErrorConfiguration on the partitoin, measure group or on the cube.

Take a look at the properties dialog for cube or partition in SQL Management Studio, you will find a Error Configuraiton tab there.

In BI Dev Studio look at the properties panel and find ErrorConfiguration property. Once you set it to "Custom", you will be able to set individual error configuration properties.

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

|||

right-click on the cube in the solution explorer pane.

select 'process...'

press the 'change settings' button.

select the 'dimension key errors' tab

select the radio button 'use custom error configuration'

|||

Your settings won't "stick" in the Analysis designer itself for some reason... you must create an Analysis Services Task in BI Studio to run against the cube you've created.

|||

Hello,

I get the same error msg but here's the situation

I create a new project, with a data source and a data source view with only one table

I create a dimension base on this table and try to process it

There's no cube, only a dimension and it failed with attribute key not found error

After many test I discover that the lines causing the error where random and the error line are same as those that work

I understand the reason why this error is thrown when a cube reference to an item that doesn't in the dimension but in my situation I really can't understand what happen !!

Can somebody help me with this one

thank you

Billy

|||make sure you process your dimensions before your CUBE.

Error: Attribute key cannot be found

Helo, I have the following problem

I have one fact-table in my cube
And I have one dimension table

When I process the cube I get the following error:

"Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fbi_analytic_journals, Column: journals_key, Value: 306."

I understand the error, and I know why I get the error, but how can I solve the error

In the fact-table there is a record with key 306, but this key is not found in the dimension table. What I want is that in the cube are all the record that are in the fact-table with a reference in the dimension table, so the record with key 306 must not be in the cube

Anyone an idea ?

Thx

Look at your processing options. On the "Dimension key errors" tab select "Use custom error configuration" and change the setting to "Convert to unknown".

|||

I have this same situation. But where are the processing options found? I don't see it!

thx,

Marilyn

|||found it! thanks.|||

Is there a way to set the "Dimension key errors" to automatically use the 'Use Custom error configuration' without having to set it each time processing is performed?

thx,

-Marilyn

|||

It is also possible to set ErrorConfiguration on the partitoin, measure group or on the cube.

Take a look at the properties dialog for cube or partition in SQL Management Studio, you will find a Error Configuraiton tab there.

In BI Dev Studio look at the properties panel and find ErrorConfiguration property. Once you set it to "Custom", you will be able to set individual error configuration properties.

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

|||

right-click on the cube in the solution explorer pane.

select 'process...'

press the 'change settings' button.

select the 'dimension key errors' tab

select the radio button 'use custom error configuration'

|||

Your settings won't "stick" in the Analysis designer itself for some reason... you must create an Analysis Services Task in BI Studio to run against the cube you've created.

|||

Hello,

I get the same error msg but here's the situation

I create a new project, with a data source and a data source view with only one table

I create a dimension base on this table and try to process it

There's no cube, only a dimension and it failed with attribute key not found error

After many test I discover that the lines causing the error where random and the error line are same as those that work

I understand the reason why this error is thrown when a cube reference to an item that doesn't in the dimension but in my situation I really can't understand what happen !!

Can somebody help me with this one

thank you

Billy

|||make sure you process your dimensions before your CUBE.

sql

Error: Attribute key cannot be found

Helo, I have the following problem

I have one fact-table in my cube
And I have one dimension table

When I process the cube I get the following error:

"Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fbi_analytic_journals, Column: journals_key, Value: 306."

I understand the error, and I know why I get the error, but how can I solve the error

In the fact-table there is a record with key 306, but this key is not found in the dimension table. What I want is that in the cube are all the record that are in the fact-table with a reference in the dimension table, so the record with key 306 must not be in the cube

Anyone an idea ?

Thx

Look at your processing options. On the "Dimension key errors" tab select "Use custom error configuration" and change the setting to "Convert to unknown".

|||

I have this same situation. But where are the processing options found? I don't see it!

thx,

Marilyn

|||found it! thanks.|||

Is there a way to set the "Dimension key errors" to automatically use the 'Use Custom error configuration' without having to set it each time processing is performed?

thx,

-Marilyn

|||

It is also possible to set ErrorConfiguration on the partitoin, measure group or on the cube.

Take a look at the properties dialog for cube or partition in SQL Management Studio, you will find a Error Configuraiton tab there.

In BI Dev Studio look at the properties panel and find ErrorConfiguration property. Once you set it to "Custom", you will be able to set individual error configuration properties.

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

|||

right-click on the cube in the solution explorer pane.

select 'process...'

press the 'change settings' button.

select the 'dimension key errors' tab

select the radio button 'use custom error configuration'

|||

Your settings won't "stick" in the Analysis designer itself for some reason... you must create an Analysis Services Task in BI Studio to run against the cube you've created.

|||

Hello,

I get the same error msg but here's the situation

I create a new project, with a data source and a data source view with only one table

I create a dimension base on this table and try to process it

There's no cube, only a dimension and it failed with attribute key not found error

After many test I discover that the lines causing the error where random and the error line are same as those that work

I understand the reason why this error is thrown when a cube reference to an item that doesn't in the dimension but in my situation I really can't understand what happen !!

Can somebody help me with this one

thank you

Billy

|||make sure you process your dimensions before your CUBE.

error: Attempt to fetch logical page

Hi,
During an upgrade from sql server 6.5 to sql server 2000 I receive the
follwoing error and the upgrade process remains stuck until terminated
manually:
ODBC error 605 (HY000) Attempt to fetch logical page 1430280 in database
'nice_cls' belongs to object 'NICE_CLS_CALLS_0008', not to object
'NICE_CLS_CALLS_0007'.
I tried using dbcc checkdb and received the same error.
Is there any idea how to address this situation or how to delete the
specific page?
Thanks,
YanivHi Yaniv,
This error occurs when Microsoft SQL Server detects database corruption.
The second object specified in the text not to object '%.*ls' is probably
corrupt. Because this error can mask the existence of other errors, execute
DBCC CHECKDB to determine the extent of the damage.
I am assuming that the corruption is happening on your SQL Server 6.5
server. The best way to recover from corruption is to restore from your
good backup.
I hope this helps !!!
Thanks,
Fargham
Microsoft - SQL Server

error: Attempt to fetch logical page

Hi,
During an upgrade from sql server 6.5 to sql server 2000 I receive the
follwoing error and the upgrade process remains stuck until terminated
manually:
ODBC error 605 (HY000) Attempt to fetch logical page 1430280 in database
'nice_cls' belongs to object 'NICE_CLS_CALLS_0008', not to object
'NICE_CLS_CALLS_0007'.
I tried using dbcc checkdb and received the same error.
Is there any idea how to address this situation or how to delete the
specific page?
Thanks,
YanivHi Yaniv,
This error occurs when Microsoft® SQL Server detects database corruption.
The second object specified in the text not to object '%.*ls' is probably
corrupt. Because this error can mask the existence of other errors, execute
DBCC CHECKDB to determine the extent of the damage.
I am assuming that the corruption is happening on your SQL Server 6.5
server. The best way to recover from corruption is to restore from your
good backup.
I hope this helps !!!
Thanks,
Fargham
Microsoft - SQL Server

error: Attempt to fetch logical page

Hi,
During an upgrade from sql server 6.5 to sql server 2000 I receive the
follwoing error and the upgrade process remains stuck until terminated
manually:
ODBC error 605 (HY000) Attempt to fetch logical page 1430280 in database
'nice_cls' belongs to object 'NICE_CLS_CALLS_0008', not to object
'NICE_CLS_CALLS_0007'.
I tried using dbcc checkdb and received the same error.
Is there any idea how to address this situation or how to delete the
specific page?
Thanks,
Yaniv
Hi Yaniv,
This error occurs when Microsoft SQL Server detects database corruption.
The second object specified in the text not to object '%.*ls' is probably
corrupt. Because this error can mask the existence of other errors, execute
DBCC CHECKDB to determine the extent of the damage.
I am assuming that the corruption is happening on your SQL Server 6.5
server. The best way to recover from corruption is to restore from your
good backup.
I hope this helps !!!
Thanks,
Fargham
Microsoft - SQL Server

ERROR: A variable may only be added once to either the read lock list or the write lock list.

Hi,
I have set of 2 DTS packages, one of which calls the other by forming a command-line (dtexec) using a Execute Process task.

From the parent package-> Execute Process Task->
dtsexec /F etc... /<pkg variable> = "servername"

Each of the parent and the called package have a variable: "User::DWServerSQLInstance" which is mapped to the SQL server connection manager server name property using an expression. The outer package has the above variable and so does the inner called package (which gets assigned through the command line from the outerpackage call to inner)

I "sometimes" get the following error:

OnError,I4,TESTDOM\Administrator,ACDWAggregation,{A1F8E43F-15F1-4685-8C18-6866AB31E62B},{77B2F3C7-6756-46EB-8C01-D880598FB4B3},5/22/2006 5:10:28 PM,5/22/2006 5:10:28 PM,-1073659822,0x,The variable "User::DWServerSQLInstance" is already on the read list. A variable may only be added once to either the read lock list or the write lock list.

Help would be appreciated!

I have seen other posts on this but, not able to relate the solution to my scenario.

Do you have multiple tasks (in the same package) executing in parallel, and using same variable, e.g. in property mappings?

If yes, I think this problem is fixed by this post-SP1 fixes collection:
http://support.microsoft.com/Default.aspx?id=918222

Alternatively, you may change the package so the tasks are executed sequentially by creating precedence constraints.|||

Hi Brian,
The child Package uses the User Variable: DWSQLInstanceName mentioned above to initialize 4 SQL Server connections (2 OLEDB & 2 ADO .NET) -- Only <<Server Name>> property using expressions.

I also checked that this error seems to be only on Multi-proc machine. Don't get the same on my laptop.

I cannot seralize the tasks since, the error is coming @. package level while evaluating the package expressions (i.e. for the connections) when the package starts.

What is the best way to still use expressions for connection server names but, get around this error?
Is this what is fixed in SP1?

Also, it seems that the packages does not fail when it encounters the error which I am getting. I have MaxErrorCount = 1 for Package. The package goes ahead.

|||I believe the issue with connections sharing the variable is fixed in the commulative hotfix package I've mentioned above. It should be installed on top of SP1: first, install SP1 then install all the component packages from the hotfix package in the order they are listed in the article.

http://www.microsoft.com/downloads/details.aspx?FamilyId=CB6C71EA-D649-47FF-9176-E7CAC58FD4BC
and then
http://support.microsoft.com/Default.aspx?id=918222|||This was indeed a bug and the post SP1 hotfix "fixes" it.

However, you can still create the bug. It's harder but stil there...|||

Thanks Michael and Crispin for the help on this!

I think we will need to upgrade to SP1 and install the Hotfix bundle for SP1. I think this should fix the issue which I am facing i.e. use of same variable for setting connection "Server Name" - Property in the expressions.

Thanks,
Gaurav

Error: 26 - Error Locating Server/Instance Specified - (My hosting company says it's in my conn

Hi All...

I am trying to move my site (incomplete) for testing and I am finding that the Db connection process to be

the most difficult, well back to my problem. I can't seem to get past this error and am frustrated with overall

connectivity problems. Please help!!!

===================================================================================

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735123 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

Now you all must admit that, if your somewhat new to this databasing, It's a ***.

The source for my application is Visual Web Designer 2005 Express

It is an ASP.Net driven site with membership roles and all the good stuff.

the latest theory is that I need to change the provider config in the web.config file from AspNetSqlProvider

to something else. Most of my complications and frustrations come from GoDaddy and no access to the

shared server (understandibly).

I hope I gave enough info for help and not too much..

Dave

Please check this blog for solutions:

http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

sql

Error: 18456, Severity: 14, State: 16

DBCC TRACEON 4808, server process ID (SPID) 58. This is an
informational message only; no user action is
required.
2007-02-26 16:01:43.270 spid58 DBCC TRACEON 4808, server process
ID (SPID) 58. This is an informational message only; no user action is
required.
2007-02-26 16:02:12.590 spid62 Starting up database
'MYDB'.
2007-02-26 16:02:34.840 spid62 Starting up database
'MYDB'.
2007-02-26 16:02:47.410 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:47.410 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:48.580 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:48.580 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:50.410 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:50.410 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:52.930 spid55 Starting up database
'sampledb'.
2007-02-26 16:02:59.160 Logon Error: 18456, Severity: 14,
State: 16.
The Connection is maded from .net application using trusted connectionIt looks like you're running your .NET application as LocalSystem. You
need to run it as a user who has an account defined in the database with
the appropriate credentials. If you're running an ASP.NET app on
Windows 2003, you'll generally be able to find the configuration for
your identity under "Application Pools" in the IIS configuration.
AMBROSE wrote:
> DBCC TRACEON 4808, server process ID (SPID) 58. This is an
> informational message only; no user action is
> required.
> 2007-02-26 16:01:43.270 spid58 DBCC TRACEON 4808, server process
> ID (SPID) 58. This is an informational message only; no user action is
> required.
> 2007-02-26 16:02:12.590 spid62 Starting up database
> 'MYDB'.
> 2007-02-26 16:02:34.840 spid62 Starting up database
> 'MYDB'.
> 2007-02-26 16:02:47.410 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:47.410 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:48.580 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:48.580 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:50.410 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:50.410 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:52.930 spid55 Starting up database
> 'sampledb'.
> 2007-02-26 16:02:59.160 Logon Error: 18456, Severity: 14,
> State: 16.
> The Connection is maded from .net application using trusted connection
>

Error: 18456, Severity: 14, State: 16

DBCC TRACEON 4808, server process ID (SPID) 58. This is an
informational message only; no user action is
required.
2007-02-26 16:01:43.270 spid58 DBCC TRACEON 4808, server process
ID (SPID) 58. This is an informational message only; no user action is
required.
2007-02-26 16:02:12.590 spid62 Starting up database
'MYDB'.
2007-02-26 16:02:34.840 spid62 Starting up database
'MYDB'.
2007-02-26 16:02:47.410 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:47.410 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:48.580 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:48.580 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:50.410 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:50.410 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:52.930 spid55 Starting up database
'sampledb'.
2007-02-26 16:02:59.160 Logon Error: 18456, Severity: 14,
State: 16.
The Connection is maded from .net application using trusted connectionIt looks like you're running your .NET application as LocalSystem. You
need to run it as a user who has an account defined in the database with
the appropriate credentials. If you're running an ASP.NET app on
Windows 2003, you'll generally be able to find the configuration for
your identity under "Application Pools" in the IIS configuration.
AMBROSE wrote:
> DBCC TRACEON 4808, server process ID (SPID) 58. This is an
> informational message only; no user action is
> required.
> 2007-02-26 16:01:43.270 spid58 DBCC TRACEON 4808, server process
> ID (SPID) 58. This is an informational message only; no user action is
> required.
> 2007-02-26 16:02:12.590 spid62 Starting up database
> 'MYDB'.
> 2007-02-26 16:02:34.840 spid62 Starting up database
> 'MYDB'.
> 2007-02-26 16:02:47.410 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:47.410 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:48.580 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:48.580 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:50.410 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:50.410 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:52.930 spid55 Starting up database
> 'sampledb'.
> 2007-02-26 16:02:59.160 Logon Error: 18456, Severity: 14,
> State: 16.
> The Connection is maded from .net application using trusted connection
>

Error: 17883, Severity: 1, State: 0

MS SQL Server 2000 sp4 Got a series of errors:
Sleeping until external dump process completes.
Resuming after waiting on external debug process for 8 seconds.
Stack Signature for the dump is 0x00000000
Error: 17883, Severity: 1, State: 0
Process 104:0 (fd4) UMS Context 0x0775B548 appears to be non-yielding on
Scheduler 0.
SQL Server has encountered 37 occurrence(s) of IO requests taking longer
than 15 seconds to complete on file [e:\Microsoft SQL
Server\\webslog631_2.mdf] in database [webslog631_2] (35). The OS file handle
is 0x0000071C. The offset of the latest long IO is: 0x0000007e6b8000
Looks like there is a post sp4 hotfix to fix this..
http://support.microsoft.com/kb/909734
how do I contacty MS without having to give them a Credit Card number?"itsonlyme4" wrote:
> MS SQL Server 2000 sp4 Got a series of errors:
> Sleeping until external dump process completes.
> Resuming after waiting on external debug process for 8 seconds.
> Stack Signature for the dump is 0x00000000
> Error: 17883, Severity: 1, State: 0
> Process 104:0 (fd4) UMS Context 0x0775B548 appears to be non-yielding on
> Scheduler 0.
> SQL Server has encountered 37 occurrence(s) of IO requests taking longer
> than 15 seconds to complete on file [e:\Microsoft SQL
> Server\\webslog631_2.mdf] in database [webslog631_2] (35). The OS file handle
> is 0x0000071C. The offset of the latest long IO is: 0x0000007e6b8000
> Looks like there is a post sp4 hotfix to fix this..
> http://support.microsoft.com/kb/909734
> how do I contacty MS without having to give them a Credit Card number?
>
Hi
The cumulative update pack is publically available and will contain this fix
http://support.microsoft.com/kb/916287/
John

Error: 17883, Severity: 1, State: 0

Hi ,
We are getting 17833 error with below message .
Process 54:0 (ac4) UMS Context 0x09F5C830 appears to be non-yielding on
Scheduler 3.
We have SQL 2000 SP4 , per MS documentation this bug has been fixed in SP4
but I still see this in SQL log at least once a week .
Can you pl. suggest the solution .
Thanks,
PrabhuTry to open a case with MS, when we did, they asked us to forward the
minidump file that gets created when that error is recorded in the SQL server
logs. Once MS took a look at the dump file, they determined that the errors
indicate possible underlying hardware issues on writes and reads, that effect
performance and hangs the scheduler. They recommended a thorough test of the
EMC hardware portion. So open a case and send them the minidump files you
should have on your harddrive and they can try to detect what may ba causing
SQL Server to throw error 17883. My understanding is that error 17883 can be
caused by many reasons, could be SQL server related and could be other
resource related.
"Prabhu" wrote:
> Hi ,
> We are getting 17833 error with below message .
> Process 54:0 (ac4) UMS Context 0x09F5C830 appears to be non-yielding on
> Scheduler 3.
> We have SQL 2000 SP4 , per MS documentation this bug has been fixed in SP4
> but I still see this in SQL log at least once a week .
> Can you pl. suggest the solution .
> Thanks,
> Prabhu

Error: 17883, Severity: 1, State: 0

Hi ,
We are getting 17833 error with below message .
Process 54:0 (ac4) UMS Context 0x09F5C830 appears to be non-yielding on
Scheduler 3.
We have SQL 2000 SP4 , per MS documentation this bug has been fixed in SP4
but I still see this in SQL log at least once a week .
Can you pl. suggest the solution .
Thanks,
PrabhuTry to open a case with MS, when we did, they asked us to forward the
minidump file that gets created when that error is recorded in the SQL serve
r
logs. Once MS took a look at the dump file, they determined that the errors
indicate possible underlying hardware issues on writes and reads, that effec
t
performance and hangs the scheduler. They recommended a thorough test of the
EMC hardware portion. So open a case and send them the minidump files you
should have on your harddrive and they can try to detect what may ba causing
SQL Server to throw error 17883. My understanding is that error 17883 can be
caused by many reasons, could be SQL server related and could be other
resource related.
"Prabhu" wrote:

> Hi ,
> We are getting 17833 error with below message .
> Process 54:0 (ac4) UMS Context 0x09F5C830 appears to be non-yielding on
> Scheduler 3.
> We have SQL 2000 SP4 , per MS documentation this bug has been fixed in SP4
> but I still see this in SQL log at least once a week .
> Can you pl. suggest the solution .
> Thanks,
> Prabhu

Error: 17883, Severity: 1, State: 0

Hi ,
We are getting 17833 error with below message .
Process 54:0 (ac4) UMS Context 0x09F5C830 appears to be non-yielding on
Scheduler 3.
We have SQL 2000 SP4 , per MS documentation this bug has been fixed in SP4
but I still see this in SQL log at least once a week .
Can you pl. suggest the solution .
Thanks,
Prabhu
Try to open a case with MS, when we did, they asked us to forward the
minidump file that gets created when that error is recorded in the SQL server
logs. Once MS took a look at the dump file, they determined that the errors
indicate possible underlying hardware issues on writes and reads, that effect
performance and hangs the scheduler. They recommended a thorough test of the
EMC hardware portion. So open a case and send them the minidump files you
should have on your harddrive and they can try to detect what may ba causing
SQL Server to throw error 17883. My understanding is that error 17883 can be
caused by many reasons, could be SQL server related and could be other
resource related.
"Prabhu" wrote:

> Hi ,
> We are getting 17833 error with below message .
> Process 54:0 (ac4) UMS Context 0x09F5C830 appears to be non-yielding on
> Scheduler 3.
> We have SQL 2000 SP4 , per MS documentation this bug has been fixed in SP4
> but I still see this in SQL log at least once a week .
> Can you pl. suggest the solution .
> Thanks,
> Prabhu
sql

Error: 17883

8.00.818, SP3, Standard Edition
After installing SP3, the server hangs with Error: 17883, Severity: 0,
State: 1. Process 0:0 (a04) UMS Context 0x105BB428 appears to be
non-yielding on Scheduler 0.
MS03-031 does not resolve this problem.
Any suggestions?Correction: Severity: 1, State 0.
"TLW" <tlw@.oceanlighthouse.com> wrote in message
news:eSomf6FKEHA.1760@.TK2MSFTNGP10.phx.gbl...
> 8.00.818, SP3, Standard Edition
> After installing SP3, the server hangs with Error: 17883, Severity: 0,
> State: 1. Process 0:0 (a04) UMS Context 0x105BB428 appears to be
> non-yielding on Scheduler 0.
> MS03-031 does not resolve this problem.
> Any suggestions?
>|||I'm having the same issue. I was able to discuss it with a MS
instructor at Sql Connections last week. He said the error is too
internal for troubleshooting other than by MS.
I have setup a black box trace and an alert. The alert will fire on
17883 stopping the black box trace and doing a dbcc stackdump. When
it happens again I'll open a ticket with Microsoft and send off the
files.

Error: 17883

8.00.818, SP3, Standard Edition
After installing SP3, the server hangs with Error: 17883, Severity: 0,
State: 1. Process 0:0 (a04) UMS Context 0x105BB428 appears to be
non-yielding on Scheduler 0.
MS03-031 does not resolve this problem.
Any suggestions?Correction: Severity: 1, State 0.
"TLW" <tlw@.oceanlighthouse.com> wrote in message
news:eSomf6FKEHA.1760@.TK2MSFTNGP10.phx.gbl...
> 8.00.818, SP3, Standard Edition
> After installing SP3, the server hangs with Error: 17883, Severity: 0,
> State: 1. Process 0:0 (a04) UMS Context 0x105BB428 appears to be
> non-yielding on Scheduler 0.
> MS03-031 does not resolve this problem.
> Any suggestions?
>|||I'm having the same issue. I was able to discuss it with a MS
instructor at Sql Connections last week. He said the error is too
internal for troubleshooting other than by MS.
I have setup a black box trace and an alert. The alert will fire on
17883 stopping the black box trace and doing a dbcc stackdump. When
it happens again I'll open a ticket with Microsoft and send off the
files.