Application Compatibility Toolkit V5.0 -- Database ISSUE --

Apr 9, 2008

Hello,

In topic http://forums.microsoft.com/TechNet/showpost.aspx?postid=3143663&siteid=17 I have mentioned a problem I have. I was told that this forum is a better place to ask for a solution.

The problem I have:

On a fresh installed Windows 2003 R2 with SP2 (x86) I have installed ACT 5.0.5428.1056. The installation went well but no data is transferred from the ACT Share to the database. All the data is moved to the 'Failed' folder. On the same server MS SQL Server 2005 with SP2 has been installed successfully.

In the eventvwr I see the following error messages:

Source: ACTUpload
Categorie: NONE
EventID: 0


ACTUPLOAD: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms.

at System.Security.Cryptography.MD5CryptoServiceProvider..ctor()

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle._InvokeConstructor(Object[] args, SignatureStruct& signature, IntPtr declaringType)

at System.RuntimeMethodHandle.InvokeConstructor(Object[] args, SignatureStruct signature, RuntimeTypeHandle declaringType)

at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

at System.Security.Cryptography.CryptoConfig.CreateFromName(String name, Object[] args)

at System.Security.Cryptography.MD5.Create(String algName)

at System.Security.Cryptography.MD5.Create()

at Microsoft.ApplicationExperience.Common.DataManipulation.HashGenHelper..ctor(ObjectContext existingContext)

at Microsoft.ApplicationExperience.Common.DataManipulation.XmlDataProcessor..ctor(String inputConnection, EventLog actLog, XmlSchemaCollection schemaCollection, ObjectContext objectContext)

at Microsoft.ApplicationExperience.Common.DataManipulation.XmlDataService.InsertXmlDocument(String xmlFile, Boolean checkVersion)

at Microsoft.ApplicationExperience.Common.DataManipulation.XmlDataService.InsertXmlDocument(String xmlFile)



Source: ACTUpload
Categorie: None
EventID: 0


ACTUPLOAD: FAILED LOG: \SPNLAPP90125ACT_LogFilesSTATUS-WPNLL9000812{8C869987-5D71-4DD2-9893-7405B274E13C}.xml

PREVIOUS LOG:


Source: ACT-LPS
Categorie: None
EventID: 1017


[queuer.exe] [Queuer] Cannot insert log file \SPNLAPP90125ACT_LogFilesSTATUS-WPNLL9000812{8C869987-5D71-4DD2-9893-7405B274E13C}.xml to the database! Details:



The Act Log Processing Service is running with the logon as a service account. This account is local admin on the ACT-server. Also this account has 'db-owner', db-datareader' and 'db-datawriter' rights on the ACT-database.

Other installed software:
- Dot Net 1.1
- Dot Net 2.0
MS SQL Server 2005 Details:
MS SQL Server 2005: Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 7.0.5730.13
Microsoft .NET Framework 2.0.50727.832
Operating System 5.2.3790

---> My question is: what do I have to do to get this running?

Your help is appreciated.

With kind regards,
Willem

View 4 Replies


ADVERTISEMENT

Compatibility Between 70 And Landmark Application(DIMS)

Jun 22, 2000

hi,
Any one knows about LAndmark application DIMS....
we are having DIMS application with SQL 65, Now we are planning to upgrade our sql 65 to 70, somebody said DIMS application is not compatible to SQL 70,
any suggestions or Clues..which i can find or get the solution.
Landmark --DIms is useful for OIL industry...

thank u
Ram

View 1 Replies View Related

SQL Express Compatibility Testing On Vista Using Application Verifier

Feb 9, 2007



I tested my program (written in VB.Net VS 2005/.Net Framework 2.0 with db SQL Express) using Application Verifier for Vista Compatibility and I got this error :

avrf:logEntry Time="2007-02-09 : 14:53:33" LayerName="LuaPriv" StopCode="0x331B" Severity="Error">


<avrf:message>Access was restricted to trusted users only.</avrf:message>

<avrf:formatmessage>CreateFileA: File (DeviceNamedPipeSQLLocalSQLEXPRESS) only grants requested 'FILE_APPEND_DATA' to 'NT AUTHORITYNETWORK SERVICE'</avrf:formatmessage>

<avrf:parameter1>3d1160 - Object Type</avrf:parameter1>

<avrf:parameter2>23b2fa8 - Object Name</avrf:parameter2>

<avrf:parameter3>3d294c - Access Mask</avrf:parameter3>

<avrf:parameter4>23b6fc0 - String SID</avrf:parameter4>

- <avrf:stackTrace>


<avrf:trace>vfluapriv!NS_LuaPriv::LogRestrictedRightEntry+3f</avrf:trace>

<avrf:trace>vfluapriv!NS_LuaPriv::LogRestrictedRight+154</avrf:trace>

<avrf:trace>vfluapriv!NS_LuaPriv::AnalyzeLuaPermission+178</avrf:trace>

<avrf:trace>vfluapriv!NS_LuaPriv::AnalyzeLuaSecurity+ae</avrf:trace>

<avrf:trace>vfluapriv!NS_LuaPriv::CheckLuaAccess+35</avrf:trace>

<avrf:trace>vfluapriv!NS_LuaPriv::CheckSecurityOnOpenObject+b3</avrf:trace>

<avrf:trace>vfluapriv!NS_LuaPriv::VfHookCreateFileA+148</avrf:trace>

<avrf:trace>System.Data!+64ff2273</avrf:trace>

<avrf:trace>System.Data!+64ff2663</avrf:trace>

<avrf:trace>System.Data!+64ff7be8</avrf:trace>
</avrf:stackTrace>
</avrf:logEntry>

How can I resolve this problem? (Is the problem in the area of Named Pipe?)

Thanks in advance.

View 3 Replies View Related

Database Compatibility Level

Feb 20, 2001

Hi!
After upgrading SQL Server from 6.5 to 7.0 my production database compatibility level is "65".
I checked that by executing sp_dbcmptlevel <database_name>.
I can change it to "70" but my question is how it's going to affect the application and do I have to change it?

Thank you

Lena

View 2 Replies View Related

Sp_executesql And Database Compatibility Levels

Apr 15, 2003

I have captured some trace output for performance evaluation for an application which has just been upgraded. Originally, this application can only run with database compatible 70.

So, after we have switched this level from 70 to 80, I noticed that all T-SQL statements which executed thru the use of "sp_executesql" have much higher IO usuage. The usage increased from approximately 50 I/O to approximately 12000 I/O. When I reviewed the profiler output, I noticed that all select statements which executed thru this "sp_executesql" statements performed "index scan".

When I switch back to run with database compatibility level 70, my profiler output shows that all these "sp_executesql" statements performed "index seek".

All these statements use the same unique non-clustered index.

Is it a SQL Server bug? Does anyone know which service pack or hot fix address this problem?

Thanks...byyu :)

View 7 Replies View Related

Database Settings Or SQL2K Compatibility ?

Jul 17, 2002

Hi,

I just upgraded to SQl Server 2000 from 7, and realized that all my reports created with existing scripts no longer work fine. The reports appear corrupt. Below is an example of a report script:

declare @vSubject varchar(30),
@vMessage varchar(20)
Begin

Select @vSubject = 'Report as of :' + convert(varchar,getdate()-1,1)
Select @vMessage = 'Automatic Report'
EXEC xp_sendmail @recipients = 'Bob',
@query = "FetchEmailData",
@attachments = 'DailyReport.wri',
@subject = @vSubject,
@message = @vMessage,
@attach_results = 'TRUE',@width = 250
End

The DailyReport.wri file appears corrupt when opened with notepad. The same happens to .xls reports too.

Are there settings I need to change or is this a SQL2K issue ?. Any suggestions/help would be appreciated. SQL Server 2000 runs on Windows 2000 Adv.

Thanks.

View 1 Replies View Related

Database Compatibility Mode - When To Change???

Sep 14, 2004

I have been migrating Databases from a SQL Server 7.0 Instance to a 2000 Instance. Basically the method I use is as follows:

a)Create a new Database on the Destination Server (same name as the Source) When I create the new Database on my destination server, the compatibility mode is '80' and the source is always '70'

b) do a 'revlogin' on the Source Server and use the output from that query to recreate the logins on the destination server

c) make sure that the default DB for the newly creates logins are correct and change them if necessary

d) Backup the DB on the Source Server and Restore it to the Destination Server.

e) Check login permissions and fix any orphaned users - usually I don't find any that need to be fixed, but I always check.

I've read BOL on Changing the compatibility mode on the Database... but I'm still unsure when I would have to do this and why???????????????? SHOULD I be changing the compatiblity mode from 80 to 70 when migrating Databases from 7.0 to 2000???? Any advice on moving DBs in this manner would be appreciated.

View 2 Replies View Related

Programmatically Checking The Database Compatibility Level?

Jun 28, 2006

When my app starts up I want to ensure that the database compatibility level has been set to 90. I know about sp_dbcmptlevel, but that only seems to work in an interactive session; the documentation says it can't be used in a stored procedure, and that appears to be true. Does anyone know how I could read the database compatibility level in a stored proc?

View 3 Replies View Related

Down Time To Switch Compatibility Level On Large Database?

Aug 4, 2015

We have a reasonably large (several TB) database that was recently migrated from 2008 to a new box running 2014.  Before giving it back to the users we forgot to change the compatibility level of the DB to bring it up to date with it's new environment.

We want to do some testing with backup compression so want to change the compatibility level, but we are unsure whether making the change on such a large database would cause slowness or downtime for our users.

Does the process of changing the compatibility level simply allow options that are not available in the older version or does it make structural changes to the database that would cause the users to notice slowness or downtime?

View 7 Replies View Related

Running SQL 2005 Database On 80 Compatibility Mode And DTS Import

Mar 11, 2008



Hi,

We are planning to upgrage our SS 2000 databases(couple of hundreds) to SS 2005.

To minimise the potential work arounds, it is agreed to have complex databases, continue running on compatibility mode 80. What are the potential impact of having database on mode 80(apart from not being able to use new feature)on SS2005?

Fruther how we can we import SS 2000 DTSs to SS 2005 SSIS in an cluster environment?

Thanks,
Sajish


View 2 Replies View Related

How To Assess Impact Of Changing Database Compatibility Level

Aug 28, 2006

I noticed that a database I am working with has a compatibility level set to SQL Server 2000. The instance is actually SQL Server 2005. I'm guessing that it was created like this because the database originally existed on 2000 and was created via backup/restore.

I'm trying to figure out if this needs to be changed and if so how to go about making the change in a non-disruptive manner. What features of 2005 are turned off as a reult of having a 2000 compatibility level?

View 4 Replies View Related

MSSQL 2005: Backward Compatibility Problem With Database Owner

Nov 25, 2005

Hello all,i'm moving all my development to the new 2005/Fw2 environment.Now, i have an MSSQL 2005 server on the development server. To restore an existing database, i've created a new database with MSSQL 2000 compatibility level, and i've restored the backup over it. Everything seems ok, but when i try to create a diagram, i get the following error message:"Database diagram support objects cannot be installed because the database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."I've checked the properties and there seems to be the right owner (sa). If i create a new database with 2005 compatibility level, everithing works fine.Where is the problem?Also, a side question: by setting compatibility level to 2000, is it correct that the database can be deployed to a 2000 Server environment with no problems?Thanks in advance for any advice. -LV

View 4 Replies View Related

Missing Compatibility Level Sql Server 2005(90) In Database Properties Options

Jul 13, 2007

I installed SQL Server 2005 Developer Edition. When i create a new database (using the "New Database" dialog) i cannot set the new database's compatibility level to "SQL Server 2005(90)" because this option is not in the "dropdown list". the only items shown are: "SQL Server 7.0(70)" and "SQL Server 2000(80)". I set the owner to "sa". How do i get "SQL Server 2005(90)" in my "compatibility level" drop down list? Is this an installation option that i missed? Thanks in advance for any assistance!

-chris

View 12 Replies View Related

SQL2005 SP2 IA64 Fails Installing Database And Backward Compatibility Components.

Aug 30, 2007



Hi, pls can anyone help me out with this? I'm installing SQL2005 SP2 over an Itanium machine with W2003 SP2 but it keeps on failing on those features. Client components got installed with no problems. I've installed SQL2005-SP2 over x86 and x64 (not Itanium) machines many times before successfuly. I've been investigating this issue for several days with no luck so I'm a bit clueless at the moment. As I'm using Administrator account I think it is not file permission related.
Summary says "Unable to install Windows Installer MSP file".

let me know if further info is nedeed.

Many thanks.



View 3 Replies View Related

Cannot Install Toolkit.

Jan 3, 2007

Trying to install SQL Everywhere Beta Toolkit. And am getting following error message:

"The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program.
The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade path."

On difference is I'm installing on top of the "recently released" verision of VS2005 SP1, not the beta.

But, other than that, all the prereqs are installed.

Any insight on suggestions would be greatly appreciated.

Thanks
Rob Vettor

View 1 Replies View Related

SQL 2005 Express ToolKit

Sep 12, 2007

 I can not install the tool kit and I am not getting any
information in a log.  Also I would like to know where I can get
information for importing a database downloaded from Microsoft into my
sql 2005 express database.  Is there also a way to import using
scripts.  Is there a way to do this the same as you would with
mysql manager? Thanks for any and all help provided.Dee 

View 3 Replies View Related

SQL 2205 Server ToolKit

Sep 15, 2007

 I am having problems installing the SQL 2005 Server
ToolKit.  Are there any prerequisites for doing this
install?  How can I look at a log?  It just tells me there
are no items to update, however I notice that some of my applications
are greyed out, like business Intelligence. ThanksDee 

View 1 Replies View Related

Installing Express Toolkit

Aug 7, 2007

Hello

I have SQL Express with Advance report tools installed. I have download the express toolkit to use the Business Intelligence, however after I have installed the add on, when ever I select the Musiness Intelligence Management Studio I have a browser looking for the file Devenv.exe file and a reinstall is not working.

Can anyone help with this?

View 4 Replies View Related

Not Able To Install Sqlserver Express Toolkit.

Nov 9, 2007



All the Componets are grayed out disabled and not available to proceed further while installing.
All of them have a red cross mark on it saying "Unavailable"

I actually wanted to instal Reporting services component and related services in my machine

Note : MY database server(sqlserver 2005) is connected to this report server(above) by LAN.

Could you please let me know where and how I could install Reporting services

Thanking you in anticipation
Srinivas

View 1 Replies View Related

Install SQL Server 2005 Exp With ToolKit

Nov 7, 2006

Hi,

I would like to have SQL Server 2005 Express with the most features as possibles. It seems to be correct about 'AdvancedEdition' but, when I installed the "ToolkitEdition", in order to get "Business Intelligence Development Studio", I was not able to open this option. The file 'devenv.exe' is missed.

Do you have some procedure and links to get best set up with theses features for SQL Server 2005 Express?

Thanks.

View 12 Replies View Related

SQL Advanced Toolkit - Full-text Feature

Mar 6, 2007

Hi I have installed SQL Server 2005 Enterprise Edition on my laptop and get the following version:

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)

I know that it cannot install the enterprise version on my OS, but I would like the full-text feature. Therefore I downloaded the SQL Server Express Toolkit and selected to install the full-text feature.

BUt...I still do not have the full-text feature installed. Any ideas why not??? can my version of SQL support it? if not, how do I get my way around this?

My OS is Windows XP Professional Version 2002 SP2

View 5 Replies View Related

Microsoft Sql Express 2005 Edition Toolkit

Mar 11, 2008

I am using Microsoft SQL Server 2005 Express Edition. I have also downloaded the Sql Server Express toolkit from the Microsoft site in order to get access to the server's Reporting Services. The toolkit, according to Microsoft, should have included a cut-down version of the Business Intelligence Development Studio. The problem is that after downloding and installing I cant find Business Intelligence development Studio. The shortcut in the start menu brings me to Visual Studio 2005 and not to Business Intelligence Development Studio. Am I missing something?

View 1 Replies View Related

NEED HELP!!! Unknown Error In SQL 2005 Express Toolkit

Mar 7, 2007

I am encountering this error when tried to execute a simple select statement against the Enterprise Edition SQL 2000 and SQl2005

An error occurred while executing batch. Error message is: Unknown error "-1".

 Please advise what is the cause of this.

Thanks.

View 13 Replies View Related

Unable To Install SQL Express 2005 Toolkit Sp2

Apr 12, 2008

Hi support

I have a copy of Visual studio 2008, SQL Express advanced 2005 sp2 and i want to install SQL Express 2005 toolkit 2005.

I have run the install several times and each time the installer thinks i've already installed the software and refers me back to add/remove to modify the install.

According to my registry i have installed the toolkit ..90/tools/setup/editiontype ( = Express Edition Toolkit) but the Business Intelligence Development Studio options haven't installed along with all the other options offered under the toolkit sp2, as i can't see them as an option to select from the start/all programs/microsoft sql server 2005.

Also for some reason there is no options to uninstall the toolkit, which again means i have no way of reinstalling the software.

Please help

Damian

View 1 Replies View Related

Which Edition To Buy?(The Data Warehouse Toolkit By Ralph Kimball)

Apr 1, 2004

I would like to buy the book "The Data Warehouse Toolkit by Ralph Kimball" but unfortunately only the 1st edition is currently available over here and they say that it will take at least 6 weeks if I want to order the 2nd edition.

Can someone please guide if there are MAJOR differences between the 1st and the 2nd edition of this book? If not, then what are the differences if any.

I'll appreciate your reply.

View 2 Replies View Related

Where Is The Toolkit Software For SQL Server 2008 Express Edition CTP?

May 5, 2008



Is there a Business Intelligence Development Studio, Management Studio Express for SQL Express 2008 CTP?

If so where can I find this software.

Willie

View 5 Replies View Related

Where To Download SQL Server 2005 Metadata Samples Toolkit?

Mar 17, 2008

Hi,
Can someone tell me where I can download the "SQL Server 2005 BI Metadata Samples toolkit"? Seems the old ulr doesn't work right now.

Thanks in advance.

Mike

View 5 Replies View Related

Need Help Installing SQL Server 2005 Express Edition Toolkit SP1

Sep 13, 2006



hi,

I have SQL Server Express edition installed on my PC , but now I need to use SQL Server reporting service, there is SP1 for express edition contains reporting service with express edition. Here..

http://msdn.microsoft.com/vstudio/express/sql/download/

Do I need to download 213 MB SQL Server 2005 Express Edition Toolkit SP1 ?

or there is any other method to use reporting services ?



Thanks

View 1 Replies View Related

Business Intelligence Development Studio Not Installing From Toolkit

Jun 13, 2006

Everytime I went throught the express Toolkit install and I chose, all components, it just responded with "nothing to do."

I installed the BIDS by just executing vs_setup.msi. as mentioned above.

This seems to have worked partially. Visual Studio is now there.

However, no templates are available except "Blank Solution"

The case seems some Report Builder/Model Builder templates should exist?

What am I doing wrong?

What can I do to fix the problem?

Where can I find the "report building templates?"

Thanks.

AIMDBA



View 11 Replies View Related

SQL Server 2005 Express Toolkit &&amp; Reporting Services

Dec 27, 2006

Hi,
I had previously installed SQL Server 2005 Express edition (and later, SQl Server Management studio express). Recently, I wanted to try out 'Reporting services' and downloaded 'SQL server 2005 express Toolkit'.
After installation, I have a new program group 'Visual studio 2005' . I started that with 'New Report Project'. I tried to attach an existing database (to be precise, in 'connection string' part) , but it is giving error saying

'An error has occured while establishing connection to Server. When connecting to SQL Server 2005 (???) ,..... may be caused the fact that under default setting SQL Server does not allow remote connections '

I tried my existing SQL Server 2005 express edition Surface Area Configuration and it is configured for accepting remote connection using both TCP/IP & named pipes.

Now, I have following doubts:
1. Do I have to download & install SQL Server 2005 Express edition wiht Advanced options, if I wish to use Reporting services or I can use the existing SS2005EE along with Toolkit services?
2. If answer is yes to above question, how do I attach a database?

If you can throw some light on above, I shall be very grateful to you.

Thanks & regards,
Sathya

View 4 Replies View Related

Database Compatibility Between Sql 2005 Standard V/s Sql 2005 64 Bit

Jul 24, 2006

I am a newbie developing a web site. My local machine has sql 2005 standard edition on it. The host that I am trying to use only has sql 2005 64 bit version.

would I be able to do the use the same database between the two ( i.e. once my site is running at host, would I be able to download the database on my local machine, make changes to my site and then upload again on the hose without any glitches?). In addition, how about sql express doing the same with sql 2005 64 bit.

Thanks a lot for taking time to read the post.

View 1 Replies View Related

Can't Start SS Business Intelligence Installed From SS 2005 Express Edition Toolkit

Apr 22, 2006

I downloaded and installed Microsoft SQL Server 2005 Express Edition with Advanced Services and Microsoft SQL Server 2005 Express Edition Toolkit. Installs completed successfully, and I can launch the SS Management Studio, but when I launch SS Business Intelligence Development Studio, I get message saying "Windows is searching for devenv.exe". When I search for this file I don't find it on my hard drive.

I thought I'd reinstall the SS Express Edition Toolkit, but I can't find this application in the Control Panel Installed Programs list, so I can't uninstall it.

Any ideas as to how I can get SS Business Intelligence Studio working?





View 11 Replies View Related

64 Bit Install Problems - Management Studio Expr &&amp; Advanced Services &&amp; Toolkit

Jun 2, 2008

Hi folks

I have a 64 bit Vista Home Premium PC SP1.

I downloaded and attempted to install the 64 bit version of SQL Express and I then got an error message to do with the ASP.NET Version registration requirement.

I then noticed a similar problem somebody else had & they solved it by doing the install/download as part of the Visual web Developer Expr installation - so I did the same. It seemed to work without any problems.

I had previously downloaded the 64 bit Management Studio Expr file, so after installing SQL server I attempted to install the management Studio program. Anyhow after starting the install program, I discovered that the instructions were either in Japanese or Chinese.

On the download page for SQL Server Express http://www.microsoft.com/express/sql/download/default.aspx, Under section 3 on the RHS it talks about Advanced Services & the Toolkit. Presumably, those downloads are for the 32 bit version, so is it possible to get a 64 bit version of Reporting Services & full-text search & the toolkit?

Anyway, if somebody could give me a bit of a clue I would really appreciate it.

Kind regards

Ross

View 4 Replies View Related







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