Answer Questions

• PeteJS Problem with plug-in algorithm in SQL Server 2005

  Hi,all here, Could please anyone here help me for this problem My problem is: I have registered my plug-in algortihm with SQL Server 2005 analysis services, and I can see my plug-in algortihm added to the analysis service configuration file (msmdsrv.ini). But why I can not see my algorithm appearing in the list of algorithms when I tested it Really need help for that. Thanks a lot for any guidance and help. With best regards, You ...Show All

• Ed cramgo Install fails on SQL2k5 because no IIS on Server

  We have a new cluster that we are trying to install SQL 2k5 enterprise on and the security requirements will not allow us to install IIS on the same server as SQL. Is there a way around the requirement of having IIS installed on the server with SQL 2k5 The setup just closes itself down when it is doing the check for server components. There is no error at all. When we check the log file there is a statement about IIS not being installed o ...Show All

• jmorgan Conditional Insertion & Updation in Destination Table (SSIS)

  HI, How to create package in SSIS by applying the business Logic like if the record already exist it should be and update else it should be an insert in the destination table. how to achive this funcality in SQL SERVER 2005 (Business Intelligence studion). Thanks & Regards Nagaraj.S I don't know of any. Its very easy to use - there should be information in BOL. -Jamie Thanks, ...Show All

• Normajean Failed to generate a user instance of SQL Server

  Hello all, I unisntall products as it are recommended (VS 2005 and SQL Server 2005 beta 2) in readme.txt of MSDN products subscription... I install VS 2005 Pro and I have no problem during install. Now, if I want to open database, I have this error mesage : "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." In MBSA report, I see that the folders of SQL ...Show All

• Rachel Falzone - MSFT Deployment of SSRS 2005 Reports, etc...

  Hello, I am working on a Reporting Services 2005 (SSRS 2005) report project and am getting close to deploying the reports. The client I am working for would like to keep deployment automated (i.e. not have to use Report Manager or Visual Studio) when moving in between environments. I have seen a few things out there for this, but wanted to make sure there is not a more supported or recommended way of doing this. Here are the solutions I ha ...Show All

• Erick Thompson Configuring Sql Job Agent for SSIS - Issues

  Hi, I have created a package which extracts data from src table to dest table. src and dest are available in test database.Another database test1 is available which has only src table. Now I have created package level variables for source and connection string.if both are test database then data from test.src - > test.dest otherwise if source is test1 then test1.src = test.dest . All these things worked fine from Business Intelli ...Show All

• Joel Archambault xp_readmail failed

  Hi, I'm using sql server 2000 and Im trying to execute an sql in an email, using xp_readmail. But I keep pn getting this error. "xp_readmail: failed with mail error 0x8004010f". I am able to execute xp_sendmail though. Can anyone please help Thanks in advance. See if any of these may be of any help. http://support.microsoft.com/ scid=kb;en-us;290058&spid=2852&sid=1256 http:/ ...Show All

• Anderson505 SSIS Runtime Object could not be created error:

  I am using SQL Server 2005 Version 9.00.1399.06 (Intel X86). Whether I try to start a new Integration Services project in Visual Studio or try to import data into a database I receive the following error: SSIS Runtime Object could not be created. Verify the DTS.dll is available and registered. The wizard can not continue and will terminate. Unable to cast COM of type 'Microsoft.SqlServer.DTS.Runtime.Wrapper.PackageNeutralClass' to in ...Show All

• Zephryn Xirdal The connection manager 'OLEDB' is not properly installed on this computer

  Please help someone from MSFT! I've just finished installing the Sep CTP on my laptop.  I previously had the April CTP and June CTP.  I followed the instructions for removing a previous installation of SQL 2005. Now, when I try to create an SSIS package, I get a message that says: TITLE: Microsoft Visual Studio ------------------------------ The new connection manager could not be created. ------------------------------ ADDITIONAL IN ...Show All

• C Dionne Can't Creat Subscriptions

  We're new to SQL Reporting Services and have a new SQL 2005 server. I'm having a problem activating scubscriptions. - "New Subscription" is greyed out in Server Management Studio. - Subscribing via the browser, even as the Content Manager, allows you to fill in the form for the subscription but then reports the following error; "The current action cannot be completed because the user data source credentials that are ...Show All

• Monu_India Do I want the Developer version?

  I've downloaded 2005 Express but I want to do SSIS and don't see any way to do that with Express. The Developer Edition apparently has all features, but says you can upgrade to Enterprise, which I don't need (Standard would probably be fine). Here are my questions: 1) Is there any way to develop SSIS packages in Developer and run them in Express 2) Is it possible to upgrade Developer to something less than Enterprise, such as Workgroup ...Show All

• Nathan Skerl problem with exports

  HI I was trying to export a report which i created in sql 2005 businees studio to excel..the problem is that the report is in drill down format and excel doesnt show the information quiete well when i export it to excel..i really need the drill down version to b exported in excel...wat shall i do hi Chris, what you mean by the report does not appear in the output of the main report is that mean we n ...Show All

• m.schlestein SQL Server 2005 Express Edition -Configuration Manager

    When i am trying to start sql server configuration manager i got one error as follows, Cannot connect to WMI provider.You do not have permission or the server is unreachable.Note that you can only manage SQL Server 2005 Servers with SQL Server Configuration Manager. Wmi provider error[call to wmi provider returned error code :0x8004100a] How can i solve this issue   Aji If ...Show All

• Juergen Wenz Replication Foreing Key Problem

  Hi, I want to replicate in the same Server 2 tables, first I test with the same data datbases in other Server but 1 table and all is ok , when I try to do the same in the production server occurs an error, Distibution Agent Error Details show me this: Could not drop object 'SER_CURRENCY' because it is referenced by a FOREIGN KEY constraint. Like I said first I run a test, in this test I check IDENTITY: YES (Not for replication), ENFORCE RELAT ...Show All

• soellnas Parameter is missing a value

  I have a report parameter with Allow null value checked (and also Allow blank value). The report works as expected when viewed in Visual Studio, i.e. if I don't supply a value for the parameter, the report still renders. However, when I try to view this report through the web ReportViewer I get the error message "The X parameter is missing a value". It works fine when a value is supplied but I want that parameter to be optional. Any ...Show All