After successfully setting up RS on a Win2k server I've been trying to
get forms authentication sample working. I went through all the steps
given at
http://msdn.microsoft.com/sql/sqlwarehouse/reportingservices/default.aspx?pull=/library/en-us/dnsql2k/html/ufairs.asp
but when I get to the login page and try to register a user I get the
following:
An error occurred while attempting to add the account. SQL Server does
not exist or access denied.
I am having trouble finding any documentation on this. Has anyone run
into a similar problem before, and if so, what was the solution?See my other post regarding forms authentication and mixed security. Does
that solve the problem?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Oleg Raskin" <oleg@.rhd.org> wrote in message
news:1103132329.322870.140150@.f14g2000cwb.googlegroups.com...
> After successfully setting up RS on a Win2k server I've been trying to
> get forms authentication sample working. I went through all the steps
> given at
> http://msdn.microsoft.com/sql/sqlwarehouse/reportingservices/default.aspx?pull=/library/en-us/dnsql2k/html/ufairs.asp
> but when I get to the login page and try to register a user I get the
> following:
> An error occurred while attempting to add the account. SQL Server does
> not exist or access denied.
> I am having trouble finding any documentation on this. Has anyone run
> into a similar problem before, and if so, what was the solution?
>sql
Showing posts with label win2k. Show all posts
Showing posts with label win2k. Show all posts
Tuesday, March 27, 2012
Forms authentication sample
Forms Authentication sample
After successfully setting up RS on a Win2k server I've been trying to
get forms authentication sample working. I went through all the steps
given in the MSDN article but when I get to the login page and try to
register a user I get the following:
An error occurred while attempting to add the account. SQL Server does
not exist or access denied.
It's worth mentioning that RS and the database reside on 2 different
servers, but this setup was working just fine with NT-based
authentication.
I am having trouble finding any documentation on this. Has anyone run
into a similar problem before, and if so, what was the solution?
Thanks for any info.Hope you implemented your Custom Security correctly...
Try to debug -custom security- when trying to login.
b/w are you trying to login using using "Username" ?
I am able to get this(form authen) working in my last two projects and it
always works like a charm
"Oleg Raskin" wrote:
> After successfully setting up RS on a Win2k server I've been trying to
> get forms authentication sample working. I went through all the steps
> given in the MSDN article but when I get to the login page and try to
> register a user I get the following:
> An error occurred while attempting to add the account. SQL Server does
> not exist or access denied.
> It's worth mentioning that RS and the database reside on 2 different
> servers, but this setup was working just fine with NT-based
> authentication.
> I am having trouble finding any documentation on this. Has anyone run
> into a similar problem before, and if so, what was the solution?
> Thanks for any info.
>|||Is your database set to mixed security? I've had some problems with the
ReportServer service connecting to a database using SQL authentication until
I changed the Log On account (Control Panel > Administrative Tools >
Services > ReportServer) to an account that the database recognizes. I
know, that seems weird to me too, since I'm using SQL authentication for
this connection.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Oleg Raskin" <oleg@.rhd.org> wrote in message
news:1103133182.531381.92650@.z14g2000cwz.googlegroups.com...
> After successfully setting up RS on a Win2k server I've been trying to
> get forms authentication sample working. I went through all the steps
> given in the MSDN article but when I get to the login page and try to
> register a user I get the following:
> An error occurred while attempting to add the account. SQL Server does
> not exist or access denied.
> It's worth mentioning that RS and the database reside on 2 different
> servers, but this setup was working just fine with NT-based
> authentication.
> I am having trouble finding any documentation on this. Has anyone run
> into a similar problem before, and if so, what was the solution?
> Thanks for any info.
>
get forms authentication sample working. I went through all the steps
given in the MSDN article but when I get to the login page and try to
register a user I get the following:
An error occurred while attempting to add the account. SQL Server does
not exist or access denied.
It's worth mentioning that RS and the database reside on 2 different
servers, but this setup was working just fine with NT-based
authentication.
I am having trouble finding any documentation on this. Has anyone run
into a similar problem before, and if so, what was the solution?
Thanks for any info.Hope you implemented your Custom Security correctly...
Try to debug -custom security- when trying to login.
b/w are you trying to login using using "Username" ?
I am able to get this(form authen) working in my last two projects and it
always works like a charm
"Oleg Raskin" wrote:
> After successfully setting up RS on a Win2k server I've been trying to
> get forms authentication sample working. I went through all the steps
> given in the MSDN article but when I get to the login page and try to
> register a user I get the following:
> An error occurred while attempting to add the account. SQL Server does
> not exist or access denied.
> It's worth mentioning that RS and the database reside on 2 different
> servers, but this setup was working just fine with NT-based
> authentication.
> I am having trouble finding any documentation on this. Has anyone run
> into a similar problem before, and if so, what was the solution?
> Thanks for any info.
>|||Is your database set to mixed security? I've had some problems with the
ReportServer service connecting to a database using SQL authentication until
I changed the Log On account (Control Panel > Administrative Tools >
Services > ReportServer) to an account that the database recognizes. I
know, that seems weird to me too, since I'm using SQL authentication for
this connection.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Oleg Raskin" <oleg@.rhd.org> wrote in message
news:1103133182.531381.92650@.z14g2000cwz.googlegroups.com...
> After successfully setting up RS on a Win2k server I've been trying to
> get forms authentication sample working. I went through all the steps
> given in the MSDN article but when I get to the login page and try to
> register a user I get the following:
> An error occurred while attempting to add the account. SQL Server does
> not exist or access denied.
> It's worth mentioning that RS and the database reside on 2 different
> servers, but this setup was working just fine with NT-based
> authentication.
> I am having trouble finding any documentation on this. Has anyone run
> into a similar problem before, and if so, what was the solution?
> Thanks for any info.
>
Monday, March 26, 2012
Forms Authentication - Error about 'text/html; charset=utf-8'
I saw post on the same issue but it is not answered.
I use win2k server and reporting service standard edition. The register
function works fine. But When I try to log on to http://servername/reports, I
get the following error:
Client found response content type of 'text/html; charset=utf-8', but
expected 'text/xml'. The request failed with the error message: --
Reporting Services Erro
----
This operation is not supported in this edition of Reporting Services
(rsOperationNotSupported) Get Online Help
----
Microsoft Reporting Services --.
********************************************
Is this because of the Standard edition of reporting service?
Any help will be appreciated.
MichaelStandard edition doesn't support custom security extensions (which is what
the forms auth extension is).
http://www.microsoft.com/sql/reporting/productinfo/features.asp
--
Adrian M.
MCP
"bsanders" <missisummer@.community.nospam> wrote in message
news:F24683E8-1410-4C27-B478-6D2F7407FD42@.microsoft.com...
>I saw post on the same issue but it is not answered.
> I use win2k server and reporting service standard edition. The register
> function works fine. But When I try to log on to
> http://servername/reports, I
> get the following error:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'. The request failed with the error message: --
> Reporting Services Error
> ----
> This operation is not supported in this edition of Reporting Services
> (rsOperationNotSupported) Get Online Help
> ----
> Microsoft Reporting Services --.
> ********************************************
> Is this because of the Standard edition of reporting service?
> Any help will be appreciated.
> Michael|||Hello Michael,
By default, Reporting Services uses a Windows-based authentication
extension, which uses Windows account protocols to verify the identities of
users who claim to have accounts on the system. Reporting Services uses a
role-based security system to authorize users. The Reporting Services
role-based security model is similar to the role-based security models of
other technologies.
Because security extensions are based on an open and extensible API, you
can create new authentication and authorization extensions in Reporting
Services. However, Security extension API is not supported in Reporting
Services Standard Edition.
For more detailed information, you can also refer to the following article:
Using Forms Authentication in Reporting Services
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/ufairs.asp?frame=true
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
I use win2k server and reporting service standard edition. The register
function works fine. But When I try to log on to http://servername/reports, I
get the following error:
Client found response content type of 'text/html; charset=utf-8', but
expected 'text/xml'. The request failed with the error message: --
Reporting Services Erro
----
This operation is not supported in this edition of Reporting Services
(rsOperationNotSupported) Get Online Help
----
Microsoft Reporting Services --.
********************************************
Is this because of the Standard edition of reporting service?
Any help will be appreciated.
MichaelStandard edition doesn't support custom security extensions (which is what
the forms auth extension is).
http://www.microsoft.com/sql/reporting/productinfo/features.asp
--
Adrian M.
MCP
"bsanders" <missisummer@.community.nospam> wrote in message
news:F24683E8-1410-4C27-B478-6D2F7407FD42@.microsoft.com...
>I saw post on the same issue but it is not answered.
> I use win2k server and reporting service standard edition. The register
> function works fine. But When I try to log on to
> http://servername/reports, I
> get the following error:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'. The request failed with the error message: --
> Reporting Services Error
> ----
> This operation is not supported in this edition of Reporting Services
> (rsOperationNotSupported) Get Online Help
> ----
> Microsoft Reporting Services --.
> ********************************************
> Is this because of the Standard edition of reporting service?
> Any help will be appreciated.
> Michael|||Hello Michael,
By default, Reporting Services uses a Windows-based authentication
extension, which uses Windows account protocols to verify the identities of
users who claim to have accounts on the system. Reporting Services uses a
role-based security system to authorize users. The Reporting Services
role-based security model is similar to the role-based security models of
other technologies.
Because security extensions are based on an open and extensible API, you
can create new authentication and authorization extensions in Reporting
Services. However, Security extension API is not supported in Reporting
Services Standard Edition.
For more detailed information, you can also refer to the following article:
Using Forms Authentication in Reporting Services
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/ufairs.asp?frame=true
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Posts (Atom)