I wrote a CLR TVF for SQL Sever to retrieve the filenames in a directory. It contains the following code to retrieve the filenames:
View Complete Post
View Complete Post
Edited by Nancy Michell
MSDN Magazine January 2004
Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint
The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error
The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.
However, report rendering is a problem from the internet (external site), the following error is displayed:
I sometimes get the following error while printing crystal report to pdf:
System.Runtime.InteropServices.COMException (0x80004005): The process cannot access the file because it is being used by another process. at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportOptions options) at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType) at CommonWA.CommonFunc.GetPDFMemoryStream(DCMSReportDoc _dcmsreportdoc, Boolean& _DataExist) in E:\wwwroot\ASPWA\CommonWA\CommonCom.vb:line 382
The error not occurs frequently but sometimes it will happen, can someone tell me why the error occurs and how can I solve the problem?
Thank you very much.
I am able to access reports from my computer that has the SQL Server (2008) installed, but can't seem to access from other computers in the network. All I get is
"The permissions granted to user 'MyComputerName\Guest' are insufficient for performing this operation. (rsAccessDenied)"
Can someone please help?
I tried creating user "MyComputerName\Guest" and assign permission to view reports, but still cannot get it to work. Am I doing something wrong?
Here are some details from my Report Services Configuration Manager
Service Account is set up to Use built-in account : Network Service
Current Report Server Database
SQL Server Name : MyComputerName\ServerName
Database Name : ReportServer$ServerName
Report Server Mode : Native
Current Report Server Database Credential
Credential : SQL Account
Login : sa
Password : **********
Hopefully someone can give me some input on this problem
I have a secured network share which has folders arranged by user Identifiers. These folders consists of HTML files (and their content which is spread across sub folders). The content can be any static file (image,css) etc. All i know (through a config file)
is the HTML file i need to load. Then i am blind to its content.
I cannot unfortunately import this folder/files under my web application due to certain security concerns.
Is there any way through my web application(Asp.net 2 and IIS 6) that i can load this file when the request comes through.
We have setup a test SharePoint environment on a single box. If we create a new classic authentication web application using NTLM the site works fine, and recognizes AD users correctly. Users can then login successfully. If we create a new claims based authentication
web application using NTLM all users receive an Access Denied error when trying to view the site. The application will recognize AD users when applying permissions in Central Admin's User Policy section, but none of those users are able to access the site.
If I turn on Fiddler Capture, the sites will work fine. Once I turn it off the sites no longer work and we are again presented with an Access Denied exception (or sometimes 403 Forbidden in Firefox and Chrome). I know that Fiddler create a local proxy so
I'm curious what that proxy is doing that allows claims based to work correctly.
Has anyone seen this before? Does this sound Firewall/Antivirus related? Client or server?
I've been checking previous postings. We are opening up a sharepoint site for partner companies. Once they get to their site we don't want them on any other servers on the network.
I followed the info in previous postings and created a group called Computer_Deny, created a user and added them to that group. I created a GPO and linked it to the default domain with the user right deny access to this computer from the network enabled
and the Computer_Deny group added. Removed authenticated users from the filtering and added the Computer_Deny group.
did gpupdate /force
restarted an internal machine for testing. Logged on as the user I created, the user can't get to any server except the domain controller. What I'm not sure about....they need to authenticate with the DC, I believe, once they finish their HTTPS
entry and then need to get to the sharepoint server. If that is true, the authentication process has to happen on the DC. I would think the authentication process is different that a user trying to access a computer from the network. Am I
correct? Am I least moving in the right direction?
The user can still access the DC various ways i.e. run command, entire network but NOT via RDP since that right has not been granted. Some further research indicates that if
I am trying to call a function in SQL Server 2005 from Access 2003. It works fine with the constant value, but fails with a variable of the same value. This works:
strSQL = "SELECT * FROM functionName (constantValue)"
rs.Open strSQL, cn
when I use variable in the parameter, I get error. I have tried creating parameter objects in Access, but couldn't execute it and don't know if this is a way to go anyway.
Would appreciate for any help or suggestion.