Answer Questions

• kanuhelp System Configuration Check

  Hi all, when I try to install SQL Express 2005, it seems to install SQL Server Native Client & SQL Support Files OK, but at the end when I click next a window pops up labeled "System Configuration Check" with a message which reads "SQL Server Setup is scanning your computer's configuration" The problem is that the Configuration window doesnt seem to do anything after that, the Configuration window just stays there ...Show All

• David Chase Secondary/multiple data sources in data source view

  I am new to reporting services and am trying to use model designer to build a data source view (and then a model) based off of multiple data sources. I am sorry if this question has been asked before but I could find the question by searching for it) Using a model project I have create 2 data sources from 2 different databases on two different servers. Then using the data source view wizzard I created a data source view (DSV) for my primary d ...Show All

• OneWay and BegineInvoke differen Call Reporting Services Report from Stored Procedure

  Hi Is it possible to call Reporting Services Report from Stored Procedure, if so please let me know how. Thanks in Advance Babu ...Show All

• EddiRae Limitation on Multiple parameters with Multi-Select and default values

  Dear Anyone, I created 6 parameters in my report. Each of these parameters are multi-select enabled. Each of their available values comes from a data set. Their default values also comes from a data set in order to have the select all check box selected by default. My problem is only the first 2 parameters gets to have the select all selected. And the rest just have blank values. I was wondering if RS parameters have some sort of limitation that ...Show All

• vbmon MSXML6 breaks viewer used with Microsoft Electronic Learning Library

  Installation of SQL 2005 Express resulted in the failure of the viewer used with the Microsoft Electronic Learning Library products. The viewer runs under IE and is driven by an XML file. This has been verified on several systems. I uninstalled only MSXML6 and the viewer worked normally. I have no idea if the problem is with the viewer script, the XML file driving it, or MSXML6 but obviously this might be a breaking change to the product. ...Show All

• kocherek analysis service DTS keeps failing . ERRORSOURCE = DSO

  i have an analysis services dts job on an old sql server 2000 box. i have never used analysis services before, and am a bit stuck. the job used to run and succeed all the time, but now it fails most of the time. this is the error that goes with the failure. someone suggested that its because more than 1 cube processing jobs were running at the same time, but i dont know how i would sort that out as they have to be run at the times they are s ...Show All

• LukeRazor Transactions and Service Broker

  Problem: I want to use the Service Broker to split up my processes so that they can process concurrently next to each other, but I only want the changes committed if all the processes of the same conversation group succeed. Is this possible in the service broker I came up with this, but the problem with this solution is that my transactions are all started first (4 in this example) and only are committed after all 4 are started, so only the las ...Show All

• Pooja Katiyar Error while restoring database,

  Hi, Im trying to restore a database, when i try to restore by selecting the file groups option it gives me an error Microsoft SQL DMO The backup set holds a backup of a database other than the existing database. RESTORE DATABASE terminated abnormally. I tried deleting all the tables and the stored procedures that are there, but it still gives the same error. If you check "Force Restore over existing ...Show All

• Betuca Does Report Builder have exposed APIs just like Reporting Services?

  Dear Anyone, Does Report Builder have exposed APIs just like Reporting Services The reason I asked is that we would like to customize Report Builder to some extent to fit to our client's specific requirements. Can anyone shed a light on this Thanks, Joseph If you are asking about the Report Builder client, then no, you can't change it. If you are looking for APIs for publishing models, generating models, executeing queries, or setting mo ...Show All

• catman123 Making SSAS Developer Edition act like standard edition

  My understanding is that the Developer Edition of SQL/SSAS contain all of the functionality of the Enterprise Edition. Is there a way to force it to act as if it were Standard Edition (and therefore subject to all of the limitations of SE) The reason I ask is that with our product we're trying to maintain compatibility with both SE and EE. I realize I can just install SE instead of DE, but if there's a way to simple toggle the behavior, that wo ...Show All

• Joos how can i import the northwind DB into ms sql server 2005???

  i hava tried installing the "SQL2000SampleDb" but the db is not on the db list after the install Make sure that you installed the DBs on the right instance you are connecting to. Additionally make sure that the script executed successfully. If you are not sure just rerun the script, the db will be dropped and recreated then. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Benji_bunni insert BLOB

  Is it possible to import BLOB data using SQL statements stored in a file to an SQL server. Can the actual INSERT statement contain binary data  Or how should I convert the binary data in order to work with an INSERT statement Thanks. I'm using different versions of Microsoft SQL server. Sorry, not sure in earlier versions. You might be able to use some external code a ...Show All

• AlanuB Different kind of connection issue

  Was able to solve my connection issues with my local (test) machine. However, now I've got a much bigger issue on my intranet machine (W2K Server that acts as a domain controller). When I use essentially the same set up for connecting as I did for the other machine (adjusted for machine name, etc), I get the following message: Login failed for user '[username]'. The user is not associated with a trusted SQL Server connection. I went int ...Show All

• OptikDev Failed to decrypt protected XML node

  Failed to decrypt protected XML node ... blah blah. Looks familiar, right Package Protection mode is : EncryptSensitiveWithPassword Package runs fine from within BIDS. Close package. Open package - asks for password. So far so good. When running from command prompt with: dtexec /File "C:\Program Files\Microsoft SQL Server\90\DTS\Packages\MyPackage.dtsx" /De mypassword Get that cryptography error. Doesn't happen for other packages... what can I ...Show All

• nathanjones Metadata storage and intelligent use

  I am contemplating moving a huge integration project (hundreds of different medical practice management systems) from a competitor's dedicated data integration tool to SSIS.  One of the main questions I have about SSIS regards it's capability to maintain - and even more importantly - intelligently use metadata regarding source and target data in the integration processes. One significant example: There is an ETL tool that I am fam ...Show All