sql reports: evaluation

Showing posts with label evaluation. Show all posts

Wednesday, March 7, 2012

Can SQL Server 2005 Evaluation be used to upgrade a system?

I have multiple development SQL Servers running Enterprise edition that I want to upgrade for application testing before upgrading our production system. All of the servers meet the hardware and software requirements for SQL Server 2005 Enterprise edition. However, when I try to install to use the SQL Server 2005 Evaluation Edition to upgrade the servers in place, I get the blocked upgrade message:

Name: Microsoft SQL Server 2000 Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. Edition check: Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Can the Evaluation Edition be used to upgrade these servers or do you need the full blown version?

thanks

Sorry, upgrades are prohibited *to* the Eval edition.|||I am getting this error now myself and I don't know why. I installed the trial SQL Server Express for my boss. He then asked if I would install the trial SQL Server 2005 becuase it has more capabilities he would like to try out. So I installed 2005. He noticed that there was no management studio installed and needed. So I uninstalled it and am trying to reinstall it and am getting this error. I haven't even used the software yet! I don't know what to do!|||

I was able to continue the installation but just before I click OK to install, I see this in a window

The following components that you selected will not be changed:

Client Components

that might be why I had my original problem. That problem was the Management Studio was never installed which prompted me to reinstall the system alltogether thinking I must have not checked that installation option.

Ahh!!!

Can SQL Server 2005 Evaluation be used to upgrade a system?

Name: Microsoft SQL Server 2000

Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Can the Evaluation Edition be used to upgrade these servers or do you need the full blown version?

thanks

I was able to continue the installation but just before I click OK to install, I see this in a window

The following components that you selected will not be changed:

Client Components

Ahh!!!

Saturday, February 25, 2012

can SQL 2000 evaluation install on XP

Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:

>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
|||Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:

>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
|||Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:

>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
|||Sorry about the multi-posts. Thunderbird spat the dummy.
Mike Hodgson wrote:
[vbcol=seagreen]
> Which edition? Personal, standard or enterprise? Standard &
> Enterprise must go on a server O/S. Personal edition can go on a
> workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
> Developer edition is the same as the Enterprise edition except just
> licensed differently.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> maxzsim wrote:
|||Hi Mike ,
i am using the evaluation copy of the Enterprise Edition
rdgs
"Mike Hodgson" wrote:

> Sorry about the multi-posts. Thunderbird spat the dummy.
>
> Mike Hodgson wrote:
>
|||You'd need one of the Windows NT Server, Window 2000 Server or Windows
2003 Server O/S families for Enterprise Edition (even if it is just an
eval - that just means it's time bombed for 120 days). For Windows XP
Pro you'll need the Personal Edition of SQL Server 2000.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
[vbcol=seagreen]
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
>
|||Yes...the Enterprise Evaluation Edition is supported on XP
Pro. You can find the supported operating systems at:
http://msdn.microsoft.com/library/en...ar_ts_7eur.asp
-Sue
On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
<maxzsim@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
|||Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
lately. Maybe I should take a break from the newsgroups for a while and
going back to playing chess.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Sue Hoegemeier wrote:

>Yes...the Enterprise Evaluation Edition is supported on XP
>Pro. You can find the supported operating systems at:
>http://msdn.microsoft.com/library/en...ar_ts_7eur.asp
>-Sue
>On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
> <maxzsim@.discussions.microsoft.com> wrote:
>
>
>
|||thks everyone for the help given
"Mike Hodgson" wrote:

> Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
> lately. Maybe I should take a break from the newsgroups for a while and
> going back to playing chess.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
>
> Sue Hoegemeier wrote:
>

can SQL 2000 evaluation install on XP

Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgsThis is a multi-part message in MIME format.
--020107020505020303050800
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
--020107020505020303050800
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Which edition?Â Personal, standard or enterprise?Â Standard &
Enterprise must go on a server O/S.Â Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation).Â The
Developer edition is the same as the Enterprise edition except just
licensed differently.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
maxzsim wrote:
<blockquote cite="midE0C7A008-8152-49CF-888B-F3CB9A87E7F8@.microsoft.com"
type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</body>
</html>
--020107020505020303050800--|||This is a multi-part message in MIME format.
--020009090209050906080707
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
--020009090209050906080707
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Which edition?Â Personal, standard or enterprise?Â Standard &
Enterprise must go on a server O/S.Â Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation).Â The
Developer edition is the same as the Enterprise edition except just
licensed differently.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a>
| W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
maxzsim wrote:
<blockquote cite="midE0C7A008-8152-49CF-888B-F3CB9A87E7F8@.microsoft.com"
type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</body>
</html>
--020009090209050906080707--|||This is a multi-part message in MIME format.
--090003090205020301090702
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
--090003090205020301090702
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Which edition?Â Personal, standard or enterprise?Â Standard &
Enterprise must go on a server O/S.Â Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation).Â The
Developer edition is the same as the Enterprise edition except just
licensed differently.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a>
| W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
maxzsim wrote:
<blockquote cite="midE0C7A008-8152-49CF-888B-F3CB9A87E7F8@.microsoft.com"
type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</body>
</html>
--090003090205020301090702--|||This is a multi-part message in MIME format.
--000409060207070309090809
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Sorry about the multi-posts. Thunderbird spat the dummy.
Mike Hodgson wrote:
> Which edition? Personal, standard or enterprise? Standard &
> Enterprise must go on a server O/S. Personal edition can go on a
> workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
> Developer edition is the same as the Enterprise edition except just
> licensed differently.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> maxzsim wrote:
>>Hi ,
>> i am using sql server 2000 evaluation copy , can it be installed on XP
>>professional ?
>>rdgs
>>
>>
--000409060207070309090809
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Sorry about the multi-posts.Â Thunderbird spat the dummy.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
</div>
 
 
 
Mike Hodgson wrote:
<blockquote cite="mid421D4005.3080803@.mallesons.nospam.com" type="cite">
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<tt>Which edition?Â Personal, standard or enterprise?Â Standard &
Enterprise must go on a server O/S.Â Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation).Â The
Developer edition is the same as the Enterprise edition except just
licensed differently.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a>
| W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
maxzsim wrote:
<blockquote
cite="midE0C7A008-8152-49CF-888B-F3CB9A87E7F8@.microsoft.com"
type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</blockquote>
</body>
</html>
--000409060207070309090809--|||Hi Mike ,
i am using the evaluation copy of the Enterprise Edition
rdgs
"Mike Hodgson" wrote:
> Sorry about the multi-posts. Thunderbird spat the dummy.
>
> Mike Hodgson wrote:
> > Which edition? Personal, standard or enterprise? Standard &
> > Enterprise must go on a server O/S. Personal edition can go on a
> > workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
> > Developer edition is the same as the Enterprise edition except just
> > licensed differently.
> >
> > --
> > *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> > *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> > *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> > http://www.mallesons.com
> >
> >
> >
> > maxzsim wrote:
> >
> >>Hi ,
> >>
> >> i am using sql server 2000 evaluation copy , can it be installed on XP
> >>professional ?
> >>
> >>rdgs
> >>
> >>
> >>
> >>
>|||This is a multi-part message in MIME format.
--060404050301060308050608
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
You'd need one of the Windows NT Server, Window 2000 Server or Windows
2003 Server O/S families for Enterprise Edition (even if it is just an
eval - that just means it's time bombed for 120 days). For Windows XP
Pro you'll need the Personal Edition of SQL Server 2000.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
>
>>Sorry about the multi-posts. Thunderbird spat the dummy.
>>
>>Mike Hodgson wrote:
>>
>>Which edition? Personal, standard or enterprise? Standard &
>>Enterprise must go on a server O/S. Personal edition can go on a
>>workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
>>Developer edition is the same as the Enterprise edition except just
>>licensed differently.
>>--
>>*mike hodgson* |/ database administrator/ | mallesons stephen jaques
>>*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
>>*E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
>>http://www.mallesons.com
>>
>>maxzsim wrote:
>>
>>Hi ,
>> i am using sql server 2000 evaluation copy , can it be installed on XP
>>professional ?
>>rdgs
>>
>>
>>
--060404050301060308050608
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>You'd need one of the Windows NT Server, Window 2000 Server or
Windows 2003 Server O/S families for Enterprise Edition (even if it is
just an eval - that just means it's time bombed for 120 days).Â For
Windows XP Pro you'll need the Personal Edition of SQL Server 2000.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
maxzsim wrote:
<blockquote cite="mid1AFC65A9-8C8F-4F0B-ADF8-A7E78AD678BC@.microsoft.com"
type="cite">
<pre wrap="">Hi Mike ,
i am using the evaluation copy of the Enterprise Edition
rdgs
"Mike Hodgson" wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Sorry about the multi-posts. Thunderbird spat the dummy.
Mike Hodgson wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Which edition? Personal, standard or enterprise? Standard &
Enterprise must go on a server O/S. Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
Developer edition is the same as the Enterprise edition except just
licensed differently.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a> |* W*
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.mallesons.com</a>">http://www.mallesons.com">http://www.mallesons.com</a>
maxzsim wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</body>
</html>
--060404050301060308050608--|||Yes...the Enterprise Evaluation Edition is supported on XP
Pro. You can find the supported operating systems at:
http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp
-Sue
On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
<maxzsim@.discussions.microsoft.com> wrote:
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
>> Sorry about the multi-posts. Thunderbird spat the dummy.
>>
>> Mike Hodgson wrote:
>> > Which edition? Personal, standard or enterprise? Standard &
>> > Enterprise must go on a server O/S. Personal edition can go on a
>> > workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
>> > Developer edition is the same as the Enterprise edition except just
>> > licensed differently.
>> >
>> > --
>> > *mike hodgson* |/ database administrator/ | mallesons stephen jaques
>> > *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
>> > *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
>> > http://www.mallesons.com
>> >
>> >
>> >
>> > maxzsim wrote:
>> >
>> >>Hi ,
>> >>
>> >> i am using sql server 2000 evaluation copy , can it be installed on XP
>> >>professional ?
>> >>
>> >>rdgs
>> >>
>> >>
>> >>
>> >>|||This is a multi-part message in MIME format.
--030203010807050905000109
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
lately. Maybe I should take a break from the newsgroups for a while and
going back to playing chess.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Sue Hoegemeier wrote:
>Yes...the Enterprise Evaluation Edition is supported on XP
>Pro. You can find the supported operating systems at:
>http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp
>-Sue
>On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
> <maxzsim@.discussions.microsoft.com> wrote:
>
>>Hi Mike ,
>>i am using the evaluation copy of the Enterprise Edition
>>rdgs
>>"Mike Hodgson" wrote:
>>
>>Sorry about the multi-posts. Thunderbird spat the dummy.
>>
>>Mike Hodgson wrote:
>>
>>Which edition? Personal, standard or enterprise? Standard &
>>Enterprise must go on a server O/S. Personal edition can go on a
>>workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
>>Developer edition is the same as the Enterprise edition except just
>>licensed differently.
>>--
>>*mike hodgson* |/ database administrator/ | mallesons stephen jaques
>>*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
>>*E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
>>http://www.mallesons.com
>>
>>maxzsim wrote:
>>
>>Hi ,
>> i am using sql server 2000 evaluation copy , can it be installed on XP
>>professional ?
>>rdgs
>>
>>
>>
>
>
--030203010807050905000109
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Hmmm...oops. Sorry 'bout my errata. 
:-[ I'm having a shocker lately. Maybe I should
take a break from the newsgroups for a while and going back to playing
chess.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
Sue Hoegemeier wrote:
<blockquote cite="midalkq11h6gpb048hoi2rum3otilivp4ci8q@.4ax.com"
type="cite">
<pre wrap="">Yes...the Enterprise Evaluation Edition is supported on XP
Pro. You can find the supported operating systems at:
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp</a>">http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp">http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp</a>
-Sue
On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
<a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:maxzsim@.discussions.microsoft.com"><maxzsim@.discussions.microsoft.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi Mike ,
i am using the evaluation copy of the Enterprise Edition
rdgs
"Mike Hodgson" wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Sorry about the multi-posts. Thunderbird spat the dummy.
Mike Hodgson wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Which edition? Personal, standard or enterprise? Standard &
Enterprise must go on a server O/S. Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
Developer edition is the same as the Enterprise edition except just
licensed differently.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a> |* W*
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.mallesons.com</a>">http://www.mallesons.com">http://www.mallesons.com</a>
maxzsim wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><!-->
</pre>
</blockquote>
</body>
</html>
--030203010807050905000109--|||thks everyone for the help given
"Mike Hodgson" wrote:
> Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
> lately. Maybe I should take a break from the newsgroups for a while and
> going back to playing chess.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
>
> Sue Hoegemeier wrote:
> >Yes...the Enterprise Evaluation Edition is supported on XP
> >Pro. You can find the supported operating systems at:
> >http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp
> >
> >-Sue
> >
> >On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
> > <maxzsim@.discussions.microsoft.com> wrote:
> >
> >
> >
> >>Hi Mike ,
> >>
> >>i am using the evaluation copy of the Enterprise Edition
> >>
> >>rdgs
> >>
> >>"Mike Hodgson" wrote:
> >>
> >>
> >>
> >>Sorry about the multi-posts. Thunderbird spat the dummy.
> >>
> >>
> >>
> >>Mike Hodgson wrote:
> >>
> >>
> >>
> >>Which edition? Personal, standard or enterprise? Standard &
> >>Enterprise must go on a server O/S. Personal edition can go on a
> >>workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
> >>Developer edition is the same as the Enterprise edition except just
> >>licensed differently.
> >>
> >>--
> >>*mike hodgson* |/ database administrator/ | mallesons stephen jaques
> >>*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> >>*E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> >>http://www.mallesons.com
> >>
> >>
> >>
> >>maxzsim wrote:
> >>
> >>
> >>
> >>Hi ,
> >>
> >> i am using sql server 2000 evaluation copy , can it be installed on XP
> >>professional ?
> >>
> >>rdgs
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
>|||No problem Mike...we all have those moments. Don't worry
about it.
-Sue
On Thu, 24 Feb 2005 15:26:40 +1100, Mike Hodgson
<mike.hodgson@.mallesons.nospam.com> wrote:
>Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
>lately. Maybe I should take a break from the newsgroups for a while and
>going back to playing chess.

can SQL 2000 evaluation install on XP

Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgsWhich edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:

>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>|||Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:

>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>|||Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:

>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>|||Sorry about the multi-posts. Thunderbird spat the dummy.
Mike Hodgson wrote:
[vbcol=seagreen]
> Which edition? Personal, standard or enterprise? Standard &
> Enterprise must go on a server O/S. Personal edition can go on a
> workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
> Developer edition is the same as the Enterprise edition except just
> licensed differently.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> maxzsim wrote:
>|||Hi Mike ,
i am using the evaluation copy of the Enterprise Edition
rdgs
"Mike Hodgson" wrote:

> Sorry about the multi-posts. Thunderbird spat the dummy.
>
> Mike Hodgson wrote:
>
>|||You'd need one of the Windows NT Server, Window 2000 Server or Windows
2003 Server O/S families for Enterprise Edition (even if it is just an
eval - that just means it's time bombed for 120 days). For Windows XP
Pro you'll need the Personal Edition of SQL Server 2000.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
[vbcol=seagreen]
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
>
>|||Yes...the Enterprise Evaluation Edition is supported on XP
Pro. You can find the supported operating systems at:
http://msdn.microsoft.com/library/e..._ar_ts_7eur.asp
-Sue
On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
<maxzsim@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
>|||Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
lately. Maybe I should take a break from the newsgroups for a while and
going back to playing chess.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Sue Hoegemeier wrote:

>Yes...the Enterprise Evaluation Edition is supported on XP
>Pro. You can find the supported operating systems at:
>http://msdn.microsoft.com/library/e..._ar_ts_7eur.asp
>-Sue
>On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
> <maxzsim@.discussions.microsoft.com> wrote:
>
>
>
>|||thks everyone for the help given
"Mike Hodgson" wrote:

> Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
> lately. Maybe I should take a break from the newsgroups for a while and
> going back to playing chess.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* [url]http://www.mallesons.com[/url
]
>
> Sue Hoegemeier wrote:
>
>

Can someone, MS?, please explain the Reporting Server security?

I just installed the evaluation version and am comparing it to Crystal
Reports. I can't seem to figure out the user level security.
My set-up:
Web server Win2003: Has IIS6 and Report server
DB SQL Server Win 2003: has Sql Server 2k
These boxes are not on a domain, they are test machines.
I open the report server up and get the home page, I can add folder, files,
etc but I no user level security. I went into site settings and all I can
find is roles, but no logins, etc.' I can go to the site and do everything
with no login?
Help.you are correct. Where you've gone awry is the difference between
authentication and authorization.
authentication is the process of determining who you are, most commonly done
via a username and password.
authorization is the process of determining what you can do now that we know
who you are.
In the Reporting Services world, RS relies on external authentication. In
other words, somebody other than RS has to authenticate the user. In most
cases that will be windows. So all user accounts are created in windows.
Users are managed there as per normal.
In the security settings you then create roles. Those roles have specific
permissions on report items etc. You then assign windows users and groups
these roles.
So if we take Joe User... His user account is maintained in windows (userID,
Password etc) either at the domain or the server level. Joe's account is
then assigned to roles in RS which determine what he can do with RS.
Make sense?
Regards,
Rob Labbé, MCP, MCAD, MCSD, MCT
Lead Architect/Trainer
Fidelis
Blog: http://spaces.msn.com/members/roblabbe
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:B6C6072D-63BC-422F-9DF9-A4400B300EF8@.microsoft.com...
>I just installed the evaluation version and am comparing it to Crystal
> Reports. I can't seem to figure out the user level security.
> My set-up:
> Web server Win2003: Has IIS6 and Report server
> DB SQL Server Win 2003: has Sql Server 2k
> These boxes are not on a domain, they are test machines.
> I open the report server up and get the home page, I can add folder,
> files,
> etc but I no user level security. I went into site settings and all I can
> find is roles, but no logins, etc.' I can go to the site and do
> everything
> with no login?
> Help.|||then why is there several tables that house roles, users, and their assigned
roles then is Sql Server?
Also, Crystal take sit to the lowest level via a "Universe" to a record
level. Does MS Report Serv. not do this either?
Are you saying that I have to add everyone to the windows box? That doesn't
make sense for web reporting, the IUSR account can access everything?
thanx.
"Rob Labbe (Lowney)" wrote:
> you are correct. Where you've gone awry is the difference between
> authentication and authorization.
> authentication is the process of determining who you are, most commonly done
> via a username and password.
> authorization is the process of determining what you can do now that we know
> who you are.
> In the Reporting Services world, RS relies on external authentication. In
> other words, somebody other than RS has to authenticate the user. In most
> cases that will be windows. So all user accounts are created in windows.
> Users are managed there as per normal.
> In the security settings you then create roles. Those roles have specific
> permissions on report items etc. You then assign windows users and groups
> these roles.
> So if we take Joe User... His user account is maintained in windows (userID,
> Password etc) either at the domain or the server level. Joe's account is
> then assigned to roles in RS which determine what he can do with RS.
> Make sense?
> Regards,
>
> --
> Rob LabbÃ©, MCP, MCAD, MCSD, MCT
> Lead Architect/Trainer
> Fidelis
> Blog: http://spaces.msn.com/members/roblabbe
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:B6C6072D-63BC-422F-9DF9-A4400B300EF8@.microsoft.com...
> >I just installed the evaluation version and am comparing it to Crystal
> > Reports. I can't seem to figure out the user level security.
> > My set-up:
> > Web server Win2003: Has IIS6 and Report server
> > DB SQL Server Win 2003: has Sql Server 2k
> >
> > These boxes are not on a domain, they are test machines.
> >
> > I open the report server up and get the home page, I can add folder,
> > files,
> > etc but I no user level security. I went into site settings and all I can
> > find is roles, but no logins, etc.' I can go to the site and do
> > everything
> > with no login?
> >
> > Help.
>
>|||As you've discovered, the security model is vastly different in RS as
compared to Crystal. You're going to drive yourself nuts if you try to do a
one-to-one mapping of security features between the two.
You're best bet is to look at the end result you're after, not "how" it was
implemented in Crystal. Then look at RS security and set it up to get the
same end result. If you describe your scenario, and what the result you're
after is, we may be able to help you out here.
Regards,
Rob Labbé, MCP, MCAD, MCSD, MCT
Lead Architect/Trainer
Fidelis
Blog: http://spaces.msn.com/members/roblabbe
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:65196924-819E-4F4E-AD10-78D60F4A729C@.microsoft.com...
> then why is there several tables that house roles, users, and their
> assigned
> roles then is Sql Server?
> Also, Crystal take sit to the lowest level via a "Universe" to a record
> level. Does MS Report Serv. not do this either?
> Are you saying that I have to add everyone to the windows box? That
> doesn't
> make sense for web reporting, the IUSR account can access everything?
> thanx.
> "Rob Labbe (Lowney)" wrote:
>> you are correct. Where you've gone awry is the difference between
>> authentication and authorization.
>> authentication is the process of determining who you are, most commonly
>> done
>> via a username and password.
>> authorization is the process of determining what you can do now that we
>> know
>> who you are.
>> In the Reporting Services world, RS relies on external authentication.
>> In
>> other words, somebody other than RS has to authenticate the user. In
>> most
>> cases that will be windows. So all user accounts are created in windows.
>> Users are managed there as per normal.
>> In the security settings you then create roles. Those roles have
>> specific
>> permissions on report items etc. You then assign windows users and
>> groups
>> these roles.
>> So if we take Joe User... His user account is maintained in windows
>> (userID,
>> Password etc) either at the domain or the server level. Joe's account is
>> then assigned to roles in RS which determine what he can do with RS.
>> Make sense?
>> Regards,
>>
>> --
>> Rob Labbé, MCP, MCAD, MCSD, MCT
>> Lead Architect/Trainer
>> Fidelis
>> Blog: http://spaces.msn.com/members/roblabbe
>> "Chris" <Chris@.discussions.microsoft.com> wrote in message
>> news:B6C6072D-63BC-422F-9DF9-A4400B300EF8@.microsoft.com...
>> >I just installed the evaluation version and am comparing it to Crystal
>> > Reports. I can't seem to figure out the user level security.
>> > My set-up:
>> > Web server Win2003: Has IIS6 and Report server
>> > DB SQL Server Win 2003: has Sql Server 2k
>> >
>> > These boxes are not on a domain, they are test machines.
>> >
>> > I open the report server up and get the home page, I can add folder,
>> > files,
>> > etc but I no user level security. I went into site settings and all I
>> > can
>> > find is roles, but no logins, etc.' I can go to the site and do
>> > everything
>> > with no login?
>> >
>> > Help.
>>|||if there is no central login then how do you restrict it as a web app in the
manager? The roles don't appear to be machine or AD roles?
Are we saying that all users get "everything".
I'm still not seeing this. I thought maybe the eval version doesn't have
login dilaogs or something?
thanx.
"Rob Labbe (Lowney)" wrote:
> As you've discovered, the security model is vastly different in RS as
> compared to Crystal. You're going to drive yourself nuts if you try to do a
> one-to-one mapping of security features between the two.
> You're best bet is to look at the end result you're after, not "how" it was
> implemented in Crystal. Then look at RS security and set it up to get the
> same end result. If you describe your scenario, and what the result you're
> after is, we may be able to help you out here.
> Regards,
>
> --
> Rob LabbÃ©, MCP, MCAD, MCSD, MCT
> Lead Architect/Trainer
> Fidelis
> Blog: http://spaces.msn.com/members/roblabbe
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:65196924-819E-4F4E-AD10-78D60F4A729C@.microsoft.com...
> > then why is there several tables that house roles, users, and their
> > assigned
> > roles then is Sql Server?
> > Also, Crystal take sit to the lowest level via a "Universe" to a record
> > level. Does MS Report Serv. not do this either?
> >
> > Are you saying that I have to add everyone to the windows box? That
> > doesn't
> > make sense for web reporting, the IUSR account can access everything?
> >
> > thanx.
> >
> > "Rob Labbe (Lowney)" wrote:
> >
> >> you are correct. Where you've gone awry is the difference between
> >> authentication and authorization.
> >>
> >> authentication is the process of determining who you are, most commonly
> >> done
> >> via a username and password.
> >>
> >> authorization is the process of determining what you can do now that we
> >> know
> >> who you are.
> >>
> >> In the Reporting Services world, RS relies on external authentication.
> >> In
> >> other words, somebody other than RS has to authenticate the user. In
> >> most
> >> cases that will be windows. So all user accounts are created in windows.
> >> Users are managed there as per normal.
> >>
> >> In the security settings you then create roles. Those roles have
> >> specific
> >> permissions on report items etc. You then assign windows users and
> >> groups
> >> these roles.
> >>
> >> So if we take Joe User... His user account is maintained in windows
> >> (userID,
> >> Password etc) either at the domain or the server level. Joe's account is
> >> then assigned to roles in RS which determine what he can do with RS.
> >>
> >> Make sense?
> >>
> >> Regards,
> >>
> >>
> >> --
> >> Rob LabbÃ©, MCP, MCAD, MCSD, MCT
> >> Lead Architect/Trainer
> >> Fidelis
> >>
> >> Blog: http://spaces.msn.com/members/roblabbe
> >>
> >> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> >> news:B6C6072D-63BC-422F-9DF9-A4400B300EF8@.microsoft.com...
> >> >I just installed the evaluation version and am comparing it to Crystal
> >> > Reports. I can't seem to figure out the user level security.
> >> > My set-up:
> >> > Web server Win2003: Has IIS6 and Report server
> >> > DB SQL Server Win 2003: has Sql Server 2k
> >> >
> >> > These boxes are not on a domain, they are test machines.
> >> >
> >> > I open the report server up and get the home page, I can add folder,
> >> > files,
> >> > etc but I no user level security. I went into site settings and all I
> >> > can
> >> > find is roles, but no logins, etc.' I can go to the site and do
> >> > everything
> >> > with no login?
> >> >
> >> > Help.
> >>
> >>
> >>
>
>|||Role and groups are two different things. I do the following. I create a
local group called Reports. For that group I add either individual users or
I add domain groups. Then in the home page of Report Manager, Properties,
New Role Assignment. For the user/group I put in Reports (the local group I
created previously) and I give it Browse rights.
RS is totally integrated with Windows security. If you are not going to be
using that (for instance over the internet) then you need to create your own
authentication that you integrate in with Reporting Service. Search the
books on line on authentication. Lots of good info. Just remember,
authentication and roles are two different thing. Once someone is
authenticated to be in a particular group (or authenticated to be a
particular user) then RS allows them rights based on the role assignment for
that group/user.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:7DABBC90-778B-4991-8177-1E7495A87788@.microsoft.com...
> if there is no central login then how do you restrict it as a web app in
the
> manager? The roles don't appear to be machine or AD roles?
> Are we saying that all users get "everything".
> I'm still not seeing this. I thought maybe the eval version doesn't have
> login dilaogs or something?
> thanx.
> "Rob Labbe (Lowney)" wrote:
> > As you've discovered, the security model is vastly different in RS as
> > compared to Crystal. You're going to drive yourself nuts if you try to
do a
> > one-to-one mapping of security features between the two.
> >
> > You're best bet is to look at the end result you're after, not "how" it
was
> > implemented in Crystal. Then look at RS security and set it up to get
the
> > same end result. If you describe your scenario, and what the result
you're
> > after is, we may be able to help you out here.
> >
> > Regards,
> >
> >
> > --
> > Rob Labbé, MCP, MCAD, MCSD, MCT
> > Lead Architect/Trainer
> > Fidelis
> >
> > Blog: http://spaces.msn.com/members/roblabbe
> >
> > "Chris" <Chris@.discussions.microsoft.com> wrote in message
> > news:65196924-819E-4F4E-AD10-78D60F4A729C@.microsoft.com...
> > > then why is there several tables that house roles, users, and their
> > > assigned
> > > roles then is Sql Server?
> > > Also, Crystal take sit to the lowest level via a "Universe" to a
record
> > > level. Does MS Report Serv. not do this either?
> > >
> > > Are you saying that I have to add everyone to the windows box? That
> > > doesn't
> > > make sense for web reporting, the IUSR account can access everything?
> > >
> > > thanx.
> > >
> > > "Rob Labbe (Lowney)" wrote:
> > >
> > >> you are correct. Where you've gone awry is the difference between
> > >> authentication and authorization.
> > >>
> > >> authentication is the process of determining who you are, most
commonly
> > >> done
> > >> via a username and password.
> > >>
> > >> authorization is the process of determining what you can do now that
we
> > >> know
> > >> who you are.
> > >>
> > >> In the Reporting Services world, RS relies on external
authentication.
> > >> In
> > >> other words, somebody other than RS has to authenticate the user.
In
> > >> most
> > >> cases that will be windows. So all user accounts are created in
windows.
> > >> Users are managed there as per normal.
> > >>
> > >> In the security settings you then create roles. Those roles have
> > >> specific
> > >> permissions on report items etc. You then assign windows users and
> > >> groups
> > >> these roles.
> > >>
> > >> So if we take Joe User... His user account is maintained in windows
> > >> (userID,
> > >> Password etc) either at the domain or the server level. Joe's
account is
> > >> then assigned to roles in RS which determine what he can do with RS.
> > >>
> > >> Make sense?
> > >>
> > >> Regards,
> > >>
> > >>
> > >> --
> > >> Rob Labbé, MCP, MCAD, MCSD, MCT
> > >> Lead Architect/Trainer
> > >> Fidelis
> > >>
> > >> Blog: http://spaces.msn.com/members/roblabbe
> > >>
> > >> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> > >> news:B6C6072D-63BC-422F-9DF9-A4400B300EF8@.microsoft.com...
> > >> >I just installed the evaluation version and am comparing it to
Crystal
> > >> > Reports. I can't seem to figure out the user level security.
> > >> > My set-up:
> > >> > Web server Win2003: Has IIS6 and Report server
> > >> > DB SQL Server Win 2003: has Sql Server 2k
> > >> >
> > >> > These boxes are not on a domain, they are test machines.
> > >> >
> > >> > I open the report server up and get the home page, I can add
folder,
> > >> > files,
> > >> > etc but I no user level security. I went into site settings and all
I
> > >> > can
> > >> > find is roles, but no logins, etc.' I can go to the site and do
> > >> > everything
> > >> > with no login?
> > >> >
> > >> > Help.
> > >>
> > >>
> > >>
> >
> >
> >|||There is a Reporting Services 2005 book screaming to be written, here -
I know I'd buy multiple copies for work if someone could clearly
present this topic.
As is, it would make Oppenheimer stagger across the room for a
Tylenol...

Wednesday, March 7, 2012

Can SQL Server 2005 Evaluation be used to upgrade a system?

Can SQL Server 2005 Evaluation be used to upgrade a system?

Saturday, February 25, 2012

can SQL 2000 evaluation install on XP

can SQL 2000 evaluation install on XP

can SQL 2000 evaluation install on XP

Can someone, MS?, please explain the Reporting Server security?

sql reports

Blog Archive

About Me