Answer Questions

• Richard Grant Have to install to c:\ ?

  I'm having a hard time with installation of SQL 2005 on Windows Server 2000. I'm trying to put everything on d:\ but I think it is failing as a result. Is there anything I should know about this Thanks in advance. -Greg As a follow up on this, as soon as I installed everything to C:\ everything worked stellarly. In listening to the traffic here, it appears 98% of SSRS users are using a non-distributed configuration. While the product sup ...Show All

• Alejandro Rodriguez Setting Paper Size to be default A4

  Hi, I have been trying to configure the Paper Size to be default "A4" instead of "Letter". My Report is configured to 21cm x 29,7cm and margins 1,5cm. The Body is configured to 18cm x 26,7cm. Everything looks fine in the Preview but the Size is always "Letter". The printers are all configured for A4 printing. Is there a way to set these default values in the Page Setup Toolbar or is it supposed to figure it ...Show All

• Laschek Interactive Sort on date field

  I have an RS 2005 June CTP report where the data source is an MDX query against AS 2005 June CTP.  I'm using Interactive Sort on several columns and it's working fine for the numeric and string fields, but it's sorting the date columns alphabetically instead of chronologically.  Is there a way I can specify that these fields are date fields and should be sorted chronologically Thanks, Dirk ...Show All

• DPP .NET Remoting or Direct Connection to SQL Server 2005 Express

  Hi,   I'm currently designing an application that I want to be able to connect to a SQL Server 2005 Express either locally, over the LAN or through the internet. What is the best way to go about this:- 1. Should I allow the client application to connect directly to the SQL Server 2005 Express database whether the database be on the local machine, over the LAN or through the internet. 2. Should I use .NET Remoting by use of a  ...Show All

• jjamjatra Sort on group total: How?

  How do I sort on a group total item Hi Robert, I have a similar problem, in my case I have: 2 row groups and 1 column group. The group names are: Row : CompanyName, TotalUsers Column: UserType Detail Group has a count of number of user in each type. I want to use interactive sort feature on my column group so that when I click on my column header, it sort my detail group data ascending or decending and companyName and t ...Show All

• dto Web Forum Setup Fails To Connect To Database Error :80004005

  In my string below, my forum setup up file, setup.asp , when run delivers an error that it is unable to connect to the database. Error: 800004005 I am running this from within IIS 5.0 aon a Windows 2000 Server, by right clicking the file in IIS and choosing "browse" I am trying to set this up so user IUSR_SERVER_NAME can "read and Write" to the database or instance I have created called rpggamerpro. The authentication in t ...Show All

• JustinSmith Problem in SQL Server 2005 Beta II

  Sir ,   I have problem to access SQL Server 2005 Beta II (April Ver..) – from Microsoft Visual Studio Beta II (Feb Ver.).   Error   A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)   How to solve it …     I'm ...Show All

• Mike_Kla Sql Server 2000 connection problem

  Hi all... I'm getting some problem while am connecting to my Sql Server 2000. I have design an application in vb.net and using remoting (Tcp Channel). But while connecting to the server am getting "your server is not confiured to allow remote access" can anyone help, thanks.... Hello I am facing same kind of problem.... But no solution yet... :( Your Sql Server is Behind a Firewall, if yes add po ...Show All

• pfear Replication Trigger Problem (SQL 2005): Assistance Please

  Our company is wanting to replicate a bunch of data down from our central server to tablet PC's. We really do not have anyone on staff with solid experience in replication, and have hit an error that we cannot seem to find any information whatsoever on. Here is the problem: When setting up a publication to replicate certain tables, we stop being able to do any updates on the tables. After some research, we were able to narrow the problem i ...Show All

• KevinMullin Using report parameters in data set

  I am trying to do some date manipulation in the data set based on a report parameter . The parameter is called RDate and is a datetime type. DATEADD(DateInterval.month, DATEDIFF(DateInterval.month, RenewalDate, @RDate), Month) When I "run" the dataset, I get this message: " Syntax error or access violation" When I replace @RDate with a "real" date like 1/1/2000 it runs fine. I have tried a variety of things ...Show All

• hrubesh Help files for MS SQL Management Studio Express?

  Hi Are there any specific Help files to download for SQL Server Management  Studio Express . I thought I saw a link the other day, but I am not sure anymore... Or is it part of the Book online for SQL Server Management Express I can't find reference to Studio in there... Thanks Gauguin   Hi, Here are some links for MS Sql Management Studio Express Help.   ...Show All

• ajes How can I configure sql mail in sql express?

  is that possible You asked about SQL Mail, thats a specific feature of SQL Server and it does not ship in Express. This is also true for Database Mail. The current version of express has as a reporting solution the report controls that are part of VS. An express version of Reporting Services will be made available, but its not part of Sept CTP and I am not sure if it will include sending mail SQL Express does not have SQL Reporting ...Show All

• DeepaHadimani How to make Custom Log provider appear in VS???

  Hi, I've created a custom log provider signed it put it in GAC and in ...\DTS\LogProviders restarted Visual Studio At this point I expected my custom log provider to appear in the drop down list of log providers when selecting SSIS | Logging..., but I only see the out of box providers. Any idea what I'm missing or how to troubleshoot it Do I need to reload anything in VS Thanks!Kristian P.S. Here's the first ...Show All

• David Crocker Changes not replicated to subscriber

  Hi, I hope you can help me with this. I am setting up a tranasctional publication with updateable subscriptions using: use [LIMS_PUBLISHER_TEST] exec sp_replicationdboption @dbname = N'LIMS_PUBLISHER_TEST', @optname = N'publish', @value = N'true' GO -- Adding the transactional publication use [LIMS_PUBLISHER_TEST] exec sp_addpublication @publication = N'LIMS_PUBLISHER_TEST', @description = N'Transactional publication with updatable subscription ...Show All

• ug751 ReportingService2005.CreateReport() warning...

  I am using Reporting Services 2005 on SQL Express with Advanced Services... I am dipping into the SOAP API and trying to add DataSources and Reports dynamically, as is how I would like to be able to deploy them... My problem is this: I have a shared datasource and a report that were deployed to the server via the 'Deploy' method in VSTS...I can access that report just fine, and it obviously uses the shared datasource... Next, I copy ...Show All