ActiveX Scripting Transform 'AxScriptXform' Was Not Able To Initialize

Aug 16, 2006

I was using the DTS Import/Export wizard and I went to edit the
vbscript that does the transformation. When I run the package I get an
error message --

ActiveX Scripting Transform 'AxScriptXform' was not able to initialize
the script execution engine.
Help appreciated.

Ian O'Neil.

View 4 Replies


ADVERTISEMENT

ActiveX Scripting Was Not Able To Initialize The Script Execution Engine

Aug 9, 2005

When I attempt to run my DTS Pkg that contains ActiveX task, I get following error:
"ActiveX Scripting was not able to initialize the script execution engine"
When I run this from another computer, it runs fine.
I have tried reregistrate DTS DLLs:
Regsvr32.exe "C:Program FilesMicrosoft SQL Server80ToolsBinnaxscphst.dll"
Regsvr32.exe "C:Program FilesMicrosoft SQL Server80ToolsBinndtspkg.dll"
Regsvr32.exe "C:Program FilesMicrosoft SQL Server80ToolsBinndtspump.dll"
But it does not help.
I am worried the great site for DTS issues "http://www.sqldts.com " is down :-(
Any ideas ?

My System:
Windows Server 2003 + SP1
MS SQL Srrver 2000 + SP4

I will appreciate any thoughts you have!

View 2 Replies View Related

Not Able To Initialize Scripting Engine

Nov 27, 2006

 

I have a DTS package that is running under SQL 2005 (64-bit Itanium).  It has a data driven query in it and I receive the following error:

ActiveX Scripting Transform 'DTSTransformation__1' was not able to initialize the script execution engine

I don't want to have to re-register any DLLs if I don't have to.  Shouldn't this work out of the box?

Any ideas?

View 2 Replies View Related

ActiveX Safe For Scripting

Jul 30, 2007

Can someone help

I create a activeX with c# .net 2005, and need that it be "safe for scripting", but I don't have examples for do it


help me please

thanks

View 1 Replies View Related

DTS - AxScriptXform Invalid Data Value

Dec 10, 2007

Hello,

I'm trying to migrate a table from Oracle over to SQL Server. About half way through the migration, I get an error saying Invalid Data Value for 'SERVICE_START_DATE' source.

I'm trying to locate the value in Oracle that is causing the error but I'm having trouble finding it.

This is the code I'm using for the transformation:

if isdate(DTSSource("SERVICE_START_DATE")) and DTSSource("SERVICE_START_DATE") > "1/1/2000" and DTSSource("SERVICE_START_DATE") < "1/1/2020" then
DTSDestination("SERVICE_START_DATE") = DTSSource("SERVICE_START_DATE")
else
DTSDestination("SERVICE_START_DATE") = Null
end if

I can add on error resume next to the code but I would like to find the culprit.

Thanks.

View 4 Replies View Related

Data Scripting Tool ( NOT DATABASE Scripting)

Mar 16, 2004

Hi to all
Is there any option in sql server DTS or any other third party tool that can script data. By scripting data i mean that....

if a table "Employee" contains 50 rows, i want the tool to write 50 insert queries for me so that i can run in it anywhere.

Problem is i have to insert data in a remote server where i cannot use DTS. I just have a text area to write my query and press the run button..

Hope u understand my problem. In case of any explanation please reply. Waiting for your response. Thanx in advance.

by to all

View 1 Replies View Related

Snap-in Failed To Initialize

Feb 19, 2008

When i try to open Sql Server Enterpris Manager the following error msg appers
Snap-in Failed to initialize
Name- unknown
CLSID{--}
 
how to solve this pbm help me very urgent

View 3 Replies View Related

How Initialize A Connection String In .Net

Feb 3, 2004

i am using a control that i downloaded from the control gallery It has a line for a connection string.

which i put on in there: data source=server;initial catalog=database;user id=blahblah;password=557896 and i get an error:

Exception Details: System.InvalidOperationException: The ConnectionString property has not been initialized.

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:


[InvalidOperationException: The ConnectionString property has not been initialized.]
System.Data.SqlClient.SqlConnection.Open() +433
Microsoft.Vote.VoteButtonClick(Object sender, EventArgs e) +289
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277


How would i initialize the connection string.


any help would be appreciated


alucke

View 1 Replies View Related

MMC Snap-in Failed To Initialize

Sep 16, 2004

I am getting this problem when I try to open a DTS package.

MMC: Snap-in Failed to Initialize: Name: Meta Data Services:
CLSID(xxxxxxxxxxx)

Have anyone encountered this problem?

Lystra

View 4 Replies View Related

Snap-im Failed Initialize

Jun 9, 2008

I have problem with sql server configuration tool. it can not be opened

View 3 Replies View Related

RS 2005 Initialize Greyed Out ???

Sep 13, 2006

HI There

I have installed Reportin Services 2005 , X64. I selected install but do not configure.

Afterwards i applied Service Pack 1 and ran all the hotfixes for sql components as per KB 918222.

The i launch the RS configuration manager i succesffuly setup Report Server/Manager Virtual DIrectory and servcie identity.

I then setup the database, i create a new database to the local 2005 instance i just installed with RS, the databse is created successfully.

Basically i have green ticks all the way, however Initialize is greyed out i cannot take the option to initialize the server ???

When i try to restart the RS service it says that the service failed to repond in a timely fashion, when i check the even log the servcie only started 10 minutes later, and there are no errors ?

WHen i go back to RS config manager , initialize is till greyed out , this is the last step i ahve to do but i cannot take the option ???

PLEASE HELP, Thanx

View 6 Replies View Related

How Can I Skip An Initialize Snapshot?

Jun 2, 2006

Hence you have a database which huge tables and a transactional replication (push subscriptions).

Now my question:

1. if I have to initialize a snapshot but I would like to do it without the snapshot agent, what methods are available?



2. Usually the distribution agent will request an initialize snapshot. How can I tell him, that I would like to use an alternative method and that the distribution agent should NOT request a snapshot?



3. Any suggestions about a good practive for materializing huge and big tables wihtout using the disitrbution agent (e.g. "switch off" replication, bcp table out of the primary site and bcp it into the target site, "start" distribution agent so that it doesn't request a snapshot).



Regards

Nobsay

View 6 Replies View Related

Reporting Services Won't Initialize

Feb 18, 2008

I have just completed a fresh install of SSRS 2005. Now, when I try to initialize it, it fails. I then try to delete any encrypted content and get the following error:




Code Snippet
ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted value for the "LogonCred" configuration setting cannot be decrypted. (rsFailedToDecryptConfigInformation)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()




From what I know, Reporting Services has never been installed on the machine in question. And if so, then haow can I get around this encrypted key issue?

Thanks!

View 6 Replies View Related

How To Initialize Package Variables?

May 2, 2007

I have a For Loop container where each iteration a Master record is inserted. I also have a number of package variables capturing rowcounts from the dataflow task. I later update the master record with the rowcounts. How do I initialize the package variables containing the rowcounts because currently, some of the rowcounts are being populated with rowcounts from another file.



thanks

View 3 Replies View Related

Report Server Does Not Initialize

Jun 25, 2006

I am using ms sql 2005 standard edition on windows Nt

Everything is working fine except the report server..

when i run the configuration tool and try to start the report server, it fails to start.. i am using sql on the local machine .

i have set p lmy database on the windows credentials..

i am using my machine name/user name as the account name for the database setup.

i have also used rsconfig utility to configure the report server but nothing happens after that..



pls help

View 5 Replies View Related

Initialize All Fields When Table Is Created

Sep 24, 2006

Is there a way to give fields or rows default data when the table is created?

View 1 Replies View Related

IDBInitialize::Initialize Returned 0x80004005

Jun 5, 2008

When executing the following SQL statement we get the error as message below:

INSERT INTO [dbo].[ProductImport] ([CustomerName], [AccountCode], [ProductCode], [Description1],
[Description2], [MaterialType], [Brand], [PGroup], [Type], [GSM], [Colour], [Size1], [Size2], [Microns],
[PriceQuantity], [PriceUnit], [Packed], [Price], [MinQuantity], [TonnePrice], [LeadTime], [WebURL])

SELECT [CustomerName], [AccountCode], [ProductCode], [Description1], [Description2], [MaterialType], [Brand],
[PGroup], [Type], [GSM], [Colour], [Size1], [Size2], [Microns], [PriceQuantity], [PriceUnit], [Packed], [Price],
[MinQuantity], [TonnePrice], [LeadTime], [WebURL]
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'
Text;Database=D:ApplicationsxxxxxxxxxAppRootxxxxxxxxxSQLCatalogues;HDR=YES', 'SELECT * FROM [product_test.csv]')
AS ImportFile WHERE [ImportFile].[MaterialType] IN (1, 2, 3, 4)


Error message
Server: Msg 7399, Level 16, State 1, Line 5
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Unspecified error]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ].



