Did MS change RS licensing in 2005?

Hi,
With SQL Server 2000 and Reporting Services, I'd have to have an additional
SQL Server license if I wanted to run Reporting Services on a server other
the database server. I don't want to run Reporting Services on the same
machine as SQL Server as I'm not so crazy about running IIS and SQL Server on
the same machine.
My question is did MS change licensing for Reporting Services in the new
version that will be released w/ SQL Server 2005? Or will I still need an
additional license for Reporting Services if I wanted to run it on a
different machine?
--
Thanks,
SamAs far as I know this has not changed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:AC7D944B-258E-4394-AF42-493E1E1E190E@.microsoft.com...
> Hi,
> With SQL Server 2000 and Reporting Services, I'd have to have an
> additional
> SQL Server license if I wanted to run Reporting Services on a server other
> the database server. I don't want to run Reporting Services on the same
> machine as SQL Server as I'm not so crazy about running IIS and SQL Server
> on
> the same machine.
> My question is did MS change licensing for Reporting Services in the new
> version that will be released w/ SQL Server 2005? Or will I still need an
> additional license for Reporting Services if I wanted to run it on a
> different machine?
> --
> Thanks,
> Sam

Developer licensing

Ok, simple question:

We have 10 developers. All 10 use ONE server to do development work (design, coding, testing ONLY!). We have a Developer Edition licence for EACH developer. Is this OK? We have 10GB plus in test data and do not want to replicate that to each desktop.

According to the Developer Edition EULA, I would say NO. It looks like you can only have one developer (and a few testers, I forget the number) per server. It says NOTHING about having more than one developer access the same server under this license. The Developer Edition EULA appears to be designed around installing a database on a desktop just for that developer, not installing a central database that all developers use.AFAIK thats fine.

You would only need to switch from the Dev licence once your apps are in an actual production environment ie making someone very rich. In which case you would need the appropriate server licence, cal's, vs's and so forth.

It is a very difficult field to understand, however Microsoft are getting ever better at making things clear and easy to understand; this site should make it even easier for you to answer questions; http://www.microsoft.com/licensing/default.mspx

Developer Edition

Hi All,
I have a very basic licensing question. SQL Server Developer edition is
about $50. Does this include the whole software or is it just a cheaper seat
/ license for an existing SQL Server ?
ThanQ for the information.
Sashank SinguluriThe $50 includes the complete server software, with all the features of SQL
Server Enterprise Edition. There are limitation on how you can use it
though, it is only allowed for development and testing, not production.
Jacco Schalkwijk
SQL Server MVP
"Sashank Singuluri" <sasmo@.hotmail.com> wrote in message
news:OL3P53t%23DHA.552@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I have a very basic licensing question. SQL Server Developer edition is
> about $50. Does this include the whole software or is it just a cheaper
seat
> / license for an existing SQL Server ?
> ThanQ for the information.
> Sashank Singuluri
>|||It includes the whole software. But... you can not use it for a production
application...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Sashank Singuluri" <sasmo@.hotmail.com> wrote in message
news:OL3P53t%23DHA.552@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I have a very basic licensing question. SQL Server Developer edition is
> about $50. Does this include the whole software or is it just a cheaper
seat
> / license for an existing SQL Server ?
> ThanQ for the information.
> Sashank Singuluri
>

Developer Edition

Hi All,
I have a very basic licensing question. SQL Server Developer edition is
about $50. Does this include the whole software or is it just a cheaper seat
/ license for an existing SQL Server ?
ThanQ for the information.
Sashank SinguluriThe $50 includes the complete server software, with all the features of SQL
Server Enterprise Edition. There are limitation on how you can use it
though, it is only allowed for development and testing, not production.
--
Jacco Schalkwijk
SQL Server MVP
"Sashank Singuluri" <sasmo@.hotmail.com> wrote in message
news:OL3P53t%23DHA.552@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I have a very basic licensing question. SQL Server Developer edition is
> about $50. Does this include the whole software or is it just a cheaper
seat
> / license for an existing SQL Server ?
> ThanQ for the information.
> Sashank Singuluri
>|||It includes the whole software. But... you can not use it for a production
application...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Sashank Singuluri" <sasmo@.hotmail.com> wrote in message
news:OL3P53t%23DHA.552@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I have a very basic licensing question. SQL Server Developer edition is
> about $50. Does this include the whole software or is it just a cheaper
seat
> / license for an existing SQL Server ?
> ThanQ for the information.
> Sashank Singuluri
>

Determining the number of Active users logged into a SQL Server Database

How does one Determine the number of Active users logged into a SQL Server Database?

I want to use the info to control concurrent licensing for my Application

This query will give you a count grouped by DB, you can also use sp_who or sp_who2

select db_name(dbid),count(*) from master..sysprocesses
where spid > 49 --everyting below 50 is SQL Server itself
group by db_name(dbid)

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||Thanks, I will. I believe this is exactly what I am looking for. Is it safe to assume that the data is available in "real time"? Also if a user logged in to the DB drops his connection by doing something stupid like powering off his workstation without closing the app first, will the count be reduced, the next time it is run?|||Yes the data is real time, the server connection will disapear once the connection times out or the connection has been removed from the connection pool.