Answer Questions

• aghoneim SQL SERVER & Coldfusion connection problem - server newbie

  I've just updated my XP and installed SQL Server 20005 Express but can't connect to my Coldfusion server. I opened up Studio Express and created a new database. I tried to go to Administrative Tools and establish an ODBC connection there but can't get a validation. The Coldfusion Admin won't validate it either. Where do I start to solve this problem. Thanks for any help! Rob Painful! - well I think I have good ...Show All

• saqib shahab baloo service broker error : Connection handshake failed

      When I configure SSB in two machine to send message, I get a error message in target machine SQLProfiler:     "Connection handshake failed. There is already an existing connection with the same peer and this connection lost the arbitration. State 80."     Then I get another message "This message could not be delivered because it is a duplicate.", but I am sure the configuration of routes is r ...Show All

• Cleiton Garcia Reporting Service Matrix in a table

  Hello, Can anyone tell if and how a Matrix used as a Pivot Table could be put in a Table with several Datasets. Thank You in Advance GregoryI ...Show All

• KristofferSjoo Configuration files and variables

  Hi .. I need some information on the package configuration files. i.e how to set the configuration parameters from outside the packages. Pls provide me some detailed information along with examples. I want to make my packages to read paramaters from the configuration files as we have in .NET(web.config)//// Secondly I want to know how to play well with variables.. i.e setting a variable.. reading a variable.. passing a variable in the ...Show All

• Brock Andrew Sql Sever 2000 Reporting Services

  Hi,   I wanted to know if there was any way of setting the SMTPAuthenticate in the RSReportServer.config file, so i could connect to a remote SMTP with username and password thanks in advance kered In order to send emails you need some SMTP server that you have permission to send email to.  If you currently have RS set up to use the SMTPServer setting then you can make your local SMTP server r ...Show All

• Cory E How find WHICH HW requirement that is not met?

  Dear All, I get a warning from the SQLExpress 2005 installation that a hardware requirement is not met. The error printout gives absolutely NO info about which requirement that is not met. So far I have manually scrutinized the HW req's and compared with my machine and found no errors. Is there a test program somewhere that can tell exactly which requirement that is not met How can this error message have passed system test I reminds ...Show All

• ShimpiSuhas [Expired subscription clean up] job failing

  Hi, The "Expired subscription clean up" job at the distributor keeps failing with the following error. Any ideas what it could be Message Executed as user: domain\servicesql. The Distributor has not been installed correctly. [SQLSTATE 42000] (Error 20036).  The step failed. Thanks, Priyanga This did not fix the error, and I'm running SP2 on SQL Server 2005. Any other solutions available THANKS! Th ...Show All

• Shuja login problems after database move

  I'm trying to move a darabase from one sql2005 server to another sql2005 server within the same domain. I have tried both backup/restore and attach/dettach and get the same problem. With this database I'm using a SQL Server user, the user name is on both servers with exactly the same password. On the new sql 2005 server after I have moved the database to it, if I goto security->Users and do properties on the username. It says the ...Show All

• J.Bizzle security context could not be retrieved

  some time back i had problem with sending the service broker messages on remote machine, I had some security issues and they were resolved by the help of Remusu. since the ip of the remote machine was changed in between so i just re-executed the same scrips which used to successfully send messages on the remote machine.(I just updated the IP in the route ) To my surprise same script did not work now where as no change have been made. ...Show All

• Raymundo Chapa G Changing Database collation

  I am trying to use DTS to change the collation of a database.  I am using SQL 2000.  The default is Case Insensitive, and I am trying to change one of the databases from Case Sensitive to Case Insensitive.  I have created a new database with the proper collation, and I am trying to import all the database objects.  I want end up with the exact same database with the collation the only thing that is changed.  I have ...Show All

• Apparel1 SQL Server engine vs. Analysis Services: are they different engines?

  We currently run monthly computations using a SQL Server database and SELECT, and store the results in SQL Server. Before publishing the results, they are validated by a 3rd party, who recomputes the values based on the raw input data, using a program, and compares the results. We are considering bringing the validation step in-house. The requirement is that we recompute the validation numbers using a "different way", and we are ...Show All

• KH Tan sql DB on Server1 and SSIS server on Server 2 problem

  I want to deploy my packages to the MSDB on Server1 and I want to use the SSIS server on Server2 to execute those packages. so: Server1 = SQL Server, Server Agent Server2 = SSIS server, SSRS server, SSAS server Question1: I'm using this setup because then the CPU on Server2 is used for processing the package, right So ... I want to execute a Job on Server Agent on Server1 to run packages stored also on Server1 but the SSIS ser ...Show All

• Learning WPF SQL Agent Failing when trying to run my SSIS Package

  My SQL Agent was working fine.  Now when I try to run it, it failes when trying to run my SSIS package.  I looked in the logs, and job history, no luck in finding any critical errors. My SSIS package runs fine through VS 2005 in debug mode. Here are the only errors: 01/04/2006 09:53:48,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect 01/04/2006 09:53:48,,Warning,[260] Unable ...Show All

• sean_kirkpatrick SQL Server 2000 DTS Tools Web Download

  Is the Web Download to install SQL Server 2000 DTS tools available yet If so where Thanks Darren Can we install the SQL Native Client on a SQL2000 box   would that make any difference to the Management Studio Scott, There is no documented resolution from Microsoft that these forums will be frequented by MS staff. You should seek support via your MSDN subscription and then PSS as far as I know ...Show All

• kskwon SSSB Error Message

  What could be causing the following: This message could not be delivered because its message timestamp timestamp has expired or is invalid. Yes, you must synchronize the clocks. Is OK for the computers to be in various geographical locations (different time zones) since the time used for messages is GMT. In Windows the "Windows Time" service is ussually used to achieve clock synchronization between machin ...Show All