This is being run on
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
Windows 2003, build 3790.srv03_gdr.070301-2306


Have checked a number of knowledge base articles
C:Windowssystem32msjet40.dll version 4.0.8618.0

REGEDT32: HKEY_LOCAL_MACHINESOFTWAREODBC, Administrator/everyone full access

D:ApplicationsxxxxxxxxxAppRootxxxxxxxxxSQLCatalogues has full permissions for Administrator/everyone groups

Can anyone suggest the next step to identifying a possible cause to this issue.

View 3 Replies View Related

Replication Without Initialize Subscriptor With The Snapshot

Feb 1, 2007

Hello all,


I am developing a system using SQL Server replication between SQL Server EXPRESS 2005 clients and SQL Server 2005 servers. I initialize the replica databases with a script, then I do not want to initilize the subscriber with the snapshot; I configure each subscriber to "not initilize", but when I run the first synchronization the snapshot copy process is always is executed.

Maybe am I forgetting something? Can I use this SQL Server EXPRESS - SQL Server replication scheme without initialize the subscribers with the snapshot?
Thaks for reading!

View 5 Replies View Related

Merge Process Could Not Initialize The Subscription

Jul 19, 2007

I am experiencing some replication problems. I have a test server with a test database which has been working just fine with some simple Merge Replication. That old server is now been targeted for decommissioning. I have moved the test database to another test server and have set everything conceivable up the same as it was on the prior server but I am experiencing errors that I have not been able to resolve. I am using the same Domain User account with the same privileges on both systems...



