Answer Questions

• Bluzdude In 2000 is it possible to list second parameter based on the first parameter selection

  Hi In 2000 is it possible to list second parameter based on selection in the first parameter list Cheers Hi, For each parameter it is possible to set the datatype. Go to the Report\Report Parameters menu to change the datatype. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog So for datetime picker what i need to do Where do I declare the parameter type to be datetime so that a datetimepicker control shows up It was the order of the parameters no Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog When using RS 2005: set the ...Show All

• PhilipDaniels Can NOT login in to SQL2005 with SQl Server Mangement Tool

  I get the following error when trying to connect to my server that is on my local maching: provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233 It happened after I changed the allowed remote connections to 1.  It appears tha I can not log into the server at all.  Any way to fix this besides reinstalling SQL Server Thanks, Doug   You do not need to re-install. Start here for a complete tutorial: http://msdn2.microsoft.com/en-us/library/ms345332.aspx And then check here as well: http://support.microsoft.com/default.aspx/kb/265808/ If you've done all that, make sure your firewall is set up, as refer ...Show All

• Jeff Weber partition switch and non unique index

  I have a table partitioned by month. There are no primary key. There is another table with the same structure that I use to load data for the current month. I can perform partition switch with no problem. I created non unique index on integer field in both tables. After this change partition switch does not work anymore. Here is an error that I am getting: 'ALTER TABLE SWITCH' statement failed. The table 'dbo.test' is partitioned while index 'IX_test' is not partitioned." Any help I experience this also. My destination table is partitioned by month. I have a "from_filtered_by_month_replication" table which is also filtered by month and have a ...Show All

• eldiener Deadlock at trigger

  a trigger need to insert or update record at the other table in high traffic environments however, the deadlock happens; ie, a trigger running twice at the same time want to need to insert record at the table. i trid to change isolation as SERIALIZABLE or REPEATABLE , but i cannot solve the problem. i guess the "while loop" affects the result because i try to cancel the loop and execute smoothly. How to solve the deadlock Thx ----------------------------- i used the following commands to change isolation level: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE begin transaction commit transaction ----------------------------- the code are as follows: declare setskuCursor cursor local static for select item, qua ...Show All

• sl5 Analysis Services 2005 OLE DB Provider Error

  I try to open a SSAS Cube but I get a OLE DB error message below. The same cube I can browse with the SQL Server Business Intelligence Development Studio. Error message: Microsoft OLE DB Provider for Analysis Services 2005 Microsoft OLE DB Provider for Analysis Services 2005 reported: Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the '<MY Server Name>' server. Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the '<MY Server Name>' server. Hi Dave, Some questions for you about your options: 1. How do you make SQL ...Show All

• fuongptit-kodomo Importing Data from Oracle 8i/9i to SQL Server 2005 using SQL Server Import and Export Wizard (AKA DTS Wizard)

  Hi All, I have become frustrated and I am not finding the answers I expect. Here's the gist, we support both Oracle and SQL for our product and we would like to migrate our Clients who are willing/requesting to go from Oracle to SQL. Seems easy enough. So, I create a Database in SQL 2005, right click and select "Import Data", Source is Microsoft OLE DB Provider for Oracle and I setup my connection. so far so good. I create my Destination for SQL Native Client to the Database that I plan on importing into. Still good Next, I select "Copy data from one or more tables or views". I move on to the next screen and select all of the Objects from a Schema. These are Tables that only relate to our application or ...Show All

• ozhonetech SQL server connection error and cliconfg

  Hi Folks; I had a problem with connecting to an SQL server remotely: ConnectionOpen(CreateFile()). Client unable to establish connection I then tracked the problem down to named pipes. I found a solution in cliconfg by changing the network protocol to TCP/IP however this is not satisfactory as the problem exists with dozens of computers and the lab administrator doesn't want to have to run this on ever single system. I made another attempt on the SQL server end by running SQL Server Configuration Manager for SQL Server 2005. I enabled "Named Pipes" and restarted the service. Unfortunately this did not resolve the situation. So is there something else I can do on the SQL server end or is there a command-line paramter f ...Show All

