Satya, Microsoft said with SQL Server 2008 and SQL Server 2008 R2 Reporting Services, you cannot change the location of the logfiles. It can be done...
A screen shot of the reportingservicesservice.exe.config file.? The only modification I have is added this line " <add name="Directory"...
No restrictions on the server. The SSRS account has rights to the folder. I even made sure by logging in with the SSRS account and creating a file...
Satya, The SQL Server Service Account has write permissons to the folder. I tried it againafter confirming the permission but still did not work....
I did that too. Did not work. Maybe an issue witn our permissions. I am able to create a file in the relevant log folder on D:\. using the...
Satya, Thank you for replying. I did add the Directory value to ReportingServicesService.exe.config file. I then restarted Reporting Services,...
How do I change the location of the Reporting Server log files? By default they are created on (our server) C:\Microsoft SQL Server\<SQL Server...
We are using EE. We have an Active/Passive cluster.
Since we have a copy of SQL Server installed on the Passive node, won't that take care of the license?When failing over from Active to Passive, we...
Going to use it more for the purpose of displaying data. Have a number of 'select' statements that return a large number of rows/columns. Thought by...
Buying another server for the replicated databases. The node has 8CPUs 32RAM, just sitting out there. Thanks for your reply.
Thank you for reply. I should be been more descriptive, meant, I will setup an instance on the Passive node that contains a copy of the databases....
Hello, Currently have an Active/Passive Cluster. Looking at using the Passive node to setup replication for some of the databases that are on the...
Thanks. Did read that. We are using SQL Server 2000. Just wanted confirmation based on what I read. Thanks.
Hello, RAM is 32GB. Memory allocated to SQL Server is 30GB. AWE is enabled. What should the Performance Counter - 'Total Memory' for the SQL...
Yes, have the /PAE switch on both nodes. AWE enabled is enabled too. I have set a whole lot of performance counters, don't see anything abnormal...
SQL Server 2000 - Enterprise Edition - SP4 Windows 2003 - SP2 8 CPUs RAID5
Hello, Total Physical Memory on the server is 25GB. SQL Server 'MAX MEMORY' is set to 20GB. The SQL Server has been hanging. When this happens...
Yes, that is true. The Index Scan that the optimizer is using is the best option in this case. Thank you. I have created indexes on all the temp...
Thank you all for your replies. The temp table is only being used in join statements. There are no filters specified in the query. I did use the...
Separate names with a comma.
