Connect to remote RS in SSMS

Got following error when try to connect to remote reporting service in SSMS:

TITLE: Microsoft SQL Server Management Studio

The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

OK

No problem to connect to reporting service in SSMS on RS box locally. Use windows authentication with same account in both case. How to configure that? Thanks.

Odd - You're logged in on as the same user on both computers? Are both computers in the same domain?

Can you access the report server in a web browser from the remote computer?

If you can, try this:

in the SSMS connection dialog. Replace machine\instance in the server textbox with the URL to your report server, e.g. http://yourserver/reportserver.

Does that work?

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||Yes, I can access the report server in a web browser from same remote computer where I tried to connect RS in SSMS. Replacing server name with RS url doesn't work either, got same 401 error.|||Is the user in the Administrators group on the box?|||Yes, it's local admin on both server and client machine.|||Very strange.. Since it is a 401 error, maybe you could look in the %windir%\system32\LogFiles\W3SVC1 for the latest log file to see what request is being denied.|||

Another thing to try is to change the Authentication Type to Digest in Management Studio when logging in from the remote machine. Type in your windows credentials and see if you get the same error.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I found followings in the log file, any hint? By the way, got same error when try to connect with basic authentication. Thanks.

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 2 2148074254

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 1 0

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 301 0 0

2005-12-30 14:15:55 172.20.193.76 GET /reportsdr/home.aspx - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 302 0 0

|||

Looks like you're passing the Report Manager virutal directory. You need to pass the report server virtual directory.

By default these are:

Report Manager: http://localhost/reports

Report Server: http://localhost/reportserver

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||Worked with report server url, thanks for the help.|||Glad to see it worked for you.

Can you provide the IIS logs for when you try to connect using just

server\instance in the SSMS connection dialog. I'm curious to

know why you can't connect to RS with management studio.

Thanks,

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.|||

Did you ever find out why you couldn't just us the servername in SSMS? I am having this same problem.

Thanks,

Bryan

|||No, fine with me to use url.

Confused with FQDNs

Hi NG,
if i call a report with
http://servername/report everything works fine.
If i call the report with
http://servername.domain.com/report the report failed because he couldn't
find the datasource to the olap-cube.
I use win-auth on iis.
Any suggests?
FrankFrank Matthiesen wrote:
> Any suggests?
Solved...
frank

Configuring SIS in a Cluster problem

I am attempting to configure SIS in a clustered environment using the
instructions found at http://msdn2.microsoft.com/en-us/library/ms345193.aspx.
I have added the required dependancies to a new generic resource in
the Cluster Adminstration screen and it is now asking me for DHCP
Service Parameters such as Database Path; Audit File Path, Backup
Path. These are not discussed in the instructions in the instructions
and I can't find any info on this page. Can anyone advise what
information the wizard is looking for here?
My SysAdmin tells me we are getting DHCP from Novel, if that helps.
On Dec 10, 10:11 am, Fayven Wren <FayvenW...@.gmail.com> wrote:
> I am attempting to configure SIS in a clustered environment using the
> instructions found athttp://msdn2.microsoft.com/en-us/library/ms345193.aspx.
> I have added the required dependancies to a new generic resource in
> the Cluster Adminstration screen and it is now asking me for DHCP
> Service Parameters such as Database Path; Audit File Path, Backup
> Path. These are not discussed in the instructions in the instructions
> and I can't find any info on this page. Can anyone advise what
> information the wizard is looking for here?
> My SysAdmin tells me we are getting DHCP from Novel, if that helps.
My Bad. Misread the instructions and did not specify the Service Type
as "Generic Service".

Configuring reporting services

Hello Experts,

I have this problem when i go to http://<servername>/reprots

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

I dont have any problem viewing the deployed reports from the site, http://<servername>/reportserver. only issue is in viewing report manager.

i have searched the forums and did all the suggested changes required in the config file, by adding the full report url and removing the entries in the virtualdirectory tag. still it didnt help....

would be great if someone suggests.

regards,

lakshman.

Hi Lakshman,

Is it RS 2000 or 2005? In RS 2005, you can use RS config tool to see if all sections are correctly configured. If not, fix the problems using the config tool and try again.

Thanks,
Sharmila

|||

Hi Sharmila,

Thanks for the reply.

Its RS2005. I am pretty new to the subject, can you please guide about using the RSConfig tool. Or resources where i can find the subject.

Best Regards,