The first error I receive in my SQL Server error logs is:



Message
Error: 14151, Severity: 18, State: 1.



Rapidly followed by the following error message:



Message
Replication-Replication Merge Subsystem: agent SOURCE-DATABASE-MERGE-DESTINATION-16 failed. The merge process could not initialize the subscription. Ensure that the subscription registration exists at the publisher, and reregister the subscription if necessary.



From within the Replication Monitor I look into the subscription and I can see the following error message:



Command attempted:

{call sys.sp_MSmergesubscribedb ('true', 0) }



Error messages:

The merge process could not initialize the subscription. Ensure that the subscription registration exists at the publisher, and reregister the subscription if necessary. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201011)
Get help: http://help/MSSQL_REPL-2147201011



INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods. (Source: MSSQLServer, Error number: 1934)
Get help: http://help/1934



I have looked into the help links from above, researched codes and also browsed this forum and others to no avail so far. Any help or suggestions would be greatly appreciated! THANKS!



View 5 Replies View Related

The Merge Process Could Not Initialize The Subscription.

Jul 25, 2007

I met some problems in merge replication with sql server 2005 (sp2).

one user who is using the PDA (SQL Mobile 2005) try to sync with server, the error info is coming.

the error in replication monitor is shown as following:
Error messages:
The merge process could not initialize the subscription. Ensure that the subscription registration exists at the publisher, and reregister the subscription if necessary. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201011)
Get help: http://help/MSSQL_REPL-2147201011
The subscription could not be found. (Source: MSSQLServer, Error number: 20021)
Get help: http://help/20021
The subscription has expired. Mark the subscription for reinitialization and restart the Merge Agent to reinitialize the subscription. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200980)
Get help: http://help/MSSQL_REPL-2147200980

