Answer Questions

• palestine Error returning OLAP data in RS 2005

  I have a .rdl file that was exported out of ProClarity's Desktop Professional 6.1 using their RS plug-in. I uploaded the file into Report Manager and when I execute it, I get the following error: An error has occurred during report processing. Query execution failed for data set 'Three_Month_Funding_Trend'. Unable to recognize the requested property ID 'ReturnCellProperties'. Does anyone have any idea what this is referring to Does it have something to do with my configuration, connection or the report definition Other reports such as DBMS based reports work fine. Thanks for your assistance It doesn't end here. SSRS 2005 support to AS 2000 varies based on AS 2000 hosting platform ...Show All

• bitem2k Can connect to 'ServerName' but not to its IP address

  I'm using SQL Manager from my Enterprise server to connect to my SQL Express server that will act as a witness to a db mirroring system. If I try to connect to the SQL Express server using its IP address, I get a "named pipes error 53." If I connect by browsing the network and connect to the Name of the Server "Machinename\SQLExpress", I am successful. I would like to be able to connect to the IP directly as it's not dependant upon certain services to be started or configured a certain way. Thank you, Chad Try Data Source=tcp:192.168.0.3,1433 in your connection string using applicable IP and port number (remember to setup port number in SQL Configuration Manager on the SQL Express machine). ...Show All

• Kevin Rodgers Conditional running total question

  Hi there, I have a problem with trying to get a total of a conditional value. My data output looks as follows: HEAD OFFICE BRANCH (group1) (Group 2 below) Ford         Mustang     2001     Blue     Excellent Toyota      Raider        2005     Red     Good BMW       5.30 i         2006     Blue     Excellent Mazda      MX5          2003     Yellow Good WESTERN CAPE BRANCH Ford         ...Show All

• BJones82 Connect to SSIS Service on machine "localhost" failed

  Greetings all, I cannot connect to my SSIS service from Management Studio. This is on my local machine, which is my "sandbox" and preliminary development platform. There are slightly different error messages and extended information returned depending on whether I connect using "localhost" or my explicit machine name. I have tried registering MSXML*.dll as suggested elsewhere in these forums. I've also tried the DCOM config changes suggested elsewhere in these forums (or someone's blog ) - can't find the link at the moment. This is all on the same machine and I am a local admin on this machine. Anyone seen this Anyone have any suggestions. I'd appreciate any tips. Regards, Tom << LocalHost - Copy Message Text ...Show All

• Sajal Mahajan "!New" Indicator on report

  Is there a way to set how long the "!New" flag is displayed next to a report in reporting services Thank you, Dave Unfortunately no, this is fixed at 48 hours. ...Show All

• Mr_White Ad-Hoc Matrix report calculations

  Is there a way to change the value in an ad-hoc matrix report to be the percent of the row an not just the raw number unfortunatly not ...Show All

• Colmeister Importing Online XML file into SQL Server 2005 tables – no data transferred

  Does anyone have any great suggestions on how I can import an online XML file into an SQL 2005 table So far I tried to accomplish it with SSIS Data Flow Task where my source is XML Source (Data access mode: XML file location; XML location: URL, Use inline schema = True). This set up properly identified the columns to be imported. I used Copy Column data flow transformation task to load data to OLE DB destination table that has same structure. When I run the task it does execute with no errors, however the table remains empty. It looks like I am failing to read the actual data. Do you have any suggestions I am willing to go around this approach with stored procs/com/you name it – just make it work! ...Show All

• lm089 SQL server express installation issue

  I am trying (unsuccessfully!) to install at a client site. They're running W2K SP4 which has never had any instance of SQL of any flavour installed. The install seems to be failing at the same place each time. I have tried complete uninstalls of SQL and associated components but to no avail. Here is the contents of Summary.txt: Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows 2000 Service Pack 4 (Build 2195) Time : Fri Nov 10 10:13:13 2006 Machine : ALC Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.1.2047.00 Install : Failed Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0012_ALC_WI.log Err ...Show All

