.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Cannot Access Reports from Computers Within Network

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :Sql Server
 

Hi,

 

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 : **********

 

Thanks




View Complete Post


More Related Resource Links

Share Point integrated SSRS reports rendering when access from external site

  

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:

 
An unexpected error occurred while connecting to the report server. Verify that the report server is avai

how can i connect to Access DB in another PC in network

  
Hello all ,  i want to make 2 separated programs that share database in network the Access DB is on PC and the program is on another one how can i make the connection between them ?Kareem Naguib

Unable to access VM network drive in SQL during backup generated by stored procedure

  
I get the following error in a log file created in the osql command: Msg 3201, Level 16, State 1, Server KAC2KGS2, Procedure usp_Kaman_Full_SqlDB_Backup, Line 150Cannot open backup device 'x:\Servername_master_sqlbu_200703101930.bkf'.Device error or device off-line. See the SQL Server error log for moredetails.Msg 3013, Level 16, State 1, Server KAC2KGS2, Procedure usp_Kaman_Full_SqlDB_Backup, Line 150BACKUP DATABASE is terminating abnormally. The device is established in a CMD file right before the osql command is started that starts my stored procedure.  The CMD in this file is: for /f "tokens=15 delims=." %%i in ('ipconfig^|find "IP Address"^|find "192.168"') do set SUBNET=%%i :loopif exist x:\ net use x: /delnet use x: \\192.168.%SUBNET%.1\backup if not ERRORLEVEL 1 ( goto continue) else ( echo FAILED TO CONNECT TO BACKUP SERVER >> "%SystemDrive%\LogFiles\%Computername%.log" sleep 60 goto loop) :continue echo IP ADDRESS OBTAINED Echo delete old log file if it exists if exist %3\%computername%_kaman_full_sqldb_backup_old.log del /Q %3\%computername%_kaman_full_sqldb_backup_old.log Echo Rename log file to old.log rename %3\%computername%_kaman_full_sqldb_backup.log %computername%_kaman_full_sqldb_backup_old.log echo backup SQL Databases on server will start now osql -E -n -d %1 -i %2\kaman_full_sqldb_backup.sql -h-1 -o %3\%Co

Public Access to Reports

  

I'm designing some reports to summarize recently compiled research findings.  These reports are going to be posted on an ASP.NET page (via the report control) on the web site.  I do not want to authenticate users, as the findings are meant to be public and requiring users to register and authenticate would add a barrier and is likely to decrease traffic.

I've seen similar posts where reports are meant to be viewed by everyone on an intranet and permissions could be set using a designated workgroup.  I need alternative solutions to the problem of making a report viewable by everyone who visits a site.  I'm also currently unfamiliar with Kerberos (and I know that will probably pop up as a potential solution), so if there's a convenient way outside of that it would be great.


user access reports

  

We've got a Sharepoint 2010 infrastructure that we're going to need to audit in a "who has access to what" type of report. Complicating things a bit is that we're using AD groups, so SharePoint often doesn't seem to know who's in whatever AD group, they just know the group has access. 

But our auditors want to know what no-kidding-human-being has access to what. I was wondering if there is a native way to do this, and if not, any recommendations on third party software approaches? Thanks so much!


Public Access to SSRS Reports

  

I'm designing some reports to summarize recently compiled research findings.  These reports are going to be posted on an ASP.NET page (via the report control) on the web site.  I do not want to authenticate users, as the findings are meant to be public and requiring users to register and authenticate would add a barrier and is likely to decrease traffic.

I've seen similar posts where reports are meant to be viewed by everyone on an intranet and permissions could be set using a designated workgroup.  I need alternative solutions to the problem of making a report viewable by everyone who visits a site.  I'm also currently unfamiliar with Kerberos (and I know that will probably pop up as a potential solution), so if there's a convenient way outside of that it would be great.


Cannot access /reportserver and /reports - http 404: webpage cannot be found

  

hi

i just made a new install of sql server 2008 r2 with reporting services. unfortunately i'm not able to access the two urls. i get an 404. does anybody know that problem?

i switched off uac, started ie as admin, added the sites to the trusted sites, opened port 80, changed the port in rss to 8080.... no positive solution.

thanks for your help


Does a SQL Server Compact 4.0 database support simultaneous access from different computers?

  

For example, if an sdf file is on a network server, could two network clients running SQL Server Compact 4.0 access the file at the same time?

This was not possible using SQLCE 3.5. I'm wondering if it's been added to 4.0 (so that it brings back the one advantage of using an Access db.)


Claims Based Authentication - Access Denied for NTLM - Network Related

  

Hello,

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?

Thank you,
Sam

 


www.sawyercreativedesign.com

How do I access Usage Reports Top Queries programmatically

  
Hi, I need to retrieve the top queries from the Usage Reports? Do I need to fetch it directly from SQL or are there classes that does this for me? Regards, Martin

allowing remote users access to a specific site but not to any other network servers

  

Hi 

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

File access across the network, credentials, logonuser, impersonation

  

Hello,

I have an application that has both a server and client... the client can exist on any computer.

I have a need to allow a client to export a set of files.  The server process that will be exporting the job runs as the Local System account.

When I want to export resources to a remote UNC such as \\servername\share that I don't have permission on I would like to prompt my user for credentials.

How do I then use these new credentials to authenticate and then System.IO.File.Copy(src,dst)?

I've found several articles on impersonation and I can impersonate a local user, but not a remote user it seems... 

I'm programming in C#.

Thanks,
Mike


get hardware information in local network computers using vb.net

  
Hi i am currently developing a software where it can get hardware information in a local network computers like getting the RAM size, getting mac address as well as getting hard disk drive capacity.

I have no problem in getting those information in my local computer but the problem is on getting those information to my local network computers.

can someone help and guide me to this development.. thanks!

Access to network map drive blocked in .net 4.0 wpf application on win 7

  
I am developing in VS2010 a validation tool that needs to look for files on a network share. The files are pathed via a mapped drive. When the code

var

is executed, I get the follow exception.

Could not find a part of the path 'I:\active\production\09 Vrod deu\'.

   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileSystemEnumerableIterator`1.CommonInit()
   at System.IO.FileSystemEnumerableIterator`1..ctor(String path, String originalUserPath, String searchPattern, SearchOption searchOption, SearchResultHandler`1 re

asp.net cannot access network folders

  
I have a few computers (with Vista Business OS) connected in a private network. A C#.NET application running on one computer is currently able to access the network shared folders without problems. However, I am trying to get an ASP.NET application on that computer to access the same folders but I am getting "Access denied" errors. I added NETWORK SERVICE to all the shared folders' security (with full control) but it still gives the same errors.

 


Cannot access reports?

  

Hello,

 

I am getting an error when trying to run a report:

An error has occurred during report processing. (rsProcessingAborted)

Cannot impersonate user for data source 'MITSAssets'. (rsErrorImpersonatingUser)

Log on failed. Ensure the user name and password are correct. (rsLogonFailed)

Logon failure: unknown user name or bad password 

I am able to got to http://vossql1/Reports/Pages/Folder.aspx  but when clicking on any report http://vossql1/Reports/Pages/Report.aspx?ItemPath=%2fAssets+Detailed+per+Data+Center I am getting the error above.

Apparently the dbo of the database is gone... how could I retrieve the access to it... I tried an sp_changedbowner and I am getting an error:

Msg 15110, Level 16, State 1, Line 1

The proposed new database owner is already a user or aliased in the database.

I restarted the SQL Server and the SQL Reporting services... still no luck

I deleted my account from the Database and readded it with the sp_changedbowner, restarted services ==> no luck 

What should I run or pass as command to get access?

Thanks,

Dom


System Center Operations Man
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend