Answer Questions

• Rolf700 Availability of SQL Server 2000

  It may be not suitable to ask about SQL 2000 here, but I really want an answer from you experts. I have my SQL 2000 installed in a Win2000 server, however, the SQL 2000 is not available to my application until I log into a shared folder of the Win2000 or I enable the Guest account of the Win2000. What is the proper way to let the SQL 2000 available to my application   My SQL 2000 uses SQL Security Mode. Thanks. If you're using SQ ...Show All

• deCreateObject.Ryan.Shell Out of Memory

  Hi Guys, What i'm trying here is to run a .bat file containing Osql Command's on the server using asp. Which is Generating Out Of Memory Error. In Detail. This .bat file is having a Osql command to connect to a database with a parameter to run a .sql file and output parameter to give to output in .txt file. This is working fine if I simply run the .bat file on the server. its working fine no probes, but when I try the same from a .asp file run ...Show All

• anemvr SqlServer2005 can support merge replication with SqlCe2.0??

  Hi guys, Correct me if I'm wrong. That's wat I was doing.. Try to perform a merge replication between the 2. But the following errors are wat I've got during the syncronization: Error Code: 80004005 Message : Run Minor Err.: 28557 Source : Microsoft SQL Server 2000 Windows CE Edition Err. Par. : ssce:database;password=mypassword;data source=Program Files\helloWorld\database.sdf; Error Code: 80040E14 Message : The OLE DB Execute method failed. ...Show All

• newDBA02131 ForEach Config validation errors

  I have a Config file for a Data Flow that is utilizing a Configuration file. I have specified in the Configuration file to capture the Directory and FileSpec for the ForEach Enumeration. When I open the package, I get the following error: Warning 1 Warning loading ISOTypeLoss.dtsx: The package path referenced an object that cannot be found: "\Package\Foreach TC03 File.ForEachEnumerator.Properties[Directory]". This occurs when an attem ...Show All

• sammy URGENT: Insert and Update in a transaction is getting blocked

  Hello, I have the following situation: -Package A begins a transaction (TransactionOption="Required") with IsolationLevel=Serializable -PackageA calls PackageB -PackageB has 2 data-flows. The first one inserts into TableA. The second one updates TableA. They run serially. They both have TransactionOption="Supported". The update is blocked in SQL Server by SPID=-2   (which I know is MSDTC). I tried setting RetainSameConne ...Show All

• Patrick Covert Cluster install fails on SQL Native client

  When I try to install SQL 2k5 Developer on a Windows 2003 SP1 cluster I keep getting an error popping up while trying to install. the error looks like this: An Installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi' Can someone please tell me what is wrong. I figure out what the proble ...Show All

• GrantV Encrypted .dtsconfig files

  Hi all, Is there any plans in the pipeline to provide us a way of encrypting our configuration files. I ask because I use configuration files everywhere in order to make my packages location independant but then you have to lock down access to those configuration files because they may have passwords in them. I'd rather they were encrypted. Thoughts -Jamie Jamie, Have you thought about securing the config files by setting up NTFS permis ...Show All

• CraigInGeorgia Need help running .dtsx package from web page

  I'm trying to get the syntax right to run a sql agent from my server that in turn will run a .dtsx package when the user clicks a button.  So far I have: in my .aspx page: < form id ="form1" runat ="server"> < div > < asp : button id ="contact_submitted" onclick ="Run_Process" runat ="server" cssclass ="submitbutton" Text ="Click here to start Processing" PostBackUrl =""> ...Show All

• DarkGREY Merge join problem

  I don't know if anyone is having this issue with merge join. I built a custom SCD to handle insert, update and delete records. So far I am having success with the delete but after I do a union all combining the updated and new rows, I merge them with the source. My proble is that is I have 10 records coming from the flow and I have say 30 records from the source, it will only load about half of these records. IBy the way, I am doing inner join. ...Show All

• Pawel Olszewski SQL Express user permissions?

  I'm trying to build a web application using SQL2005 Express and Visual Studio Express.  It all works OK on the local machine, but gives an error "Login failed for user xxxx\ASPNET" when used remotely.  I can't find where I can set login permissions for SQLServer 2005 Expresss - can anyone help, please Thanks John I need more information about what you mean by "login function" and what is the error ...Show All

• wetblanket found the fix for the issue

  I am having trouble to access Report Manager on a fresh SQL Reporting Services install on Win 2003, SQL 2000 SP3a machine. /ReportServer works fine, I've created a Virtual Directory /OnlineReports to allow anomynous access but /Reports doesn't work. So I can't add IUSR to the folder I need anomymous access on. Can somebody please help Thanks in advance. Well, now I have a different error. It said The request failed with HTTP status ...Show All

• Anne8408 BIDS problem

  I just installed the RTM of the standard version of SQL Server 2005 Client Tools on a Windows XP machine. When I initially opened the SQL Server Business Intelligence Development Studio, I received about 6 pop-up messages saying that it couldn't load a package (I didn't copy the message and can't get it to repeat now). When I try to create an Analysis Services package, I now get the message: "Could not load type 'Microso ...Show All

• olmich How to view reports from ASP.Net

  I'm new to reporting services and can't figure out how to access/show a report from an ASP.Net web page. It'd be nice is reporting services BOL explained this but it doesn't. I've put a reportviewer control on the an ASP.Net web page but everything I put into the ServerReport properties for the control are wrong. Help. Luis, It works now; I had to put report path "/somefolder/reportname". Thanks. ...Show All

• DanielTS help on SELECT

  Help on creating correct select query on the following table where customer = multi-race ( that is, customers that have value ‘1’ on more than one race category) Thanks! CustomerID Black AmIndian Asian White PacIslander Hispanic NoRaceDisc 32501 1 1 32677 ...Show All

• echom How to add My look and feel

  I would like to browse for reports, schedule delivery and render the reports from my web pages instead of <URL>\Reports. I seen some SharePoint integration examples, but is there a tutorial or walk-thru for how to integrate the Report Server into my own pages build a tree with exisitng reports and link them to the rendering page Take a look at these webcasts http://blogs.msdn.com/gsnowman/archive/2 ...Show All