is there anybody who has any idea about it?

View 1 Replies View Related

Initialize A Backup Device - Without Backing Anything Up To It

Sep 5, 2007

Is there a way to initialize a backup device without actually backing anything up to it?

This would make my backup code much simpler.

View 3 Replies View Related

Unable To Get Snapshot Agent To Initialize

Feb 20, 2006

I am unable to get my snapshot agent to initialize. When I start the "View Snapshot Agent Status" and press the Start button, it appears that the snapshot agent attempts to starts and then it doesn't.

I have configured the a distribution server and need to push a replication to another database, both can connect, etc.

I used the wizard to configure the distributon server and subscription server. I am using AdventureWorks, and am attempting to replicate a single small table.

View 4 Replies View Related

Unable To Initialize Report Server

Nov 13, 2006

View 1 Replies View Related

Initialize Pull Transaction From Backup

Feb 8, 2007

I'm trying to initialize a subscriber from a backup for a pull subscription. The publisher was started before the full backup was made. I followed the instructions @ Books Online topic "Initializing a Transactional Subscription Without a Snapshot" http://msdn2.microsoft.com/en-us/library/ms151705.aspx and How to: Initialize a Transactional Subscriber from a Backup (Replication Transact-SQL Programming) http://msdn2.microsoft.com/it-it/library/ms147834.aspx . I initialized the subscriber by restoring the db before I run the create subscriber scripts. All agents run successfully except for the following:

The network setup is that the publisher and the subscriber are in 2 different domains with the distribution database at the publisher. The subscriber agent is able to connect and run however the error on the subscriber side is:

"Agent message code 14080. The remote server "subscriber" does not exist, or has not been designated as a valid Publisher, or you may not have permission to see available Publishers."

The warning on the publisher side is in the Replication Monitor where in the status it says Uninitialized Subscription.

Any ideas on why it says it isn't initialized? Is there a StoredProc that I have to execute to initialize from backup?

View 5 Replies View Related

Initialize Error Connecting To SQL Server Database

Mar 8, 2006

    Newbie strikes again..   I'm attempting to connect to a SQL Server database (using VS 2005).  My code generated no errors in the build but when I tried to access the database, I got the following message:"The ConnectionString property has not been initialized."My connection string is stored in my web.config file.  My code goes as follows:Dim strSQL As String = "SQL string stored here"Dim objConnection as SqlConnection = New SQLConnection(ConfigurationManager.AppSettings("name of connection string is here"))Dim objCommand as SQLCommand = New SqlCommand(strSQL, objConnection)objConnection.Open()Then I go on to open my reader and such.  Where should I be initializing the ConnectionString property?TIA,Lesley

View 1 Replies View Related

Disk Space Required To Initialize Subscriber

Apr 30, 2008

Quick question- how much disk space is required on the subscriber to initialize a subscription (transactional replication) – does it have to copy the snapshot files (e.g. the bcp files etc) from the distributor, and then initialize the subscriber from this, or does it do this over the network?

Does it differ depending on whether it is push or pull?

Say I have a 10 GB snapshot on the distributor with a push subscription to the subscriber. Do I need 20 GB free on the subscriber? E.g. 10 GB to receive the snapshot files + 10 GB for the subscriber DB? Or just 10 GB for the subscriber DB which is initialized from the snapshot files over the network?

