SSRS Performance

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - table scan Hi All, When an end user view a report using report manager or a custom build web site, would query of the report scan the tables in original data base In this case it is a OLTP data base. Thanks Tag: SSRS Performance
  - 2
    - Foreign Key Constraint issues!! Hello! Im in a bit of a jam, and before I start pulling my hair out, I was wondering if someone could help me with this! We've setup and have been running our backend database for our new site for about two or three weeks, now. Everything has been running fine, except we've hit a little bump. When a User creates an account on our website, they have to specify which Organization they are with. Inside the database, this creates a record in the Users table, which then creates a new record in a UserOrganizations table. After these actions have taken place, a record is created in a UserOrganizationsAdded table. All of this is purely to keep track of people on our website. Below is a basic outline of our tables. Users ---------- UserID Username Pasword . . . UserOrganizations --------------------------- UserOrganizationID UserID OrganizationID RoleID . . . UserOrganizationAdded --------------------------------- UserOrganizationAdded UserOrganizationID Added AddedBy . . . Now- When a User registers on our site, it shows up in the UserOrganizationAdded table that they've added themself. In other words their UserID shows up in the AddedBy field of the UserOrganizationAdded table. This is what we want. However, we run into the problem, that if a User is for whatever reason rejected from our site, and their record deleted from the Users table, we get a foreign key error. I understand that we get this error because AddedBy is referencing UserID (the very thing we want to delete), and we are receiving this error because they are the same value. I guess my question is, is there anything we can do to keep the reference constraint between AddedBy and UserID and still be able to delete users Any help would be much appreciated!!!! Thank you! Tag: SSRS Performance
  - 3
    - Help in Query? i have a table for staff allocation.i need to allocated them for class input table Staffid Class Subject Priority Hours hrspday 2 7 1 2 10 2 1 7 5 2 10 2 2 1 1 3 10 2 1 5 1 3 10 2 3 1 31 3 8 2 o/p must be in first row staff id is 2 goes to class 7 for 10 hrs in week 2 hrs per day so output must be like this staff id class subject 2 1,1 7 1 2 1,4 7 1 2 2,1 7 1 goes on.............. here id 1,1 represent mon first peroid similiarly 1,4 means mon 4th hour so plz me tell query to generate output like this ... Tag: SSRS Performance
  - 4
    - x64 version of Microsoft .NET Data Provider for mySAP Business Suite Hi everybody, Does anyone know if there is a x64 version of the Microsoft .NET Data Provider for mySAP Business Suite for use with SSIS On the SAP site, I found a librfc32.dll which works under x64, but the x86 SAP Connector can't use it. Thanks Hans Tag: SSRS Performance
  - 5
    - How do I automate removal of reports? We can use rs.exe to publish a report automatically, but how do we do the reverse - remove a report automatically Is there a way by using a MS utility Is there a way by writing code, using library objects Part of the problem we face is having servers with RS all set up with a particular connection string and published reports. We then want to change everything and we want to do it automatically. Tag: SSRS Performance
  - 6
    - User credentials delegation from IIS on WinXP to SQL Server on Win2003SRV fails Problem: I am trying to create an asp.net website with integrated windows authentication to access SQL databases. IIS resides on WinXP and SQL Server on Win2000 SRV. Both are in the same NT Domain. IIS and SQL Server cannot reside on the same machine and a stand alone web server is ideal as the website needs to access multiple SQL Servers. IIS is set to Integrated Windows Authentication. The machine running IIS & the SQL Server are set to be "trusted for delegation" in active directory. The domain user accounts that will be accessing the databases are not marked as "Account is sensitive and cannot be delegated". The connection string that the web app uses to connect to SQL database is: "Data Source=PWSSQLT;Integrated Security=SSPI;Initial Catalog=Pace_Master;Persist Security Info=true" with which the user credentials should be flown to the SQL database. But instead the delegation fails and results in the following ANONYMOUS authentication failure error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. -------------------------------------------------------------------------------------------------------------------- Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Source Error: // Open the connection, and return it oConn.Open(); return oConn; Source File: e:\ING eIMS\App_Code\DataAccess\ConnectionManager.cs Stack Trace: [SqlException (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() INGRS.DataAccess.ConnectionManager.GetConnection() in e:\ING eIMS\App_Code\DataAccess\ConnectionManager.cs: DAActivity.Page_Load(Object sender, EventArgs e) in e:\ING eIMS\DA\DAStatus\DAActivity.aspx.cs System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) _______________ Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210 --------------------- Tag: SSRS Performance
  - 7
    - Running SSIS package (.dtsx) from a ASP.Net web service Where do I find about running an SSIS package (.dtsx) from a ASP.Net web service, particularly issues to do with permissions cheers Rob Tag: SSRS Performance
  - 8
    - ExecuteNonQuery hangs in Timer event notification If I call ExecuteNonQuery() in a timer event callback in a console application, it hangs. Why is that .B ekiM class Program { static SqlConnection conn = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=NONEOFYOURBISUINESS;Data Source=localhost"); static void Main(string[] args) { NativeMethods.MEMORYSTATUSEX mem = new NativeMethods.MEMORYSTATUSEX(); NativeMethods.GlobalMemoryStatusEx(mem); Console.WriteLine("{0} bytes", mem.ullAvailPhys); System.Timers.Timer aTimer = new System.Timers.Timer(); // Set the Interval to 2 seconds (2000 milliseconds). aTimer.Interval = 1000; aTimer.Enabled = true; // Hook up the Elapsed event for the timer. aTimer.Elapsed += new ElapsedEventHandler(OnTimedEvent); Console.ReadLine(); } private static void OnTimedEvent(object source, ElapsedEventArgs e) { NativeMethods.MEMORYSTATUSEX mem = new NativeMethods.MEMORYSTATUSEX(); NativeMethods.GlobalMemoryStatusEx(mem); SqlCommand cmd = new SqlCommand( "INSERT INTO Observation (StatisticType, StatisticObserved, StatisticValue) VALUES (1, @When, @AvailPhys);\n" + "INSERT INTO Observation (StatisticType, StatisticObserved, StatisticValue) VALUES (2, @When, @AvailPageFile);\n" + "INSERT INTO Observation (StatisticType, StatisticObserved, StatisticValue) VALUES (3, @When, @AvailVirtual);\n" + "INSERT INTO Observation (StatisticType, StatisticObserved, StatisticValue) VALUES (4, @When, @AvailExtendedVirtual);\n"); DateTime dt = DateTime.Now; cmd.Parameters.AddWithValue("AvailPhys", mem.ullAvailPhys); cmd.Parameters.AddWithValue("AvailPageFile", mem.ullAvailPageFile); cmd.Parameters.AddWithValue("AvailVirtual", mem.ullAvailVirtual); cmd.Parameters.AddWithValue("AvailExtendedVirtual", mem.ullAvailExtendedVirtual); cmd.Parameters.AddWithValue("When", dt); cmd.ExecuteNonQuery(); Console.WriteLine("Inserted {0}", dt); } } Tag: SSRS Performance
  - 9
    - Cannot get access to my Access 2003 database tables I developed a database with Access 2003 and everything was working good until my tech came in and reformated my hard drive and install a new Ghost image that met our company standards. Now I cannot go in and make any changes to any of the tables, queries and forms. All of this started when a new Ghost image was installed on my pc. The message I get when I try to open my database is "You do not have permission to run "tblSwitchboard." I get the same error message when I try to do anything at all on the database. I am at a loss as to what to do. Please help. Tag: SSRS Performance
  - 10
    - Combine two stored procedure results Hi, I have two databases DB2006, DB2005.I have the Stored Procedure getdata which has the 2 parameters startdate and end date.This Stored procedure exist in all databases. STored procedure CallGetdata @startdate datetime @enddate datetime If startdate < 1/1/2007 the call getdata in the DB2006 if startdate <1/1/2006 then call getdata in the DB2005. Here the problem is if startdate is 6/1/2005 and Enddate is '3/1/2006' then combine the stored procedure results from the DB2006 and DB2005 databases. I have one idea i.e create a temp table and insert the two Stored procedure results into it. Create #table1(name varchar(20)) insert into #table1 exec DB2006.dbo.getdata insert into #table1 exexc DB2005.dbo.getdata Select * from #table1 drop table #table1. Anyone please give me better idea than creating temp table. Thanks in advance Tag: SSRS Performance
  - 11
    - soap message exchange between .NET Webservice and stored procedure Hello, is message exchange between a .NET Webservice and a SQL stored procedure possible And if, could you please explain me how Or give me a tip where i can get more informations and maybe samples thanks for your help regards pamelia Tag: SSRS Performance
  - 12
    - Shared Connections and Stored Credentials for Subscriptions? I can't seem to get this to work and have to resort to a custom connection for each report in Server Manager. The problem with that is that I have to re-do it every time I re-deploy the reports. Is there a secret to this that I have not found yet Dick Campbell Tag: SSRS Performance
  - 13
    - T-SQL / varchar truncate solutions Why does SQL Server truncate the data being stuffed into "@vt" without throwing some kind of error or warning The print statement puts "123456" into the output window. Believe it or not .. our development team is actually trying to use this minor issue as justification for going with Oracle on this project, because they deem this as a data integrity issue and PL/SQL does throw an error. They would prefer to have an error thrown, instead of just silently truncating the data. declare @vt varchar(6) select @vt = '12345678' print @vt Is there a way that I can get T-SQL to throw an error or warning when this occurs I thought a UDT with a rule applied to it might do the trick, but that hasn't worked for some reason. Or any other creative solutions that you can think of Thank you, Mark Tag: SSRS Performance
  - 14
    - Data Flow Task Stuck I have a simple data flow task setup... 2 ADO.NET connection managers, each referencing a DSN pointed to a Unidata database. 2 DataReader sources, each using a single ADO.NET connection managers, running a simple SELECT statement from a table. I have a Union All transform setup to merge the data and write to a OLE DB Destination (SQL05 database) When I run the package, each source will validate, but only one will execute. The other source will do nothing. The data source will be colored yellow, and will just sit there. The package will just sit, almost like it is waiting for input. This behavior is not consistent, however. It varies which data source will hang, pretty much 50-50. About 25% of the time, both sources will execute, and all rows will be written to the destination. Any help is appreciated. thanks Tag: SSRS Performance
  - 15
    - Reporting Services Preview View different from Print Layout I'm currently using Sql server 2005 Reporting Services. I'm trying to take data and fill in a form that I'm making a background image. When I go to preview all the textboxes filled with data align with the fields in the background image form. When I go to print they are off by a inch or so horizontally. Can anyone help me on this topic. Tag: SSRS Performance
  - 16
    - Delete row where a particular field value is not in a list I have a table which has a field called filename, thus the data in the field would look something like this: FileName.doc FileName.txt FileName.foo I need to delete several rows from this table where the filename field DOES NOT contain the following extensions (e.g. row with FileName.foo would be deleted): .txt .pdf .rtf .doc .htm .html .mht .mhtml .dot .wk1 .wk3 .wk4 .xls .xlw .asc .olk .pab .scd .ans .wri .mcw .wpd .wps .ppt .pps .xls .xlt .xlw Tag: SSRS Performance
- Next
  - 1
    - Does fragmentation changes after backup/restore operation? Hello, If i backup a database and then restore it, would physical structure remain the same specially fragmentation. I'm concerned about output of DBCC SHOWCONTIG. Senario: I want to check if client database needs defragmentation, so he's sending db backup file. But is it possible that when i restore it fragmentation info has got lost Thank you. STG Labs Tag: SSRS Performance
  - 2
    - sp_spaceused equivalent in CE? I am looking for a way to programatically determine the size of the data contained in a table, much like the sp_spaceused proc in SQL Server. Thanks. Tag: SSRS Performance
  - 3
    - Wat's the effective way to improve performance in table using indexing? Hi guys , assuming there's a table called 'transactions' which contains more than 1 million records and normally will retrieve the records for monthly/yearly summary report. There are 5 fields within the 'transaction' table which are : - transaction_ID (PRIMARY) - transaction_Name - transaction_Date - transaction_Amount - transaction_reference Right now I would like to add indexing feature and I was wondering which use I take it as index for the effective way. Normally those summary report will sort by date. Is it take transaction_Date as non-cluster index n transaction_ID as unique cluster index. Hope able to get any assistance here. Thx a lot. Best Regards, Hans Tag: SSRS Performance
  - 4
    - How to verify installed license I have inherited serveral SQL 2000 servers and need to know if there is a way to verify the license that was installed, per processor or Server + Cals. Thanks, Skip Berry Tag: SSRS Performance
  - 5
    - How to rename a column or table on the desktop? I am using the compact edition on a desktop using VS2005 as well as SQL Server Management Studio. None of those tools allow me to rename a column or rename a table. Can someone point me a tool the runs on the desktop (as opposed to running on a CE device) that allows me to do the renaming Thanks Tag: SSRS Performance
  - 6
    - CAB Files Can anyone Please point me to a place that I can find some documentation on what the sql.ppc.wce5.armv4i.CAB does I basically need to know which files are being placed in the handset by deplyoing the CAB file. Thanks, Farnaz Tag: SSRS Performance
  - 7
    - Executing an SSIS package containing Analysis Services from ASP.NET I'm trying to execute an SSIS package from an ASP.NET web page. Using some code from http://msdn2.microsoft.com/en-us/library/ms403355.aspx I have managed to get this working when executing a package that contains a stored procedure, however it does not work when there is an Analysis Services cube to build. Here is my code for the webservice Code Snippet Public Class SCCBuildDW Inherits System.Web.Services.WebService ' LaunchPackage Method Parameters: ' 1. sourceType: file, sql, dts ' 2. sourceLocation: file system folder, (none), logical folder ' 3. packageName: for file system, ".dtsx" extension is appended _ Public Function LaunchPackage( _ ByVal sourceType As String , _ ByVal sourceLocation As String , _ ByVal packageName As String ) As Integer 'DTSExecResult Dim packagePath As String Dim myPackage As Package Dim integrationServices As New Application ' Combine path and file name. packagePath = Path.Combine(sourceLocation, packageName) Select Case sourceType Case "file" ' Package is stored as a file. ' Add extension if not present. If String .IsNullOrEmpty(Path.GetExtension(packagePath)) Then packagePath = String .Concat(packagePath, ".dtsx" ) End If If File.Exists(packagePath) Then myPackage = integrationServices.LoadPackage(packagePath, Nothing ) Else Throw New ApplicationException( _ "Invalid file location: " & packagePath) End If Case "sql" ' Package is stored in MSDB. ' Combine logical path and package name. If integrationServices.ExistsOnSqlServer(packagePath, "." , String .Empty, String .Empty) Then myPackage = integrationServices.LoadFromSqlServer( _ packageName, "(local)" , String .Empty, String .Empty, Nothing ) Else Throw New ApplicationException( _ "Invalid package name or location: " & packagePath) End If Case "dts" ' Package is managed by SSIS Package Store. ' Default logical paths are File System and MSDB. If integrationServices.ExistsOnDtsServer(packagePath, "." ) Then myPackage = integrationServices.LoadFromDtsServer(packagePath, "localhost" , Nothing ) Else Throw New ApplicationException( _ "Invalid package name or location: " & packagePath) End If Case Else Throw New ApplicationException( _ "Invalid sourceType argument: valid values are 'file', 'sql', and 'dts'." ) End Select Return myPackage.Execute() End Function End Class This is the code from my page Code Snippet Protected Sub btnBuildDW_Click( ByVal sender As Object , ByVal e As System.EventArgs) Handles btnBuildDW.Click ExecutePackage() End Sub Protected Sub ExecutePackage() Dim launchPackageService As New SCCBuildDW.SCCBuildDW Dim packageResult As Integer Try packageResult = launchPackageService.LaunchPackage( "file" , "c:\ssis" , "PackageTest" ) Catch ex As Exception ' The type of exception returned by a Web service is: ' System.Web.Services.Protocols.SoapException lblResult.Text = "The following exception occurred: " & ex.Message End Try lblResult.Text = CType (packageResult, PackageExecutionResult).ToString ' Console.ReadKey() End Sub Private Enum PackageExecutionResult PackageSucceeded PackageFailed PackageCompleted PackageWasCancelled End Enum I'm using windows authentication and impersonating an identity. The identity has access to the analysis services role but the package still fails to run. Can anyone offer any help or advice on this Thanks Tag: SSRS Performance
  - 8
    - Upgrade SQL 2005 Standard to SQL 2005 Enterprise Can SQL 2005 32bit Standard edition be upgraded to SQL 2005 32bit Enterprise Edition in-place. Tag: SSRS Performance
  - 9
    - SQL Reporting Services performance on navigation pages. I am experimenting with SQL Reporting Services on a machine with SQL Server 2005 loaded and deploying reports to a different server. both servers are equivalent in resources. In the browser on the Reports machine when I first go to the Reports address, it takes a very long time to build and load the page. it then takes a long time for each drilled down page. Subsequent calls to the same pages are very fast if done within a certain amount of time. This implies that there must be some form of caching going on and that the cache expires after a period of time. I have seen in the RSReportserver.config file that there are parameters relating to report caching, but they all appear to reference the actual reports being generated. My issue is simply being able to build the start page and other navigation more quickly and to keep it active so it does not have to perform that build each time. Any information related to managing this situation would be very much appreciated.. Thank you, Ray Tag: SSRS Performance
  - 10
    - Determine if a column is indexed (and the index name) Is there a slick way to determine if all the indexes (if any) for a particular field let's say: tbPeople ID (bigint) FirstName (varchar(50)) LastName (varchar(50)) I need to determine if [FirstName] in indexed anywhere, and if so, what are the name(s) of the indexes. thanks ahead of time. Tag: SSRS Performance
  - 11
    - Personalize Reports for Each User Hello Everyone, I am trying to personalze my reports for each user, for example: Say I have a report which takes in userName as a parameter and then generates the report. Is it possible to use the same userName that the user used to login to the reporting services enviornment. This way the user don't have to enter their userName to see the report, it will be entered by default. Thanks a lot, -Rohit Tag: SSRS Performance
  - 12
    - excel data mining add-in for categorical data Thank you very much for your previous answers conserning clustering algorithm. I change a bit my data and now I can get two and three clusters as I wish. But now I have a different question. I wish to keep my Structure and Model for further trials with different algorithm values, like cardinality. I tried the following I selected in excel Data Mining and then the option cluster button. Then in the cluster wizard I chose analysis service data source and I reform the query as I need adding only at the end where "STAFF_YES" = 1. Then I choose the needed columns and target value. Finally I select browse model, enable drill through only and I finish the wizard and get some results, rather good. But i need to try again with different parameters. I tried Business intelligent Studio to check my Analysis service. The structure were here but when I changed any parameter and I tried to reprocess I got the following messages Processing Mining Structure 'try Structure_1' completed successfully. Start time: 5/8/2007 4:55:08 �̦�; End time: 5/8/2007 4:55:08 �̦�; Duration: 0:00:00 Processing Dimension 'try Structure_1 ~MC-__RowIndex' completed successfully. Start time: 5/8/2007 4:55:08 �̦�; End time: 5/8/2007 4:55:08 �̦�; Duration: 0:00:00 Processing Dimension Attribute '(All)' completed successfully. Start time: 5/8/2007 4:55:08 �̦�; End time: 5/8/2007 4:55:08 �̦�; Duration: 0:00:00 Processing Dimension Attribute 'EPI_CELL_SINO_GOOD' completed successfully. Start time: 5/8/2007 4:55:08 �̦�; End time: 5/8/2007 4:55:08 �̦�; Duration: 0:00:00 Processing Dimension Attribute 'EPI_CELL_SINO_LOOSE' completed successfully. Start time: 5/8/2007 4:55:08 �̦�; End time: 5/8/2007 4:55:08 �̦�; Duration: 0:00:00 Errors and Warnings from Response Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: An unexpected error occurred (file 'pcprocbinding.cpp', line 6645, function 'PCDBProcBinding: electOrChangeCartridge'). Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'try Structure_1 ~MC-__RowIndex', Name of 'try Structure_1 ~MC-__RowIndex' was being processed. Errors in the OLAP storage engine: An error occurred while the 'EPI_CELL_SINO_LOOSE' attribute of the 'try Structure_1 ~MC-__RowIndex' dimension from the 'DMAddinsDB2' database was being processed. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: An unexpected error occurred (file 'pcprocbinding.cpp', line 6645, function 'PCDBProcBinding: electOrChangeCartridge'). Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'try Structure_1 ~MC-__RowIndex', Name of 'try Structure_1 ~MC-__RowIndex' was being processed. Errors in the OLAP storage engine: An error occurred while the 'EPI_CELL_SINO_GOOD' attribute of the 'try Structure_1 ~MC-__RowIndex' dimension from the 'DMAddinsDB2' database was being processed. And no change to the structure take place. Please help me if you can Thank you in advnce Best regards. Manolis Tag: SSRS Performance
  - 13
    - HOW TO DELETE OLD BACK UP FILES AND TRANSACTION LOGS IN SQL 2005 SQL 2005 DOES NOT HAVE THE SAME FEATURE THAT WAS IN 2000 TO DELETE OLDER FILES OLDER THAN CERTAIN DAYS. I DO HAVE A JOB THAT CREATES A FULL DAILY BACKUPS BUT SINCE I DON'T HAVE ENOUGH SPACE, I WOULD LIKE TO FIND A WAY TO DELETE ALL OLD BACKUP FILES OLDER THAN X AMOUNT OF DAYS AND ALSO DELETE TRANSACTION FILES OLDER THAN X AMOUNT OF DAYS. IS THERE A TOOL TO DO THIS. CAN ANYONE HELP PLEASE. EMADKB Tag: SSRS Performance
  - 14
    - Embedded image does not appear Hi there! I've an embedded image (logo) in my report, and in the preview it looks wonderful, but after deploy the logo doesnt appear in the report (report server). The url of the dead-link-image is http://hamsql1/Reports$BI/Reserved.ReportViewerWebControl.axd . I thought that an embedded image is stored "in" the report, but it seems to be an other place. Is it nessecary to deploy an embedded image too Is it a problem of permissions (i read it in another threat) How to set these image-see-permission Or is there an other problem Every idea is very welcome! Thanks, Torsten Tag: SSRS Performance
  - 15
    - can't (re)start SQLServerAgent after changing its logon credentials Since Copy Databas Wizard failed to copy anything from remote SS20005 (both are with SP2 3054) in any combination, I changed SQLServerAgent(myinstance_name) to run under Network from Local System with the help of SQL Server Configuration Manager For this change it was restarted, failed to start again and continues to be stopped giving "SQLServerAgent could not be started (reason: Unable to connect to server '<mymachine_name>\<myinstance_name>'; SQLServerAgent cannot start)." I changed SQL Server Agent (myinstance_name) back to Local Service, then to Local System and still can't start it. So, my questions: 1) What has happened and how can I start SQLServerAgent 2) Why cannot I start it under Network Service since it apparently should access remote resources for CDW to copy from remote SS2005 This is on MS Windows XP SP2 PS After few trials I amnaged to restart it again under Local System but still cannot change to any different one Tag: SSRS Performance
  - 16
    - I have a VB script that works in WinXP sp1 but not in WinXp sp2 hello all, I have the following script that does not work in windows XP SP2 //Script sub UpLoad (UploadFileName) dim b1 b1=&H4000000 set objStream =CreateObject( "ADODB.Stream" ) set objRecord =CreateObject( "ADODB.Record" ) set cnn =CreateObject( "ADODB.Connection" ) cnn.Open "provider=MSDAIPP.DSO;data source= http://192.168.0.100" objRecord.Open UploadFileName,cnn, 3,b1 objStream.Type = 1 'adTypeBinary objStream.Open objRecord,3,4 /////// Error line ////// objStream.LoadFromFile "c:\" +UploadFileName objStream.Flush objStream.Close objRecord.Close Set objStream = Nothing Set objRecord = Nothing cnn.close set cnn = nothing end sub Error Message is "No such interface supported" Any idea whoud be appreciated highly Tag: SSRS Performance

Purva007

Hi All,

I am facing an issue while working with huge data in tables.

I have a stored procedure which when exceuted on SQL Server Browser takes little time to display the output on the screen.

The same stored procedure is used by the application with SQL Server Reporting Services to generate the report.
When executed, the application stops responding after sometime.

After debugging steps by steps, I found that the dataset fetches the records from database using stored procedure takes around 11 mins and application stops responding while generating the reports.

Now, does this happens with some performance related issue with SQL Server Reporting Services or Do I need to modify stored procedure

Top