Answer Questions

• ryan.berry Help on replication from SQL 2005 to DB2/AS400

  I was trying to set up a replication process to move data from SQL 2005 to DB2/AS400. To get it started, I have create a simplest table (say, PERSON) on SQL 2005 server, and the same table (PERSON) on DB2/AS400. I have only one column SSN (of type int). I have journaled the table on DB2 end. I was able to have successfully configured publisher (on SQL 2005) and subscriber (i.e. a pushed subscription). I used transactional replication. And I ...Show All

• pascalh Error 404 when opening reportserver

  Hi, On a new WinXP Pro SP2, I've installed VS2005 Pro, IIS 5.1, and SQL SRV 2005 Dev Ed (in that order - in stalled accepting all default settings). Although the State of the Default Web Site is "Running", I can't open http://localhost/reportserver (not in IE6, nor with IIS manager). Even worse, http://localhost/ nor http://localhost/iisHelp/ won't open either. The IIS reply is "HTTP Error 404 - File or directory not found& ...Show All

• DDaniel Cannot generate SSI Context

  New install of SQL Server 2005 (x64) Standard after uninstalling previous version SQL Server (x86) Standard. After installation, client connections are receiving "Cannot generate SSI Context" error messages. TCP/IP Integrated Authentication is being used. Kerboros authentication is failing when SQLService is running under a domain account and works when running under local system account by reverting back to NTLM authentication. ...Show All

• CharlieDigital Navigating to a File

  In reporting services, does anyone know of a way to navigate to a file, rather than a Website or another report I know this is possible in Crystal, but was wanting to do it in RS. How about \\server\sharename\filepathandname.ext Ok...but you can't navigate to a file on some other server or directory Hi Hepper - You can place the file somewhere where it's downloadable and use the Jump to URL property to navigate to it. HTH. ...Show All

• JulieD 264] An attempt was made to send an email when no email session has been established

  Is there any way I can get sp1 please. I'm getting the same error no matter which email method I use. Thanks Sam SQL Agent jobs failing to send notficatin mails on 64 bit platfiorm using Databasemail issue is addressed in SP1 CTP It could be also of another issue that we have bug tracking that we are planning to get it addressed in our next release Since Databasemail is off by default and setti ...Show All

• NotaProgrammer Active Database Connections SQL Express, how many

  How can I determine if everyone has logged off of the SQL Express database, ie, no one else is connected. I need to clean up some files that are generated in my code, but I only want to do that when everyone has logged off the database In MS Access, I could try to re-open the MDB file exclusively. Is there a connection number etc Hi there, There isn't a connection number per se (well there is ...Show All

• Johan Normén - Nsquared2 "project creation error" with Ivolva Component Wizards for Integration Services

  Hi, I'm just getting started with SSIS and want to create a custom data flow component. I found the Ivolva Digital "Component Wizards for Integration Services" which says it make starting your own custom task or data flow component a snap by providing a functional base project for your task or component. Therefore I installed the Component Wizards for Integration Services and everything seemed to install ok - when I started Visual Stu ...Show All

• DarrenONeill111 XMLA To Create Dimension Attribute

  I am looking for an XMLA (or ASSL) script to add an attribute to a dimension. Can anyone help ...Show All

• kloepper Package Configuration wizard:-SQL Configurations Configuration filter not working

  Hi --I was wondering if this is a bug when I add new data in my table SSIS Confiurations and give wizard a new Configuration filter the package configuration wizard can not see the new values --the old values from the previous configuration are still showing---is there any known workaround or forced refresh I can do thanks in advance Dave Background: SQL Package Configurations are most important because they provide the possibility of a ...Show All

• nguyen_van Lookup transformation

  Hi Everyone, I'm trying to perform a lookup transformation. But the deal is, I have this one value that I am passing into the transformation, but I would like to gather all values that match the value I put in....does the lookup transformation do this I tried it, and it appears as if it only returns one value for the one input. After the lookup, I have an access OLE DB destination setup...so I can capture all those values that corresponds to ...Show All

• comcy SQL Mobile Server Tools install on SQL 2000 SP4

  I am trying to install SQL Mobile Server Tools (beta 1) on my SQL Server 2000 SP4 server.  I have already installed the SP4 Replication Components upgrade and my existing SQL-CE databases replicate ok, however when trying to run the SQL Mobile Server Tools (beta 1) install it fails the System Configuration Check with the following error: "You must first install the Replication Components for SQL Server SP 3a or higher or the SQL Server 200 ...Show All

• laputa92 SQL Server Date/Time & other data typesV

  Hi I'm have big problems trying to save Unicode information into my MS SQL Server 2000 Desktop Engine. Alright, so the problem I'm having now is I'm working with MS SQL 7.0 and PHP5. I've trying to get information to save into MS SQL, however it is storing it all weird. When I save the information and try to view it in Enterprise Manager it shows it has random characters but for some weird reason I can output that information on the page ...Show All

• Tomasz007 2005 64 bit : Client Tools for 32 bit.

  We installed 64 bit version of sql server. Now we need to install the client side 'SQL Server Management Studio' on 32 bit box. The 64 bit software does not support for the installation on 32 bit box ... what is the work around for this Thanks KM You would need to install from 32bit Media. As you've discovered, the installers on the 64bit media won't install onto 32bit machines. -Jeffrey All client tools in SQL 2005 ...Show All

• phc Major Problems with Calculated Fields

  Is anyone else having problems with Calculated Members Everything was working fine with viewing the cubes in the browser, in Reporting Services, and via Pivot tables...but once I put in some simple calculated members (simple parallel period functions), query times are extremely slow, everything locks up,unexpected Visual Studio crashes occur...SSAS pretty much becomes unusable. Anyone with similar experiences ...Show All

• Sandoc Semantic Model

  Hello, I got the following error while trying to create a report model: The semantic model is not valid. Details: The element 'Entity' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling' has incomplete content. List of possible elements expected: 'IdentifyingAttributes' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling'. Line 943, position 3. (rsModelingError) (Report Services SOAP ...Show All