error handling flow: failed

Showing posts with label failed. Show all posts

Tuesday, March 27, 2012

Error installing SQL Server Developer 2005

I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
time I attempt to I get the error message:
"Failed to install and configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: MSDTC was unable to read its configuration information.
(Exception from HRESULT: 0x8004D027)"
Not only that, but in my Component Services->Distributed Transaction
Coordinator section, I get the following error message when trying to open
either the Transaction List or Transaction Statistics:
"Cannot open this folder because connection to the MSDTC service on 'My
Computer' failed."
Please help!
Thanks in advance,
Mervin Williams
Mervin Williams schrieb:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: MSDTC was unable to read its configuration information.
> (Exception from HRESULT: 0x8004D027)"
> Not only that, but in my Component Services->Distributed Transaction
> Coordinator section, I get the following error message when trying to open
> either the Transaction List or Transaction Statistics:
> "Cannot open this folder because connection to the MSDTC service on 'My
> Computer' failed."
>
Maybe MSDTC is not running. You can check this by going into cmd
and type "net start" <enter>. You should see a "distributed transaction
coordinator" service. If not maybe its starttype is "disabled" and you
should change it to "automatic".
hth
Gregor Stefka
|||Actually, I have no "Distributed Transaction Coordinator" service in my
Services applet. Why is this and how do I install it?
Thanks in advance,
Mervin Williams
"Gregor Stefka" <stefka@.zuehlke-bieker.de> wrote in message
news:egCWZ7zkHHA.4876@.TK2MSFTNGP03.phx.gbl...
> Mervin Williams schrieb:
> Maybe MSDTC is not running. You can check this by going into cmd
> and type "net start" <enter>. You should see a "distributed transaction
> coordinator" service. If not maybe its starttype is "disabled" and you
> should change it to "automatic".
> hth
> Gregor Stefka
|||Mervin Williams (mwilliams@.innovasolutions.net) writes:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
>
Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notifications
ervices.dll
> in the COM+ catalog. Error: -2146233087
Do you plan to work with Notification Services? Not that I want to
belittle it, but is not the most commonly used component of SQL Server.
So if you have no direct need of it, why not just skip installing it?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Error installing SQL Server Developer 2005

I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
time I attempt to I get the error message:
"Failed to install and configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: MSDTC was unable to read its configuration information.
(Exception from HRESULT: 0x8004D027)"
Not only that, but in my Component Services->Distributed Transaction
Coordinator section, I get the following error message when trying to open
either the Transaction List or Transaction Statistics:
"Cannot open this folder because connection to the MSDTC service on 'My
Computer' failed."
Please help!
Thanks in advance,
Mervin WilliamsMervin Williams schrieb:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: MSDTC was unable to read its configuration information.
> (Exception from HRESULT: 0x8004D027)"
> Not only that, but in my Component Services->Distributed Transaction
> Coordinator section, I get the following error message when trying to open
> either the Transaction List or Transaction Statistics:
> "Cannot open this folder because connection to the MSDTC service on 'My
> Computer' failed."
>
Maybe MSDTC is not running. You can check this by going into cmd
and type "net start" <enter>. You should see a "distributed transaction
coordinator" service. If not maybe its starttype is "disabled" and you
should change it to "automatic".
hth
Gregor Stefka|||Actually, I have no "Distributed Transaction Coordinator" service in my
Services applet. Why is this and how do I install it?
Thanks in advance,
Mervin Williams
"Gregor Stefka" <stefka@.zuehlke-bieker.de> wrote in message
news:egCWZ7zkHHA.4876@.TK2MSFTNGP03.phx.gbl...
> Mervin Williams schrieb:
>> I'm trying to install Microsoft SQL Server 2005 Developer Edition and
>> each
>> time I attempt to I get the error message:
>> "Failed to install and configure assemblies C:\Program Files\Microsoft
>> SQL
>> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll
>> in the COM+ catalog. Error: -2146233087
>> Error message: Unknown error 0x80131501
>> Error description: MSDTC was unable to read its configuration
>> information.
>> (Exception from HRESULT: 0x8004D027)"
>> Not only that, but in my Component Services->Distributed Transaction
>> Coordinator section, I get the following error message when trying to
>> open
>> either the Transaction List or Transaction Statistics:
>> "Cannot open this folder because connection to the MSDTC service on 'My
>> Computer' failed."
> Maybe MSDTC is not running. You can check this by going into cmd
> and type "net start" <enter>. You should see a "distributed transaction
> coordinator" service. If not maybe its starttype is "disabled" and you
> should change it to "automatic".
> hth
> Gregor Stefka|||Mervin Williams (mwilliams@.innovasolutions.net) writes:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
>
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notifications
ervices.dll
> in the COM+ catalog. Error: -2146233087
Do you plan to work with Notification Services? Not that I want to
belittle it, but is not the most commonly used component of SQL Server.
So if you have no direct need of it, why not just skip installing it?
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Error installing SQL Server Developer 2005

