Answer Questions

• Karthikeyan Mahadevan The underlying connection was closed: Could not establish trust relationship with remote server.

  Hi, I am installing reporting services sp1 in loadbalanced servers. I keep on getting this error upon installation and upon configuration of target url in the config files. The underlying connection was closed: Could not establish trust relationship with remote server. Its not with the ssl since the ssl uses the full dns and is valid. So i was wondering what else needs to be done to fix this error. Thanks! karen What do you mean by "getting the error during installation and configuration" Are you able to access the report server on individual NLB nodes using SSL Basically make sure when report server is accessed, the CN name in the certific ...Show All

• thomas f Display SQL Information in VB

  How can I display and retreive information from an SQL Express 2005 database in a Visual Basic Express 2005 application I know that I can drag and drop a node onto the form (to display a sort of spreadsheet), but the method I wish to approach is to display information in a text box. Start here to learn about all kinds of databinding goodness. Mike ...Show All

• CharissaJB123 date parsing

  Hello, I have a source with two smalldatetime fields, the first field contains 8/1/2006 12:00:00 AM, and the second field contains 8/10/2006 7:57:00 PM. I would like to have the date from the first field and the time from the second field. No chance of changing the source system to do this for me. What I have so far works, except the time portion is converted to 19:57:00 instead of 7:57:00 p.m. Any Ideas My expression is below. (DT_STR,2,1252)DATEPART("month",FIELD1) + "/" + (DT_STR,2,1252)DATEPART("Day",FIELD1) + "/" + (DT_STR,4,1252)DATEPART("Year",FIELD1) + " " + (DT_STR,2,1252)DATEPART("Hour",FIELD2) + ":" + (DT_STR,2,1252)DATEPART("Mi ...Show All

• rob_a89 Filter measure

  I have a delima. I have a dataset that needs to return "Fatalities Involving drivers age 15-17". For years 2003 , 2004, 2005. So i set up 3 different filters: Year : 2003,2004,2005 Person type: Driver Age : 15,16,17 Now this is fine for getting a crash count and fatalities (for teen drivers). But i want the fatalities for everyone ( All Person Types) and (All Ages) ...how do i go about this. All i get right now, is the fatalities for Drivers 15-17. Please help..im confused! That would show only the fatalities for what ever is selected. But it will not show all the fatalities . I heard something about a filter mdx que ...Show All

• TkNeo Problems Deleting / Renaming Dimensions

  I had a problem with a dimension and so decided to re-created it. Once I was happy with the new dimension I deleted the old and renamed the new to what the old one was called previously. When I try and build my cube I get the following error: Error 18 Errors in the metadata manager. The dimension with the name of 'dim_product' already exists in the 'Sales_AS' database. Not sure why this is happening as I thought I'd got rid of all trace of the old dimension. If I rename the new dimension I have no problem. Is anyone able to explain what's going on here Thanks. If you deploy with the default settings the old dimension still exists on the server and if you want too deploay a second one with ...Show All

• Bruno Ribeiro SQL Server over Point-to-Point T1

  I'm running SQL Server 2005 on a Server 2003 machine serving both our home network as well as a remote site through a point-to-point T1. While file transfer speeds are up to par, the remote site's interaction with SQL Server (Point of sale system) is very slow. After testing I am certain that it has nothing to do with the actual physical machine in place neither is it an issue with the program itself since speeds are as they are supposed to be over the home network lan. It seems that there might be a packet size issue or something of the sort. Has anyone dealt with this before or have any thoughts Thanks, Peter Is Point-to-Point T1 the same as Frame relay or a regular T1 Line How big is your resul ...Show All

• MarcGBeauchamp MCTS Documents

  Hi, Anyone please do tell me where i can find documents to prepare for MCTS ( SQL SERVER 2005 ) Thanks in advance. ohh well, Thanks a lot ! If you're trying to learn SQL, a great start is to install the evaluation version and play around with the tools, product, etc. If you're looking for specific books or sights, someone else may be able to suggest a few. Let us know a few more details and we can fill in the gaps. Thanks, Sam Lester (MSFT) It's probably too later but I just joined here and acquired this cert last month this is what I did: Read through cover to cover o'reilly's "Learning SQL on SQL Server 2005" Took MS official course 2780 and then went back cover to cover wit ...Show All

• ChrisHelt Move data to DB2 on AS400 with SSIS

  Anyone writing data to DB2 on an AS400 with SSIS I cannot get the OLEDB destination configured correctly. I can set the destination up with a SELECT sql query, and preview the resultset. Attempt #1 When I try to set up a data source / conn mgr with the MICROSOFT OLE DB PROVIDER FOR DB2, I get an error when I test the connection: "Test connection failed because of an error in initializing provider. The parameter is incorrect." I have the login and password correct, and I get the same error regardless of whether I have the server name or the IP listed, and whether I provide an Initial Catalog or do not. I always get the same error. BJ, That is an error specific to the as400 ...Show All

• Shaun M. How can I export data to a .sql with insert statements?

  Can someboby help me sith this issue. thanks in advance There's already data in the tables and I would like to become something like this... INSERT INTO Vertices VALUES (-99.6875 , 13.9952516555786, 0, 1); INSERT INTO Vertices VALUES (-46.597225189209, 14.1290817260742, 1, 1); INSERT INTO Vertices VALUES (-34.9146385157818, -8.08516788087916, 2, 1); INSERT INTO Vertices VALUES (-66.7407750757877, -54.3090734484738, 3, 1); INSERT INTO Vertices VALUES (-69.9132614086578, ......... Ariel Valentin wrote: Did you figure this out I have the same question. I am able to use 3rd party tools, but I was hoping to do it with SQL Server Mgt Studio. No, you can't do it in SSMS, you can script the da ...Show All

• rwbogosian Reading value of a Windows variable in a SQL script?

  MS SQL Server 2000 Hello Everyone, I am executing a SQL script from a Windows batch program using isqlw.exe as: rem - test.bat set SCRIPTS=C:\Scripts set TMP=C:\Temp isqlw.exe -S dbserver -E -i %SCRIPTS%\test.sql -o %TMP%\test.tmp -FA Is it possible to read the value of the SCRIPTS or the TMP variable inside test.sql Thanks for any suggestions. I am 99% sure that you can do anything you need to do with 2000 using SQLCMD. You wouldn't be able to do things in 2000 that are only supported in 2005, but the tools should work fine since it wouldn't rely as heavily on things like system tables as a GUI tool would, and the GUI tools are backward compatible too. You can download SQLCMD and ...Show All

• Warboy how can I obtain message_id?

  Hi all! How can I obtain message_id when I SEND the message, before I execute RECEIVE statement Thanks a lot for the help! Hi, SimonS_! Thank you for fast response. I'm send the message in one procedure: create procedure [dbo] . [proc_Client] as begin set nocount on ; declare @conversation_handle uniqueidentifier begin dialog conversation @conversation_handle FROM SERVICE [My Service1] TO SERVICE [My Service2] ON CONTRACT [Custom Comtract] send on conversation @conversation_handle message type [//Messaging/CustomMsg] ('message data' ); and here I want to save the Service Broker message_ID in the my table end con ...Show All

• Leandro Loureiro dos Santos SQL Server vs. XML Configurations

  I have been experimenting with both XML and SQL Server Configurations. Management would really like to go with the SQL Server Configurations, but I seem to be having problems with them. The main goal is to be able to create a configuration for each connection and have every package refer to its specific configuration, therefore in the future we could change say our SA password and only have to update this in a few places rather than for every package. In order to experiment with the problem I am having I developed 2 identical packages, except one uses SQL Server Configurations and the other uses XML. The configurations save the exact same properties. With the XML package I can go into the configuration file and change say the passwor ...Show All

• Umachandar Jayachandran - MS Populate values for a parameter in a drop down list

  How to Populate multiple values for Parameters in reporting services.i am talking about the Default values for a parameter As i am a fresher in this field , i would like to know much about it I havn't worked on SQL Server 2000. As far as i remember it works in 2000 even. No other way, Multi Val Params only allowed in SQL2005, what i will say is the upgrade is painless!! Its not working multi value is not supported in sql server 2000 so any other way Still anyother way to work on with 2000 as i am working on with 2000 only You can provide comma separated values in the NON ...Show All

• Alexnaldo Santos Back to Parent Report button not visible

  When I preview a report that has a link to a details report page in VS a "Back to Parent Report" button is displayed. However, when I publish the report to the Report Server, the .aspx page doesnt display the "Back to Parent Report" button. Is there a setting I need to make to have the button displayed thanks, lance Was this functionality released Or is it still coming. I concur. I need to add the back to parent report button as well. Ok. So it sounds like you want the browser back button to take you to the previous page (when paging through reports), and you want a separate "back to parent" button. Once you jump back to parent, I guess you would expect ...Show All

• Vipul123 How to read sql tasks and so on from a package programmatically??

  Hi everyone, Once I've accesed to package by means of LoadFromSqlServer method how to read its Sql Tasks, for example I'm trying with the Executables property but unsuccessfully results: pkg.Executables.Item(0) Thanks in advance, Does anyone have any idea Thanks again, Our goal is just to obtain the metadata for each SSIS. Now, we've got only ten SSIS but in a future there will be a lot of them running. Thanks. Do you receive an error message Have you read http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.package.executables.aspx Enric, You'll want to cast the executable from the package's executable collection to Microsoft.SqlServer.Dts.Tasks.Execut ...Show All