Cannot Access Report Manager Website By Hostname, Only By IP Address...?

Jul 26, 2007

Hello all - this has now happened to me on a few occasions (different installs, different sites, etc.), but my client PCs cannot access Report Manager by the server's hostname (even though I can ping by hostname from the client).

For instance, if I try:

http://ovenserver/reports

I get the infamous "Internet Explorer cannot display the webpage" message.

If I try:

http://10.0.0.20/reports

The Report Manager loads properly without a hitch.

I know I am missing something simple here - can anyone help?

Thanks!

View 10 Replies


ADVERTISEMENT

Sqlcmd With Trusted Connection And IP Address Or Fully Qualified Hostname

Nov 9, 2006

The command sqlcmd seems to fail when using trusted connection and an IP address or a fully qualified hostname. For example:

sqlcmd -E -S nnn.nnn.nnn.nnn

where nnn.nnn.nnn.nnn is the real IP address of the machine, or

sqlcmd -E -S hostname.domain.com

where hostname.domain.com is the fully qualified hostname of the machine, gives the error:

Msg 18452, Level 14, State 1, Server 380GX280B05, Line 1
Login failed for user ''. The user is not associated with a trusted SQL Server c
onnection.

On the other hand, sqlcmd -E -S 127.0.0.1 works, and so does sqlcmd -E -S hostname, or sqlcmd -E -S tcp:hostname,1433.

This is on a clean machine, with SQL Server 2005 freshly installed as Administrator with mixed authentication, and the test runned also by Administrator.

Is it normal or is it a bug?

Thanks.

Georges

View 1 Replies View Related

Sqlcmd With Trusted Connection And IP Address Or Fully Qualified Hostname

Nov 9, 2006

The command sqlcmd seems to fail when using trusted connection and an IP address or a fully qualified hostname. For example:

sqlcmd -E -S nnn.nnn.nnn.nnn

where nnn.nnn.nnn.nnn is the real IP address of the machine, or

sqlcmd -E -S hostname.domain.com

where hostname.domain.com is the fully qualified hostname of the machine, gives the error:

Msg 18452, Level 14, State 1, Server 380GX280B05, Line 1
Login failed for user ''. The user is not associated with a trusted SQL Server c
onnection.

On the other hand, sqlcmd -E -S 127.0.0.1 works, and so does sqlcmd -E -S hostname, or sqlcmd -E -S tcp:hostname,1433.

This is on a clean machine, with SQL Server 2005 freshly installed
as Administrator with mixed authentication, and the test runned also by
Administrator.

Is it normal or is it a bug?

Thanks.

Georges

View 12 Replies View Related

Find Website From Email Address

Jul 4, 2007

Hi,I have 2 fields in a database: 'email' and 'website'.In the majority of cases, the website field is not populated even though theemail address is. In 90% of cases, the website will be 'www.' followed bywhatever is after the '@' symbol in the email address.Would anyone be able to help me with the SQL that would take whatever isafter the '@' sign in the email address, add it to 'www.' and populate the'website' field?Thanks!

View 3 Replies View Related

Deny Builtin/administrators Full Access To Report Services Report Manager 2005

Apr 14, 2008



I need to prevent domain and local administrators from having full control over our report manager. (I want them to be assigned permissions just like everyone else, some reports they can see other reports they can not.)

How can I accomplish this? I tried going into Report Manager -> Site Settings -> Configure Site Wide Security and re-assigning BUILTINAdministrators to the System User role instead of the System Administrator role. (A different set of report manager admins was given the system administrator role).

However, it appears that members of the BUILTINAdministrators group still have full control in Report Manager.

View 3 Replies View Related

Can't Access Report Manager

Mar 14, 2008