I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
time I attempt to I get the error message:
"Failed to install and configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notifications
ervices.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: MSDTC was unable to read its configuration information.
(Exception from HRESULT: 0x8004D027)"
Not only that, but in my Component Services->Distributed Transaction
Coordinator section, I get the following error message when trying to open
either the Transaction List or Transaction Statistics:
"Cannot open this folder because connection to the MSDTC service on 'My
Computer' failed."
Please help!
Thanks in advance,
Mervin WilliamsMervin Williams schrieb:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificatio
nservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: MSDTC was unable to read its configuration information.
> (Exception from HRESULT: 0x8004D027)"
> Not only that, but in my Component Services->Distributed Transaction
> Coordinator section, I get the following error message when trying to open
> either the Transaction List or Transaction Statistics:
> "Cannot open this folder because connection to the MSDTC service on 'My
> Computer' failed."
>
Maybe MSDTC is not running. You can check this by going into cmd
and type "net start" <enter>. You should see a "distributed transaction
coordinator" service. If not maybe its starttype is "disabled" and you
should change it to "automatic".
hth
Gregor Stefka|||Actually, I have no "Distributed Transaction Coordinator" service in my
Services applet. Why is this and how do I install it?
Thanks in advance,
Mervin Williams
"Gregor Stefka" <stefka@.zuehlke-bieker.de> wrote in message
news:egCWZ7zkHHA.4876@.TK2MSFTNGP03.phx.gbl...
> Mervin Williams schrieb:
> Maybe MSDTC is not running. You can check this by going into cmd
> and type "net start" <enter>. You should see a "distributed transaction
> coordinator" service. If not maybe its starttype is "disabled" and you
> should change it to "automatic".
> hth
> Gregor Stefka|||Mervin Williams (mwilliams@.innovasolutions.net) writes:
> I'm trying to install Microsoft SQL Server 2005 Developer Edition and each
> time I attempt to I get the error message:
> "Failed to install and configure assemblies C:\Program Files\Microsoft SQL
>
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notifications
ervices.dll
> in the COM+ catalog. Error: -2146233087
Do you plan to work with Notification Services? Not that I want to
belittle it, but is not the most commonly used component of SQL Server.
So if you have no direct need of it, why not just skip installing it?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Error installing sql server 2005 express edition

I am trying to install sql server 2005 express edition.But i get an error stating that

sql server setup unexpectedly failed. For more information review the detup summary log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\summary.txt

Summary.txt looks like this.It has only these 3 lines of information nothing else other this, which i have seen in many posts.

Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Home Edition Service Pack 2 (Build 2600)
Time : Tue Apr 03 22:36:33 2007

I am using windows xp. Probably many of you might have had this problem.Could anyone please provide me with some help.Thanks in advance.

Are there any files in the folder at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files? These are the detailed log files. If there are any files with similar date/time stamps as the summary.txt file, take a look at those to see if anything stands out.

Mike

|||

Thanks for your reply. There are 2 more folders (Files and Hotfix). under Files there was a file named

SQLSetup0025_ARUN_Core.txt. I am not sure what these files mean and there are few more files under Hotfix. Any suggestions?

Microsoft SQL Server 2005 Setup beginning at Tue Apr 03 22:36:33 2007
Process ID : 1932
d:\7733ee80231e45be08e36dd892bf84ea\setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/3/3 22:36:33
Complete: LoadResourcesAction at: 2007/3/3 22:36:33, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/3 22:36:33
Loaded DLL:\7733ee80231e45be08e36dd892bf84ea\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/3 22:36:33, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "1932"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/3/3 22:36:33
Complete: ValidateWinNTAction at: 2007/3/3 22:36:33, returned true
Running: ValidateMinOSAction at: 2007/3/3 22:36:33
Complete: ValidateMinOSAction at: 2007/3/3 22:36:33, returned true
Running: PerformSCCAction at: 2007/3/3 22:36:33
Complete: PerformSCCAction at: 2007/3/3 22:36:33, returned true
Running: ActivateLoggingAction at: 2007/3/3 22:36:33
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
00E5CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "1932"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

Thanks,
Arun

|||

Hi Arun,

It looks like the CryptoAPI is failing, check out this post and look at the answer from Jeffery.

Mike

sql

Monday, March 26, 2012

Error Installing Service Pack 1

