Dear folks
When I deploy an assemly into SQL Server using the Visual Studio IDE, it claims than it also deploys the source code to the server and the build process also shows deploying the files, but I can not find the files.
I am now developing on Windows XP and the SQL Server is also the Developer Edition on my PC.
Please help.
Parviz
Hi,
My question kind of covers a couple of areas.
I have written some SQL 05 CLR code that produces a single DLL file. I have specified that the code is 'Safe' e.g. it will not be carrying out any external assembly access or other file accesss.
The code simply contains some stored procedures that will update/instert etc data from the database.
The question is, how do I actually deploy the code to a a remote server? Do i simply take the DLL and use CREATE ASSEMBLY code to set it up?
Furthermore, are there any security issues i need to consider when i deploy the assembly given that I have already set up the security to be 'Safe' ? e.g. is there anyway that a database can be locked down so that CLR code would not run irrespective of the safe setting.
As far as I understand it, SQL CLR code is ran under the SQL Server service account, so does this mean that if this user is locked down the code would not run?
Any clarifications or extra info would be greatly appreciated.
Peds
I have code
Function GetDealCount(reportItems)
return iif(IsNothing(reportItems!txtDetailCountRows.Value), 0, reportItems!txtDetailCountRows.Value)
End Function
Function GetSumNotionalAmount(reportItems)
return iif(IsNothing(reportItems!txtDealSumNotionalAmount.Value), 0, reportItems!txtDealSumNotionalAmount.Value)
End Function
That I am calling from a textboxes in the page header
= Code.GetDealCount(ReportItems) & " Deal(s)"
also
= Parameters!BaseCurrency.Value + " " + Format(Code.GetSumNotionalAmount(ReportItems),"N2").ToString().Replace(",","'")
When I preview the report in VS.NET I get values showing.
When I deploy the report I just get #Error showing.
Also this report used to work fine in RS2000
Does anyone know the cause of this issue?
Hi All,
I deployed many reports in sql server 2005 reporting services. I want to remove some of the unnecessary reports. How to remove those reports?
thank you
thanks,
Muniappan Kandasamy
I have a report being utilized for return address labels, conforming to Avery 5167. I have tried designing both as a table and as data in rectangles. Since these are return labels their is only one instance of data replicated for all textboxes, therefore the columns are of consistant length.
The report has seven columns of precise measurement, the data filled colums are set as 1.75in, 0.25in, and between the data columns are blank columns set to .3125in, 0.25in. I have also tried to fill data into the blank colums and set the font color to white. All report margins are set to 0in and the table location is 0.04167in, 0.125in. all textboxes have the properties for increase/decrease to accomadate turned off.
The biggest issue I am having is in printing from the deployed report versus printing while designing. I have adjusted for the glitch in margins for RS2005 and have printed succussfully prior to deployment to adhere to the specific measures for the label, report margins and textbox height and width and blank column spacing.
However, after deploying the report the data spacing seems to be compressed when printed. I am not getting the same measure between data fields as I had when designing the report. The entire printout seems to be slightly compressed.
When printed from design colums 1,3,5, and 7 start respectively at .3125in,2.375in,4.3756in,6.4375in from the edge of the page.
When printed fromt he deployed report columns 1,3,5 and7 start respectively at .3125in,2.3125in,4.28125in,6.28125in.
The progression of compressed measure seems to increase from left to right inthat by the time the report is printed via the deployed report the "Tab" area is a difference of .15625in which when printing for very precise template format this creates a problem. As well as a headache when one thinks the report is correct before deployment.
Hi Msdn,
I have developed a program that required user to store information at their own machine (sql server express). So, i have included SQL Server 2005 Express Edition in the Prerequisites
When i try to deployed my program at test machine, the installer works fine, by installing the .net framework 2.0, then SQL Server 2005 Express Edition, then Finish.
When i tried to run on the test machine, my program showing me error "Open connection error". Well, i know somethings to do with my connection string,
Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True; Initial Catalog=abc;User ID=123456;Data Source=localhost
Logically, i do not understand how this things works.
my own developer machine contain Database Named "abc" with username and password "123456". The test machine do not contained any database nor username nor password.
How can i fix this problem? I mean some code to perform this operation without end user knowledge.
hi all,
i've followed the tutorial in SQL Server 2005 for deploying packages. everything works ok until i came to lesson 3 installing packages.
i could connect to SSIS but when i expanded the Stored Packages node, i get an error message saying :
Login timeout expired
An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
named Pipes Provider: Could not open a connection to SQL Server[2]. (Microsoft SQL Native Client)
my database engine has an instance name. will this affect SSIS connectivity?
thanks!
Hi, I was hoping someone can help me fix a problem I am having when I deploy my rs report. What happens is when I view my report in designer everything works fine, however when I deploy me report to the report server and begin to drilldown into the matrix the entire report shifts down each time I toggle one of my drilldown fields. This causes the top of the report to disappear. The user than has the scroll up each time to reposition the report. Has this happened to anyone else? Does anyone how to fix it?
Thanks!
Hi,
I want to take the backup of all SSIS packages deployed in the SQL server. I need the backup in DTSX format, how should i do that. Please advice.
If I deploy an SSIS packages in SQL Server (not in file system).
Where are they stored? Are they stored in a DB? if yes, which one?
Also, is it a best practise to deploy the SSIS package in SQL (I guess it should be because I can have a central place for deploying all package and have one place to load all the packages from).
regards,
Abhishek.
I encountered the following error after I deployed a report . The deployment process was successful, however, when I try to run the reports from the remote machine, It gives me an error message saying:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'SessionOLAP'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
On the other hand, I deployed this report on the local machine where the reportserver resides and it is running perfect.
Do you have any idea how to deal with this problem?
I have created several reports in SRS and I deploy them by establishing a VPN connection than deploying. That much works fine.
Now I want to allow user of my website to access the reports by clicking on a link. Do I need to establish user level access for the reports for each user or just one public access account? How do I pass login and credential information with the link so that users can access the report.
Thanks in advance
I deployed my phone directory to the server and now dynamic images are no longer being displayed. They are specifically employee photos based on a naming convention. I used the path as ''file:/// etc.'' and when I open up my start menu and throw it into run it works fine. It also runs fine in my visual studio report, but for whatever reason when its deployed it no-longer runs. Does anyone know what could eb causing this problem?
Hi all,
When I run the SSRS report in development mode, it is working fine. When I run in deployed localhost, I faced an error message as below:
The permissions granted to user 'FAROUKYEWNOTEBOASPNET' are insufficient for performing this operation. (rsAccessDenied)
Hope someone can enlighten me on this.
Regards,
Farouk Yew
VS2005 project with imbedded SQL Server reports works fine in VS IDE going agianst a network SQL Server 2005 or the local SQL Server 2005. However, when the application is deployed (to another computer). the application starts and connects successfully to the network SQL Server 2005. Everything works until the user tries to produce a report. Then the following error is generated:
Named Pipes Provider, error: 0 - No process is on the other end of the pipe (the verbose part of the error message is left out). SQL Server agent is running both on the file server and the local computer. Also, named pipes and shared memory are enabled in file server and local computer (TCP and VIA protocoles are disabled). Same is done for Client protocoles.
Any suggestions are greatly appreciated.
Hi All,
I am using ssrs and vs2005 to develop reports.The deployed reports are placed in the source directory(c:source) and i am using a asp.net page with a button on it to generate a report in .Pdf format and after generation this Pdf document will be placed in a destination folder(c: arget).
Can anyone help me out in solving this or atleast direct me as how to go on with it?
thanks
I have an SSIS package that executes in about 1:20min from Visual Studio on my local machine. While executing, my machine is somewhat unresponsive.
When I deploy the package to the database server -- the very same database server that I am accessing from my local machine -- the package executes but eventually hangs. It appears to be running out of memory, and I usually have to kill the process to get the machine to respond. While it's hanging, the machine is unresponsive to all users. The hardware (including memory) is identical between my local development box and the server.
How should I troubleshoot this? I've tried deploying the package to MSDB, file system, running from dtexec, and running from dtexecui. This is very frustrating!
Thanks for any help.
--j
When deploying my application that uses sql server it doesn't connect to the server.
I checked the connection string & it's ok the server instance is the same.
The computer name isn't the same & i use the .SQLExpress as the data source.
I get an error saying 'sqlserver does not allow remote connections error 26 locating server / instance specified'.
I have developed an SSIS package which uses an XML configuration file for connection information. It runs fine both from Visual Studio and from an Agent job after I specify the location of the XML configuration file in the Agent job definition.
My question is regarding the target location of the XML configuration file after deployment. I do my SSIS development on a local workstation with SQL Server 2005 DE and Visual Studio 2005 installed on it. I deploy my SSIS packages to a remote SQL Server 2005 SE server. Both machines are running SP1. I double-click the package manifest from my local workstation and specifiy the remote server in the deployment utility. The package gets deployed to the remote server just fine but the XML configuration file ends up on my local workstations C:Program FilesMicrosoft SQL Server90DTSPackages path. I would have expected that the XML configuration file would have gone to the same path on the remote server, where the package itself was deployed. Obviously, when I run the deployment utility from the remote server, it stores the XML configuration file in the same path on the remote server. But this is not a workable production solution.
I'm still trying to get a recent install/setup of Reporting Services 2005 working. I have Report Server installed on ServerA which already had IIS running on it, the Report Catalog can be found on a 2nd server, ServerB, with SQL 2005 Std Edition installed.
I am able to browse to the Reports Manager site and see the test report I deployed there through Visual Studio 2005, installed on my machine. But when I try to view the report, I get:
An error has occurred during report processing.
Cannot create a connection to data source '[our db name]'.
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'
Now, when I created the data source for that report, I used a Trusted Connection, which of course worked for me when authoring on my machine since I belong to a Windows group that has been granted access to the SQL Server and db in question.
Since Reports Mgr requires Windows authentication, I assumed that when attempting to view the report from within Reports Manager, it would again use my credentials. So I'm confused where the local system account, NT AUTHORITYANONYMOUS LOGON is coming from.
Any help would be greatly appreciated.
M Noreen
I am wondering why deployed packages are so much smaller than built packages. What is removed and why isn't it removed when the packages are built?
I have a package that goes from 3Mb to 1.5Mb
Hello-
I have developed a number of reports on Win XP with VS2005. They run on our development server, which is running Windows Server 2003 32-bit. I then deploy these reports on our production server, which is running Windows Server 2003 64-bit edition.
Accessing any of the reports from Report Manager results in javascript errors, such as 'Line 41 Error: 'RSClientController' is undefined'
I get these errors also when invoking these reports through a form post.
It appears that some javascript code generated by the report server is missing. Could this be a 32-bit vs 64-bit issue? Report Manager seems to work fine; it is only when I run a report that I have this problem. This is the first time I've tried to deploy reports to this server.
Thanks.
How can we control the accesses to a SQL Server that has been deployed on customer site? Basically, we do not want user to log in the database server, even as sa, except through our application.
Any recommendation?
Thanks,
Xiaodoudou
I have mult-value parameter set up for a report and when i preview the report in visual studio 2005, the "select all" option is displayed in the drop down list and works beautifully for selecting all.
When i deploy the report to the intranet website and click on the report, reporting services doesn't show that option to select all. It will however let me click amongst the generated list, but not an option to just click a "select all"?
Is this normal? I suppose i could always just code a value that generates all and add it as one of the selection, but this is more of a functionality question than a coding.
Thanks in advance!
I have been handed a datawarehouse environment to look at however I cannot find the ssis packages (.dtsx).
I see that the packages have been deployed to SSISDB but I can't find the files to load into Datatools.
Once the files have been deployed is it possible to remove the package files? Is there a way of retro'ing the deployed packages out of SQL so I can view them in Datatools?
We will making a change to our Reporting Services deployment next month. We will be moving from our SQL 2000 server to a new SQL 2005 server. In addition, we will moving from a Local Catalog Deployment to a Remote Catalog Deployment. My question is this: Is there a way I can prevent my team from having to manually redeploy our reports in the new system? They have not been diligent about saving the Visual Studio solution or project files, so they will have to pull the most up-to-date RDL's off the server and deploy them on the new server one by one.
I suppose I can install SQL 2000 on the new server first, then move the Reporting Services databases to the new server, then upgrade the server to 2005, but installing 2000 and upgrading to 2005 does not sound like a best practice. I would prefer a clean install of 2005. Does anyone know if I can move the deployed reports from one server to another?
Paul Teal
paul@partytilyoupop.com
I have a report deployed on reporting serice. I am using reporting web service.
How can we call the report, assign parameters and execute it on a webpage
This has only started happening in the last two days
When we invoke our SSIS package from a web service it used to work fine but now gives the following error. the DLL name changes all the time. Any help would be appreciated
Code SnippetSystem.IO.FileNotFoundException: Could not find file 'C:WINDOWSTEMPvrjeaanf.dll'.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
at Microsoft.CSharp.CSharpCodeGenerator.FromFileBatch(CompilerParameters options, String[] fileNames)
at Microsoft.CSharp.CSharpCodeGenerator.FromSourceBatch(CompilerParameters options, String[] sources)
at Microsoft.CSharp.CSharpCodeGenerator.System.CodeDom.Compiler.ICodeCompiler.CompileAssemblyFromSourceBatch(CompilerParameters options, String[] sources)
at System.CodeDom.Compiler.CodeDomProvider.CompileAssemblyFromSource(CompilerParameters options, String[] sources)
at System.Xml.Serialization.Compiler.Compile(Assembly parent, String ns, XmlSerializerCompilerParameters xmlParameters, Evidence evidence)
at System.Xml.Serialization.TempAssembly.GenerateAssembly(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, Evidence evidence, XmlSerializerCompilerParameters parameters, Assembly assembly, Hashtable assemblies)
at System.Xml.Serialization.TempAssembly..ctor(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, String location, Evidence evidence)
at System.Xml.Serialization.XmlSerializer.FromMappings(XmlMapping[] mappings, Evidence evidence)
at System.Web.Services.Protocols.XmlReturn.GetInitializers(LogicalMethodInfo[] methodInfos)
at System.Web.Services.Protocols.XmlReturnWriter.GetInitializers(LogicalMethodInfo[] methodInfos)
at System.Web.Services.Protocols.MimeFormatter.GetInitializers(Type type, LogicalMethodInfo[] methodInfos)
at System.Web.Services.Protocols.HttpServerType..ctor(Type type)
at System.Web.Services.Protocols.HttpServerProtocol.Initialize()
at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing)
we have SSRS and I've worked on my local PC and developed a report which connects to a database e.g. on server 3 with the credentials set as a particular SQL user. All works fine locally but as soon as I deploy the report to the report server (server 2), I receive the following error: Cannot create a connection to data source"
The database server records the following SQL error:"Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. Reason: Could not find a login matching the name provided."what I need to do to successfully run this from server 2? The fact it works locally fine means that the login is working ok I guess so I'm not sure what happens when it is transferred to the database server.The user is a SQL user rather than domain one and the user exists on SQL databases on both servers.
I am migrating from local to Dev,QA and Prod.
I created a .dtsconfig file containing database connection strings to Dev database. What is the "location" on the Dev server where this .dtsconfig file nees to be deployed to??
Thanks for your help.
we're about to plan exactly how we install rs reports on our customers' systems and are wondering if there is more of a binary/compiled format that can be deployed as opposed to the xml source we see in .rdl files?
We keep the lowest form of everything (.dlls, sql scripts etc) in deployment directories and wonder if RS2005's lowest (or most efficient for deployment) form is the .rdl itself. I noticed that Reporting Services (when scripting a report in mgt studio) shows what appears to be the .rdl wrapped in VB but dont really know if that form has to be stored or not on the ReportServer DB in order for RS to work. I couldnt find a ReportServer DB table that had this form but have to believe it is there somewhere if Reporting Services can display it. But maybe a format more geared toward execution is stored along side it?
So if .rdl can be considered "source code" I guess the question is "does it need to be deployed in that form for RS to work or is a more binary like format also available"?
Hi All,
I need your help to call an SSIS package using ASP.NET. I have deployed the package using SQL server deployment with an windows authentication. I need to call that package from a remote machine. Also i need to assign a value for a variable in that package while calling it from ASP.NET.
Plz let me know the steps to call that package from ASP.NET
Thanks
Hi all,
Thanks for sharing your experiences here. In some cases, I've saved quite a bit of time. Unfortunately, I haven't found a solution for my current issue.
I'm using VS.NET 2005 and SQL Server 2005. My development computer is running Windows XP SP2. SQL Server 2005 database and reporting services are running on Windows 2003 Server.
My business requirement is to develop and deploy a report which takes rich text (RTF) stored in the database (datatype = TEXT) and converts it to an image at runtime using a custom assembly (source can be found here http://blogs.digineer.com/blogs/jasons/archive/2006/10/03/520.aspx). I am able to generate and view the dynamic image containing the RTF on my local (i.e., developer) computer both using the ReportManager web interface and using the Render method. When I deploy this to our test server, I end up with a broken link image.
To recap, I have taken the following steps.
Created custom assembly using VS.NET 2005 which converts RTF to bitmap image. Custom assembly has a strong name.
On local developer machine
Copied custom assembly to C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssemblies.
Modified C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesRSReportDesigner.config to include a CodeGroup which grants FullTrust to custom assembly based on StrongNameMembership (NOTE: ReadMe.txt doesn't mention adding an entry to this file).
Modified C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesRSPreviewPolicy.config to include a CodeGroup which grants FullTrust to custom assembly based on StrongNameMembership (NOTE: ReadMe.txt doesn't mention adding an entry to this file).
Modified report using VS.NET 2005 as follows
Added reference to custom assembly and System.Drawing.
Added image control with type=Database, MimeType=image/bmp, Value = call to custom assembly method; method is passed value of database field which contains RTF.
Deployed report.
Viewed report successfully both via HTML and via Render method of WebService using EXCEL as output format. HTML for image <IMG SRC="/Reports/Reserved.ReportViewerWebControl.axd?ReportSession=ohj0pjaplbl5h255phlplz45&ControlID=883e299f22ca4413b398a024cec134b2&Culture=2055&UICulture=7&ReportStack=1&OpType=ReportImage&StreamID=ed4b4d3b-d54d-4043-9fea-1c06f153f9a1"/>
On local developer machine and server
Copied custom assembly to C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerin
Modified C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer
ssrvpolicy.config to include a CodeGroup which grants FullTrust to custom assembly based on StrongNameMembership (NOTE: source code indicates permissions should be granted based on UrlMembership).
Deployed report.
Viewed report unsuccessfully both via HTML and via Render method of WebService using EXCEL as output format. HTML for image <IMG SRC="" />
Initially, I got error messages when exporting to Excel along the lines of ,"data is missing" but these appear to have been resolved by granting permissions in .config files which we not mentioned in ReadMe.txt. I've have run out of things to try and am at my wits end. I am convinced the solution has something to do with permissions since this works on my computer but not on the server.
Thanks in advance for any thoughts or suggestions.
Regards,
Bill