Thanks in advance for any help with this.

View 2 Replies View Related

Error Message: Failed To Initialize Distributed COM

Oct 13, 2006

Here is the full message from the Event Log.

Failed to initialize Distributed COM (CoInitializeEx returned 80010119). Heterogeneous queries and remote procedure calls are disabled. Check the DCOM configuration using Component Services in Control Panel.

Any ideas as to how to troubleshoot or solve this?

Thanks!

View 3 Replies View Related

'Invalid Authorization Specification' From IDBInitialize::Initialize (c++)

Nov 13, 2006

Hi

I've been trying to connect to my local SQL Server instance (SQL Server 2005) using the SQLNCLI interface from c++ without success. I consistently receive an 'Invalid authorization specification' error (SQL state 28000 and SQL error number 0) when I call IDBInitialize::Initialize to connect to the database. I was hoping someone here could shed some light on this and help me out.

The strange thing is that I get no error if I leave the user blank (L"" in vValue.bstrVal) and try to connect. Also, IDBProperties::SetProperties returns 0 when the user is blank but 40eda when the user is set. This seems to be a message from the pipeline facility but I haven't found the description of the code (0xeda).

The user in the database is configured with no password and I can successfully connect to the server and open the database using that user through Management Studio.

I've also tried using the SQLOLEDB provider with the same results.

Suspecting that I'm setting the properties wrong I include a code snippet below showing how I'm setting the properties:

for (int i = 0; i < sizeof(dbprop) / sizeof(dbprop[0]); i++)
VariantInit(&dbprop[ i ].vValue);

// Server name
dbprop[0].dwPropertyID = DBPROP_INIT_DATASOURCE;
dbprop[0].vValue.vt = VT_BSTR;
dbprop[0].vValue.bstrVal = SysAllocString(L"localhost");
dbprop[0].dwOptions = DBPROPOPTIONS_REQUIRED;
dbprop[0].colid = DB_NULLID;

// Database
dbprop[1].dwPropertyID = DBPROP_INIT_CATALOG;
dbprop[1].vValue.vt = VT_BSTR;
dbprop[1].vValue.bstrVal = SysAllocString(L"test");
dbprop[1].dwOptions = DBPROPOPTIONS_REQUIRED;
dbprop[1].colid = DB_NULLID;

// Username
dbprop[2].dwPropertyID = DBPROP_AUTH_INTEGRATED;
dbprop[2].vValue.vt = VT_BSTR;
dbprop[2].vValue.bstrVal = SysAllocString(L"jph");
dbprop[2].dwOptions = DBPROPOPTIONS_REQUIRED;
dbprop[2].colid = DB_NULLID;

Cheers,
JP

View 1 Replies View Related

Trouble Getting Snapshot Agent To Initialize Publication

Nov 16, 2006

I have been trying to set up transactional replication between an OLTP SQL Server 2005 Standard edition server and a BI SQL Server 2005 Enterprise edition server. I am using a pull subscription. I was able to establish the replication from the developement server to the BI server however when I tried setting up the replication between the production environment and the BI server, using the same configuration settings, I ran into a problem. The production server had been renamed after it was initially set up. I used the sp_dropserver and sp_addserver to solve this issue and was able to run the replication wizard. However once the wizard finishes the snapshot agent doesn't initialize the publication. When I look at the replication monitor it has a status of "never run". I try to run it manually and it appears to run for a few seconds then stops and still has the status of "never run". I don't get any error messages and can't find anything in the log. I am wondering if this is related to the server rename? I am hoping to find a soultion that doesn't involve uninstalling SQL Server and reinstalling since this is a production environment.

Thanks.

View 3 Replies View Related

Do I Really Need A Snapshot (to Initialize Transactional Replication, In SQL2000)?

Feb 20, 2006

