Answer Questions

• n0n4m3 Problem using Reporting Services forms authentication with SSL

  I am using Reporting services 2005 and have enabled forms authentication using the example found in: 'C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Extension Samples\FormsAuthentication Sample' This works correctly without SSL, but when I enable SSL I get an error when logging in. The symptoms are as follows. I can login to the reporting server (in my case <server>/ReportServer2) directory, but when I login to the report manager (in my case at <server>/Reports2) I get the following error: 'The underlying connection was closed: An unexpected error occurred on a send.' Can anyone suggest why I might be getting this error Thank you, Graham Please check your RSWebApplicatio ...Show All

• Daniel Coleman Upgrading a cube from Analysis Services 2000 to SQL 2005

  I am trying to upgrade a cube that was developed in Analysis Services 2000 to SQL 2005. I have gone through the following MSDN Links http://msdn2.microsoft.com/en-us/library(d=printer)/ms143686(sql.90).aspx#upgradeASfromEarlierVersion http://msdn2.microsoft.com/en-us/library/ms143235.aspx According to this information, it appears that I cannot migrate a single cube from analysis services 2000 to 2005 - I need to upgrade the server and run the migration wizard. I think the migration happens for the entire AS200 database. Explicitly migrating a single cube might not be possible I guess. I was looking into the migration wizard, but I think the smallest unit that can be migrated is a database and ...Show All

• AlexBB SQL Express SP1 with Advanced Options

  I'm having trouble installing SQLEXPR_ADV. It says it's not a valid win32 app. System: Dell Precision 380 3.00ghz 2gb RAM Windows XP Pro SP2 Hi Greg, I'm going to shoot this to the Setup forum and let the gurus of install consider this. Mike Has anyone else experienced this to date I downloaded a fresh copy and refreshed the PC (Cleared out all internet cache, shutdown for 5+ minutes). I downloaded to a new drive and received the same error. It must be something on my PC, or perhaps something wrong with the download. I don't think it's the firewall, because I've downloaded other EXE's fine. Any other thoughts Sounds like the installer is corrupt, try downloading a fresh copy from the do ...Show All

• tdcntt Error Code of 3238395904 and 3240034316

  I get the following error for a cube that used to process just fine. Executed as user: PREMIER_AD\SQLExec. ...ts xmlns="http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults"><root xmlns="urn:schemas-microsoft-com:xml-analysis:empty"><Exception xmlns="urn:schemas-microsoft-com:xml-analysis:exception" /><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception"><Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: Unspecified error." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" /><Error ErrorCode="3240034316" Description="Errors in the OLAP stor ...Show All

• ScubaBob A call to SQL Server Reconciler failed. SQL Server 2005, SQL Server Mobile merge replication

  Hi, Iam trying to perform merge replication between SQL Server 2005 and SQL server mobile.  It has previously been working.  Recently something is causing the following problem when i try to perform the merge.  I grabed the following output from the replication monitor. Error messages: An error occurred while reading the .bcp data file for the 'MSmerge_rowtrack' article. If the .bcp file is corrupt, you must regenerate the snapshot before initializing the Subscriber. (Source: MSSQLServer, Error number: 2147767868) Get help: http://help/2147767868 The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message ...Show All

• jbujold Network timeout to Mirror causes Primary to deny connections

  We've had two instances now where when there is a network connection timeout to the mirror from the primary, the primary db server goes to 100% utilization and refuses all connections. The first time we had to reboot the primary, the 2nd time mirroring picked up again 10 minutes later. There are two dbs being mirrored, one is 15gig, the other 4gig. Both boxes are running SQL2005 64 bit and Win 2003 64bit. This happened at 6am and typically there shouldn't be a lot of traffic at that time but here are the error messages in the SQL log below. We are going to try and move db communications to a separate network and network card - but this looks like either a bug in mirroring or a configuration problem on our end - though it works ...Show All

• dmarze01 truncating the package buffer after each table copy

  Hi I have a SSIS package that I run from dtexec command prompt in parallel. they run completely isolated. Sometime when I push 3 instance of the packege at the same time, one of the instances will fail. I have implemented detail Log on the package to see exactly where it's going wrong. to brife you on what the package does, I can say in nutsheel that it does copy tables between servers. due to the nature of the problem, the point in failer can is completely random. if I run just one instance it will work fine (always). if it is more than one that there is a chance that it might fail. (but there is agood chance that they will run successfully). my guess is, as this packages share resources (CPU,Mempry and disk I/O) sometimes is there is an ...Show All

