Answer Questions

• BRCEWANE Calculated Members and Aggregation

  Hi, I am still in AS 2000 and would like to know if it is possible to have calculations performed at lowest granular level of the cube before aggregation. Perhaps I am missing a basic understanding on this but what I am hoping to achieve is to hold parameters at the lowest level in a separate measure ‘Param’ (separate column in the Fact table) and then reference to those parameters in a calculated member with the resulting values held in the default measure of the cube before being rolled up in the aggregations to higher levels. Currently in the higher levels input parameters are being aggregated before determination of the calculated member value. Will much appreciate your suggestions on whether it is possible ...Show All

• Allen Hsu Flight Sample Debate

  Hi All, I found the Flight Sample Description at http://msdn2.microsoft.com/en-us/library/ms160946(d=ide).aspx . I installed the file SQLServerSamples.msi which is in C:\Program Files\Microsoft SQL Server\90\Tools\Samples by default. I followed the steps strictly. Every thing was OK except: - I didn't have any response in the Notifications folder which by default resides in C:\Program Files\Microsoft SQL Server\90\Samples\Notification Services\Flight - I didn't understand what happened exactly So: - What are the probable causes of not getting a result - I want some documentation about what happens in the example. Thanks in advance, Bishoy An ...Show All

• Bloom326984 Why we have different duration value for same Procedure in SQL Profiler

  Hi, When we did stress testing, we found that for the same procedure the time taken is between 80 ms to 5000 ms. The procedure got executed 19929 times and out of which the value was > 1000ms only 13 times and many times it was between 80 to 800. Time in milli seconds was computed as DATEDIFF(ms,STARTTIME,ENDTIME). The statistics are as below >1000 - 13 times with Max ms (4486) and Min ms (1106) >800 and <=1000 - 13 times with Max ms (950) and Min ms (813) >600 and <=800 - 30 times with Max ms (780) and Min ms (606) >400 and <=600 - 148 times with Max ms (596) and Min ms (403) >200 and <=400 - 702 times with Max ms (393) and Min ms (203) >100 and <=200 - 3465 times with Max ms (200) and ...Show All

• arogan I am accessing data using data access pages in IIS 7 to SQL server 2005 Authentication is failing

  is there a step by step paper to get there here is what i need to consider. I Iwill have many customers that will need their own set of records and access pages "branded for their company" each customer will have many clients. I am hosting this application on a windows 2003 server with SQL 2005 server enterprise. I am using windows authentication, I have created a username in windows, then i added the windows user in SQL management studio in security, granted "DB Read" and "DB write" and again under the database security tab. still from the web authentication fails. i must be nissing a step or two I expect to set up a username for each database as i setup new customers. There is another post that had a similar issue...the dis ...Show All

• Meile Zetstra Permissions

  I posted a problem with connecting programmatically last week. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=590672&SiteID=1 Nobody seemed to have any suggestions, however since then, I've mucked things up and recovered to the same problem and now I've mucked things up again in a different way. Also last week  I didn't mention that I was running my connection through remote desktop. That apparently can be a problem although not the fix. I'm still getting the ServerVersion member status set to "'this.conn.ServerVersion' threw an exception of type 'System.InvalidOperationException' when I try to create a SqlConnection . I still don't understand why. But when I try to open the connection I now get the follo ...Show All

• Trish Error when attempting to upgrade MSDE to Express using command line /UPGRADE

  When attemping to install SQL 2005 Express using the following command line arguments /qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE or /qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE SECURITYMODE=SQL SAPWD=MY_PASSWORD the following error occurs. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. Edition check: Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. The follow ...Show All

• ancient sord Error 70038 on install Solved!

  Hi all I packaged .Net Framework & Sql Express with my setup project. When I attempt to install it on an XP (with SP2) system .Net Framework installs fine. The Sql Express gets about 25% of the way through then fails. Here's the content of the log file: The following properties have been set: Property: [AdminUser] = true {boolean} Property: [ProcessorArchitecture] = Intel {string} Property: [VersionNT] = 5.1.2 {version} Running checks for package '.NET Framework 2.0', phase BuildList Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\dotnetfx\dotnetchk.exe" Process exited with code 1 Setting value '1 {int}' for property 'DotNetInstalled' Reading value 'Version' of registry key 'HKLM\Softw ...Show All

