rsAccessDenied with Forms Authentication

I have implemented custom forms authentication with Reporting Services and
everything worked fine. I was able able to deploy reports from Visual
Studio 2003, VS would prompt me to enter a valid UserID and Password.
Recently, I have changed workstations and installed a new copy of visual
studio 2003. When I try to deploy a report to the same report server, I get
the following error:
The permissions granted to user '' are insufficient for performing this
operation.
VS does not prompt me to enter a userID and password and simply fails to
authenticate. I am still able to login direcly to report manager and
report server directly without any problems.
I am running:
** Workstation
OS: Windows XP Pro
Visual Studio 2003
** Server:
Windows 2000 Server SP 4
Reporting Services with Service Pack 1
Could someone please give some hints on what went wrong?
Thanks,
- Adil -Was the original install of Visual Studio on the same box as the server?
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> I have implemented custom forms authentication with Reporting Services and
> everything worked fine. I was able able to deploy reports from Visual
> Studio 2003, VS would prompt me to enter a valid UserID and Password.
> Recently, I have changed workstations and installed a new copy of visual
> studio 2003. When I try to deploy a report to the same report server, I
get
> the following error:
> The permissions granted to user '' are insufficient for performing this
> operation.
> VS does not prompt me to enter a userID and password and simply fails to
> authenticate. I am still able to login direcly to report manager and
> report server directly without any problems.
> I am running:
> ** Workstation
> OS: Windows XP Pro
> Visual Studio 2003
> ** Server:
> Windows 2000 Server SP 4
> Reporting Services with Service Pack 1
> Could someone please give some hints on what went wrong?
> Thanks,
> - Adil -
>
>|||Bryan,
No, the original installation of Visual studio was not on the Server. It was
on a Windows 2000 Workstation.
- Adil -
"Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
news:%23Njq%23WjeEHA.1652@.TK2MSFTNGP10.phx.gbl...
> Was the original install of Visual Studio on the same box as the server?
> --
> Bryan Keller
> Developer Documentation
> SQL Server Reporting Services
> A friendly reminder that this posting is provided "AS IS" with no
> warranties, and confers no rights.
>
> "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> > I have implemented custom forms authentication with Reporting Services
and
> > everything worked fine. I was able able to deploy reports from Visual
> > Studio 2003, VS would prompt me to enter a valid UserID and Password.
> > Recently, I have changed workstations and installed a new copy of visual
> > studio 2003. When I try to deploy a report to the same report server, I
> get
> > the following error:
> >
> > The permissions granted to user '' are insufficient for performing this
> > operation.
> >
> > VS does not prompt me to enter a userID and password and simply fails to
> > authenticate. I am still able to login direcly to report manager and
> > report server directly without any problems.
> >
> > I am running:
> > ** Workstation
> > OS: Windows XP Pro
> > Visual Studio 2003
> >
> > ** Server:
> > Windows 2000 Server SP 4
> > Reporting Services with Service Pack 1
> >
> > Could someone please give some hints on what went wrong?
> >
> > Thanks,
> > - Adil -
> >
> >
> >
>|||Okay, VS should prompt for credentials when using Forms auth. You obviously
reinstalled the Designer on the new VS box correct? Are you using a report
project from the old install? If so, try deleting the .user and .suo files
for your project and deploying again.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
news:ew3XA%23yeEHA.1100@.TK2MSFTNGP10.phx.gbl...
> Bryan,
> No, the original installation of Visual studio was not on the Server. It
was
> on a Windows 2000 Workstation.
> - Adil -
> "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> news:%23Njq%23WjeEHA.1652@.TK2MSFTNGP10.phx.gbl...
> > Was the original install of Visual Studio on the same box as the server?
> >
> > --
> > Bryan Keller
> > Developer Documentation
> > SQL Server Reporting Services
> >
> > A friendly reminder that this posting is provided "AS IS" with no
> > warranties, and confers no rights.
> >
> >
> > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> > > I have implemented custom forms authentication with Reporting Services
> and
> > > everything worked fine. I was able able to deploy reports from Visual
> > > Studio 2003, VS would prompt me to enter a valid UserID and Password.
> > > Recently, I have changed workstations and installed a new copy of
visual
> > > studio 2003. When I try to deploy a report to the same report server,
I
> > get
> > > the following error:
> > >
> > > The permissions granted to user '' are insufficient for performing
this
> > > operation.
> > >
> > > VS does not prompt me to enter a userID and password and simply fails
to
> > > authenticate. I am still able to login direcly to report manager and
> > > report server directly without any problems.
> > >
> > > I am running:
> > > ** Workstation
> > > OS: Windows XP Pro
> > > Visual Studio 2003
> > >
> > > ** Server:
> > > Windows 2000 Server SP 4
> > > Reporting Services with Service Pack 1
> > >
> > > Could someone please give some hints on what went wrong?
> > >
> > > Thanks,
> > > - Adil -
> > >
> > >
> > >
> >
> >
>|||Bryan,
Thanks for the help. I found the bug and it was in my code! (<-- Very rare!
:))
Apparently, it seems that when you try to deploy from VS for the first time,
VS sends a blank UserID and Password to ReportServer. This call normally
fails and the Login dialog box is therefore displayed.
In my case, the LogonUser method returned a boolean true for a blank
UserName and Password (<-- Bug in security extension), so VS moved on to the
Authorization phase which failed because no permissions have been assigned
to the blank user. Hence the error message:
"The permissions granted to user '' are insufficient for performing
this operation."
The problem disapeared as soon as I set the LogonUser method of the security
extension to return a "false" when the userName is blank.
- Adil -
"Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
news:OHlkL08eEHA.3028@.TK2MSFTNGP12.phx.gbl...
> Okay, VS should prompt for credentials when using Forms auth. You
obviously
> reinstalled the Designer on the new VS box correct? Are you using a report
> project from the old install? If so, try deleting the .user and .suo files
> for your project and deploying again.
> --
> Bryan Keller
> Developer Documentation
> SQL Server Reporting Services
> A friendly reminder that this posting is provided "AS IS" with no
> warranties, and confers no rights.
>
> "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> news:ew3XA%23yeEHA.1100@.TK2MSFTNGP10.phx.gbl...
> > Bryan,
> >
> > No, the original installation of Visual studio was not on the Server. It
> was
> > on a Windows 2000 Workstation.
> >
> > - Adil -
> >
> > "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> > news:%23Njq%23WjeEHA.1652@.TK2MSFTNGP10.phx.gbl...
> > > Was the original install of Visual Studio on the same box as the
server?
> > >
> > > --
> > > Bryan Keller
> > > Developer Documentation
> > > SQL Server Reporting Services
> > >
> > > A friendly reminder that this posting is provided "AS IS" with no
> > > warranties, and confers no rights.
> > >
> > >
> > > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > > news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> > > > I have implemented custom forms authentication with Reporting
Services
> > and
> > > > everything worked fine. I was able able to deploy reports from
Visual
> > > > Studio 2003, VS would prompt me to enter a valid UserID and
Password.
> > > > Recently, I have changed workstations and installed a new copy of
> visual
> > > > studio 2003. When I try to deploy a report to the same report
server,
> I
> > > get
> > > > the following error:
> > > >
> > > > The permissions granted to user '' are insufficient for performing
> this
> > > > operation.
> > > >
> > > > VS does not prompt me to enter a userID and password and simply
fails
> to
> > > > authenticate. I am still able to login direcly to report manager
and
> > > > report server directly without any problems.
> > > >
> > > > I am running:
> > > > ** Workstation
> > > > OS: Windows XP Pro
> > > > Visual Studio 2003
> > > >
> > > > ** Server:
> > > > Windows 2000 Server SP 4
> > > > Reporting Services with Service Pack 1
> > > >
> > > > Could someone please give some hints on what went wrong?
> > > >
> > > > Thanks,
> > > > - Adil -
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Great news. I'm glad you tracked that down.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
news:ulz671ZfEHA.1048@.tk2msftngp13.phx.gbl...
> Bryan,
> Thanks for the help. I found the bug and it was in my code! (<-- Very
rare!
> :))
> Apparently, it seems that when you try to deploy from VS for the first
time,
> VS sends a blank UserID and Password to ReportServer. This call normally
> fails and the Login dialog box is therefore displayed.
> In my case, the LogonUser method returned a boolean true for a blank
> UserName and Password (<-- Bug in security extension), so VS moved on to
the
> Authorization phase which failed because no permissions have been assigned
> to the blank user. Hence the error message:
> "The permissions granted to user '' are insufficient for
performing
> this operation."
> The problem disapeared as soon as I set the LogonUser method of the
security
> extension to return a "false" when the userName is blank.
> - Adil -
> "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> news:OHlkL08eEHA.3028@.TK2MSFTNGP12.phx.gbl...
> > Okay, VS should prompt for credentials when using Forms auth. You
> obviously
> > reinstalled the Designer on the new VS box correct? Are you using a
report
> > project from the old install? If so, try deleting the .user and .suo
files
> > for your project and deploying again.
> > --
> > Bryan Keller
> > Developer Documentation
> > SQL Server Reporting Services
> >
> > A friendly reminder that this posting is provided "AS IS" with no
> > warranties, and confers no rights.
> >
> >
> > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > news:ew3XA%23yeEHA.1100@.TK2MSFTNGP10.phx.gbl...
> > > Bryan,
> > >
> > > No, the original installation of Visual studio was not on the Server.
It
> > was
> > > on a Windows 2000 Workstation.
> > >
> > > - Adil -
> > >
> > > "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> > > news:%23Njq%23WjeEHA.1652@.TK2MSFTNGP10.phx.gbl...
> > > > Was the original install of Visual Studio on the same box as the
> server?
> > > >
> > > > --
> > > > Bryan Keller
> > > > Developer Documentation
> > > > SQL Server Reporting Services
> > > >
> > > > A friendly reminder that this posting is provided "AS IS" with no
> > > > warranties, and confers no rights.
> > > >
> > > >
> > > > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > > > news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> > > > > I have implemented custom forms authentication with Reporting
> Services
> > > and
> > > > > everything worked fine. I was able able to deploy reports from
> Visual
> > > > > Studio 2003, VS would prompt me to enter a valid UserID and
> Password.
> > > > > Recently, I have changed workstations and installed a new copy of
> > visual
> > > > > studio 2003. When I try to deploy a report to the same report
> server,
> > I
> > > > get
> > > > > the following error:
> > > > >
> > > > > The permissions granted to user '' are insufficient for
performing
> > this
> > > > > operation.
> > > > >
> > > > > VS does not prompt me to enter a userID and password and simply
> fails
> > to
> > > > > authenticate. I am still able to login direcly to report manager
> and
> > > > > report server directly without any problems.
> > > > >
> > > > > I am running:
> > > > > ** Workstation
> > > > > OS: Windows XP Pro
> > > > > Visual Studio 2003
> > > > >
> > > > > ** Server:
> > > > > Windows 2000 Server SP 4
> > > > > Reporting Services with Service Pack 1
> > > > >
> > > > > Could someone please give some hints on what went wrong?
> > > > >
> > > > > Thanks,
> > > > > - Adil -
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||I too am having this exact problem. I'm trying to publish my reports using
the batch rs method. Where do I set my logon credentials there, I never see
a pop-up.
Thanks,
Gabe
"Bryan Keller [MSFT]" wrote:
> Great news. I'm glad you tracked that down.
> --
> Bryan Keller
> Developer Documentation
> SQL Server Reporting Services
> A friendly reminder that this posting is provided "AS IS" with no
> warranties, and confers no rights.
>
> "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> news:ulz671ZfEHA.1048@.tk2msftngp13.phx.gbl...
> > Bryan,
> > Thanks for the help. I found the bug and it was in my code! (<-- Very
> rare!
> > :))
> > Apparently, it seems that when you try to deploy from VS for the first
> time,
> > VS sends a blank UserID and Password to ReportServer. This call normally
> > fails and the Login dialog box is therefore displayed.
> > In my case, the LogonUser method returned a boolean true for a blank
> > UserName and Password (<-- Bug in security extension), so VS moved on to
> the
> > Authorization phase which failed because no permissions have been assigned
> > to the blank user. Hence the error message:
> > "The permissions granted to user '' are insufficient for
> performing
> > this operation."
> >
> > The problem disapeared as soon as I set the LogonUser method of the
> security
> > extension to return a "false" when the userName is blank.
> >
> > - Adil -
> >
> > "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> > news:OHlkL08eEHA.3028@.TK2MSFTNGP12.phx.gbl...
> > > Okay, VS should prompt for credentials when using Forms auth. You
> > obviously
> > > reinstalled the Designer on the new VS box correct? Are you using a
> report
> > > project from the old install? If so, try deleting the .user and .suo
> files
> > > for your project and deploying again.
> > > --
> > > Bryan Keller
> > > Developer Documentation
> > > SQL Server Reporting Services
> > >
> > > A friendly reminder that this posting is provided "AS IS" with no
> > > warranties, and confers no rights.
> > >
> > >
> > > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > > news:ew3XA%23yeEHA.1100@.TK2MSFTNGP10.phx.gbl...
> > > > Bryan,
> > > >
> > > > No, the original installation of Visual studio was not on the Server.
> It
> > > was
> > > > on a Windows 2000 Workstation.
> > > >
> > > > - Adil -
> > > >
> > > > "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> > > > news:%23Njq%23WjeEHA.1652@.TK2MSFTNGP10.phx.gbl...
> > > > > Was the original install of Visual Studio on the same box as the
> > server?
> > > > >
> > > > > --
> > > > > Bryan Keller
> > > > > Developer Documentation
> > > > > SQL Server Reporting Services
> > > > >
> > > > > A friendly reminder that this posting is provided "AS IS" with no
> > > > > warranties, and confers no rights.
> > > > >
> > > > >
> > > > > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > > > > news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> > > > > > I have implemented custom forms authentication with Reporting
> > Services
> > > > and
> > > > > > everything worked fine. I was able able to deploy reports from
> > Visual
> > > > > > Studio 2003, VS would prompt me to enter a valid UserID and
> > Password.
> > > > > > Recently, I have changed workstations and installed a new copy of
> > > visual
> > > > > > studio 2003. When I try to deploy a report to the same report
> > server,
> > > I
> > > > > get
> > > > > > the following error:
> > > > > >
> > > > > > The permissions granted to user '' are insufficient for
> performing
> > > this
> > > > > > operation.
> > > > > >
> > > > > > VS does not prompt me to enter a userID and password and simply
> > fails
> > > to
> > > > > > authenticate. I am still able to login direcly to report manager
> > and
> > > > > > report server directly without any problems.
> > > > > >
> > > > > > I am running:
> > > > > > ** Workstation
> > > > > > OS: Windows XP Pro
> > > > > > Visual Studio 2003
> > > > > >
> > > > > > ** Server:
> > > > > > Windows 2000 Server SP 4
> > > > > > Reporting Services with Service Pack 1
> > > > > >
> > > > > > Could someone please give some hints on what went wrong?
> > > > > >
> > > > > > Thanks,
> > > > > > - Adil -
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>