• vito1281 one package running with different connection strings?

  I have a SSIS package which needs to connect to 5 different servers to import data. I want to schedule one task to run this one .dtsx but run once for each server connection( 5 different servers). Is it possible how can i accomplish it Is Package configuration possible How to go about it if so thanks, kushpaw So, are you planning to run the same package n times but connecting to a different data source each time On a previous project I accomplished that by creating a parent package with multiple sequence containers in it; in your case it would have 5. Each sequence container had 2 things a variable, e.g. @User::SourceConnectionString, that hold the proper connection string f ...Show All

• Mahmoud_Fayed can'd find SSIS for installation in Server2003SBS-PR

  I bought a new HP server with Windows 2003 SBS Premium. I also was told buy the company how installed the server, that they installed all the components of SQL. When another company came to install a new business software for us, they told me that the Integration services is not installed. We tried together to install the SSIS with no luck. When we run the Setup(or used Add/Remove software) we couldn't find the Integration services check box in the list of the setup. I also asked assistans from the company that i bought the server fromk, and they also couldn't understand where is it. We have an HP Proliant server, Windows server 2003 small business preminum SP1, SQL server 2005. I was told that without the ...Show All

• esiboda SQL Statement

  Hello All, I imported a excel file from SSIS and created a table called Lockbox. To avoid the user from having to change the excel file -it is being imported as is. I only need 4 fields: [Contract ID] , [Check Number], [Owner ID], [Site ID] The table I need to import to Transaction has Diffrent Column Names -ex-CustomerID, ResortID. The columns are in diffrent order. And I need to add more information into them like UserID = 'Hwells', Trantype = 'MF' and convert to a diffrent data type [Site ID] to text. Is their a sql statment that can do this SQL2005 Thanks for your time Not automatically. You could either: 1. Build a SELECT statement to format the data like you want using the INTO keyword to create a new table. 2. (t ...Show All

• momo_lang Collect SSRS/SSAS schema (metadata)

  Hi all, I would like to collect metadata from cubes&reports automatically from servers SSAS and SSRS. Metadata include name, description, dimensions, members, permissions, etc. Then I store it into a table to be searchable. I am searching the best solution for this. Maybe it would be a SQL stored procedure. Do anybody has an idea or some piece of help thx. attila Both servers expose management APIs. The Report Server has web service management APIs while SSAS comes with AMO library. ...Show All

• Kirti Mistry Folders for instances

  Hi everyone, I've got a Sql2k running with one instance and I can see through NTFS these folders: MSSQL MSSQL$INST01 After that, I've got a Sql25k running without instances and I can see through NTFS these folders: MSSQL.1 MSSQL.2 MSSQL.3 It goes to misunderstandings, is it possible to change them It seems three instances Thanks in advance, If you have chosen default options while installing SQL 2005 instance then it will create such directories. http://msdn2.microsoft.com/en-us/library/ms143547.aspx fyi. thanks ...Show All

• StGeorge saving DTS package to sql server

  hi, I have a "Transfer sql server object task" in SSIS that transfers few tables from one database to another. The task works fine and the project is saved on my c: drive. I was trying to save the project on the SQL server and don't know if i am doing somehting wrong I have the following selections made: Package Location: SQL server Server: ServerName Authentication Type: Windows Package path: /TransferTables Protection Level: Encrypt sensitive data with user key Now when i hit ok i get the "No description found" error with the following details: No description found (Microsoft Visual Studio) ------------------------------ Program Location: at Microsoft.SqlServer.Dts.Runtime.Appli ...Show All

• nonno counting records in all tables

  Hello all,    I was wondering if there is anyway to find number of records in all tables instead of count one table at a time by select count(*) from table_name. thanks   Unfortunately, we're fully upgraded to SQL 2005 here (we were active in the beta and were ready to go when 2005 was released). So I can't accurately convert it back to 2000 code. While SQL 2000 doesn't have a sys.tables, it does have a systables. It should be possible to get this working on the older version with minor adjustments. -Ryan Hello Ryan and all, I am using SQL Server 2000; therefore, I won't be able to see table as sys.schemas and sys.tables. Would you advise how to do this in SQL Se ...Show All

• norpe Time calculation Growth % from Business Intelligence wizard

  Hi, I need some help to solve an issue I have on displaying data from cube onto a OWC Pivottable. What I did is as follows. I created, using the wizard of the BIDS evironment the measure “Month Over Month Growth %”, calculates on the Time dimension. Browsing the cube, when the calculation is applicated to a measure containing a 0 value, I see “-1,#IND”. How I can avoid this Is it necessary to modify the MDX expression created by the wizard If so, How Thanks in advance. Client development is not my strong side but I have seen the same problem in Reporting Services 2005 when building reports with SSAS2005 as source. In SSRS2005 I can set the formats for percentages like "###.# ...Show All