I have installed SQL Server September CTP (Full Install) on a Windows 2003
Server with IIS 6 setup with SSL. I have also installed Visual Studio 2005
(Full Install).
I installed the custom security extension example that comes with the server
install and the AdventureWorks sample reports.
When I login to the web-based Report Manager I get the following error:
Key cannot be null. Parameter name: key
The error message is displayed on an rs manager like interface with no links.
I followed the instructions that came with the Custom security extension to
the tee. I have tried several different configurations including non-SSL and
nothing works.
Does anyone know what this error pertains to or has ANYONE been able to get
Forms Authentication work AT ALL? Microsoft is not responding to any of our
posts so I guess it's up to us.
Thanks in advance.I am having the same problem with the final release version. Did you ever
resolve this issue?
"Zach" wrote:
> I have installed SQL Server September CTP (Full Install) on a Windows 2003
> Server with IIS 6 setup with SSL. I have also installed Visual Studio 2005
> (Full Install).
> I installed the custom security extension example that comes with the server
> install and the AdventureWorks sample reports.
> When I login to the web-based Report Manager I get the following error:
> Key cannot be null. Parameter name: key
> The error message is displayed on an rs manager like interface with no links.
> I followed the instructions that came with the Custom security extension to
> the tee. I have tried several different configurations including non-SSL and
> nothing works.
> Does anyone know what this error pertains to or has ANYONE been able to get
> Forms Authentication work AT ALL? Microsoft is not responding to any of our
> posts so I guess it's up to us.
> Thanks in advance.
Showing posts with label ctp. Show all posts
Showing posts with label ctp. Show all posts
Tuesday, March 27, 2012
Forms Authentication Does Not Work in Sep CTP
Forms authentication still does not work in Sep CTP. I've been posting
questions in this forum for weeks and have received exactly 0 responses from
Microsoft. Do you guys even monitor this forum. There are lots of folks
trying to get forms authentication working and it sure does not help that you
took the 2000 instructions and just pasted them into the 2005 help file. I
get erros like:
Key cannot be null. Parameter name: key
which is not really helpful. I can't debug and find out what is causing the
error because I don't have the code. If you guys are so busy you can't
response to any of our questions then please just send me the source code to
report manager and reportingservices web server and I'll fix it for you so I
can get on with my life. I appologize if I'm a little terse but I've called
Microsoft offering to pay to get these issues resolved and I got the response
that I needed to be a BETA tester. So I became a BETA tester and then got
the response that the only interaction I have with MS is this newsgroup.
If there is a rouge MS developer out there willing to help me out just let
me know. Otherwise I can't really recommend my enterprise clients continue
down the SQL 2005 path.Zach,
Did you ever figure this out? I'm having the same problem with the RTM
version. I've got Forms Auth installed, I can register a user and login as
long as its not set as the adminUser. However, this user does not have any
rights to any reports. Also, I can't set the rights, because if I log in as
the admin user I get the same error message about "Key cannot be null.
Parameter name: key" Any suggestions from MS would be handy about now.
Jonathan Miller
webmaster@.accs.net
"Zach" wrote:
> Forms authentication still does not work in Sep CTP. I've been posting
> questions in this forum for weeks and have received exactly 0 responses from
> Microsoft. Do you guys even monitor this forum. There are lots of folks
> trying to get forms authentication working and it sure does not help that you
> took the 2000 instructions and just pasted them into the 2005 help file. I
> get erros like:
> Key cannot be null. Parameter name: key
> which is not really helpful. I can't debug and find out what is causing the
> error because I don't have the code. If you guys are so busy you can't
> response to any of our questions then please just send me the source code to
> report manager and reportingservices web server and I'll fix it for you so I
> can get on with my life. I appologize if I'm a little terse but I've called
> Microsoft offering to pay to get these issues resolved and I got the response
> that I needed to be a BETA tester. So I became a BETA tester and then got
> the response that the only interaction I have with MS is this newsgroup.
> If there is a rouge MS developer out there willing to help me out just let
> me know. Otherwise I can't really recommend my enterprise clients continue
> down the SQL 2005 path.|||Hi Jonathan,
Yes, I did finally figure it all out. The forms authentication sample code
shipped with the product has several bugs. There is also a bug in the sample
proxy for the web services calls. The key cannot be null error originates
from Authorization.GetPermissions. The problem is the base maps buit in
InitializeMaps are incorrect. You will have to make sure all available enum
entries are loaded into each map. You will also need to re-code the For Each
statements in GetPermissions to declare the variable oper as the correct type.
The bug in the Proxy class is in the GetWebResponse function. Change the
line that reads
AuthCookie = authCookie
to
Me.AuthCookie = authCookie
Hope this helps!
"Jonathan Miller" wrote:
> Zach,
> Did you ever figure this out? I'm having the same problem with the RTM
> version. I've got Forms Auth installed, I can register a user and login as
> long as its not set as the adminUser. However, this user does not have any
> rights to any reports. Also, I can't set the rights, because if I log in as
> the admin user I get the same error message about "Key cannot be null.
> Parameter name: key" Any suggestions from MS would be handy about now.
> Jonathan Miller
> webmaster@.accs.net
> "Zach" wrote:
> > Forms authentication still does not work in Sep CTP. I've been posting
> > questions in this forum for weeks and have received exactly 0 responses from
> > Microsoft. Do you guys even monitor this forum. There are lots of folks
> > trying to get forms authentication working and it sure does not help that you
> > took the 2000 instructions and just pasted them into the 2005 help file. I
> > get erros like:
> >
> > Key cannot be null. Parameter name: key
> >
> > which is not really helpful. I can't debug and find out what is causing the
> > error because I don't have the code. If you guys are so busy you can't
> > response to any of our questions then please just send me the source code to
> > report manager and reportingservices web server and I'll fix it for you so I
> > can get on with my life. I appologize if I'm a little terse but I've called
> > Microsoft offering to pay to get these issues resolved and I got the response
> > that I needed to be a BETA tester. So I became a BETA tester and then got
> > the response that the only interaction I have with MS is this newsgroup.
> >
> > If there is a rouge MS developer out there willing to help me out just let
> > me know. Otherwise I can't really recommend my enterprise clients continue
> > down the SQL 2005 path.|||The demo code that ships is busted' That stinks. Is there anyway you can
zip up the fixed version and email it to me? webmaster@.accs.net
Thanks again!
"Zach" wrote:
> Hi Jonathan,
> Yes, I did finally figure it all out. The forms authentication sample code
> shipped with the product has several bugs. There is also a bug in the sample
> proxy for the web services calls. The key cannot be null error originates
> from Authorization.GetPermissions. The problem is the base maps buit in
> InitializeMaps are incorrect. You will have to make sure all available enum
> entries are loaded into each map. You will also need to re-code the For Each
> statements in GetPermissions to declare the variable oper as the correct type.
> The bug in the Proxy class is in the GetWebResponse function. Change the
> line that reads
> AuthCookie = authCookie
> to
> Me.AuthCookie = authCookie
> Hope this helps!
> "Jonathan Miller" wrote:
> > Zach,
> >
> > Did you ever figure this out? I'm having the same problem with the RTM
> > version. I've got Forms Auth installed, I can register a user and login as
> > long as its not set as the adminUser. However, this user does not have any
> > rights to any reports. Also, I can't set the rights, because if I log in as
> > the admin user I get the same error message about "Key cannot be null.
> > Parameter name: key" Any suggestions from MS would be handy about now.
> >
> > Jonathan Miller
> > webmaster@.accs.net
> >
> > "Zach" wrote:
> >
> > > Forms authentication still does not work in Sep CTP. I've been posting
> > > questions in this forum for weeks and have received exactly 0 responses from
> > > Microsoft. Do you guys even monitor this forum. There are lots of folks
> > > trying to get forms authentication working and it sure does not help that you
> > > took the 2000 instructions and just pasted them into the 2005 help file. I
> > > get erros like:
> > >
> > > Key cannot be null. Parameter name: key
> > >
> > > which is not really helpful. I can't debug and find out what is causing the
> > > error because I don't have the code. If you guys are so busy you can't
> > > response to any of our questions then please just send me the source code to
> > > report manager and reportingservices web server and I'll fix it for you so I
> > > can get on with my life. I appologize if I'm a little terse but I've called
> > > Microsoft offering to pay to get these issues resolved and I got the response
> > > that I needed to be a BETA tester. So I became a BETA tester and then got
> > > the response that the only interaction I have with MS is this newsgroup.
> > >
> > > If there is a rouge MS developer out there willing to help me out just let
> > > me know. Otherwise I can't really recommend my enterprise clients continue
> > > down the SQL 2005 path.|||Hi Jonathan,
I also have the same problem opening the Sample Form Authentication.
Hope you don't mind to send the File that you have been fixed to me...
nicky_tsh@.hotmail.com
Thanks
Nicky
"Zach" wrote:
> Hi Jonathan,
> Yes, I did finally figure it all out. The forms authentication sample code
> shipped with the product has several bugs. There is also a bug in the sample
> proxy for the web services calls. The key cannot be null error originates
> from Authorization.GetPermissions. The problem is the base maps buit in
> InitializeMaps are incorrect. You will have to make sure all available enum
> entries are loaded into each map. You will also need to re-code the For Each
> statements in GetPermissions to declare the variable oper as the correct type.
> The bug in the Proxy class is in the GetWebResponse function. Change the
> line that reads
> AuthCookie = authCookie
> to
> Me.AuthCookie = authCookie
> Hope this helps!
> "Jonathan Miller" wrote:
> > Zach,
> >
> > Did you ever figure this out? I'm having the same problem with the RTM
> > version. I've got Forms Auth installed, I can register a user and login as
> > long as its not set as the adminUser. However, this user does not have any
> > rights to any reports. Also, I can't set the rights, because if I log in as
> > the admin user I get the same error message about "Key cannot be null.
> > Parameter name: key" Any suggestions from MS would be handy about now.
> >
> > Jonathan Miller
> > webmaster@.accs.net
> >
> > "Zach" wrote:
> >
> > > Forms authentication still does not work in Sep CTP. I've been posting
> > > questions in this forum for weeks and have received exactly 0 responses from
> > > Microsoft. Do you guys even monitor this forum. There are lots of folks
> > > trying to get forms authentication working and it sure does not help that you
> > > took the 2000 instructions and just pasted them into the 2005 help file. I
> > > get erros like:
> > >
> > > Key cannot be null. Parameter name: key
> > >
> > > which is not really helpful. I can't debug and find out what is causing the
> > > error because I don't have the code. If you guys are so busy you can't
> > > response to any of our questions then please just send me the source code to
> > > report manager and reportingservices web server and I'll fix it for you so I
> > > can get on with my life. I appologize if I'm a little terse but I've called
> > > Microsoft offering to pay to get these issues resolved and I got the response
> > > that I needed to be a BETA tester. So I became a BETA tester and then got
> > > the response that the only interaction I have with MS is this newsgroup.
> > >
> > > If there is a rouge MS developer out there willing to help me out just let
> > > me know. Otherwise I can't really recommend my enterprise clients continue
> > > down the SQL 2005 path.|||Can I also get a copy of the corrected code?|||Can I also get a copy of the corrected code?
ebertsch@.gmail.com|||I am very interested in this code as well.
Thanks,
mdg
"ebertsch@.gmail.com" wrote:
> Can I also get a copy of the corrected code?
> ebertsch@.gmail.com
>|||I am interested in this code as well....
Thanks for help,
Mdg
"ebertsch@.gmail.com" wrote:
> Can I also get a copy of the corrected code?
> ebertsch@.gmail.com
>|||Could I please also ask for the corrected code?
clyons@.camsoftdata.com
Thanks!
"Zach" wrote:
> Hi Jonathan,
> Yes, I did finally figure it all out. The forms authentication sample code
> shipped with the product has several bugs. There is also a bug in the sample
> proxy for the web services calls. The key cannot be null error originates
> from Authorization.GetPermissions. The problem is the base maps buit in
> InitializeMaps are incorrect. You will have to make sure all available enum
> entries are loaded into each map. You will also need to re-code the For Each
> statements in GetPermissions to declare the variable oper as the correct type.
> The bug in the Proxy class is in the GetWebResponse function. Change the
> line that reads
> AuthCookie = authCookie
> to
> Me.AuthCookie = authCookie
> Hope this helps!
> "Jonathan Miller" wrote:
> > Zach,
> >
> > Did you ever figure this out? I'm having the same problem with the RTM
> > version. I've got Forms Auth installed, I can register a user and login as
> > long as its not set as the adminUser. However, this user does not have any
> > rights to any reports. Also, I can't set the rights, because if I log in as
> > the admin user I get the same error message about "Key cannot be null.
> > Parameter name: key" Any suggestions from MS would be handy about now.
> >
> > Jonathan Miller
> > webmaster@.accs.net
> >
> > "Zach" wrote:
> >
> > > Forms authentication still does not work in Sep CTP. I've been posting
> > > questions in this forum for weeks and have received exactly 0 responses from
> > > Microsoft. Do you guys even monitor this forum. There are lots of folks
> > > trying to get forms authentication working and it sure does not help that you
> > > took the 2000 instructions and just pasted them into the 2005 help file. I
> > > get erros like:
> > >
> > > Key cannot be null. Parameter name: key
> > >
> > > which is not really helpful. I can't debug and find out what is causing the
> > > error because I don't have the code. If you guys are so busy you can't
> > > response to any of our questions then please just send me the source code to
> > > report manager and reportingservices web server and I'll fix it for you so I
> > > can get on with my life. I appologize if I'm a little terse but I've called
> > > Microsoft offering to pay to get these issues resolved and I got the response
> > > that I needed to be a BETA tester. So I became a BETA tester and then got
> > > the response that the only interaction I have with MS is this newsgroup.
> > >
> > > If there is a rouge MS developer out there willing to help me out just let
> > > me know. Otherwise I can't really recommend my enterprise clients continue
> > > down the SQL 2005 path.|||Just so you know - I never obtained that code so I can not forward it to you.
Thanks,
Michael Gardipee
"Chris_CamSoft" wrote:
> Could I please also ask for the corrected code?
> clyons@.camsoftdata.com
> Thanks!
>
> "Zach" wrote:
> > Hi Jonathan,
> >
> > Yes, I did finally figure it all out. The forms authentication sample code
> > shipped with the product has several bugs. There is also a bug in the sample
> > proxy for the web services calls. The key cannot be null error originates
> > from Authorization.GetPermissions. The problem is the base maps buit in
> > InitializeMaps are incorrect. You will have to make sure all available enum
> > entries are loaded into each map. You will also need to re-code the For Each
> > statements in GetPermissions to declare the variable oper as the correct type.
> >
> > The bug in the Proxy class is in the GetWebResponse function. Change the
> > line that reads
> > AuthCookie = authCookie
> > to
> > Me.AuthCookie = authCookie
> >
> > Hope this helps!
> >
> > "Jonathan Miller" wrote:
> >
> > > Zach,
> > >
> > > Did you ever figure this out? I'm having the same problem with the RTM
> > > version. I've got Forms Auth installed, I can register a user and login as
> > > long as its not set as the adminUser. However, this user does not have any
> > > rights to any reports. Also, I can't set the rights, because if I log in as
> > > the admin user I get the same error message about "Key cannot be null.
> > > Parameter name: key" Any suggestions from MS would be handy about now.
> > >
> > > Jonathan Miller
> > > webmaster@.accs.net
> > >
> > > "Zach" wrote:
> > >
> > > > Forms authentication still does not work in Sep CTP. I've been posting
> > > > questions in this forum for weeks and have received exactly 0 responses from
> > > > Microsoft. Do you guys even monitor this forum. There are lots of folks
> > > > trying to get forms authentication working and it sure does not help that you
> > > > took the 2000 instructions and just pasted them into the 2005 help file. I
> > > > get erros like:
> > > >
> > > > Key cannot be null. Parameter name: key
> > > >
> > > > which is not really helpful. I can't debug and find out what is causing the
> > > > error because I don't have the code. If you guys are so busy you can't
> > > > response to any of our questions then please just send me the source code to
> > > > report manager and reportingservices web server and I'll fix it for you so I
> > > > can get on with my life. I appologize if I'm a little terse but I've called
> > > > Microsoft offering to pay to get these issues resolved and I got the response
> > > > that I needed to be a BETA tester. So I became a BETA tester and then got
> > > > the response that the only interaction I have with MS is this newsgroup.
> > > >
> > > > If there is a rouge MS developer out there willing to help me out just let
> > > > me know. Otherwise I can't really recommend my enterprise clients continue
> > > > down the SQL 2005 path.|||I will assume that you, as I, were working with the VB.NET version of the
sample. The C# version works. I found out the hard way and have posted my
unhappy feelings towards Microsoft for shipping a sample on their production
CD's that didn't work. The version I am working with is the actual release
and not a CTP.
"Mdg" wrote:
> Just so you know - I never obtained that code so I can not forward it to you.
> Thanks,
> Michael Gardipee
>
> "Chris_CamSoft" wrote:
> > Could I please also ask for the corrected code?
> >
> > clyons@.camsoftdata.com
> >
> > Thanks!
> >
> >
> > "Zach" wrote:
> >
> > > Hi Jonathan,
> > >
> > > Yes, I did finally figure it all out. The forms authentication sample code
> > > shipped with the product has several bugs. There is also a bug in the sample
> > > proxy for the web services calls. The key cannot be null error originates
> > > from Authorization.GetPermissions. The problem is the base maps buit in
> > > InitializeMaps are incorrect. You will have to make sure all available enum
> > > entries are loaded into each map. You will also need to re-code the For Each
> > > statements in GetPermissions to declare the variable oper as the correct type.
> > >
> > > The bug in the Proxy class is in the GetWebResponse function. Change the
> > > line that reads
> > > AuthCookie = authCookie
> > > to
> > > Me.AuthCookie = authCookie
> > >
> > > Hope this helps!
> > >
> > > "Jonathan Miller" wrote:
> > >
> > > > Zach,
> > > >
> > > > Did you ever figure this out? I'm having the same problem with the RTM
> > > > version. I've got Forms Auth installed, I can register a user and login as
> > > > long as its not set as the adminUser. However, this user does not have any
> > > > rights to any reports. Also, I can't set the rights, because if I log in as
> > > > the admin user I get the same error message about "Key cannot be null.
> > > > Parameter name: key" Any suggestions from MS would be handy about now.
> > > >
> > > > Jonathan Miller
> > > > webmaster@.accs.net
> > > >
> > > > "Zach" wrote:
> > > >
> > > > > Forms authentication still does not work in Sep CTP. I've been posting
> > > > > questions in this forum for weeks and have received exactly 0 responses from
> > > > > Microsoft. Do you guys even monitor this forum. There are lots of folks
> > > > > trying to get forms authentication working and it sure does not help that you
> > > > > took the 2000 instructions and just pasted them into the 2005 help file. I
> > > > > get erros like:
> > > > >
> > > > > Key cannot be null. Parameter name: key
> > > > >
> > > > > which is not really helpful. I can't debug and find out what is causing the
> > > > > error because I don't have the code. If you guys are so busy you can't
> > > > > response to any of our questions then please just send me the source code to
> > > > > report manager and reportingservices web server and I'll fix it for you so I
> > > > > can get on with my life. I appologize if I'm a little terse but I've called
> > > > > Microsoft offering to pay to get these issues resolved and I got the response
> > > > > that I needed to be a BETA tester. So I became a BETA tester and then got
> > > > > the response that the only interaction I have with MS is this newsgroup.
> > > > >
> > > > > If there is a rouge MS developer out there willing to help me out just let
> > > > > me know. Otherwise I can't really recommend my enterprise clients continue
> > > > > down the SQL 2005 path.|||Actually, I was working with the C# code. The solution I implemented - in the
end - had me validating users against a custom provider (our SQL back end)
and that worked fine for us.
"Chris_CamSoft" wrote:
> I will assume that you, as I, were working with the VB.NET version of the
> sample. The C# version works. I found out the hard way and have posted my
> unhappy feelings towards Microsoft for shipping a sample on their production
> CD's that didn't work. The version I am working with is the actual release
> and not a CTP.
>
> "Mdg" wrote:
> > Just so you know - I never obtained that code so I can not forward it to you.
> >
> > Thanks,
> > Michael Gardipee
> >
> >
> > "Chris_CamSoft" wrote:
> >
> > > Could I please also ask for the corrected code?
> > >
> > > clyons@.camsoftdata.com
> > >
> > > Thanks!
> > >
> > >
> > > "Zach" wrote:
> > >
> > > > Hi Jonathan,
> > > >
> > > > Yes, I did finally figure it all out. The forms authentication sample code
> > > > shipped with the product has several bugs. There is also a bug in the sample
> > > > proxy for the web services calls. The key cannot be null error originates
> > > > from Authorization.GetPermissions. The problem is the base maps buit in
> > > > InitializeMaps are incorrect. You will have to make sure all available enum
> > > > entries are loaded into each map. You will also need to re-code the For Each
> > > > statements in GetPermissions to declare the variable oper as the correct type.
> > > >
> > > > The bug in the Proxy class is in the GetWebResponse function. Change the
> > > > line that reads
> > > > AuthCookie = authCookie
> > > > to
> > > > Me.AuthCookie = authCookie
> > > >
> > > > Hope this helps!
> > > >
> > > > "Jonathan Miller" wrote:
> > > >
> > > > > Zach,
> > > > >
> > > > > Did you ever figure this out? I'm having the same problem with the RTM
> > > > > version. I've got Forms Auth installed, I can register a user and login as
> > > > > long as its not set as the adminUser. However, this user does not have any
> > > > > rights to any reports. Also, I can't set the rights, because if I log in as
> > > > > the admin user I get the same error message about "Key cannot be null.
> > > > > Parameter name: key" Any suggestions from MS would be handy about now.
> > > > >
> > > > > Jonathan Miller
> > > > > webmaster@.accs.net
> > > > >
> > > > > "Zach" wrote:
> > > > >
> > > > > > Forms authentication still does not work in Sep CTP. I've been posting
> > > > > > questions in this forum for weeks and have received exactly 0 responses from
> > > > > > Microsoft. Do you guys even monitor this forum. There are lots of folks
> > > > > > trying to get forms authentication working and it sure does not help that you
> > > > > > took the 2000 instructions and just pasted them into the 2005 help file. I
> > > > > > get erros like:
> > > > > >
> > > > > > Key cannot be null. Parameter name: key
> > > > > >
> > > > > > which is not really helpful. I can't debug and find out what is causing the
> > > > > > error because I don't have the code. If you guys are so busy you can't
> > > > > > response to any of our questions then please just send me the source code to
> > > > > > report manager and reportingservices web server and I'll fix it for you so I
> > > > > > can get on with my life. I appologize if I'm a little terse but I've called
> > > > > > Microsoft offering to pay to get these issues resolved and I got the response
> > > > > > that I needed to be a BETA tester. So I became a BETA tester and then got
> > > > > > the response that the only interaction I have with MS is this newsgroup.
> > > > > >
> > > > > > If there is a rouge MS developer out there willing to help me out just let
> > > > > > me know. Otherwise I can't really recommend my enterprise clients continue
> > > > > > down the SQL 2005 path.
questions in this forum for weeks and have received exactly 0 responses from
Microsoft. Do you guys even monitor this forum. There are lots of folks
trying to get forms authentication working and it sure does not help that you
took the 2000 instructions and just pasted them into the 2005 help file. I
get erros like:
Key cannot be null. Parameter name: key
which is not really helpful. I can't debug and find out what is causing the
error because I don't have the code. If you guys are so busy you can't
response to any of our questions then please just send me the source code to
report manager and reportingservices web server and I'll fix it for you so I
can get on with my life. I appologize if I'm a little terse but I've called
Microsoft offering to pay to get these issues resolved and I got the response
that I needed to be a BETA tester. So I became a BETA tester and then got
the response that the only interaction I have with MS is this newsgroup.
If there is a rouge MS developer out there willing to help me out just let
me know. Otherwise I can't really recommend my enterprise clients continue
down the SQL 2005 path.Zach,
Did you ever figure this out? I'm having the same problem with the RTM
version. I've got Forms Auth installed, I can register a user and login as
long as its not set as the adminUser. However, this user does not have any
rights to any reports. Also, I can't set the rights, because if I log in as
the admin user I get the same error message about "Key cannot be null.
Parameter name: key" Any suggestions from MS would be handy about now.
Jonathan Miller
webmaster@.accs.net
"Zach" wrote:
> Forms authentication still does not work in Sep CTP. I've been posting
> questions in this forum for weeks and have received exactly 0 responses from
> Microsoft. Do you guys even monitor this forum. There are lots of folks
> trying to get forms authentication working and it sure does not help that you
> took the 2000 instructions and just pasted them into the 2005 help file. I
> get erros like:
> Key cannot be null. Parameter name: key
> which is not really helpful. I can't debug and find out what is causing the
> error because I don't have the code. If you guys are so busy you can't
> response to any of our questions then please just send me the source code to
> report manager and reportingservices web server and I'll fix it for you so I
> can get on with my life. I appologize if I'm a little terse but I've called
> Microsoft offering to pay to get these issues resolved and I got the response
> that I needed to be a BETA tester. So I became a BETA tester and then got
> the response that the only interaction I have with MS is this newsgroup.
> If there is a rouge MS developer out there willing to help me out just let
> me know. Otherwise I can't really recommend my enterprise clients continue
> down the SQL 2005 path.|||Hi Jonathan,
Yes, I did finally figure it all out. The forms authentication sample code
shipped with the product has several bugs. There is also a bug in the sample
proxy for the web services calls. The key cannot be null error originates
from Authorization.GetPermissions. The problem is the base maps buit in
InitializeMaps are incorrect. You will have to make sure all available enum
entries are loaded into each map. You will also need to re-code the For Each
statements in GetPermissions to declare the variable oper as the correct type.
The bug in the Proxy class is in the GetWebResponse function. Change the
line that reads
AuthCookie = authCookie
to
Me.AuthCookie = authCookie
Hope this helps!
"Jonathan Miller" wrote:
> Zach,
> Did you ever figure this out? I'm having the same problem with the RTM
> version. I've got Forms Auth installed, I can register a user and login as
> long as its not set as the adminUser. However, this user does not have any
> rights to any reports. Also, I can't set the rights, because if I log in as
> the admin user I get the same error message about "Key cannot be null.
> Parameter name: key" Any suggestions from MS would be handy about now.
> Jonathan Miller
> webmaster@.accs.net
> "Zach" wrote:
> > Forms authentication still does not work in Sep CTP. I've been posting
> > questions in this forum for weeks and have received exactly 0 responses from
> > Microsoft. Do you guys even monitor this forum. There are lots of folks
> > trying to get forms authentication working and it sure does not help that you
> > took the 2000 instructions and just pasted them into the 2005 help file. I
> > get erros like:
> >
> > Key cannot be null. Parameter name: key
> >
> > which is not really helpful. I can't debug and find out what is causing the
> > error because I don't have the code. If you guys are so busy you can't
> > response to any of our questions then please just send me the source code to
> > report manager and reportingservices web server and I'll fix it for you so I
> > can get on with my life. I appologize if I'm a little terse but I've called
> > Microsoft offering to pay to get these issues resolved and I got the response
> > that I needed to be a BETA tester. So I became a BETA tester and then got
> > the response that the only interaction I have with MS is this newsgroup.
> >
> > If there is a rouge MS developer out there willing to help me out just let
> > me know. Otherwise I can't really recommend my enterprise clients continue
> > down the SQL 2005 path.|||The demo code that ships is busted' That stinks. Is there anyway you can
zip up the fixed version and email it to me? webmaster@.accs.net
Thanks again!
"Zach" wrote:
> Hi Jonathan,
> Yes, I did finally figure it all out. The forms authentication sample code
> shipped with the product has several bugs. There is also a bug in the sample
> proxy for the web services calls. The key cannot be null error originates
> from Authorization.GetPermissions. The problem is the base maps buit in
> InitializeMaps are incorrect. You will have to make sure all available enum
> entries are loaded into each map. You will also need to re-code the For Each
> statements in GetPermissions to declare the variable oper as the correct type.
> The bug in the Proxy class is in the GetWebResponse function. Change the
> line that reads
> AuthCookie = authCookie
> to
> Me.AuthCookie = authCookie
> Hope this helps!
> "Jonathan Miller" wrote:
> > Zach,
> >
> > Did you ever figure this out? I'm having the same problem with the RTM
> > version. I've got Forms Auth installed, I can register a user and login as
> > long as its not set as the adminUser. However, this user does not have any
> > rights to any reports. Also, I can't set the rights, because if I log in as
> > the admin user I get the same error message about "Key cannot be null.
> > Parameter name: key" Any suggestions from MS would be handy about now.
> >
> > Jonathan Miller
> > webmaster@.accs.net
> >
> > "Zach" wrote:
> >
> > > Forms authentication still does not work in Sep CTP. I've been posting
> > > questions in this forum for weeks and have received exactly 0 responses from
> > > Microsoft. Do you guys even monitor this forum. There are lots of folks
> > > trying to get forms authentication working and it sure does not help that you
> > > took the 2000 instructions and just pasted them into the 2005 help file. I
> > > get erros like:
> > >
> > > Key cannot be null. Parameter name: key
> > >
> > > which is not really helpful. I can't debug and find out what is causing the
> > > error because I don't have the code. If you guys are so busy you can't
> > > response to any of our questions then please just send me the source code to
> > > report manager and reportingservices web server and I'll fix it for you so I
> > > can get on with my life. I appologize if I'm a little terse but I've called
> > > Microsoft offering to pay to get these issues resolved and I got the response
> > > that I needed to be a BETA tester. So I became a BETA tester and then got
> > > the response that the only interaction I have with MS is this newsgroup.
> > >
> > > If there is a rouge MS developer out there willing to help me out just let
> > > me know. Otherwise I can't really recommend my enterprise clients continue
> > > down the SQL 2005 path.|||Hi Jonathan,
I also have the same problem opening the Sample Form Authentication.
Hope you don't mind to send the File that you have been fixed to me...
nicky_tsh@.hotmail.com
Thanks
Nicky
"Zach" wrote:
> Hi Jonathan,
> Yes, I did finally figure it all out. The forms authentication sample code
> shipped with the product has several bugs. There is also a bug in the sample
> proxy for the web services calls. The key cannot be null error originates
> from Authorization.GetPermissions. The problem is the base maps buit in
> InitializeMaps are incorrect. You will have to make sure all available enum
> entries are loaded into each map. You will also need to re-code the For Each
> statements in GetPermissions to declare the variable oper as the correct type.
> The bug in the Proxy class is in the GetWebResponse function. Change the
> line that reads
> AuthCookie = authCookie
> to
> Me.AuthCookie = authCookie
> Hope this helps!
> "Jonathan Miller" wrote:
> > Zach,
> >
> > Did you ever figure this out? I'm having the same problem with the RTM
> > version. I've got Forms Auth installed, I can register a user and login as
> > long as its not set as the adminUser. However, this user does not have any
> > rights to any reports. Also, I can't set the rights, because if I log in as
> > the admin user I get the same error message about "Key cannot be null.
> > Parameter name: key" Any suggestions from MS would be handy about now.
> >
> > Jonathan Miller
> > webmaster@.accs.net
> >
> > "Zach" wrote:
> >
> > > Forms authentication still does not work in Sep CTP. I've been posting
> > > questions in this forum for weeks and have received exactly 0 responses from
> > > Microsoft. Do you guys even monitor this forum. There are lots of folks
> > > trying to get forms authentication working and it sure does not help that you
> > > took the 2000 instructions and just pasted them into the 2005 help file. I
> > > get erros like:
> > >
> > > Key cannot be null. Parameter name: key
> > >
> > > which is not really helpful. I can't debug and find out what is causing the
> > > error because I don't have the code. If you guys are so busy you can't
> > > response to any of our questions then please just send me the source code to
> > > report manager and reportingservices web server and I'll fix it for you so I
> > > can get on with my life. I appologize if I'm a little terse but I've called
> > > Microsoft offering to pay to get these issues resolved and I got the response
> > > that I needed to be a BETA tester. So I became a BETA tester and then got
> > > the response that the only interaction I have with MS is this newsgroup.
> > >
> > > If there is a rouge MS developer out there willing to help me out just let
> > > me know. Otherwise I can't really recommend my enterprise clients continue
> > > down the SQL 2005 path.|||Can I also get a copy of the corrected code?|||Can I also get a copy of the corrected code?
ebertsch@.gmail.com|||I am very interested in this code as well.
Thanks,
mdg
"ebertsch@.gmail.com" wrote:
> Can I also get a copy of the corrected code?
> ebertsch@.gmail.com
>|||I am interested in this code as well....
Thanks for help,
Mdg
"ebertsch@.gmail.com" wrote:
> Can I also get a copy of the corrected code?
> ebertsch@.gmail.com
>|||Could I please also ask for the corrected code?
clyons@.camsoftdata.com
Thanks!
"Zach" wrote:
> Hi Jonathan,
> Yes, I did finally figure it all out. The forms authentication sample code
> shipped with the product has several bugs. There is also a bug in the sample
> proxy for the web services calls. The key cannot be null error originates
> from Authorization.GetPermissions. The problem is the base maps buit in
> InitializeMaps are incorrect. You will have to make sure all available enum
> entries are loaded into each map. You will also need to re-code the For Each
> statements in GetPermissions to declare the variable oper as the correct type.
> The bug in the Proxy class is in the GetWebResponse function. Change the
> line that reads
> AuthCookie = authCookie
> to
> Me.AuthCookie = authCookie
> Hope this helps!
> "Jonathan Miller" wrote:
> > Zach,
> >
> > Did you ever figure this out? I'm having the same problem with the RTM
> > version. I've got Forms Auth installed, I can register a user and login as
> > long as its not set as the adminUser. However, this user does not have any
> > rights to any reports. Also, I can't set the rights, because if I log in as
> > the admin user I get the same error message about "Key cannot be null.
> > Parameter name: key" Any suggestions from MS would be handy about now.
> >
> > Jonathan Miller
> > webmaster@.accs.net
> >
> > "Zach" wrote:
> >
> > > Forms authentication still does not work in Sep CTP. I've been posting
> > > questions in this forum for weeks and have received exactly 0 responses from
> > > Microsoft. Do you guys even monitor this forum. There are lots of folks
> > > trying to get forms authentication working and it sure does not help that you
> > > took the 2000 instructions and just pasted them into the 2005 help file. I
> > > get erros like:
> > >
> > > Key cannot be null. Parameter name: key
> > >
> > > which is not really helpful. I can't debug and find out what is causing the
> > > error because I don't have the code. If you guys are so busy you can't
> > > response to any of our questions then please just send me the source code to
> > > report manager and reportingservices web server and I'll fix it for you so I
> > > can get on with my life. I appologize if I'm a little terse but I've called
> > > Microsoft offering to pay to get these issues resolved and I got the response
> > > that I needed to be a BETA tester. So I became a BETA tester and then got
> > > the response that the only interaction I have with MS is this newsgroup.
> > >
> > > If there is a rouge MS developer out there willing to help me out just let
> > > me know. Otherwise I can't really recommend my enterprise clients continue
> > > down the SQL 2005 path.|||Just so you know - I never obtained that code so I can not forward it to you.
Thanks,
Michael Gardipee
"Chris_CamSoft" wrote:
> Could I please also ask for the corrected code?
> clyons@.camsoftdata.com
> Thanks!
>
> "Zach" wrote:
> > Hi Jonathan,
> >
> > Yes, I did finally figure it all out. The forms authentication sample code
> > shipped with the product has several bugs. There is also a bug in the sample
> > proxy for the web services calls. The key cannot be null error originates
> > from Authorization.GetPermissions. The problem is the base maps buit in
> > InitializeMaps are incorrect. You will have to make sure all available enum
> > entries are loaded into each map. You will also need to re-code the For Each
> > statements in GetPermissions to declare the variable oper as the correct type.
> >
> > The bug in the Proxy class is in the GetWebResponse function. Change the
> > line that reads
> > AuthCookie = authCookie
> > to
> > Me.AuthCookie = authCookie
> >
> > Hope this helps!
> >
> > "Jonathan Miller" wrote:
> >
> > > Zach,
> > >
> > > Did you ever figure this out? I'm having the same problem with the RTM
> > > version. I've got Forms Auth installed, I can register a user and login as
> > > long as its not set as the adminUser. However, this user does not have any
> > > rights to any reports. Also, I can't set the rights, because if I log in as
> > > the admin user I get the same error message about "Key cannot be null.
> > > Parameter name: key" Any suggestions from MS would be handy about now.
> > >
> > > Jonathan Miller
> > > webmaster@.accs.net
> > >
> > > "Zach" wrote:
> > >
> > > > Forms authentication still does not work in Sep CTP. I've been posting
> > > > questions in this forum for weeks and have received exactly 0 responses from
> > > > Microsoft. Do you guys even monitor this forum. There are lots of folks
> > > > trying to get forms authentication working and it sure does not help that you
> > > > took the 2000 instructions and just pasted them into the 2005 help file. I
> > > > get erros like:
> > > >
> > > > Key cannot be null. Parameter name: key
> > > >
> > > > which is not really helpful. I can't debug and find out what is causing the
> > > > error because I don't have the code. If you guys are so busy you can't
> > > > response to any of our questions then please just send me the source code to
> > > > report manager and reportingservices web server and I'll fix it for you so I
> > > > can get on with my life. I appologize if I'm a little terse but I've called
> > > > Microsoft offering to pay to get these issues resolved and I got the response
> > > > that I needed to be a BETA tester. So I became a BETA tester and then got
> > > > the response that the only interaction I have with MS is this newsgroup.
> > > >
> > > > If there is a rouge MS developer out there willing to help me out just let
> > > > me know. Otherwise I can't really recommend my enterprise clients continue
> > > > down the SQL 2005 path.|||I will assume that you, as I, were working with the VB.NET version of the
sample. The C# version works. I found out the hard way and have posted my
unhappy feelings towards Microsoft for shipping a sample on their production
CD's that didn't work. The version I am working with is the actual release
and not a CTP.
"Mdg" wrote:
> Just so you know - I never obtained that code so I can not forward it to you.
> Thanks,
> Michael Gardipee
>
> "Chris_CamSoft" wrote:
> > Could I please also ask for the corrected code?
> >
> > clyons@.camsoftdata.com
> >
> > Thanks!
> >
> >
> > "Zach" wrote:
> >
> > > Hi Jonathan,
> > >
> > > Yes, I did finally figure it all out. The forms authentication sample code
> > > shipped with the product has several bugs. There is also a bug in the sample
> > > proxy for the web services calls. The key cannot be null error originates
> > > from Authorization.GetPermissions. The problem is the base maps buit in
> > > InitializeMaps are incorrect. You will have to make sure all available enum
> > > entries are loaded into each map. You will also need to re-code the For Each
> > > statements in GetPermissions to declare the variable oper as the correct type.
> > >
> > > The bug in the Proxy class is in the GetWebResponse function. Change the
> > > line that reads
> > > AuthCookie = authCookie
> > > to
> > > Me.AuthCookie = authCookie
> > >
> > > Hope this helps!
> > >
> > > "Jonathan Miller" wrote:
> > >
> > > > Zach,
> > > >
> > > > Did you ever figure this out? I'm having the same problem with the RTM
> > > > version. I've got Forms Auth installed, I can register a user and login as
> > > > long as its not set as the adminUser. However, this user does not have any
> > > > rights to any reports. Also, I can't set the rights, because if I log in as
> > > > the admin user I get the same error message about "Key cannot be null.
> > > > Parameter name: key" Any suggestions from MS would be handy about now.
> > > >
> > > > Jonathan Miller
> > > > webmaster@.accs.net
> > > >
> > > > "Zach" wrote:
> > > >
> > > > > Forms authentication still does not work in Sep CTP. I've been posting
> > > > > questions in this forum for weeks and have received exactly 0 responses from
> > > > > Microsoft. Do you guys even monitor this forum. There are lots of folks
> > > > > trying to get forms authentication working and it sure does not help that you
> > > > > took the 2000 instructions and just pasted them into the 2005 help file. I
> > > > > get erros like:
> > > > >
> > > > > Key cannot be null. Parameter name: key
> > > > >
> > > > > which is not really helpful. I can't debug and find out what is causing the
> > > > > error because I don't have the code. If you guys are so busy you can't
> > > > > response to any of our questions then please just send me the source code to
> > > > > report manager and reportingservices web server and I'll fix it for you so I
> > > > > can get on with my life. I appologize if I'm a little terse but I've called
> > > > > Microsoft offering to pay to get these issues resolved and I got the response
> > > > > that I needed to be a BETA tester. So I became a BETA tester and then got
> > > > > the response that the only interaction I have with MS is this newsgroup.
> > > > >
> > > > > If there is a rouge MS developer out there willing to help me out just let
> > > > > me know. Otherwise I can't really recommend my enterprise clients continue
> > > > > down the SQL 2005 path.|||Actually, I was working with the C# code. The solution I implemented - in the
end - had me validating users against a custom provider (our SQL back end)
and that worked fine for us.
"Chris_CamSoft" wrote:
> I will assume that you, as I, were working with the VB.NET version of the
> sample. The C# version works. I found out the hard way and have posted my
> unhappy feelings towards Microsoft for shipping a sample on their production
> CD's that didn't work. The version I am working with is the actual release
> and not a CTP.
>
> "Mdg" wrote:
> > Just so you know - I never obtained that code so I can not forward it to you.
> >
> > Thanks,
> > Michael Gardipee
> >
> >
> > "Chris_CamSoft" wrote:
> >
> > > Could I please also ask for the corrected code?
> > >
> > > clyons@.camsoftdata.com
> > >
> > > Thanks!
> > >
> > >
> > > "Zach" wrote:
> > >
> > > > Hi Jonathan,
> > > >
> > > > Yes, I did finally figure it all out. The forms authentication sample code
> > > > shipped with the product has several bugs. There is also a bug in the sample
> > > > proxy for the web services calls. The key cannot be null error originates
> > > > from Authorization.GetPermissions. The problem is the base maps buit in
> > > > InitializeMaps are incorrect. You will have to make sure all available enum
> > > > entries are loaded into each map. You will also need to re-code the For Each
> > > > statements in GetPermissions to declare the variable oper as the correct type.
> > > >
> > > > The bug in the Proxy class is in the GetWebResponse function. Change the
> > > > line that reads
> > > > AuthCookie = authCookie
> > > > to
> > > > Me.AuthCookie = authCookie
> > > >
> > > > Hope this helps!
> > > >
> > > > "Jonathan Miller" wrote:
> > > >
> > > > > Zach,
> > > > >
> > > > > Did you ever figure this out? I'm having the same problem with the RTM
> > > > > version. I've got Forms Auth installed, I can register a user and login as
> > > > > long as its not set as the adminUser. However, this user does not have any
> > > > > rights to any reports. Also, I can't set the rights, because if I log in as
> > > > > the admin user I get the same error message about "Key cannot be null.
> > > > > Parameter name: key" Any suggestions from MS would be handy about now.
> > > > >
> > > > > Jonathan Miller
> > > > > webmaster@.accs.net
> > > > >
> > > > > "Zach" wrote:
> > > > >
> > > > > > Forms authentication still does not work in Sep CTP. I've been posting
> > > > > > questions in this forum for weeks and have received exactly 0 responses from
> > > > > > Microsoft. Do you guys even monitor this forum. There are lots of folks
> > > > > > trying to get forms authentication working and it sure does not help that you
> > > > > > took the 2000 instructions and just pasted them into the 2005 help file. I
> > > > > > get erros like:
> > > > > >
> > > > > > Key cannot be null. Parameter name: key
> > > > > >
> > > > > > which is not really helpful. I can't debug and find out what is causing the
> > > > > > error because I don't have the code. If you guys are so busy you can't
> > > > > > response to any of our questions then please just send me the source code to
> > > > > > report manager and reportingservices web server and I'll fix it for you so I
> > > > > > can get on with my life. I appologize if I'm a little terse but I've called
> > > > > > Microsoft offering to pay to get these issues resolved and I got the response
> > > > > > that I needed to be a BETA tester. So I became a BETA tester and then got
> > > > > > the response that the only interaction I have with MS is this newsgroup.
> > > > > >
> > > > > > If there is a rouge MS developer out there willing to help me out just let
> > > > > > me know. Otherwise I can't really recommend my enterprise clients continue
> > > > > > down the SQL 2005 path.
Monday, March 26, 2012
Formatting the date on report
Reporting Services 2005 (SQL Server 2005 CTP V 9.00.1187.00)
I have a date field and I want to format it on a report like:
January 9, 2006
Seems to me that should be pretty simple. But I can't find the correct format code. If I look at the textbox properties and go to the format tab, there is an option for Date, but there are only 3 choices:
1/9/2006 9:47 AM
Monday, January 9, 2006
1/9/2006
If I choose custom I found that Y gives me:
January 2006
and M gives me:
January 09
This is rather frustrating. I'm sure I could modify my source SQL to get each part of the date and past it together, but I would think a good reporting tool would give me the option on how to format the date, so I don't have to always modify the SQL. I've searched for help on the different format options and I can't find any.
Any help would be very much appreciated.
Thanks.
Well, I finally figured it out, with the help of some obscure posting on another forum. I now use format:
MMMM dd"," yyyy
interesting that you have to use MMMM, not mmmm and you have to use yyyy, not YYYY.
Now I could not find this anywhere in the documentation. I'm sure it must be there, but where? Does anybody know? I'm sure I'm going to have other formatting issues and I really don't want to have to search through forum postings on the internet to find crumbs of clues to figure out things that I think should be easily found in the products documentation. I'm sure it's me. It's gotta be right in front of me, or I did something wrong when installing and I don't have the correct documentation. (but then why can't I find it at MSDN?)
|||You can find documentation about these custom .NET format strings (e.g. MMMM and yyyy) on MSDN: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomdatetimeformatstrings.asp
-- Robert
|||Thanks!
Subscribe to:
Posts (Atom)