I am just wondering if anyone knows which options are available to you in the RSReportServer.config file for the <Render> tag. I am trying to hide some of the options for certain reports when they are exported.
Thanks in advance.
Eduard K
i try to set as follows:
<SMTPAuthenticate>1</SMTPAuthenticate>
<sendusername>xxxx</sendusername>
<senduserpassword>xxxx<</senduserpassword>
but it is not correct,how can i do?
thanks
Dear All,
i am a new in the SSRS , and i face a problem when i try the link http://localhost/reportserver
an error message appear as the following
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerRSReportServer.config' is denied
(i am accessing my PC with a user that under domain differ from my local domain i dont know that if the information help or not )
i dont know what i do , but i excepect someone answer me soon.
Best wishes and sorry for the long talking
Maylo
Hi,
I've just installed the new SQLSRV 2005 Express Adv Ed (ASP.NET 2.0.50727) and also installed the reporting services. Trying to browse the ReportServer website (via inetmgr or //localhost/ReportServer/) returns the following error (using Windows Credentials):
>>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
Access to the path 'c:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerRSReportServer.config' is denied.
<<
How can this be fixed? All hints appreciated. Thanks
I am trying to work through the SSRS 2005 Forms Authentication sample and have the form up and running on a W2K3 server. I am able to connect to my SQL Server and enter a username and password for the admin user, but when I return to the form to login, I receive an error on my report server.
When I check my server's event log, I see the following alert:
The Forms extension failed to read its configuration settings from the RSReportServer.config configuration file. The extension is not available to users.
My question is: do I have a permissions problem where some user cannot read the RSReportServer.config? If so, what user do I grant read access?
Hi!
I want to set SimplePageHeaders to true, but I'm not sure how can I do it. What is the format I should use, and where should I put it?
Thank you!
for example, if i was to change my smtp server within the rsreportserver.config file, does it automatically update in realtime the second i save it or do i need to refresh something?
any insight on this would be grateful before i do anything.
thanks!
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 ?
I am using window 2003 system where smtp is not installed and i don't want to installed it.
If there is another way to change only in Rsreportserver.config file except pick up directory.
thanks in advance
Ashok kumar yadav
I cannot determine why only PDF and EXCEL show as export formats from IE, while all of them (XML, CVS, TIFF, etc) show from Visula Studio.
Using Format=IMAGE on the URL launches Tiff, so I know the machine supports it.
I have tried adding Visible="true" with no change.
I tried changing the order of the Extension elements with no change.
All I really want is to get IMAGE (Tif) to show, since PDF strips leading spaces (unacceptable) and whatever the default is (HTML?) doesn't handle overlapping lines and rectangles with the data. TIFF seems to be the only useful view choice!
Any ideas would be greatly appreciated.
Is there a way to modify the RSReportServer.config file with a Web Service call. We want to install an app and have it modify the Renders. We want to remove the Tiff export for example. We also want to add simple headers to Excel. Right now we have to open the file and then make our edits.
View 1 Replies View RelatedIf we decide to make Report Manager the UI facing both internet and intranet users, but prefer that our intranet users not face the performance hit created by SSL, and prefer that SSL be turned on for internet users, what options do we have for configuting our RS environment if all users ultimately use the same reports and we wish to keep number of licenses at a minimum?
View 1 Replies View RelatedCurrently have a single hard coded file path to the SSRS config file which parses the file and provides the reporting services web service url. My question is how would i run this same query against 100s of servers that may or may not share the same file path as the one hard coded ?
Is there a way to query the registry to find the location of the config file of any server ? which could be on D, E, F, H, etc.
I know I can string together the address followed by "reports" and named instance if needed, but some instances may not have used the default virtual directory name (Reports).
Am I going about this the hard way ? Is there a location where the web service url exists in a table ? I could not locate anything in the Reporting service database. Basically need to inventory all of my reporting services url's.
Hello all,
I'd like to know what's considered a best practice in the following scenario...
We're in the process of converting DTS to SSIS, our current SQL2K setup has one DTS package per database, each database and package are mirror images of each other, with the exception of connection properties and the files path's they pull from. (Occasionally there may be a one off Execute SQL Task that differs from package to package...but this will be handled in a different manner outside of the package from this point on)
From a administration perspective this has been somewhat cumbersome, as every time there is a schema change we need to update the transformations in each individual package...after updating 120 packages my index finger has a bad case of carpel tunnel!
My thought with SSIS is that I can create one package, with many configuration files (one for each database).
Now my question is, 1) is this a good idea? 2) Anytime we create a new database (New Customer = New Database) and need to create a new xml config file, do I have to create the config in BIS/SSIS package then redeploy the package?...or Can I simply add a new config file to the appropriate directory and reference this config in the scheduled job?
Any suggestions are greatly appreciated!
Very often, when I generate SQL scripts for a table, I forget to go to Option tab to click the pk, default, index boxes. Is there a way to permernatly set the whole sql server generate sql scripts options ONCE?
thanks
David
HiI have created a Sql Script through Enterprise Manager for Drop acolumn. By default its creating lot of 'SET' commands. I doubt allthese SET options are required or not. Pls comment on this issueBEGIN TRANSACTIONSET QUOTED_IDENTIFIER ONSET TRANSACTION ISOLATION LEVEL SERIALIZABLESET ARITHABORT ONSET NUMERIC_ROUNDABORT OFFSET CONCAT_NULL_YIELDS_NULL ONSET ANSI_NULLS ONSET ANSI_PADDING ONSET ANSI_WARNINGS ONCOMMITBEGIN TRANSACTIONALTER TABLE EmployeeDROP COLUMN OrderDetails_IDGOCOMMITDil
View 2 Replies View RelatedHi ,
I could do with a couple of pointers to the best options to acheive my goal, I'm pretty close with the way I've done it, but I feel there is a more elegant solution out their so your help would be most appreciated.
The problem is finding the best way of moving some SQL Server 2000 changed data into sql server 2005. We are only interested in some tables in 2000 (and sometimes just subsets of those). Because there are quite a few tables and the we want to set up a schedule to run periodically, we chose SSIS. The main reason for this is to utilise a for each loop that pulls each tables name from a one column staging table of table names. (that way we can do more or less comparisons by simply adding and removing from the staging table) Also in this loop, using the table name as a variable, we run an exec sql task along the lines of 'SELECT * from varTable EXCEPT SELECT * from varTable_tracker' which gives us the difference beteween the two tables (where the tracker table is a copy of the data table which is sychronised at the end of the job run). So far so good. Now the tricky bit, EXCEPT only works under 2005, the tables are in 2000 so we ended up having a linked server in 2005 back to the 2000 table. Is there a way of acheiving the same result without involving the linked server - or is there a task (script?) we can run to verify the linked server is up before we excecute the job -we already run checks on Connection Managers to see if they are up but never tried linked servers? Lastly, will performance be an issue
Thanks
anyone know about the undocument options of DBCC?
which options are undomented?
i.e.
log
There are only a few options which are documented in SQL Online Books
thank in advance
Is it necessary to reinstall SqlSvr 6.5 in order to chance
from 'per server' to 'per seat' licensing ?
SQL 6.5
What are the most critical "dbcc" options that should be run to insure the sanity of database and DBA alike? Do these have to be run in single user mode or can they be run while users are on the system?
Thank You.
An automatic monthly delete has recently grown from 15 to 20 million rows. It is now filling my 70GB T-Log completly. I don't have any space to expand the T-Log. Do I have any options other than reducing the number of rows in the delete?
View 2 Replies View Relatedhey guys, i need your help please.
here is the scenario:
1. I need to return a data back to client (result set varies 20-10,000)
2. I only want to show 20 records at a time
3. To get info i need to display i need to join 10 tables
When there are small #s of records it works but when i get over 8000 then it becomes a problem:
1. The first version was:
Get all data using big query and return everything back to client and display only 20 at a time (not very proficient).
Takes around 15 seconds to view 20 records.
2. Inspired by 4GuysFromRolla (http://www.4guysfromrolla.com/webtech/062899-1.shtml)
Use Stored Procedure w/ server side paging logic to get 20 records at the time. I had to pass every filter parameter and stuff. SP had to sort resultset and return only 20 records i need to display.
Takes around 5 seconds to view 20 records.
I still think it's slow, i know this is a very broad question but is there any other way to do it, logically?
Any help is appreciated.
Wojo.
Hi folks, Recently i've installed a fresh Installation of Opertaing Sys and SQL.
Win 2000 server, sp4
SQl 2000 Enterprise, sp3.
I am using Domain user service startup for sql and is member of domain admin. I've manually added the user in Local-Admin group of the system. Obviously it's also has Sys-Admin server roles.
The problem is; when i use enterprise manager and change any of the server settings; Priority Boost or Fix Memory Allocation for the Sql server, nothing happens, the options dialog box closes and doesn't ask for restarting the server neither does the settings take effect when i restart SQL.
However if i change the settings using sp_configure using the same user; it works. i've assigned a fixed memory to SQL but the option "Reserver Physical Memory For SQL" won't work. Couldn't find this option in SP_Configure.
Any ideas, what has gone wrong.
Hi all,
This follows on from a query I had a few days back (and for which I was promptly flamed! However, I've got skin like a rhinoseros, so here goes...)
I have a table - ProjectSite - that is pulling information from a two tables (Project and Site). This table contains data regarding which sites are part of which project.
I now want a means of reporting dates against this. The problem is that each project has bespoke milestone dates, so I can't just create columns in ProjectSite. The only solution I can see is to pull each project (and there's quite a few and its corresponding sites into a new table) and then I can create my bespoke columns.
Does this sound like the best viable option, or can anyone suggest another means of doing this?
TIA,
SamuelT
Hello all,
I am considering the different options for package deployment on the server.
Until now, I have found several different ways to deploy packages to the server (File System):
Using the Import option from the Management Studio (only one by one)
Using the Deployment Utility (Needs building the whole project. Opens all the packages in debugging mode, cannot deploy to different folders)
Using the dtutil by constructing a command line for each package deployment. (complicated)
Simply copying the files from the local project folder to the "Program FilesMicrosoft SQL Server90DTSPackages" folder on the server.
Does anyone have any other suggestions for deployment?
The 4th seems to be the easiest one, but I seen anybody suggesting such an action. What's the downside of such an action?
Thanks,
Liran
I hoipe someone can point me in the right direction here.
I have an application with the following requirements (using SQL CE 2 alas)
A set of tables on the server that need to be imported to the handheld. Using rda, I need to get the modifications to these tables from the server (add/edit/delete) but the handheld will never update these tables.
A set of tables on the server that need to be imported to the handheld. The handheld needs to add/edit existing records, and it needs to get any changes from the server.
A set of tables on the server where the handheld needs to import a subset of the records. It needs to add (but not edit) new records, upload the new records to the server, and download any changed (add/edit/delete) records to the handheld.
What tracking options should I use in these 3 cases?
The problem comes in that I need to have some foreign key relationships in the database on the handheld. Since rda munges the names of primary keys (and indexes), I do not know of a good way to add these foreign key constraints. Any suggestions?
Thanks
Hello all. I am currently doing some research into options for
setting up reporting. Right now we have a server on EE that's
getting hit a bit too hard by the reports. The budget is
currently a bit low, but we already have a second server
purchased.
For our reporting, we need data that is up to date within the last 15
minutes (less if possible). Because of the potential size of some
of our transactions, I've ruled out log shipping as being too much
downtime of the reporting data while the second server is catching up
to speed. So, I'm trying to figure out what reporting options I
have left open to me.
1) I understand that for reporting purposes, a snapshot must be taken
of the mirrored server. Why are reports not able to run directly
off the mirror live (or am I mistaken?).
2) Is it possible to mirror from EE to SE (remember, low budget for the second server)?
3) How high is the overhead when doing a snapshot every 5-15 minutes (
I would think it's machine specific, but overall is it pretty quick or
prohibitive based on how often the snapshot would be needed)?
4) Is replication perhaps a better option based on how up to date the
data has to be? Are there any other options that may be available
for near-realtime reporting?
Thanks in advance for your time.
Hello,
I have been attempting to locate a hosting company that offers SQL Server 2005 in addition to Analysis & Reporting Services but have been unable to find a hosting company which does so without purchasing the entire server. Anyone know of a company?
Thanks in Advance,
Garrett
Sorry I am a newbie in SSIS.
I have got a small project that requires to feed in a .CSV flat file and load the data into SQL server 2000.
I developed a SSIS package for this and get it working in my computer, but I need to deploy it to customers that they don't have VS 2005 or SSIS installed. May any one of you give me some clues on that?
I played around with the flat file deployment and again it seems only working on my computer as I have everything installed.
Hello all,
Just wanted to get some feedback on this scenario. I will be developing an ASP.net application for our local intranet that employees will have access to. It may also be implmented to allow employees to access this ASP site from home as well. I would be using SQL Server 2000 as the backend DB and wondered what type of licensing would best fit this scenario?
Sorry if this is double posted....seemed to be having some issues with posting.
Thank you!
Hi,
I was recently experiencing a slowness when executing stored procedures from a .NET Application, but it went fast when executing from Query Analyzer. Research led me to find that by turning ArithAbort ON that it forces the SQL Server to use the same Execution plan whether the request is coming from Query Analyzer or the Application.
My concern now is the effect of ArithAbort. I understand what turning this option does, but I am trying to think of a scenario where turning it on could be bad. Does anyone have any suggestions on what I should be aware of when disabling/enabling ArithAbort or ArithIgnore?
Thanks.
-Brian
Hello, I am trying to bind a sqldatasource control to the gridview.
I have selected the sqldatasource control and specified the connection string, on configure Select statement page under advanced options both the check marks
Generate INSERT, UPDATE and DELETE Statements
Use Optimistic Concurrency
are disabled for me.I have a proper SQL Server database not an express data base, how do i get to generate the InserCommand, EditCommand etc
Any help would be great .. relatively new here
thanks
Morning all,
I'm writing an Insert form which will write records to a few tables. What I want to know is how do I write multiple answers to one question in different rows in the table but keeping the ID?
For example.
The form has the following fields:
HotelIDHotelFacilities (CheckBoxList)
Now each hotel (in this case) will only have one ID but more than one HotelFacility .
How do I get my table to read...
HotelID
HotelFacility
1
Bar
1
Restaurant
1
Cafe
1
Wi-Fi Access
I presume INSERT INTO tblHotelFacilities(HotelID, HotelFacility) VALUES(@HotelID, @HotelFacility) won't write more than one selected facility?Thanks,Brett
Advanced SQL generations options:
generate INSERT, UPDATE, and DELETE statements is all greyed out?
in my sql data source control.?
I have made a brand new instance with sql server management express....have I missed something?