I am running SQLExpress 2005 with Advanced Services SP2
I used the Reporting Services Configuration Tool to manually instal Report Manager to its default virtual directory. Got no error message. So far so good, but when I tried to start the manager by writing the URL (http://localhost/reports) in the address bar of my browser (iexplorer 7.0), I got the following error message:

XML-siden kan ikke vises Kan ikke vise XML-inndata ved hjelp av XSL-stilark. Rett opp feilen og velg deretter Oppdater eller prøv på nytt senere.
Et navn ble startet med et ugyldig tegn. Feil under behandling av ressursen http://localhost/reports. Linje 1, Posisjon 2
<%@ Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.HomePag...

It is in norwegian so I try to translate it to the best of my ability:
XML can't be translated by means of XSL style sheet. Invalid charater. Error occurred handling the resource http://localhost/reports Line 1 Posistion 2
<%@ Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.HomePag...
There is a squiggly line under "c#" and "codebehind" as well.


I know very little of XML and XSL. What amends can I do to access the Manager? Please help somebody. Is it possible to use the Reporting Services Configuration once again to instal the Manager to another location?


OR

View 1 Replies View Related

Cannot Access Report Manager

Dec 18, 2006

I have just installed Reporting Services on a 2 server web farm. I can access http://virtualserver/reportserver but when I try to access http://virtualserver/reports, I get the following:
The page cannot be found

The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.



Please try the following:

Make sure that the Web site address displayed in the address bar of your browser is spelled and formatted correctly.
If you reached this page by clicking a link, contact the Web site administrator to alert them that the link is incorrectly formatted.
Click the Back button to try another link.
HTTP Error 404 - File or directory not found.
Internet Information Services (IIS)



Technical Information (for support personnel)

Go to Microsoft Product Support Services and perform a title search for the words HTTP and 404.
Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled Web Site Setup, Common Administrative Tasks, and About Custom Error Messages.



View 6 Replies View Related

Error In Access Report Manager

Feb 20, 2007

I am able to access report server and view the reports on my machine but when i access

the report manager it gives error

"The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version"

View 2 Replies View Related

Only Able To Access Report Manager As Administrator

Sep 12, 2007



Hi,

I have Reporting Services set up with the permissions (via Right Click Server/Permisions in SSMS or System Role Assignments in Report Manager) set as follows:

BUILTINAdministrators - System Administrator

When logged in as an administrator I am able to access Report Manager, no problem.

However, I want to add a new group so that non-administrators can access Report Manager. However, whatever new item I add in the permissions appears to have no effect. For instance, if I add a permission for Users, i.e. :

BUILTINAdministrators - System Administrator
BUILTINUsers - System Administrator


I can still only access Report Manager as an administrator.. Any other user just gets the blank page.

I have tried creating a custom group, Report Users, with the same result.

I checked IIS to ensure anonymous access was turned off (this was an issue I had earlier on in my setup - it was turned on, but is now firmly off).

I don't know much about IIS, but I guess the problem is there somewhere. Does anybody have any idea what the problem could be and how I get around it?

Thanks very much in advance

Andy

View 7 Replies View Related

Unable To Access Report Manager

May 4, 2006

Hi

I'm able to get into Report Server but when I try to access the Report Manager with the same logon I get the following error:

"An error occurred while attempting to get the ReportServer Url."

Can anyone shine any light on this please?

Thanks

View 3 Replies View Related

Can Not Access Report Manager In SQL Server 2008 Feb CTP

Mar 8, 2008



Hi, I'm a beginner on SQL Server Reporting Services field. I perform a full installation of SQL Server 2008 CTP6 Developer Editon on a clean Windows Server 2008 Enterprise machine. I log on to the machine using the built-in Administrator account so there is no UAC stuff. The Enhanced Security Configuration of IE is disabled. When I want to have a look at the Report Manager by typing http://localhost/Reports, it pops up an error says "The underlying connection was closed. Could not establish trust relationship for the SSL/TLS secure channel." It makes me confused so any help or suggestion is highly appreciated.


The following is a fraction of log file from Reporting Services:
...
ReportingServicesService!resourceutilities!b5c!03/08/2008-14:25:57:: i INFO: Reporting Services starting SKU: Developer

ReportingServicesService!resourceutilities!b5c!03/08/2008-14:25:57:: i INFO: Evaluation copy: 165 days left

ReportingServicesService!appdomainmanager!4e4!03/08/2008-14:28:15:: i INFO: Appdomain:3 ReportManager_0-1-128494312954554272 started.

ReportingServicesService!appdomainmanager!4e4!03/08/2008-14:28:18:: i INFO: RS authentication mode is 5; effective ASP.NET authentication mode is Windows. vdir=/Reports.

ReportingServicesService!appdomainmanager!4e4!03/08/2008-14:28:18:: i INFO: Appdomain:3 ReportManager_0-1-128494312954554272 initialized (#1).

ReportingServicesService!appdomainmanager!e10!03/08/2008-14:28:26:: e ERROR: Remote certificate error
RemoteCertificateNameMismatch encountered for url https://localhost/ReportServer/ReportService2005.asmx.

ReportingServicesService!ui!e10!03/08/2008-14:28:27:: e ERROR: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

ReportingServicesService!ui!e10!03/08/2008-14:28:27:: e ERROR: HTTP status code --> 500

-------Details--------
System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure. at System.Net.Security.SslState.StartSendAuthResetSignal(ProtocolToken message, AsyncProtocolRequest asyncRequest, Exception exception) at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)


...

View 4 Replies View Related

Deny BuiltinAdministrators Access To Report Manager

Apr 22, 2008



I need to remove full admin privs from the builtinadministrator's group in report manager.

I tried removing the builtinadmin role from report manager and SQL Server, I removed it from the Site Settings area and from each individual folder's permissions.

Yet all the members of that group still have full run of the report server...

I even made a new folder that ONLY I am listed as having permissions to, yet they can see that as well...???

Suggestions?


View 8 Replies View Related

Restrict Login Access By Hostname/ip Possible?

Oct 2, 2007

In SQL2005, is it possible to restrict incoming sql or windows authentication logins by source hostname or IP address? Perhaps using endpoints?

We are currently using hosts file on the db server as a temporary solution, but the SA will not allow us to use this as a permanent solution.

The app team I support is asking me to build an "idiot proof" database so that an Dev or Test app server they may configure, doesn't unintentionally connect to the Production database and damage/alter data.

Don't worry, I've already asked if they can't follow some kind of M&P's to prevent this kind of silly behavior, but they insist on DBA team creating a bullet-proof database that can outsmart app developers who try to attempt something dumb like this.

Any ideas or suggestions would be greatly appreciated.

TIA,
Phil

Phil Streiff

View 2 Replies View Related

SQL Server 2000: Block Access From Hostname

Apr 8, 2008



Is possible block access to sql server database, from hostame (pc name). I know only the hostname and not the user.
Is possible?


Thanks

View 1 Replies View Related

Why Did MS Give Access To Reports Thru Both Reporting Manager And Report Server?

Dec 20, 2007

what is MS's strategy for having two off the shelf ways of getting at reports? In a typical company, is the average non administrator type user getting at his reports via one, the other, both?

View 1 Replies View Related

Report Builder Deployment Fails With Tivoli Access Manager

Mar 31, 2008

Hi All,

We are currently having an issue with a Reporting Services deployment which is being accessed through Tivoli Access Manager (with a custom SSRS security extension).

When you try to launch Report Builder, we receive the following error when ClickOnce tries to validate the deployed app (Report Builder works fine when accessed outside of the Tivoli Access Manager environment):

ERROR DETAILS
Following errors were detected during this operation.
* [20/03/2008 2:49:35 PM] System.Deployment.Application.InvalidDeploymentException (HashValidation)
- File, ReportBuilder.exe, has a different computed hash than specified in manifest.
- Source: System.Deployment

Can anyone shed any light on what might be causing this?

All of the components (including the manifest) are downloaded to the client correctly so the authentication seems to be working and it works outside of TAM so there is no issue with the files on teh server having changed etc. either.

Thanks.

View 1 Replies View Related

HTTP Status 401: Access Denied Error In Report Manager

Jun 15, 2007

This didn't use to happen but now it does.



When I go into Report Manager, http://localhost/reports, and try running a report it is giving me this error message:



The request failed with HTTP status 401: Access Denied



But if I go directly to the Report Server, http://localhost/reportserver, and try running a report there then everything is fine.



Does anyone know why it is doing this all of a sudden? I did change the Reports app in ISS to allow anonymous access but have since changed it back, and it still gives this error.

View 4 Replies View Related

Data Access :: HostName / Workstation ID Connection String In Excel

Aug 9, 2011

I currently have the following connection string set up in Excel to connect to my SQL db:
 
Provider=SQLOLEDB.1;Persist Security Info=True;User ID=XXXXXX;Initial Catalog=YYYYY;Data Source=SQL;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=PROJMNT1;Use Encryption for Data=False;Tag with column collation when possible=False

 What I would like to do is replace the Workstation ID (which apparently is hard coded?) so that the user's workstation name pulls (%COMPUTERNAME%) so that I can see who is connecting, using what, for how long etc etc.

Is there anyway to accomplish this?

View 5 Replies View Related

Can No Longer Access Report Manager - The Underlying Connection Was Closed: An Unexpected Error Occurred On A Receive.

Apr 11, 2008



Hi,

For a long time I've had SQL Server 2000 with RS on a Server2003 machine.
When I want to publish a report from my Dev box, I remove anon. access on the Production machine, deploy the report, then go into report manager to tweak a couple of parameters. I then re-enable anon. access so users can continue.


Yesterday, I removed anon. access and deployed the report but when I went into Report Manager I received the above error message... "The underlying connection was closed: An unexpected error occurred on a receive."


I can get into report manager with anonymous access enabled, but I don't have authority to do anything.


What's happened!!!? More importantly, how do I fix it?

View 8 Replies View Related

To Access Reporting Sevices (Report Manager, Reporting Web Services), Does One Has To Be An Admin On The Machine

Mar 12, 2007

Hi There,

Our DBA has installed reporting services on a server and now in order to access the report manager, one has to be an Admin on that Server. I am guessing that there is a mistake in the configuration of Reporting Services. Usually it should allow anybody who was added to the roles in the properties section of the Report Manager, right? I have also added the users to the DB..

Also I am using Windows Authentication to access Report Catalog items (Reporting Services is installed on Server2) from a web Application(deployed on Server1) and displaying the report using report viewer. For some reason, server1 has to be in an Admin role on Server2 to access the report catalog/report. This is kinda strange for me as I don't want everybody to be an Admin on Server2. Can anybody please point in the right direction?

Thanks.

View 3 Replies View Related

How Do I Access The SQL Server From A Website.

Feb 2, 2004

How do I access the SQL server from a website, using my Machine Account, not the ASP.NET account?

thanks.

.intrino.

View 5 Replies View Related

Remote Access To Website

Feb 6, 2007

I upgraded from msde to sql server express. Everything seems to work just fine. I can odbc to the database servver and can view website from local server but cannot access website from remote server. It gives me Cannot find server error.

Help is appreciated.

View 1 Replies View Related

Website Report

Dec 3, 2006

Hi I want to have a report on a website page that will respond to user input.

Basically a page that will displays requests when the user inputs a user_id; the user will then need to be able to drill down and select a specific request to display and print that request.

sql server 2005
visual studio 2005
win xp

View 2 Replies View Related

A User Group Account Acting Like A Content Manager And Admin On The Report Manager????

Nov 2, 2007



A user was created with a limited privilege under the USERS group. Once this user loged in the Report Manager he is acting like an Admin and Content Manager, though he is not given even a browser role.

What do u think that this guy is acting like a Super User evenif he is restricted to a browser role on the Report Manager ????????????

I did all my best, but no luck so far

View 5 Replies View Related

Can Not Access SQL Database For Website Security Settings

Jun 8, 2006

I'm using Visual Studio 2005 (8.0.50727.42) and going into the menu option Website > ASP.Net Configuration, access the security tab and all I get is an error message stating that there is a problem with the selected data store "Unable to Connect to the SQL Server Database"

I have SQL Server 2005 (Express Edition). I have created a database "NetDev" with the right connection, etc.

I can use the SQL server fine for my Windows applications, but somehow this ASp.Net Configuration tool is not making any sense.

I also used the aspnet_regsql command from framework 2.0 to create a DataBase to no avail.

Does anyone out there knows if there is a bug with this tool???







View 1 Replies View Related

How To Access Named Instance Throug Ip Address

Oct 27, 2006

I installed Named instance in SQL 2005 Server (TESTAVTESTNETAV), now i am not able to acces this instance in SQL Query Ana.throug IP Address.

i am able to access this instance through name

How can i resolve this issue please help me out ??

View 9 Replies View Related

Access SQL Server 2005 Database Using A Published Website

Jun 26, 2006

Hi all,
 I am stuck with a problem using ASP.Net website. I created a website which accesses a database table in SQL Server 2005. The default.aspx is a form which inserts/updates/deletes data from the database. After creating the website I published it to IIS (Inetpub -> wwwroot). When I use Visual Studio 2005 and build the website and start with debugging. the form comes up and i can insert/update or delete the data from the table as I want. Now, as I have the website published I can access the form from another sharepoint website using the url as
/Employee_Data/Default.aspx">http://<mydesktop>/Employee_Data/Default.aspx
the form shows up but I am not able to access any of the database. I do not see any errors either. Once I click on the button the page just refreshes but nothing else happens. I have my web.config as :-
<?xml version="1.0"?>
<configuration>
<appSettings/>
<connectionStrings/>
<system.web>
<compilation debug="true"/>
<authentication mode="Windows"/>
</system.web>
</configuration>
 
Am I missing something? I even have Anonymous access in the IIS inetpub properties. I can even the database as I am the administrator..... I appreciate your suggestions.
 
Thanks,
Kavya

View 1 Replies View Related

Is It Possible To Have A Website Remotely Hosted, Which Would Access Local Database?

Dec 24, 2007

Hi everybody,
Currently we have a MIS application, developed in VB 6.0 - SQL Server 2000 platform, which is used by around 60 users in our office.
We are planning to host a website remotely, which would allow clients to place orders, track order status etc. on it.
Would it be possible to access our local SQL database from the remote website?
 

View 4 Replies View Related

Printing Address Labels Using Report Builder

Sep 22, 2007



Hi,

I need to create address labels from report builder. I can create the same from report designer using list box and text boxes. But not able to create the same from report builder as it is supporting only one layout - table (Columnar) for table type. Can any one help me to place the filelds in row wise rather than column wise.

View 3 Replies View Related

A Connection Could Not Be Made To The Report Server Http://[IP Address]/ReportServer

Dec 6, 2006

Hi

I have sql server 2005 Business Intelligent studio on my machine and Report server on some other machine. I created one rdl file and tried to deploy it on the report server. I have checked the report folder name and everything. But the error mentioned in the subject is being thrown. Additional information is

The request failed with HTTP status 407: Proxy Authentication Required. (Microsoft.ReportingServices.Designer)

Please let me know what all I need to do to resolve the problem.

Regards

Rajesh





View 1 Replies View Related

Address Windowing Extensions (AWE) Requires The 'lock Pages In Memory' Privilege Which Is Not Currently Present In The Access To

Feb 6, 2008

I've read all the posts... set the security policy (for the service account running SQL Server) to lock pages in memory... ran gpupdate... still same error... HELP !!!!

View 1 Replies View Related

Reporting Services :: Hide SSRS Report Address Bar In JavaScript Window

Aug 2, 2015

I need to hide the address bar in the SSRS report pop-up using the JavaScript. I tried using below property

"&rc:Toolbar=False"
="javascript:void(window.open('https://dev/PWA/ProjectBICenter/_vti_bin/reportserver?https://dev/PWA/ProjectBICenter/Report Library/ProjectStatusReport.rdl&rv:Paramode=Hidden&rc:Toolbar=False&rv:HeaderArea=None&vuidProjectUID=Fields!ProjectUID.Value','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=800'))"

What I am missing using this property?

View 6 Replies View Related

Reporting Services :: Domain User - Unable To Run Report In SSRS Report Manager?

Oct 9, 2015

I have done the following and a domain user would not access report created a login to the SQL server to the user (this SQL Server is where data source DB is)went to site setting in Report Manager and made this use a system userright clicked on report folder and made this user in the browser roleeven checked that in the report in question, the user is already in the browser role Still the user would not access the report! "User .......... does not have required permission" is the error message I am getting. 

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved