Personal SQL Server 2000

Dear Anyone,
I am a member of Microsoft's ISV program. I have a server running Server
2000 and a laptop as my workstation. The server is running SQL Server 2000.
I want to install a desktop version of SQL Server on my laptop to do demos
of my projects.
Do I install from SQL Server Developer Edition or SQL Server 2000
Desktop Engine? Or from something I'm not aware of. Please advise.
Thank you.
James LattanzioYou can install SQL Server Personal Edition. It comes on a separate disk
with SQL Server Standard Edition and SQL Server Enterprise Edition, and is
explicitly licensed for doing demos of a product that requires SQL Server.
--
Jacco Schalkwijk
SQL Server MVP
"James Lattanzio" <europacg@.erols.com> wrote in message
news:403bb7f1$0$3079$61fed72c@.news.rcn.com...
> Dear Anyone,
> I am a member of Microsoft's ISV program. I have a server running
Server
> 2000 and a laptop as my workstation. The server is running SQL Server
2000.
> I want to install a desktop version of SQL Server on my laptop to do demos
> of my projects.
> Do I install from SQL Server Developer Edition or SQL Server 2000
> Desktop Engine? Or from something I'm not aware of. Please advise.
> Thank you.
> James Lattanzio
>|||The developer edition would work if you have it. If you just want to =demo your app, then MSDE (the desktop engine) is probably all you need. =Keep in mind that MSDE does not ship with any GUI management tools. You =will have to use osql.exe.
-- Keith
"James Lattanzio" <europacg@.erols.com> wrote in message =news:403bb7f1$0$3079$61fed72c@.news.rcn.com...
> Dear Anyone,
> > I am a member of Microsoft's ISV program. I have a server running =Server
> 2000 and a laptop as my workstation. The server is running SQL Server =2000.
> I want to install a desktop version of SQL Server on my laptop to do =demos
> of my projects.
> > Do I install from SQL Server Developer Edition or SQL Server 2000
> Desktop Engine? Or from something I'm not aware of. Please advise.
> > Thank you.
> > James Lattanzio
> >sql

Personal SQL Server 2000

Dear Anyone,
I am a member of Microsoft's ISV program. I have a server running Server
2000 and a laptop as my workstation. The server is running SQL Server 2000.
I want to install a desktop version of SQL Server on my laptop to do demos
of my projects.
Do I install from SQL Server Developer Edition or SQL Server 2000
Desktop Engine? Or from something I'm not aware of. Please advise.
Thank you.
James LattanzioYou can install SQL Server Personal Edition. It comes on a separate disk
with SQL Server Standard Edition and SQL Server Enterprise Edition, and is
explicitly licensed for doing demos of a product that requires SQL Server.
Jacco Schalkwijk
SQL Server MVP
"James Lattanzio" <europacg@.erols.com> wrote in message
news:403bb7f1$0$3079$61fed72c@.news.rcn.com...
> Dear Anyone,
> I am a member of Microsoft's ISV program. I have a server running
Server
> 2000 and a laptop as my workstation. The server is running SQL Server
2000.
> I want to install a desktop version of SQL Server on my laptop to do demos
> of my projects.
> Do I install from SQL Server Developer Edition or SQL Server 2000
> Desktop Engine? Or from something I'm not aware of. Please advise.
> Thank you.
> James Lattanzio
>|||The developer edition would work if you have it. If you just want to =
demo your app, then MSDE (the desktop engine) is probably all you need. =
Keep in mind that MSDE does not ship with any GUI management tools. You =
will have to use osql.exe.
--=20
Keith
"James Lattanzio" <europacg@.erols.com> wrote in message =
news:403bb7f1$0$3079$61fed72c@.news.rcn.com...
> Dear Anyone,
>=20
> I am a member of Microsoft's ISV program. I have a server running =
Server
> 2000 and a laptop as my workstation. The server is running SQL Server =
2000.
> I want to install a desktop version of SQL Server on my laptop to do =
demos
> of my projects.
>=20
> Do I install from SQL Server Developer Edition or SQL Server 2000
> Desktop Engine? Or from something I'm not aware of. Please advise.
>=20
> Thank you.
>=20
> James Lattanzio
>=20
>

Permissions and Administration

Do you have to be a member of the local win2K administrators group in-order
to perform administration functions and create folders in Reporting Services?Any user can be given permissions to administer Reporting Services. If
using Forms Authentication, you don't have Windows users at all. In that
case, you can set a default administrator account in the
RSReportServer.config file (replace "USERNAMEHERE"):
<Security>
<Extension Name="Forms"
Type="RSCustomSecurity.Authorization,
ReportingServices.RSCustomSecurity" >
<Configuration>
<AdminConfiguration>
<UserName>USERNAMEHERE</UserName>
</AdminConfiguration>
</Configuration>
</Extension>
</Security>
I haven't tried setting the AdminConfiguration UserName for when Extension
Name="Windows", but it may be worth a shot.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Andy998" <Andy998@.discussions.microsoft.com> wrote in message
news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> Do you have to be a member of the local win2K administrators group
> in-order
> to perform administration functions and create folders in Reporting
> Services?|||When we installed RS on a production server, we can't see the contents or
properties tab on the home page. We also do not see the New Folder or New
Data Source or Upload Files buttons and therefore can not create folders.
We had the NT administrator go into Site Settings page and add our NT
accounts on the System Role Assignments page as systems administrators, but
that did not help either. This works fine on our development server but were
also in the local admin group on that server.
"Jeff A. Stucker" wrote:
> Any user can be given permissions to administer Reporting Services. If
> using Forms Authentication, you don't have Windows users at all. In that
> case, you can set a default administrator account in the
> RSReportServer.config file (replace "USERNAMEHERE"):
> <Security>
> <Extension Name="Forms"
> Type="RSCustomSecurity.Authorization,
> ReportingServices.RSCustomSecurity" >
> <Configuration>
> <AdminConfiguration>
> <UserName>USERNAMEHERE</UserName>
> </AdminConfiguration>
> </Configuration>
> </Extension>
> </Security>
> I haven't tried setting the AdminConfiguration UserName for when Extension
> Name="Windows", but it may be worth a shot.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > Do you have to be a member of the local win2K administrators group
> > in-order
> > to perform administration functions and create folders in Reporting
> > Services?
>
>|||Hi,
I have the exact same issue. I have tried the suggested workaround below,
but the problem presists. Do you have any other ideas?
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> Any user can be given permissions to administer Reporting Services. If
> using Forms Authentication, you don't have Windows users at all. In that
> case, you can set a default administrator account in the
> RSReportServer.config file (replace "USERNAMEHERE"):
> <Security>
> <Extension Name="Forms"
> Type="RSCustomSecurity.Authorization,
> ReportingServices.RSCustomSecurity" >
> <Configuration>
> <AdminConfiguration>
> <UserName>USERNAMEHERE</UserName>
> </AdminConfiguration>
> </Configuration>
> </Extension>
> </Security>
> I haven't tried setting the AdminConfiguration UserName for when Extension
> Name="Windows", but it may be worth a shot.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > Do you have to be a member of the local win2K administrators group
> > in-order
> > to perform administration functions and create folders in Reporting
> > Services?
>|||I have the exact same issue.
I have tried the workaround below, but problem persists.
pls help.
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> Any user can be given permissions to administer Reporting Services. If
> using Forms Authentication, you don't have Windows users at all. In that
> case, you can set a default administrator account in the
> RSReportServer.config file (replace "USERNAMEHERE"):
> <Security>
> <Extension Name="Forms"
> Type="RSCustomSecurity.Authorization,
> ReportingServices.RSCustomSecurity" >
> <Configuration>
> <AdminConfiguration>
> <UserName>USERNAMEHERE</UserName>
> </AdminConfiguration>
> </Configuration>
> </Extension>
> </Security>
> I haven't tried setting the AdminConfiguration UserName for when Extension
> Name="Windows", but it may be worth a shot.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > Do you have to be a member of the local win2K administrators group
> > in-order
> > to perform administration functions and create folders in Reporting
> > Services?
>|||No I have not found the answer for this. I am starting to believe this
product is more trouble than it's worth. If I figure this out I'll let you
know.
"RIchard Baldock" wrote:
> I have the exact same issue.
> I have tried the workaround below, but problem persists.
> pls help.
>
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > Any user can be given permissions to administer Reporting Services. If
> > using Forms Authentication, you don't have Windows users at all. In that
> > case, you can set a default administrator account in the
> > RSReportServer.config file (replace "USERNAMEHERE"):
> >
> > <Security>
> > <Extension Name="Forms"
> > Type="RSCustomSecurity.Authorization,
> > ReportingServices.RSCustomSecurity" >
> > <Configuration>
> > <AdminConfiguration>
> > <UserName>USERNAMEHERE</UserName>
> > </AdminConfiguration>
> > </Configuration>
> > </Extension>
> > </Security>
> >
> > I haven't tried setting the AdminConfiguration UserName for when Extension
> > Name="Windows", but it may be worth a shot.
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > Do you have to be a member of the local win2K administrators group
> > > in-order
> > > to perform administration functions and create folders in Reporting
> > > Services?
> >
> >
>
>|||I have resolved this issue.
Follow these steps.
1. have an windows administrator go to to the report server web page.
click sitesetting and add you Windowns account as a systems administrator.
2. Have the windows administrator then got to the home page press new
folder and create your new folder, The have them add your windows local group
or domain account as a content manager for this new folder.
Once this is complete you should see this folder on the home page as well as
the New folder, New Data Source asnd Upload buttons.
Andy
"RIchard Baldock" wrote:
> I have the exact same issue.
> I have tried the workaround below, but problem persists.
> pls help.
>
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > Any user can be given permissions to administer Reporting Services. If
> > using Forms Authentication, you don't have Windows users at all. In that
> > case, you can set a default administrator account in the
> > RSReportServer.config file (replace "USERNAMEHERE"):
> >
> > <Security>
> > <Extension Name="Forms"
> > Type="RSCustomSecurity.Authorization,
> > ReportingServices.RSCustomSecurity" >
> > <Configuration>
> > <AdminConfiguration>
> > <UserName>USERNAMEHERE</UserName>
> > </AdminConfiguration>
> > </Configuration>
> > </Extension>
> > </Security>
> >
> > I haven't tried setting the AdminConfiguration UserName for when Extension
> > Name="Windows", but it may be worth a shot.
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > Do you have to be a member of the local win2K administrators group
> > > in-order
> > > to perform administration functions and create folders in Reporting
> > > Services?
> >
> >
>
>|||I logged on as the local administrator and yes I got to the home page and
added my domain account as a systems adminstrator.
I could see all the tabs.
But then logging on as myself, I still only see the 'contents' tab.
I went back as adminstrator to check, and as adminstrator I can only see the
contents tab !!!
I am really stumped by this - it is like you say a "very difficult" product.
Do you (or anyone) have any ideas , I'm desperate.
"ANDY998" <ANDY998@.discussions.microsoft.com> wrote in message
news:284DD604-9DFE-4448-BF9A-D6D2DD03277E@.microsoft.com...
> I have resolved this issue.
> Follow these steps.
> 1. have an windows administrator go to to the report server web page.
> click sitesetting and add you Windowns account as a systems administrator.
> 2. Have the windows administrator then got to the home page press new
> folder and create your new folder, The have them add your windows local
group
> or domain account as a content manager for this new folder.
> Once this is complete you should see this folder on the home page as well
as
> the New folder, New Data Source asnd Upload buttons.
> Andy
> "RIchard Baldock" wrote:
> > I have the exact same issue.
> > I have tried the workaround below, but problem persists.
> > pls help.
> >
> >
> > "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> > news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > > Any user can be given permissions to administer Reporting Services.
If
> > > using Forms Authentication, you don't have Windows users at all. In
that
> > > case, you can set a default administrator account in the
> > > RSReportServer.config file (replace "USERNAMEHERE"):
> > >
> > > <Security>
> > > <Extension Name="Forms"
> > > Type="RSCustomSecurity.Authorization,
> > > ReportingServices.RSCustomSecurity" >
> > > <Configuration>
> > > <AdminConfiguration>
> > > <UserName>USERNAMEHERE</UserName>
> > > </AdminConfiguration>
> > > </Configuration>
> > > </Extension>
> > > </Security>
> > >
> > > I haven't tried setting the AdminConfiguration UserName for when
Extension
> > > Name="Windows", but it may be worth a shot.
> > > --
> > > Cheers,
> > >
> > > '(' Jeff A. Stucker
> > > \
> > >
> > > Business Intelligence
> > > www.criadvantage.com
> > > ---
> > > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > > Do you have to be a member of the local win2K administrators group
> > > > in-order
> > > > to perform administration functions and create folders in Reporting
> > > > Services?
> > >
> > >
> >
> >
> >|||I have "solved" this.
1. If you would like to see & use all the TABS on the "/Reports" Virtual
directory - disable anonymous access on both the "/Reports" and
"/Reportserver" Virtual directories.
Or
2. If you need to provide anonymous access to your "/Reportserver " virtual
directory then you will not be able to see & use all the TABS on "/Reports"
virtual directory simultaneously.
The obvious workaround is point 1 above. These can be shuffled as required.
Shitty but true. I guess this release was not "intended" to be used over web
etc ?
"RIchard Baldock" <RIchardBaldock@.community.nospam> wrote in message
news:e9SGPKb4EHA.3644@.tk2msftngp13.phx.gbl...
> I logged on as the local administrator and yes I got to the home page and
> added my domain account as a systems adminstrator.
> I could see all the tabs.
> But then logging on as myself, I still only see the 'contents' tab.
> I went back as adminstrator to check, and as adminstrator I can only see
the
> contents tab !!!
> I am really stumped by this - it is like you say a "very difficult"
product.
> Do you (or anyone) have any ideas , I'm desperate.
>
> "ANDY998" <ANDY998@.discussions.microsoft.com> wrote in message
> news:284DD604-9DFE-4448-BF9A-D6D2DD03277E@.microsoft.com...
> > I have resolved this issue.
> >
> > Follow these steps.
> >
> > 1. have an windows administrator go to to the report server web page.
> > click sitesetting and add you Windowns account as a systems
administrator.
> >
> > 2. Have the windows administrator then got to the home page press new
> > folder and create your new folder, The have them add your windows local
> group
> > or domain account as a content manager for this new folder.
> >
> > Once this is complete you should see this folder on the home page as
well
> as
> > the New folder, New Data Source asnd Upload buttons.
> >
> > Andy
> >
> > "RIchard Baldock" wrote:
> >
> > > I have the exact same issue.
> > > I have tried the workaround below, but problem persists.
> > > pls help.
> > >
> > >
> > > "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> > > news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > > > Any user can be given permissions to administer Reporting Services.
> If
> > > > using Forms Authentication, you don't have Windows users at all. In
> that
> > > > case, you can set a default administrator account in the
> > > > RSReportServer.config file (replace "USERNAMEHERE"):
> > > >
> > > > <Security>
> > > > <Extension Name="Forms"
> > > > Type="RSCustomSecurity.Authorization,
> > > > ReportingServices.RSCustomSecurity" >
> > > > <Configuration>
> > > > <AdminConfiguration>
> > > > <UserName>USERNAMEHERE</UserName>
> > > > </AdminConfiguration>
> > > > </Configuration>
> > > > </Extension>
> > > > </Security>
> > > >
> > > > I haven't tried setting the AdminConfiguration UserName for when
> Extension
> > > > Name="Windows", but it may be worth a shot.
> > > > --
> > > > Cheers,
> > > >
> > > > '(' Jeff A. Stucker
> > > > \
> > > >
> > > > Business Intelligence
> > > > www.criadvantage.com
> > > > ---
> > > > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > > > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > > > Do you have to be a member of the local win2K administrators group
> > > > > in-order
> > > > > to perform administration functions and create folders in
Reporting
> > > > > Services?
> > > >
> > > >
> > >
> > >
> > >
>