Thursday, March 22, 2012
accessing asp.net app on client
my configuration:
client - client1
asp.net app - dev1
rs server/db - dev2
sql db - dev3
i'm using nt authentication
the following vb.net code is used for creditentials
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
and yes i do have impersonate = true
however, i do have aIf you impersonate client in you Web App you are hitting the limitation of
NT authentications. NTLM impersonation only survives one machine hop.
client->dev1 is OK, however dev1->dev2 is not possible after that. You need
to enable Kerberos delegations for this.
If you are not impersonating client in your web app, you need to run your
web app under account, known to machine dev2, such as domain account and
give that account rights to report server.
--
Dmitry Vasilevsky, SQL Server Reporting Services Developer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
---
"mg" <mg@.discussions.microsoft.com> wrote in message
news:6B13373C-36E8-409A-BE6A-1FE8EBF6F31D@.microsoft.com...
> I keep getting this "the request failed with http status 401:
Unauthorized." error when i access the web app from a client machine.
> my configuration:
> client - client1
> asp.net app - dev1
> rs server/db - dev2
> sql db - dev3
> i'm using nt authentication
> the following vb.net code is used for creditentials
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> and yes i do have impersonate = true
> however, i do have a
>
Accessing Analysis Services 2005 from MS Excel using HTTP from Windows 2000 Server
I have installed and configured SQL Server 2005 Analysis Services and MS Office 2000 with the latest Service Packs on Windows 2000 Server. I am able to connect to my Analysis Services from MS Excel using the following URl in Excel ...
http://<ip address>/olap/msmdpump.dll ("olap" being my Virtual Directory)
I was wondering whether I would be able to connect to the same service without using the fully qualified path with only IP-Address... i.e... using only
http://<ip address>
I have been able to implement the above in Windows 2003 Server, but having problems doing the same in Windows 2000 Server. Can anyone help?
Thanks in Advance
How were you able to do so in Windows 2003? I've tried using IIS 6.0 to redirect, but without success.
Monday, March 19, 2012
Access Workflow Designer Server, MOD2000 and SQL 7.0 SP4
http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;253482
Microsoft says this issue was fixed in MOD2000 SP1. What I did is = install MOD 2000 SP1 and then tried to install the
Access Workflow Designer. Yes it is in Per Seat Mode. Anyway the = install still fails. So I am thinking maybe I need
to integrate this MOD2000 SP1 in with the Developer Tools which I have = on disk so if that's right I should be able to
do it. Only I don't know how. Can anyone give any suggestions how to = get this application in by slipstreaming the SP1
in with the developer tools? Thanks.
-- George Hester
_________________________________You'll probably want to post this in one of the access
newsgroups instead. Try:
microsoft.public.access.devtoolkits
-Sue
On Wed, 26 Jan 2005 20:30:33 -0500, "George Hester"
<hesterloli@.hotmail.com> wrote:
>in Windows 2000 SP2. Please take a look at this article:
>http://support.microsoft.com/default.aspx?scid=kb;en-us;253482
>Microsoft says this issue was fixed in MOD2000 SP1. What I did is install MOD 2000 SP1 and then tried to install the
>Access Workflow Designer. Yes it is in Per Seat Mode. Anyway the install still fails. So I am thinking maybe I need
>to integrate this MOD2000 SP1 in with the Developer Tools which I have on disk so if that's right I should be able to
>do it. Only I don't know how. Can anyone give any suggestions how to get this application in by slipstreaming the SP1
>in with the developer tools? Thanks.|||Tried. Thanks though.
-- George Hester
_________________________________
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message =news:8nhgv05rc9lte54bkh5r0du4go5q07pv2p@.4ax.com...
> You'll probably want to post this in one of the access
> newsgroups instead. Try:
> microsoft.public.access.devtoolkits
> > -Sue
> > On Wed, 26 Jan 2005 20:30:33 -0500, "George Hester"
> <hesterloli@.hotmail.com> wrote:
> > >in Windows 2000 SP2. Please take a look at this article:
> >
> >http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;253482
> >
> >Microsoft says this issue was fixed in MOD2000 SP1. What I did is =install MOD 2000 SP1 and then tried to install the
> >Access Workflow Designer. Yes it is in Per Seat Mode. Anyway the =install still fails. So I am thinking maybe I need
> >to integrate this MOD2000 SP1 in with the Developer Tools which I =have on disk so if that's right I should be able to
> >do it. Only I don't know how. Can anyone give any suggestions how =to get this application in by slipstreaming the SP1
> >in with the developer tools? Thanks.
>=20
Thursday, March 8, 2012
Access to RSReportServer.config is denied
Dear All,
i am a new in the SSRS , and i face a problem when i try the link http://localhost/reportserver
an error message appear as the following
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied(i am accessing my PC with a user that under domain differ from my local domain i dont know that if the information help or not )
i dont know what i do , but i excepect someone answer me soon.
Best wishes and sorry for the long talking
Maylo
http://prologika.com/CS/blogs/blog/archive/2007/07/12/ssrs-setup-woes.aspx
|||
About the Question i had asked ,
i found its solution and know what was the problem,
so i like to share it with You all ,
all i have done is setting the Reporting Services Configuration that was need to be configure
you can find it in the following path:
from the start menu ==> All program ==>Microsoft SQL Server 2005 ==>Configuration Tools ==>Reporting Services Configuration
in my case most of the configration Was invalid and not configure right so i Reconfigure it and then everything is great after that.
Regards,
Maylo
Saturday, February 25, 2012
Access SQL Server 2005 via HTTP
Hi
Is it possible to access sql server 2005 via http and do some management and administration task?
Thanks in advance,
Larry
I believe that there may be a web based admin tool in development. Otherwise, your only good options are third party products or VPN.access sql server 2005 via http
Hi
Is it possible to access sql server 2005 via http and do some management and administration task? if possible how?
Thanks in advance,
Larry
Hi larry,I suggest you configure a windows 2000 or 2003 VPN or cisco VPN
to actually access the Sql server box via http
this is i think more secure.
You can however access sql server via SQL server Endpoint
but i suggest you do configure a VPN
since it is more secure
regards,
joey|||
http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en closely related to SQL 2000 or MSDE, but you are looking for SQL 2005 instance so as suggested endpoings are good to go, http://www.developer.com/db/article.php/3390241 and http://davidhayden.com/blog/dave/archive/2006/03/31/2897.aspxfyi..
http://codebetter.com/blogs/raymond.lewallen/archive/2005/06/23/65089.aspx tooq
Sunday, February 19, 2012
Access my SQL 2005 Express Database using http/https
Hi!
I'm new using MSSql 2005 Express. How can i access my DB using http/https for reporting and DB changes/administration?
Regards,
JP
SQL Server Reporting Services is available through the exposed websites and the appropiate ports. THere is no https support for administration. You will need direct port access to the specified port (by default 1433) for administration of SQL Server.HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
Saturday, February 11, 2012
Access denied to the access path !....ReportManager\bin
I write url Http://Servidor/Reports and present problem
Access denied to the Path C:\Archivos de programa\Microsoft SQL
Server\MSSQL\Reporting Services\ReportManager\bin".
Check the permisos and the user ASP.Net have Full acces
Thanks
HernanDid you checked the log file for the reportmanager and event log ?
"Hernan Arboleda" wrote:
> Hello
> I write url Http://Servidor/Reports and present problem
> Access denied to the Path C:\Archivos de programa\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportManager\bin".
> Check the permisos and the user ASP.Net have Full acces
> Thanks
> Hernan
>
>
Thursday, February 9, 2012
Access denied reports on http://localhost/Reports/
http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fWebCast1%2fLoanMatrix
I got error as follow:
You are not authorized to view this page
But I could acess report on http://localhost/ReportServer OK.
Notes: After everything installed, we changed the computer name from
Server02 to Dev01. And I noticed the IUSR_Server02 exists instead IUSRDev01.
Thanks,
CulamUse Enterprise Manager to add IUSRDev01 to the ReportServer
and ReportServerTempDB databases' Users, granting it the same
permissions as those of the IUSR_Server02 account.
Then delete the old account.
GeoSynch
"culam" <culam@.discussions.microsoft.com> wrote in message
news:8774E79E-5252-4EE2-8C88-EBD2E66032BC@.microsoft.com...
> When I access report on:
> http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fWebCast1%2fLoanMatrix
> I got error as follow:
> You are not authorized to view this page
> But I could acess report on http://localhost/ReportServer OK.
> Notes: After everything installed, we changed the computer name from
> Server02 to Dev01. And I noticed the IUSR_Server02 exists instead IUSRDev01.
> Thanks,
> Culam
Access Denied Error while Configuring
Hi,
I Installed SQL Reporting Developer edition on Windows 2000 Server.
After Installation, While Typing the Path http://localhost/Reports on the Browser, I am getting
Access to the Path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Reportmanager\bin" is denied Error.
What could be the Problem?
The User your IIS is running with doesn′t have access to the binary directory for the Resporting Server bin files. So either chnage your IIS Web Server account to a service account that has access to the bin files, or grant the already used account access to the directory.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de