Lakshman.

|||

Hi Sharmila,

At the command prompt, I have done the following actions:

C:\>rsconfig -c -s iplserver -d iplserver -a SQL -u sa -p P@.ssword123445
The command completed successfully

C:\>iisreset
Attempting stop...
Internet services successfully stopped
Attempting start...
Internet services successfully restarted

C:\>

when i try to access the report manager, the error persists.

pl let me know if i have to do something else.

many thanks,

lakshman.

|||

Hi Lakshman,

To access the config tool, go to Start ->All Programs -> Microsoft SQL Server -> Configuration Tools -> Reporting Services Configuration. Make sure that all sections are configured properly. You should see a green check mark. Please try this and let me know.

Thanks,
Sharmila

|||

Lakshman Pilaka wrote:

Hello Experts,

I have this problem when i go to http://<servername>/reprots

Is it safe to assume the mispelling of Reports is only here in the forums?

|||

oops, i wrote it wrong here in the thread, but i was spelling it correctly when i am testing...

Sharmila, thanks for the msg, I have checked that one and got to see that there is a blue exclamation for the "Encryption Keys". and the initialization is not done, i find a red cross. but rest all are okay with a green check mark.

i am not even able to access it the Initialization tab as its giving an error message,

plz help, or just guied me to a resource where i can have all this information..

i appreciate all your time and efforts,

lakshman.

|||

Hi,

I have installed the SQL SP2 on the server, and now the server is properly initialized. now i see a green check mark on all the tabs.

But unfortunately the problem still persists. I am seeing the same error:

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

when i attempt to go to http://<reportserver>/reports

what could be the problem?

many thanks,

lakshman.

|||

Hi Lakshman,

Can you please take a look at the RS logs located here - %programfiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles and see what you can find around the same time you see the error or can you include information from the logs?

Thanks,
Sharmila

Configuring HTTP access to SQL SERVER 2005 AS

Hi all, I have tried to configure HTTP access on SQL SERVER 2005 AS on a Windows XP machine but I am failing. When I try to browse i get errors.Could anyone help me out.

The last question is should I leave the security settings when configuring IIS as default.

Ronaldlee

Are you using instructions from http://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx

Try using first "Integrated Windows authentication" in your virtual directory and using Profiler see if Analysis Server is getting AuditLogin event.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows 2000

Microsoft has kindly posted articles on how to configure 2005 SSAS for
HTTP (formerly called XMLA) for Windows XP and Windows 2003 here:
http://www.microsoft.com/technet/pro.../httpasws.mspx
http://www.microsoft.com/technet/pro.../httpssas.mspx
However, I have not been able to find documentation to support or
refute support of this feature on Windows 2000. Is it possible to use
the native XMLA/SOAP support of SQL2005 when hosted on a Windows 2000
server?
Thanks!
Sorry, but I think you have to have XP or 2003. the native HTTP/SOAP support
in SQL Server does not work on 2000. I am not sure if SSAS for HTTP does
though. You need to check in an AS specific newsgroup.
Best regards
Michael
<russel.krause@.upsidesoft.com> wrote in message
news:1143500586.771866.101310@.j33g2000cwa.googlegr oups.com...
> Microsoft has kindly posted articles on how to configure 2005 SSAS for
> HTTP (formerly called XMLA) for Windows XP and Windows 2003 here:
> http://www.microsoft.com/technet/pro.../httpasws.mspx
> http://www.microsoft.com/technet/pro.../httpssas.mspx
> However, I have not been able to find documentation to support or
> refute support of this feature on Windows 2000. Is it possible to use
> the native XMLA/SOAP support of SQL2005 when hosted on a Windows 2000
> server?
> Thanks!
>

Configure Report Server with SQL Server Express with Advanced Services.

I am having trouble with SQL Express Reporting services.

When going to http:/localhost/reports I get the following error message:

"The report server is not responding. Verify that the report server is running and can be accessed from this computer."

In configuring the Report Server Virtual Directory, it would not let me set the name as "Report Server", so I named it "Report Server2".

I have tried uninstalling .NET framework v2 and reinstalling, but this does not help.

Any ideas?

By default, Express Advanced installs Report Server to a name instance, so you should be trying to get to http://localhost/reports$sqlexress. A default installation should have configured the virtual directory for you.

You can open SQL Server Configuration Manager and it will show you if the reporting service is running and if it has a name.

Mike