• Namrata Prashar Sql2005 standard to Sql2005 enterprise edition

  Hi We have Sql2005 x64 bit standard edition server installed in windows 2003 64 bit editio server, currently due to buisness requirements we need to have sql2005 x64 bit enterprise edition, please let me know how do i do the upgrade or change. is it possible to retain all our custom settings in the standard edition after changing to enterprise edition. This has to be done for our production and very critical, please help Thanks Samuel I You can launch enterprise edition setup.exe with SKUUPGRADE=1 parameter. This will conduct an edition upgrade. It will retain the settings of your current dev edition. To do this, goto cmd prompt, nav to to where the setup.exe is and run setup.exe SKUUPGRADE=1 In the UI, ...Show All

• flash.tato Connect to SQL Server via Internet

  Hi there We have the following problem. Our DB (MSDE 2000) is situated on remote server on which we have administrator privilege. The application which works on Local net connect to every machine in the net and see the database on one of the mashine as well. The connection string is data source=192.168.0.1\XXXX;initial catalog=XXXX;integrated security=SSPI;persist security info=True;workstation id=XXXX;packet size=4096" but when we change IP in the connection string to our remote server(in internet with static IP) one we get an exception says that SQL server does not exist or access denied. We opened ports on firewall but problem is still here. Then swithched off the firewall at all but same exception comes. Th ...Show All

• kwards3 Trouble with Connectivity

  I have been switched to recognize me as an admin. Now, I go to the database to link it to the SQL Server Database on the server. And I get the old heave/ho, first I go to a window that is asking for my DSN name. If I put something in or ignore it will then wisk me off to the next screen asking me to create a Data Source Name. The whole time I was surfing through the server attempting to get the correct path of the database that I supposedly set up. Well I did, but just has a couple of tables for now. That doesn't seem to work too well, telling me that the file name entered is invalid. Help... Hi, i would suggest to refer below links. http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx http://forum ...Show All

• Equis Compare csv file layout to SQL Server table

  I am creating a facility whereby you can select a source file (.csv), and a target (SQL table). Then I call a DTS to copy the csv file to the SQL table. How can I validate that the two files have the same number of columns You can write a custom Script Task inside the SSIS package that will open the file and check how many columns it has. You can utilize Excel object model for that or just go with regular .NET IO libraries. Hope that helps. Maciek Sarnowicz Moved to SQL Server Tools forum I need to validate that the correct file has been selected before scheduling the DTS package. This is why I need to do it in my VB.Net Windows application. ...Show All

• billqu Removed Publisher stays in Replication Monitor.

  We have a publisher that got red-crossed(Run to problem). I decide to remove and recreate it. However, after remove it, the publisher still stays in Replication Monitor. The remain thing has no distributor and logreader, but only snapshot agent. When to check the property of the agent, we got a error message basically say the job does not exist, which makes sense.  Now, it does not show up in any places, except Replication Monitor. Well, it cannot be removed from Replication Monitor. Can any one tell us how to clear it from Replication Monitor Thank you. More Infor:  The replication was set up on 2000.(2000 pub, 2000 dis and 2000 sub) with 2005 Management Studio,  and the publication was removed ...Show All

• n3zdh MaxLocksPerFile

  Hi I wrote a script in Installshield that changes the MaxLocksPerFile value in Registry for Jet 3.x and Jet 4.0 While installing the application through Installshield, the custom value for MaxLocksPerFile is being overwritten to 9500 in Registry for Jet 4.0(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0) but not for Jet 3.x(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 3.x). The value is being overwritten to 9500 before the control reaches at the script code. I am wondering from where this 9500 value is being retrieved and set in Registry. Is there some file where these default values are mentioned. If so then why 9500 value is not being set for Jet 3.x and is being set only for Jet 4.0. i am using MS Office 200 ...Show All

• Lesego How do I change a subscription owner?

  On some preexisting subscriptions there is a single person that is the owner of the subscription. Is there a way to change the ownername to someone else without having to delete the whole subscription and reenter it under the new owner name I am aware that you can use groups, but these subscriptions already exist and have a single owner. Thank you for any help. Kim- Look into the UpdateSubscription stored procedure in the Reportserver database. You may be able to do it there, as there is no way to do it through code using the web service API...the OwnerId property is ReadOnly. But you'll have to make sure that the new owner has access to that report to change the subscription to the new user. Regards, Scott ...Show All