I have a pretty big (350 gb) OLTP database that I want to replicate in its entirety. I'm concerned about the impact of taking a snapshot of it (it is processing at some level pretty much 24x7). I know on SQL2005 there is the option to initialize from backup, but unfortunately we won't be on 2005 in time.

I'm thinking of doing something like this:

Set up the distributor, publication, and subscription
Turn off distribution agent
Set the publisher to "sync with backup"
Backup the publisher, full then log
Truncate tables MSrepl_transactions and MSrepl_commands in the distribution db (I don't have any other replication going on)
Turn off "sync with backup"
Restore the full and tran log backups to new subscriber db
Create subscriber stored procs in subscriber
Start up distribution agent

I'm looking for opinions on whether it's worth going this route to avoid taking the snapshot. Data integrity is the number one priority -- if I have to do a snapshot to ensure that, I will do it.

Thanks in advance!

Mike

View 1 Replies View Related

Cannot Initialize The Data Source Object Of OLE DB Provider

Nov 21, 2007

When I try to run this SQL "Select * from [GGSyncCSV]...[MerchoMasterInfo#CSV]", I am getting the following error.

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "GGSyncCSV" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "GGSyncCSV".

The [GGSyncCSV] link server was created by following SQL statement a couple months ago.

EXEC master.dbo.sp_addlinkedserver @server = N'GGSyncCSV', @srvproduct=N'Jet 4.0', @provider=N'Microsoft.Jet.OLEDB.4.0', @datasrc=N'D:IntegrationGordonGotch', @provstr=N'Text'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'GGSyncCSV',@useself=N'False',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL

GO
EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'rpc', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'rpc out', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'use remote collation', @optvalue=N'true'

The SQL statement "Select * from [GGSyncCSV]...[MerchoMasterInfo#CSV]" always returns the content of the CSV file until 2 days ago.

I like to ask: is there anything that causes OLE DB provider "Microsoft.Jet.OLEDB.4.0" not working properly?

Any possible solution for this issue?

Thanks.

View 6 Replies View Related

Installation Issues - Failure To Initialize Application

Oct 16, 2007

When I try to install SQL server 2005 developer edition I get an error about:



Application popup: setup.exe - Application Error: The application failed to initialize properly (0xc0000005). Click on OK to terminate the application.



I have Cisco security agent and Symantec AntiVirus running on the machine, so they maybe interfering with the install. Unfortunately, I cannot shut them off.

Any ideas on what is causing the issue and how to verify that is the problem? Thx.

View 3 Replies View Related

Unable To Initialize Reporting Service After Installing SP2

Jul 12, 2007

hi, I have problem initialize report server after upgrade to SP2.. It keep saying Could not locate entry i sysdatabases 'myDatabaseName'. while i'm sure my database existing. Here's the log



<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3161.00</Product>
<Locale>en-US</Locale>
<TimeZone>Malay Peninsula Standard Time</TimeZone>
<Path>C:Program Files (x86)Microsoft SQL ServerMSSQL.2Reporting ServicesLogFilesReportServerService__07_12_2007_11_38_15.log</Path>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!resourceutilities!4!12/07/2007-11:38:15:: i INFO: Reporting Services starting SKU: Enterprise
ReportingServicesService!resourceutilities!4!12/07/2007-11:38:15:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!library!8!12/07/2007-11:38:16:: i INFO: Catalog SQL Server Edition = Enterprise
ReportingServicesService!library!8!12/07/2007-11:38:16:: i INFO: Current DB Version C.0.8.40, Instance Version C.0.8.54.
ReportingServicesService!library!8!12/07/2007-11:38:16:: i INFO: Starting upgrade DB version from C.0.8.40 to C.0.8.54.
ReportingServicesService!library!8!12/07/2007-11:38:16:: e ERROR: Exception caught while starting service. Error: System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'CCGM_'. No entry found with that name. Make sure that the name is entered correctly.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectDBVersion()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!8!12/07/2007-11:38:16:: e ERROR: Attempting to start service again...

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved