rda submitsql: personal

Hello,
If I have a SQL Server set for Per Processor Licensing can I install
Personal Edition on a number of Laptops/ PC's without purchasing a license
for them? We have laptop users that travel and use a local copy of a
database. I want to move to Per Processor licensing for our main server but
an unsure if these users will fall under the per processor licensing model or
will still require a license to use Personal edition. From what I understand
they fall under per processor but I want to make sure.
Thanks for your time.The short answer is no, sorry.
Have a look at
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
Peter
"Action speaks louder than words but not nearly as often"
Mark Twain
"DM" wrote:
> Hello,
> If I have a SQL Server set for Per Processor Licensing can I install
> Personal Edition on a number of Laptops/ PC's without purchasing a license
> for them? We have laptop users that travel and use a local copy of a
> database. I want to move to Per Processor licensing for our main server but
> an unsure if these users will fall under the per processor licensing model or
> will still require a license to use Personal edition. From what I understand
> they fall under per processor but I want to make sure.
> Thanks for your time.|||That is not how I understand it. Can you be a bit more specific, Peter? Below, for instance,
indicates to me that PE is applicable in a Per Processor environment:
http://www.microsoft.com/sql/howtobuy/faq.asp
(Search for "Personal" in above page.)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in
message news:B5A69D79-891F-4955-9A5E-DC151AB4D042@.microsoft.com...
> The short answer is no, sorry.
> Have a look at
> http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
> Peter
> "Action speaks louder than words but not nearly as often"
> Mark Twain
>
> "DM" wrote:
>> Hello,
>> If I have a SQL Server set for Per Processor Licensing can I install
>> Personal Edition on a number of Laptops/ PC's without purchasing a license
>> for them? We have laptop users that travel and use a local copy of a
>> database. I want to move to Per Processor licensing for our main server but
>> an unsure if these users will fall under the per processor licensing model or
>> will still require a license to use Personal edition. From what I understand
>> they fall under per processor but I want to make sure.
>> Thanks for your time.|||Thanks for that. Big misunderstanding on my part.
"Peter 'Not Peter The Spate' Nolan" wrote:
> The short answer is no, sorry.
> Have a look at
> http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
> Peter
> "Action speaks louder than words but not nearly as often"
> Mark Twain
>
> "DM" wrote:
> > Hello,
> >
> > If I have a SQL Server set for Per Processor Licensing can I install
> > Personal Edition on a number of Laptops/ PC's without purchasing a license
> > for them? We have laptop users that travel and use a local copy of a
> > database. I want to move to Per Processor licensing for our main server but
> > an unsure if these users will fall under the per processor licensing model or
> > will still require a license to use Personal edition. From what I understand
> > they fall under per processor but I want to make sure.
> >
> > Thanks for your time.|||I read Tibor's link and I remember reading that document a while ago and
thinking the using Per Processor would cover Personal editions. But I've no
idea what the licensing is now. Any one know for sure if Per Processing will
cover Personal Edition?
Thanks again
"Peter 'Not Peter The Spate' Nolan" wrote:
> The short answer is no, sorry.
> Have a look at
> http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
> Peter
> "Action speaks louder than words but not nearly as often"
> Mark Twain
>
> "DM" wrote:
> > Hello,
> >
> > If I have a SQL Server set for Per Processor Licensing can I install
> > Personal Edition on a number of Laptops/ PC's without purchasing a license
> > for them? We have laptop users that travel and use a local copy of a
> > database. I want to move to Per Processor licensing for our main server but
> > an unsure if these users will fall under the per processor licensing model or
> > will still require a license to use Personal edition. From what I understand
> > they fall under per processor but I want to make sure.
> >
> > Thanks for your time.|||Thanks Tibor,
Well you learn something new every day, DM, I got the answer totally wrong
(again), Tibor, thank you for pointing it out.
Peter
"Adam and Eve had many advantages but the principal one was that they
escaped teething."
Mark Twain
Q. What type of license do I need to install and run SQL Server Personal
Edition?
A. SQL Server Personal Edition is not a separate product, but instead a
component of SQL Server that is designed to bring SQL Server functionality to
desktop applications. It can be installed and used on any Microsoft
Windowsâ'based device within an organization provided it is properly licensed
with a CAL or connects to servers that are properly licensed according to the
Per Processor licensing model.
If SQL Server Personal Edition interfaces with an instance of SQL Server,
and then distributes that data to other devices, SQL Server Personal Edition
is acting as a mutliplexer and SQL Server device CALs are required for all
devices accessing it. If you have licensed SQL Server according to the Per
Processor licensing model, you can have an unlimited number of connections to
that server, whether it is through SQL Server Personal Edition or through
direct connections.
"Tibor Karaszi" wrote:
> That is not how I understand it. Can you be a bit more specific, Peter? Below, for instance,
> indicates to me that PE is applicable in a Per Processor environment:
> http://www.microsoft.com/sql/howtobuy/faq.asp
> (Search for "Personal" in above page.)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in
> message news:B5A69D79-891F-4955-9A5E-DC151AB4D042@.microsoft.com...
> > The short answer is no, sorry.
> >
> > Have a look at
> > http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
> >
> > Peter
> >
> > "Action speaks louder than words but not nearly as often"
> > Mark Twain
> >
> >
> > "DM" wrote:
> >
> >> Hello,
> >>
> >> If I have a SQL Server set for Per Processor Licensing can I install
> >> Personal Edition on a number of Laptops/ PC's without purchasing a license
> >> for them? We have laptop users that travel and use a local copy of a
> >> database. I want to move to Per Processor licensing for our main server but
> >> an unsure if these users will fall under the per processor licensing model or
> >> will still require a license to use Personal edition. From what I understand
> >> they fall under per processor but I want to make sure.
> >>
> >> Thanks for your time.
>
>|||I believe that DM should contact a sales rep as MS about this. Especially considering the last part
of below sentence:
"It can be installed and used on any Microsoft
Windows-based device within an organization provided it is properly licensed
with a CAL or connects to servers that are properly licensed according to the
Per Processor licensing model."
Note:
*It* can be installed... or connects to servers.. properly licensed according to the
Per Processor...
Seems to me like PE need to connect to the server, somehow, perhaps replication...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in
message news:48199778-BDCB-4572-8A19-91675B759D32@.microsoft.com...
> Thanks Tibor,
> Well you learn something new every day, DM, I got the answer totally wrong
> (again), Tibor, thank you for pointing it out.
> Peter
> "Adam and Eve had many advantages but the principal one was that they
> escaped teething."
> Mark Twain
>
> Q. What type of license do I need to install and run SQL Server Personal
> Edition?
> A. SQL Server Personal Edition is not a separate product, but instead a
> component of SQL Server that is designed to bring SQL Server functionality to
> desktop applications. It can be installed and used on any Microsoft
> Windows-based device within an organization provided it is properly licensed
> with a CAL or connects to servers that are properly licensed according to the
> Per Processor licensing model.
> If SQL Server Personal Edition interfaces with an instance of SQL Server,
> and then distributes that data to other devices, SQL Server Personal Edition
> is acting as a mutliplexer and SQL Server device CALs are required for all
> devices accessing it. If you have licensed SQL Server according to the Per
> Processor licensing model, you can have an unlimited number of connections to
> that server, whether it is through SQL Server Personal Edition or through
> direct connections.
>
>
>
> "Tibor Karaszi" wrote:
>> That is not how I understand it. Can you be a bit more specific, Peter? Below, for instance,
>> indicates to me that PE is applicable in a Per Processor environment:
>> http://www.microsoft.com/sql/howtobuy/faq.asp
>> (Search for "Personal" in above page.)
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote
>> in
>> message news:B5A69D79-891F-4955-9A5E-DC151AB4D042@.microsoft.com...
>> > The short answer is no, sorry.
>> >
>> > Have a look at
>> > http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
>> >
>> > Peter
>> >
>> > "Action speaks louder than words but not nearly as often"
>> > Mark Twain
>> >
>> >
>> > "DM" wrote:
>> >
>> >> Hello,
>> >>
>> >> If I have a SQL Server set for Per Processor Licensing can I install
>> >> Personal Edition on a number of Laptops/ PC's without purchasing a license
>> >> for them? We have laptop users that travel and use a local copy of a
>> >> database. I want to move to Per Processor licensing for our main server but
>> >> an unsure if these users will fall under the per processor licensing model or
>> >> will still require a license to use Personal edition. From what I understand
>> >> they fall under per processor but I want to make sure.
>> >>
>> >> Thanks for your time.
>>|||I've sent an email off to Microsoft for a little clarity.
Thanks for you help.
"Tibor Karaszi" wrote:
> I believe that DM should contact a sales rep as MS about this. Especially considering the last part
> of below sentence:
> "It can be installed and used on any Microsoft
> Windows-based device within an organization provided it is properly licensed
> with a CAL or connects to servers that are properly licensed according to the
> Per Processor licensing model."
> Note:
> *It* can be installed... or connects to servers.. properly licensed according to the
> Per Processor...
> Seems to me like PE need to connect to the server, somehow, perhaps replication...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in
> message news:48199778-BDCB-4572-8A19-91675B759D32@.microsoft.com...
> > Thanks Tibor,
> >
> > Well you learn something new every day, DM, I got the answer totally wrong
> > (again), Tibor, thank you for pointing it out.
> >
> > Peter
> > "Adam and Eve had many advantages but the principal one was that they
> > escaped teething."
> > Mark Twain
> >
> >
> > Q. What type of license do I need to install and run SQL Server Personal
> > Edition?
> >
> > A. SQL Server Personal Edition is not a separate product, but instead a
> > component of SQL Server that is designed to bring SQL Server functionality to
> > desktop applications. It can be installed and used on any Microsoft
> > Windows-based device within an organization provided it is properly licensed
> > with a CAL or connects to servers that are properly licensed according to the
> > Per Processor licensing model.
> >
> > If SQL Server Personal Edition interfaces with an instance of SQL Server,
> > and then distributes that data to other devices, SQL Server Personal Edition
> > is acting as a mutliplexer and SQL Server device CALs are required for all
> > devices accessing it. If you have licensed SQL Server according to the Per
> > Processor licensing model, you can have an unlimited number of connections to
> > that server, whether it is through SQL Server Personal Edition or through
> > direct connections.
> >
> >
> >
> >
> >
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> That is not how I understand it. Can you be a bit more specific, Peter? Below, for instance,
> >> indicates to me that PE is applicable in a Per Processor environment:
> >>
> >> http://www.microsoft.com/sql/howtobuy/faq.asp
> >>
> >> (Search for "Personal" in above page.)
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> http://www.sqlug.se/
> >>
> >>
> >> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote
> >> in
> >> message news:B5A69D79-891F-4955-9A5E-DC151AB4D042@.microsoft.com...
> >> > The short answer is no, sorry.
> >> >
> >> > Have a look at
> >> > http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
> >> >
> >> > Peter
> >> >
> >> > "Action speaks louder than words but not nearly as often"
> >> > Mark Twain
> >> >
> >> >
> >> > "DM" wrote:
> >> >
> >> >> Hello,
> >> >>
> >> >> If I have a SQL Server set for Per Processor Licensing can I install
> >> >> Personal Edition on a number of Laptops/ PC's without purchasing a license
> >> >> for them? We have laptop users that travel and use a local copy of a
> >> >> database. I want to move to Per Processor licensing for our main server but
> >> >> an unsure if these users will fall under the per processor licensing model or
> >> >> will still require a license to use Personal edition. From what I understand
> >> >> they fall under per processor but I want to make sure.
> >> >>
> >> >> Thanks for your time.
> >>
> >>
> >>
>
>|||Hello,
For those interested I have an answer from Microsoft regarding licenses for
Personal Edition. See below...
I understand your confusion over the statement quoted, but you are correct
in your assumption on the licensing requirements of SQL Personal Edition.
SQL PE is a component of the main SQL server itself, and the licensing is
dependent how you licence the server. If you decide to licence SQL with
CALs, for each CAL purchased you are entitled to install one copy of SQL PE.
If you go the processor route, as this allows for an unlimited number of
connections, you can install SQL PE on an unlimited number of PCs as well.
easy when you know how...
"Tibor Karaszi" wrote:
> I believe that DM should contact a sales rep as MS about this. Especially considering the last part
> of below sentence:
> "It can be installed and used on any Microsoft
> Windows-based device within an organization provided it is properly licensed
> with a CAL or connects to servers that are properly licensed according to the
> Per Processor licensing model."
> Note:
> *It* can be installed... or connects to servers.. properly licensed according to the
> Per Processor...
> Seems to me like PE need to connect to the server, somehow, perhaps replication...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in
> message news:48199778-BDCB-4572-8A19-91675B759D32@.microsoft.com...
> > Thanks Tibor,
> >
> > Well you learn something new every day, DM, I got the answer totally wrong
> > (again), Tibor, thank you for pointing it out.
> >
> > Peter
> > "Adam and Eve had many advantages but the principal one was that they
> > escaped teething."
> > Mark Twain
> >
> >
> > Q. What type of license do I need to install and run SQL Server Personal
> > Edition?
> >
> > A. SQL Server Personal Edition is not a separate product, but instead a
> > component of SQL Server that is designed to bring SQL Server functionality to
> > desktop applications. It can be installed and used on any Microsoft
> > Windows-based device within an organization provided it is properly licensed
> > with a CAL or connects to servers that are properly licensed according to the
> > Per Processor licensing model.
> >
> > If SQL Server Personal Edition interfaces with an instance of SQL Server,
> > and then distributes that data to other devices, SQL Server Personal Edition
> > is acting as a mutliplexer and SQL Server device CALs are required for all
> > devices accessing it. If you have licensed SQL Server according to the Per
> > Processor licensing model, you can have an unlimited number of connections to
> > that server, whether it is through SQL Server Personal Edition or through
> > direct connections.
> >
> >
> >
> >
> >
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> That is not how I understand it. Can you be a bit more specific, Peter? Below, for instance,
> >> indicates to me that PE is applicable in a Per Processor environment:
> >>
> >> http://www.microsoft.com/sql/howtobuy/faq.asp
> >>
> >> (Search for "Personal" in above page.)
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> http://www.sqlug.se/
> >>
> >>
> >> "Peter 'Not Peter The Spate' Nolan" <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote
> >> in
> >> message news:B5A69D79-891F-4955-9A5E-DC151AB4D042@.microsoft.com...
> >> > The short answer is no, sorry.
> >> >
> >> > Have a look at
> >> > http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
> >> >
> >> > Peter
> >> >
> >> > "Action speaks louder than words but not nearly as often"
> >> > Mark Twain
> >> >
> >> >
> >> > "DM" wrote:
> >> >
> >> >> Hello,
> >> >>
> >> >> If I have a SQL Server set for Per Processor Licensing can I install
> >> >> Personal Edition on a number of Laptops/ PC's without purchasing a license
> >> >> for them? We have laptop users that travel and use a local copy of a
> >> >> database. I want to move to Per Processor licensing for our main server but
> >> >> an unsure if these users will fall under the per processor licensing model or
> >> >> will still require a license to use Personal edition. From what I understand
> >> >> they fall under per processor but I want to make sure.
> >> >>
> >> >> Thanks for your time.
> >>
> >>
> >>
>
>|||Thanks for posting the response. It's always best to get the official
answer from Microsoft on licensing questions.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"DM" <DM@.discussions.microsoft.com> wrote in message
news:91581106-922D-4F43-99DC-37842F86E635@.microsoft.com...
> Hello,
> For those interested I have an answer from Microsoft regarding licenses
> for
> Personal Edition. See below...
> I understand your confusion over the statement quoted, but you are correct
> in your assumption on the licensing requirements of SQL Personal Edition.
> SQL PE is a component of the main SQL server itself, and the licensing is
> dependent how you licence the server. If you decide to licence SQL with
> CALs, for each CAL purchased you are entitled to install one copy of SQL
> PE.
> If you go the processor route, as this allows for an unlimited number of
> connections, you can install SQL PE on an unlimited number of PCs as well.
> easy when you know how...
> "Tibor Karaszi" wrote:
>> I believe that DM should contact a sales rep as MS about this. Especially
>> considering the last part
>> of below sentence:
>> "It can be installed and used on any Microsoft
>> Windows-based device within an organization provided it is properly
>> licensed
>> with a CAL or connects to servers that are properly licensed according to
>> the
>> Per Processor licensing model."
>> Note:
>> *It* can be installed... or connects to servers.. properly licensed
>> according to the
>> Per Processor...
>> Seems to me like PE need to connect to the server, somehow, perhaps
>> replication...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "Peter 'Not Peter The Spate' Nolan"
>> <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote in
>> message news:48199778-BDCB-4572-8A19-91675B759D32@.microsoft.com...
>> > Thanks Tibor,
>> >
>> > Well you learn something new every day, DM, I got the answer totally
>> > wrong
>> > (again), Tibor, thank you for pointing it out.
>> >
>> > Peter
>> > "Adam and Eve had many advantages but the principal one was that they
>> > escaped teething."
>> > Mark Twain
>> >
>> >
>> > Q. What type of license do I need to install and run SQL Server
>> > Personal
>> > Edition?
>> >
>> > A. SQL Server Personal Edition is not a separate product, but instead
>> > a
>> > component of SQL Server that is designed to bring SQL Server
>> > functionality to
>> > desktop applications. It can be installed and used on any Microsoft
>> > Windows-based device within an organization provided it is properly
>> > licensed
>> > with a CAL or connects to servers that are properly licensed according
>> > to the
>> > Per Processor licensing model.
>> >
>> > If SQL Server Personal Edition interfaces with an instance of SQL
>> > Server,
>> > and then distributes that data to other devices, SQL Server Personal
>> > Edition
>> > is acting as a mutliplexer and SQL Server device CALs are required for
>> > all
>> > devices accessing it. If you have licensed SQL Server according to the
>> > Per
>> > Processor licensing model, you can have an unlimited number of
>> > connections to
>> > that server, whether it is through SQL Server Personal Edition or
>> > through
>> > direct connections.
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> That is not how I understand it. Can you be a bit more specific,
>> >> Peter? Below, for instance,
>> >> indicates to me that PE is applicable in a Per Processor environment:
>> >>
>> >> http://www.microsoft.com/sql/howtobuy/faq.asp
>> >>
>> >> (Search for "Personal" in above page.)
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >> http://www.sqlug.se/
>> >>
>> >>
>> >> "Peter 'Not Peter The Spate' Nolan"
>> >> <PeterNotPeterTheSpateNolan@.discussions.microsoft.com> wrote
>> >> in
>> >> message news:B5A69D79-891F-4955-9A5E-DC151AB4D042@.microsoft.com...
>> >> > The short answer is no, sorry.
>> >> >
>> >> > Have a look at
>> >> > http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx
>> >> >
>> >> > Peter
>> >> >
>> >> > "Action speaks louder than words but not nearly as often"
>> >> > Mark Twain
>> >> >
>> >> >
>> >> > "DM" wrote:
>> >> >
>> >> >> Hello,
>> >> >>
>> >> >> If I have a SQL Server set for Per Processor Licensing can I
>> >> >> install
>> >> >> Personal Edition on a number of Laptops/ PC's without purchasing a
>> >> >> license
>> >> >> for them? We have laptop users that travel and use a local copy of
>> >> >> a
>> >> >> database. I want to move to Per Processor licensing for our main
>> >> >> server but
>> >> >> an unsure if these users will fall under the per processor
>> >> >> licensing model or
>> >> >> will still require a license to use Personal edition. From what I
>> >> >> understand
>> >> >> they fall under per processor but I want to make sure.
>> >> >>
>> >> >> Thanks for your time.
>> >>
>> >>
>> >>
>>

Wednesday, March 21, 2012

Qustion about join 2 tables??

Monday, March 12, 2012

Quick SQL Server version question

Wednesday, March 7, 2012

Quick Licensing Question

Saturday, February 25, 2012

quick and easy install question

rda submitsql

Blog Archive

About Me