Hi all,
I tried to upgrade a clients site to Sp1 and got the following error:
"SQL Setup failed to connect to the database service for server
configuration. Refer to the Server error logs and setup logs for more
detailed error information."
I was just wondering if anyone else has come across this error and know any
ways to fix it?
Also does the account I am logged onto (or Term Served into) the box with
require access to the Configuration Database or the Database Server?
And I can't find any documentation on what security level is required for
applying the Service Pack ie. SQL System Administrator or just DBO of the
config database?
Thanks in advance.
Angus LoganJust like the original setup, the service pack uses integrated security to
update the ReportServer database. You need to have dbo privileges to the
database on the machine where setup is being run.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Angus Logan" <angus_logan@.data3.com.au> wrote in message
news:ebzCsMeWEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I tried to upgrade a clients site to Sp1 and got the following error:
> "SQL Setup failed to connect to the database service for server
> configuration. Refer to the Server error logs and setup logs for more
> detailed error information."
> I was just wondering if anyone else has come across this error and know
> any
> ways to fix it?
> Also does the account I am logged onto (or Term Served into) the box with
> require access to the Configuration Database or the Database Server?
> And I can't find any documentation on what security level is required for
> applying the Service Pack ie. SQL System Administrator or just DBO of the
> config database?
> Thanks in advance.
> Angus Logan
>

Monday, March 19, 2012

Error in Report Server Registration

TITLE: New Server Registration

Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.

The request failed with the error message:

<html>

<head>

<title>

SQL Server Reporting Services

</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />

at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)

at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)

at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)

at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()

at Microsoft.ReportingServices.WebServer.Global.StartApp()

at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />

<style>

BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}

H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}

LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}

.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}

A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}

A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}

A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}

A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

</style>

</head><body bgcolor="white">

<h1>

Reporting Services Error<hr width="100%" size="1" color="silver" />

</h1><ul>

<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>

<li>Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>

</ul>

</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>

</body>

</html>

--. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

Do you have permissions to the path listed in the error messages? And does the log file listed give any more info?

<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li>

<li>Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>

Thanks,
Sam Lester (MSFT)

|||

I added http://localhost to Trusted Sites as recommended elsewhere.

Log On As is set to NT AUTHORITY\NetworkService

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>Alaskan Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerService__09_01_2006_10_58_14.log</Path>
<SystemName>DTC0900B6FAD685</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!configmanager!4!9/1/2006-10:58:15:: w WARN: WebServiceAccount is not specified in the config file. Using default: DTC0900B6FAD685\ASPNET
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-10:58:15:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!resourceutilities!4!9/1/2006-10:58:15:: i INFO: Reporting Services starting SKU: Express
ReportingServicesService!resourceutilities!4!9/1/2006-10:58:15:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!resourceutilities!4!9/1/2006-10:58:15:: i INFO: Running on 1 physical processors, 1 logical processors
ReportingServicesService!runningjobs!4!9/1/2006-10:58:15:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
ReportingServicesService!runningjobs!4!9/1/2006-10:58:15:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!9/1/2006-10:58:15:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!9/1/2006-10:58:15:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 54104 seconds. Cycle: 86400 seconds
ReportingServicesService!runningjobs!4!9/1/2006-10:58:15:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!9/1/2006-10:58:15:: i INFO: SQM timer timer enabled: Next Event: 57704 seconds. Cycle: 86400 seconds
ReportingServicesService!library!8!9/1/2006-10:58:17:: i INFO: Catalog SQL Server Edition = Express
ReportingServicesService!crypto!8!9/1/2006-10:58:18:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
ReportingServicesService!crypto!8!9/1/2006-10:58:18:: i INFO: Exporting public key
ReportingServicesService!crypto!8!9/1/2006-10:58:18:: i INFO: Performing sku validation
ReportingServicesService!crypto!8!9/1/2006-10:58:18:: i INFO: Importing existing encryption key
ReportingServicesService!configmanager!8!9/1/2006-10:58:18:: w WARN: Restricted feature: Scheduling
ReportingServicesService!configmanager!8!9/1/2006-10:58:18:: w WARN: Restricted feature: Delivery
ReportingServicesService!configmanager!8!9/1/2006-10:58:18:: w WARN: Restricted feature: Scheduling
ReportingServicesService!dbpolling!8!09/01/2006-10:58:18:: UpgradePolling polling service started
ReportingServicesService!dbpolling!a!9/1/2006-10:58:18:: Polling started

Here is the other log file:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>Alaskan Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerService__main_09_01_2006_09_56_29.log</Path>
<SystemName>DTC0900B6FAD685</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!configmanager!4!9/1/2006-09:56:35:: w WARN: WebServiceAccount is not specified in the config file. Using default: DTC0900B6FAD685\ASPNET
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!servicecontroller!9!9/1/2006-09:56:37:: Total Physical memory: 535707648
ReportingServicesService!servicecontroller!4!9/1/2006-09:56:37:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSSQL.3'