• Kumaresan.K Any way to put a query timeout on the datasource behind a report model????

  Folks, we're wanting to put a timeout of 2 minutes on the queries which get generated by an ad-hoc report built in Report Builder. This particular report model has been generated on top of a cube by clicking the Generate Model button after creating an Analysis Services datasource in Report Manager. The connection string for that datasource reads: Data Source=(local);Initial Catalog=MyCubeDatabase I expected there to be a connection string property I could set (such as "Timeout=120") but I can't seem to find that in the documentation anywhere... And Timeout=120 doesn't appear to do it. Do you know of one If not, do you know of another way to put a timeout limit on a Report Builder generated query or a Report Builder report i ...Show All

• Santiago Ace&amp;#241;olaza trouble getting snapshot agent to initialize publication

  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 ...Show All

• Pankaj11 Dynamic Windows Authentication

  Hi The Parent Package has a Loop Container. The Loop Container calls the Child Package and in the process the connection manager properties are changed using package configurations. When the packages are tested in BIDS both Windows and SQL authentication work. When the packages are scheduled on SQL authentication works and Windows authentication fails. (The account which executes the schedule has permissions to all the data sources required. The SQL Agent Service Account has permissions. In addition a crendential was created using a different account which also has permissions and this also failed.) If the connection managers are made static then the schedule executes. Any ideas would be appreciated. Thanks ...Show All

• g33kspeak Duplicates

  I am a newbie who did't use T-sql yet. When executed, my Fact_table turns green. But returns a Warning for some Lookups as below Dim_Salesperson, Dim_demographic. [Lookup Salesperson [7405]] Warning: The Lookup transformation encountered duplicate reference key values when caching reference data. The Lookup transformation found duplicate key values when caching metadata in PreExecute. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. How would I delete these duplicates In Dim_tables or Fact_Lookup Distinct doesn't eliminate them. Thank you! It's already solved. ok .maybe am the one how just isn't understanding this but exactly wh ...Show All

• Pramod S Kumar The annoying WMI configuration error

  I'm recieving the following error: The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine 'machine information' Error: 2147749896 (0x80041008). I've researched the error and found out some people were running batch scripts to reinstall wmi, but none of them worked for me. One of them I gave up on after thirty minutes and it wasn't doing anything. Please give some suggestions on how I can resolve this issue. TITLE: Microsoft SQL Server 2005 Setup ------------------------------ The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine S1JK9481 Error:2147749907 (0x80041013). For help, click: http://go.microso ...Show All

• muthuraja Internal error: Cannot open the shared memory region

  I'm getting this error on one of the test pc's when doing a adapter.fill for a datatable. Any ideas on how to debug this Thanks, Bernie This is the stack trace: System.Data.SqlServerCe.SqlCeException was unhandled Message="Internal error: Cannot open the shared memory region." Source="SQL Server Compact Edition ADO.NET Data Provider" HResult=-2147467259 NativeError=25118 StackTrace: at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent) at System.Data.SqlServerCe.SqlCeConnection.Open() at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, Comm ...Show All

• IGiberson Users in RS2005

  How do you set up user as who can access what report in Report Manger. I do not see security tab in RS2005. u can set security by connecting to RS from SSMS. right click report folder or report itself and click Properties. Under Select a page, select Permissions. from Report Manager, click at Show Details at the right hand side of the page. Click Edit next to the report folder or report. there's a security link at the left hand side. hth ...Show All

• Emy_P Error Starting Script Editor in SSIS

  I am having a problem in the Business Intelligence Development Studio. When I add and try to edit a Script Task or a Script Component, I click on the Design Script button and get one of two errors. For the Script task I get an error that states: Cannot show the editor for this task. (Microsoft Visual Studio) For the Script component I get: Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio) For some reason or another it just will not start Visual Studio for Applications. I have uninstalled an re-installed several times. I have also researched and discovered that there is a bug when C# tasks are include in the project. However, this is not the case. Please help! I am wondering if anyone is monitor ...Show All