• FRED.G How to Uninstall Sql Server using MSIEXEC.exe

  Hi, Is it possible to uninstall an SqlServer Instance (not Msde) using msiexec.exe. For uninstall using msiexec.exe we need product code. But in the registry i could not find any product code for an installed sql server instance Is this a SQL 2005 uninstall And is there a reason you don't want to use setup.exe with the uninstall parameters Thanks, Sam Lester (MSFT) Msiexec.exe can only be used for products installed with Widows Installer technology. SQL Server 2000 (not MSDE) uses InstallShield so you cannot use msiexec to uninstall SQL Server 2000. You can use it for MSDE 2000 because that one is Windows Installed based. Hi, It is Sql 2000. but anyhow, i can use the Registry entry key 'Uninsta ...Show All

• JPC16 StreamNotFoundException in reports with drill and images

  Hi, I always have this exception: w3wp!library!1!02/28/2007-13:50:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. When i try to drill in a report that have images. The weird is that i only have this error when i view this report in ReportViewer in a .aspx page. When i try to enter in this report directly by using the ReportServer ( http://s ...Show All

• Kenneth Lai maintenance plan

  maintenance plan is part of which component. I'm trying to fix this error and would like to un-install only that component. thanks. If you're using SQL Server 2005, Maintenance Plans span multiple components: SQL Server Management Studio SQL Server Integration Services SQL Agent What is the problem that you're having Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ ...Show All

• hillrg Changing from dropdowns to datepickers

  Hi guys, just a simple question here: i have some input parameters on my report that are datetimes (i.e. the user gets the date picker to select the date), if i want to use that parameter in a MDX statement what will it look like IOW would today's date look like the string "13/02/07", or would i be expecting a string like this: "2007/02/13 00:00" I am looking to convert some dropdowns that contain dates extracted from a cube heirarchy with the datepickers so i need to know what i have to change in the MDX to accomodate this. I also filter the dates that appear in the current dropdowns, is there a way to do this with the datepickers (maybe by pointing them to a dataset of dates extracted from the cube) Thanks ...Show All

• DanDro Adding SQL Reporting Services to SQL Server 2005 SP1

  I'm using Reporting Services Configuration tool to add the Reporting and ReportingTemb databases. Once the have been created, the tool attempts to upgrade the databases and can not create a script. This are the errors I see from the from the Reporting Services Configuration Tool after creating the databases: ! Verifing Database Version The Database version (C.0.8.40) does not match your Reporting Services installation. You must upgrade your Reporting Services database. ! Creating upgrade script for database version C.0.8.40 ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does not match a supported version. at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseUpgradeScript(Strin ...Show All

• ADurkin filter expression using measures

  Hi guys, I want to filter an MDX query based on a specific measure values, however, the MDX query designer allows you to filter only based on a dimension. Is there any soulution to resolve this problem. Sincerely, --Amde thx! In the data tab for reporting services, select your dataset you want to filter by in the drop down list. Now, click the "..." to the right. In the filters tab, you can filter the dataset by an expression you provide. For example, if you wanted to filter the results so that only customers with over 100 purchases were displayed, you could do this: Expression: =Fields!NumberOfPurchases.value Operator: > Value: 100 You ...Show All

• Juliano.net Can't run Business Intelligence Development Studio

  All, I've installed SQL Express with advanced services and the BIDS software from the SQL Toolkit using the vs_setup.msi extracted from the toolkit installer (Why not include it in the advanced services ). Now I'm trying to start BIDS and am asked to log into the Report Server. I use my username and password for ASPNET. The login fails saying that the web application is not available on the web server and to look in the application event log for more information. There are a bunch of errors listed (and more every 30 seconds are so). The error message is: aspnet_wp.exe could not be launched because the username and/or password supplied in the processModel section of the config file are invalid. Also, when I start Visual Web D ...Show All

• paso Dynamic Grouping Group Header Problem

  Hi, I am currently trying to create a report the dynamicaly groups from parameters. The grouping part works fine but I need to show the parameter label name or the field referenced by a parameter. =iif(Parameters!Param1.Value= "P" ,Parameters!Param2.Label,Fields(Parameters!Param1.Value).Value) This is the expression I have written to do this. The problem seems to be is with the true part of the iif statement. The false displays fine in the group header. The Parameters!Param2.Label also displays if used on its own. This is the error that is fires back when I run the report. The Value expression for the textbox ‘textbox4’ contains an error: The expression referenced a non-existing field in the fields collection. I ...Show All