|||I had to load the express version with advanced stuff and now it is working . Thanks for your response.

Error in Report Server Registration

TITLE: New Server Registration

Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.

The request failed with the error message:

<html>

<head>

<title>

SQL Server Reporting Services

</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />

at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)

at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)

at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)

at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()

at Microsoft.ReportingServices.WebServer.Global.StartApp()

at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />

<style>

BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}

H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}

LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}

.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}

A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}

A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}

A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}

A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

</style>

</head><body bgcolor="white">

<h1>

Reporting Services Error<hr width="100%" size="1" color="silver" />

</h1><ul>

<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>

<li>Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>

</ul>

</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>

</body>

</html>

--. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

Do you have permissions to the path listed in the error messages? And does the log file listed give any more info?

<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li>

<li>Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>

Thanks,
Sam Lester (MSFT)

|||

I added http://localhost to Trusted Sites as recommended elsewhere.

Log On As is set to NT AUTHORITY\NetworkService

Here is the other log file:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>Alaskan Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerService__main_09_01_2006_09_56_29.log</Path>
<SystemName>DTC0900B6FAD685</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!configmanager!4!9/1/2006-09:56:35:: w WARN: WebServiceAccount is not specified in the config file. Using default: DTC0900B6FAD685\ASPNET
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!9/1/2006-09:56:35:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!servicecontroller!9!9/1/2006-09:56:37:: Total Physical memory: 535707648
ReportingServicesService!servicecontroller!4!9/1/2006-09:56:37:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSSQL.3'

|||I had to load the express version with advanced stuff and now it is working . Thanks for your response.

Sunday, March 11, 2012

Error in Replication how to continue

I have transactional Replication from A to B.

My distribution agent failed becos of a primary key violation error in a table.[i have not included the skip error option].

Then the replication stopped.
The transactions on other tables are also not replicated to B.

IF an error is encountered in one of the tables will the replication stop entirely??.Is there no way for the replication to continue for the rest of the tables..
Pls clarifyI don't think you can skip this error. To use Replication you have to have a primary key in the table you want to replicate.|||The transactions are processed in a serialized fashion, meaning that if one failed nothing else goes through.

Sunday, February 26, 2012

Error in DTS

Hi When I try to convert from Prervasive V8 to SQL using an ODBC connection. I receive the error message..

ParseDisplayName failed: The specified module could not be found.

Could anyone advise what this error is? And/Or how it could be resloved. This is happing when I press actualy try to convert. The wizard will go to that point then stop.

Thanks!

DTS or SSIS? This is an SSIS forum. For DTS questions, please visit:

http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg

Error in Derived Column component

I am getting this error,

[Derived Column [192]] Error: Converting an input column from type DT_STR to type DT_WSTR failed. An error occurred while performing the implicit conversion on the input column.

But I don really understand y there is a attempt to type cast at all ?

Please advise ....

thanks in advance

The expression evaluator almost always implicitly converts DT_STR columns to DT_WSTR, because all string functions are implemented for Unicode only. There are only a couple very specific exceptions.

You might try to putting a data conversion transform in your flow and doing an explicit convert from DT_STR to DT_WSTR for that column and see if you get a more helpful error message. Or, redirect that row to an error output, and inspect the data and post it here.

Thanks
Mark

|||

Mark Durley wrote:

You might try to putting a data conversion transform in your flow and doing an explicit convert from DT_STR to DT_WSTR for that column and see if you get a more helpful error message.

I thought of this earlier and when I tried with a Data Conversion Component, I was not able to locate an option as DT_WSTR. Am I missing something here?

thanks for the Help so far...

|||

In the Data Conversion transform UI, in the Data Type drop down, you should see an option:

Unicode string [DT_WSTR]

Mark

|||

In the column marked Data Type in your Derived Column Shape change the value from Unicode [DT_WSTR] to string [DT_STR]

Does this answer your question?

|||Thx for the reply :)

Tuesday, March 27, 2012

Error installing SQL Server Developer 2005

Error installing SQL Server Developer 2005

Error installing SQL Server Developer 2005

Error installing SQL Server Developer 2005

Error installing SQL Server Developer 2005

Error installing SQL Server Developer 2005

Error installing sql server 2005 express edition

Monday, March 26, 2012

Error Installing Service Pack 1

Monday, March 19, 2012

Error in Report Server Registration

Error in Report Server Registration

Sunday, March 11, 2012

Error in Replication how to continue

Sunday, February 26, 2012

Error in DTS

Error in Derived Column component

error handling flow

Blog Archive

About Me