Load data from web page into sp (sql2000)

Hi, using sql server 2000, is there a way I can load data into a stored
procedure using just a web address? The data will just be text/xml or
some such.
cheers,
ChrisHello Chris,
Not easily sorry.
Easy in SQL 2005 with a CLR function.
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> Hi, using sql server 2000, is there a way I can load data into a
> stored procedure using just a web address? The data will just be
> text/xml or some such.
> cheers,
> Chris|||Simon Sabin wrote:
> Not easily sorry.
> Easy in SQL 2005 with a CLR function.
>
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
Thanks Simon.. I'm currently figuring it out using ado in an activex
script... would probably do it quicker upgrading to 2005 :D
cheers,
Chris

Load data from web page into sp (sql2000)

Hi, using sql server 2000, is there a way I can load data into a stored
procedure using just a web address? The data will just be text/xml or
some such.
cheers,
Chris
Hello Chris,
Not easily sorry.
Easy in SQL 2005 with a CLR function.
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> Hi, using sql server 2000, is there a way I can load data into a
> stored procedure using just a web address? The data will just be
> text/xml or some such.
> cheers,
> Chris
|||Simon Sabin wrote:[vbcol=seagreen]

> Not easily sorry.
> Easy in SQL 2005 with a CLR function.
>
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
Thanks Simon.. I'm currently figuring it out using ado in an activex
script... would probably do it quicker upgrading to 2005 :D
cheers,
Chris

Load balancing and report servers

At the moment a client has two web servers and two reporting servers. The
first web server always uses the first reporting server, and the second web
server the second reporting server. There is no shared state, and a given
user session always goes to the same web server. Report output is displayed
via a ReportViewer web control.
They'd like to move to true load balancing of the web servers, but don't
want to pay the extra for SQL Server Enterprise licenses that reporting
server farm require.
Looking at the HTTP traffic the ReportViewer sends request to the web server
to be handled by
/Reserved.ReportViewerWebControl.axd
...with some parameters, two of which...
?ReportSession=3dobaffxgmkaduj5rukvhxvy
&ControlID=841538b0792b4b27bf84e1da251a8d87
...look as though they would provide a key to some configuration information.
If we changed to shared state, and true load balancing (such that a request
could go to any web server), what would happen when the user chose to move to
the next page in a report or output a report to PDF?
Would the web server be able to find the correct session information and
forward the request to the reporting server that originally generated the
output?
Thanks,
DukeHello Duke,
According to the documents in BOL, we did not recommand customer to use
only one reporting services on the Load Balance Node.
I may consulting the internal member to check whether you could do this or
not. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Load balancing and clustering

When a web application becomes overloaded with traffic, one can offload it
by load balancing and clustering the front end web servers. What happens
when the back-end MSSQL database becomes overloaded? Does MYSQL offer load
balancing and clustering?"Shabam" <info@.pcconnect.net> wrote in message
news:U4ydnZzBnMTWcO_dRVn-tA@.adelphia.com...
> When a web application becomes overloaded with traffic, one can offload it
> by load balancing and clustering the front end web servers. What happens
> when the back-end MSSQL database becomes overloaded? Does MYSQL offer
load
> balancing and clustering?

I'm not sure if you're talking about MSSQL (Microsoft SQL Server) or MySQL.
In the case of MSSQL, clustering is supported for failover only, not for
load-balancing. If you need load-balancing, then it can be implemented in a
middle-tier.

Simon|||> I'm not sure if you're talking about MSSQL (Microsoft SQL Server) or
MySQL.
> In the case of MSSQL, clustering is supported for failover only, not for
> load-balancing. If you need load-balancing, then it can be implemented in
a
> middle-tier.

What do you mean middle tier?|||"Shabam" <info@.pcconnect.net> wrote in message news:<9oKdnTRxs9oRou7dRVn-uQ@.adelphia.com>...
> > I'm not sure if you're talking about MSSQL (Microsoft SQL Server) or
> MySQL.
> > In the case of MSSQL, clustering is supported for failover only, not for
> > load-balancing. If you need load-balancing, then it can be implemented in
> a
> > middle-tier.
> What do you mean middle tier?

I mean an application server, such as WebSphere, WebLogic, Microsoft
Transaction Server etc., which sits between the web server and the
database server. Clients connect to the application server, which
manages all the database connections, so you can use the application
server to spread database access across several physical databases.

Simonsql

load balancing

Hello,

How is load balancing working in SQL Server 2000. We want to have two different servers as a back end for our web based eCommerce application. Is this possible? While there be any modification requirement in the application?

As long as both servers are ODBC-DB or OLE-DB compatible you can do this using Enterprise Manager or T-SQL code. It happens on server side.

Linked servers are listed under the security node under each server in EM. (Left hand pane) Right click node and select 'New Linked Server'

|||

Both servers are SQL Server 2000. What I am trying to achieve is to have a backup for our SQL Server so that if one of them is down, the other is still alive and serving the application. Is this possible? If I have linked server, does that provide me what I need?

|||No. You are looking for clustering.|||

Yes Motley is right.

Clustering will give the impression of two or more servers acting as one and thus provide high-availabiltiy.

A SQL Server cluster however do not balance the SQL load and will not provide scalability.

load balancing

Hello,
How is load balancing working in SQL Server 2000. We want to have two
different servers as a back end for our web based eCommerce application. Is
this possible? While there be any modification requirement in the application?
There's no transparent load balancing in SQL Server. There are options to spread load over several
servers, each has advantages and disadvantages. Things you might want to read about in Books Online:
Distributed partitioned views (aka federated servers)
Replication
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:946586F9-803E-4248-AA8E-576A144A21FD@.microsoft.com...
> Hello,
> How is load balancing working in SQL Server 2000. We want to have two
> different servers as a back end for our web based eCommerce application. Is
> this possible? While there be any modification requirement in the application?
>

load balancing

Hello,
How is load balancing working in SQL Server 2000. We want to have two
different servers as a back end for our web based eCommerce application. Is
this possible? While there be any modification requirement in the application?There's no transparent load balancing in SQL Server. There are options to spread load over several
servers, each has advantages and disadvantages. Things you might want to read about in Books Online:
Distributed partitioned views (aka federated servers)
Replication
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:946586F9-803E-4248-AA8E-576A144A21FD@.microsoft.com...
> Hello,
> How is load balancing working in SQL Server 2000. We want to have two
> different servers as a back end for our web based eCommerce application. Is
> this possible? While there be any modification requirement in the application?
>

load balancing

Hello,
How is load balancing working in SQL Server 2000. We want to have two
different servers as a back end for our web based eCommerce application. Is
this possible? While there be any modification requirement in the applicatio
n?There's no transparent load balancing in SQL Server. There are options to sp
read load over several
servers, each has advantages and disadvantages. Things you might want to rea
d about in Books Online:
Distributed partitioned views (aka federated servers)
Replication
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:946586F9-803E-4248-AA8E-576A144A21FD@.microsoft.com...
> Hello,
> How is load balancing working in SQL Server 2000. We want to have two
> different servers as a back end for our web based eCommerce application. I
s
> this possible? While there be any modification requirement in the applicat
ion?
>sql

LiveStats.XSP Maintenance Daemon Problem

I am running Livestats.XSP 7.5 and have a problem where the maintenance daemon service continously runs at 50% CPU utilization, slowing my web server dramatically. I only have 15 web site logs being analyzed. The service never use to do this until recently. I have left the service running for weeks at a clip and it never ever drops below 50% CPU utilization. Does anyone have any idea how to correct this problem. Since support is virtually no exsistant for this product anymore, I may have to purchase another product that has support. Any help anyone could give would be much appreciated.

Dan

This really isn't the support forum for LiveStats - someone just posted here once and now the searches show this forum. But these are actually SQL Server forums.

Try the contact infomation links on DeepMetrix web site: http://www.deepmetrix.com/about_us/our_contact_info/

The Microsoft web analytics tool was rewritten since purchasing DeepMetrix and in beta as Project Gatineau and was going to release this year as Microsoft Analytics. But I'm pretty sure the SQL Server group won't end up being the group supporting this.

-Sue

Listbox that show a sql server field content

I would like 2 things:
First i would like to show in a listbox in my web page the content of a sql field.
Besides I would like depending on which value was selected in the first listbox that the second listbox show a definied content.
Thank U very muchHowdy

Try www.aspfree.com

Cheers

SG

List SSRS2005 items on treeview

Hi all,

I'm creating a Custom web interface for SQL Server reporting services 2005.

What I want to do is populate a "Navigation Treeview" component in asp.net 2. How would I get all the catalog items and items from the web API and populate my treeview?

Thanks

Hi Rudi,

You could use the SOAP API - ListChildren. Here is a link to defintion and code sample:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_ref_soapapi_service_lz_2yt2.asp

|||

Hi there Brad,

Thanks alot! I'm still having some trouble though...

I'm using this code to get the list:

Try

Dim P As New ReportingService

Dim RootList As CatalogItem = P.ListChildren("/", True)

LoadTree(RootList)

Catch ex As Exception

End Try

But this is returning the error:

\\Reportserver\NetReports\Admin\Default.aspx(1): Build (web): \\Reportserver\NetReports\MasterPage.master.vb(36): error BC30311: Value of type '1-dimensional array of ReportService.CatalogItem' cannot be converted to 'ReportService.CatalogItem'.

What am I doing wrong?

Thanks

|||

Don't worry, I got it....

I didn't add the () in

Dim RootList As CatalogItem() = rs.ListChildren("/", True)

Thanks

|||Any chance you could provide the code used for LoadTree? I'm stuck trying to figure out how to programmatically build the nodes from the CatalogItem.

Thanks,
Kel

List SSRS2005 items on treeview

Hi all,

I'm creating a Custom web interface for SQL Server reporting services 2005.

What I want to do is populate a "Navigation Treeview" component in asp.net 2. How would I get all the catalog items and items from the web API and populate my treeview?

Thanks

Hi Rudi,

You could use the SOAP API - ListChildren. Here is a link to defintion and code sample:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_ref_soapapi_service_lz_2yt2.asp

|||

Hi there Brad,

Thanks alot! I'm still having some trouble though...

I'm using this code to get the list:

Try

Dim P As New ReportingService

Dim RootList As CatalogItem = P.ListChildren("/", True)

LoadTree(RootList)

Catch ex As Exception

End Try

But this is returning the error:

\\Reportserver\NetReports\Admin\Default.aspx(1): Build (web): \\Reportserver\NetReports\MasterPage.master.vb(36): error BC30311: Value of type '1-dimensional array of ReportService.CatalogItem' cannot be converted to 'ReportService.CatalogItem'.

What am I doing wrong?

Thanks

|||

Don't worry, I got it....

I didn't add the () in

Dim RootList As CatalogItem() = rs.ListChildren("/", True)

Thanks

|||Any chance you could provide the code used for LoadTree? I'm stuck trying to figure out how to programmatically build the nodes from the CatalogItem.

Thanks,
Kel

List of what the server is running

I am working with the web service here, is there any way to get a list back
of all the current reports being ran? thanks!On Mar 2, 11:25 am, "Smokey Grindel" <nos...@.nospam.com> wrote:
> I am working with the web service here, is there any way to get a list back
> of all the current reports being ran? thanks!
I don't have the link but if you check the microsoft report packs I
beleive there are some reports for this...
Cheers,
Ben|||Take a look at the ReportService2005 Web service... There is a job class
that I think does what you wish.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Smokey Grindel" wrote:
> I am working with the web service here, is there any way to get a list back
> of all the current reports being ran? thanks!
>
>|||Just want to verify a "job" is not just a scheduled one but any report or
task that the report server is currently running correct? thanks!
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:DEF182B0-BEEE-4F7B-B597-580C91778982@.microsoft.com...
> Take a look at the ReportService2005 Web service... There is a job class
> that I think does what you wish.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Smokey Grindel" wrote:
>> I am working with the web service here, is there any way to get a list
>> back
>> of all the current reports being ran? thanks!
>>

List of SQL Server Proprietary Data Types?

Could someone point me to a list of SQL Server proprietary data types? Tried
searching this forum and the web but couldn't find a full published list.
Thanks.
NaveenTry,
select [name]
from master.dbo.systypes
go
AMB
"Naveen" wrote:

> Could someone point me to a list of SQL Server proprietary data types? Tri
ed
> searching this forum and the web but couldn't find a full published list.
> Thanks.
> Naveen|||That seems to be a list of all data types in SQL Server. I should have been
more clear. I meant non-ANSI compliant datatypes in SQL Server.
"Alejandro Mesa" wrote:
> Try,
> select [name]
> from master.dbo.systypes
> go
>
> AMB
> "Naveen" wrote:
>|||So, get a list of ANSI data types, and say:
SELECT [name] FROM master.dbo.systypes
WHERE [name] NOT IN ('type1', 'type2', etc)
Obviously, SQL Server doesn't have a flag called ANSI_COMPLIANT...
A
"Naveen" <Naveen@.discussions.microsoft.com> wrote in message
news:67059C80-35BA-4251-AB3F-0E442E582F2A@.microsoft.com...
> That seems to be a list of all data types in SQL Server. I should have
> been
> more clear. I meant non-ANSI compliant datatypes in SQL Server.
> "Alejandro Mesa" wrote:
>|||Some info here:
http://www.karaszi.com/SQLServer/in...i_datatypes.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Naveen" <Naveen@.discussions.microsoft.com> wrote in message
news:498D2709-8186-4F4D-88E1-9B5CAACA3D65@.microsoft.com...
> Could someone point me to a list of SQL Server proprietary data types? Tri
ed
> searching this forum and the web but couldn't find a full published list.
> Thanks.
> Naveen

Liscensing question

If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
accesses a database on the SQL Server does that user take a liscense for the
whole web session or only for the time that it takes the web server to query
the database and retrieve information? Basically I am trying to decide how
many and what type of licenses to buy for SQL 2005."Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.
If it is a publicly accessible website, you need a CPU license (for each
physical CPU in the machine.)
However, to really be accurate, you need to contact a Microsoft Licensing
person directly.
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||"Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.
Neither. There is no license for "concurrent users". Each user must have a
dedicated CAL. Alternatively, you can assign the CAL to the user's device,
and multiple users can share the device.
How to Buy Microsoft SQL Server
http://www.microsoft.com/sql/howtobuy/default.mspx
David|||If your SQL-Server can be accessed from a web site, you need a CPU license
for it. The SQL-Server with a CPU license cost more than a license for
SQL-Server with 25 user CALs but with it, you don't need any CAL anymore to
access it (not only from the web site but also from any other user or
device).
In this case (at least one access from a web site), the use of a CPU license
is mandatory; so you don't have any choice here.
Finally, if you want an official answer from MS (because the cost of
SQL-Server with a CPU license is high), you can call 1-800-426-9400 in the
US or your regional Microsoft office in other countries.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.|||This requirement for per CPU applies only if the web server is a publicly
available internet web server. If the web server is an intranet web server
and you can verify that no unlicensed PC's/Users connect to the web server
and can assign CAL's to those PC's and/or users you should be able to use
the per server/CAL model of licensing.
As has been pointed out elsewhere CAL's are assigned to particular users or
PC's/devices. They are usually only transferable once. After that, you have
to buy a new one.
As has been said in multiple places, this is something you don't want to
take the advice of the newsgroup on. It is legal and "the newsgroup said" is
not going to be a valid excuse should you get audited. Read the license
agreements, find a good reseller that can answer your licensing questions,
and call MS if in doubt.
Thanks,
Chuck
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:OIZlu$dWHHA.528@.TK2MSFTNGP03.phx.gbl...
> If your SQL-Server can be accessed from a web site, you need a CPU license
> for it. The SQL-Server with a CPU license cost more than a license for
> SQL-Server with 25 user CALs but with it, you don't need any CAL anymore
> to access it (not only from the web site but also from any other user or
> device).
> In this case (at least one access from a web site), the use of a CPU
> license is mandatory; so you don't have any choice here.
> Finally, if you want an official answer from MS (because the cost of
> SQL-Server with a CPU license is high), you can call 1-800-426-9400 in the
> US or your regional Microsoft office in other countries.
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
> "Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
> news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
>> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page
>> that
>> accesses a database on the SQL Server does that user take a liscense for
>> the
>> whole web session or only for the time that it takes the web server to
>> query
>> the database and retrieve information? Basically I am trying to decide
>> how
>> many and what type of licenses to buy for SQL 2005.
>

Liscensing question

If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
accesses a database on the SQL Server does that user take a liscense for the
whole web session or only for the time that it takes the web server to query
the database and retrieve information? Basically I am trying to decide how
many and what type of licenses to buy for SQL 2005.
"Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.
If it is a publicly accessible website, you need a CPU license (for each
physical CPU in the machine.)
However, to really be accurate, you need to contact a Microsoft Licensing
person directly.
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
|||"Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.
Neither. There is no license for "concurrent users". Each user must have a
dedicated CAL. Alternatively, you can assign the CAL to the user's device,
and multiple users can share the device.
How to Buy Microsoft SQL Server
http://www.microsoft.com/sql/howtobuy/default.mspx
David
|||If your SQL-Server can be accessed from a web site, you need a CPU license
for it. The SQL-Server with a CPU license cost more than a license for
SQL-Server with 25 user CALs but with it, you don't need any CAL anymore to
access it (not only from the web site but also from any other user or
device).
In this case (at least one access from a web site), the use of a CPU license
is mandatory; so you don't have any choice here.
Finally, if you want an official answer from MS (because the cost of
SQL-Server with a CPU license is high), you can call 1-800-426-9400 in the
US or your regional Microsoft office in other countries.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.
|||This requirement for per CPU applies only if the web server is a publicly
available internet web server. If the web server is an intranet web server
and you can verify that no unlicensed PC's/Users connect to the web server
and can assign CAL's to those PC's and/or users you should be able to use
the per server/CAL model of licensing.
As has been pointed out elsewhere CAL's are assigned to particular users or
PC's/devices. They are usually only transferable once. After that, you have
to buy a new one.
As has been said in multiple places, this is something you don't want to
take the advice of the newsgroup on. It is legal and "the newsgroup said" is
not going to be a valid excuse should you get audited. Read the license
agreements, find a good reseller that can answer your licensing questions,
and call MS if in doubt.
Thanks,
Chuck
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:OIZlu$dWHHA.528@.TK2MSFTNGP03.phx.gbl...
> If your SQL-Server can be accessed from a web site, you need a CPU license
> for it. The SQL-Server with a CPU license cost more than a license for
> SQL-Server with 25 user CALs but with it, you don't need any CAL anymore
> to access it (not only from the web site but also from any other user or
> device).
> In this case (at least one access from a web site), the use of a CPU
> license is mandatory; so you don't have any choice here.
> Finally, if you want an official answer from MS (because the cost of
> SQL-Server with a CPU license is high), you can call 1-800-426-9400 in the
> US or your regional Microsoft office in other countries.
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
> "Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
> news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
>

Liscensing question

If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
accesses a database on the SQL Server does that user take a liscense for the
whole web session or only for the time that it takes the web server to query
the database and retrieve information? Basically I am trying to decide how
many and what type of licenses to buy for SQL 2005."Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.
If it is a publicly accessible website, you need a CPU license (for each
physical CPU in the machine.)
However, to really be accurate, you need to contact a Microsoft Licensing
person directly.
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||"Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.
Neither. There is no license for "concurrent users". Each user must have a
dedicated CAL. Alternatively, you can assign the CAL to the user's device,
and multiple users can share the device.
How to Buy Microsoft SQL Server
http://www.microsoft.com/sql/howtobuy/default.mspx
David|||If your SQL-Server can be accessed from a web site, you need a CPU license
for it. The SQL-Server with a CPU license cost more than a license for
SQL-Server with 25 user CALs but with it, you don't need any CAL anymore to
access it (not only from the web site but also from any other user or
device).
In this case (at least one access from a web site), the use of a CPU license
is mandatory; so you don't have any choice here.
Finally, if you want an official answer from MS (because the cost of
SQL-Server with a CPU license is high), you can call 1-800-426-9400 in the
US or your regional Microsoft office in other countries.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.|||This requirement for per CPU applies only if the web server is a publicly
available internet web server. If the web server is an intranet web server
and you can verify that no unlicensed PC's/Users connect to the web server
and can assign CAL's to those PC's and/or users you should be able to use
the per server/CAL model of licensing.
As has been pointed out elsewhere CAL's are assigned to particular users or
PC's/devices. They are usually only transferable once. After that, you have
to buy a new one.
As has been said in multiple places, this is something you don't want to
take the advice of the newsgroup on. It is legal and "the newsgroup said" is
not going to be a valid excuse should you get audited. Read the license
agreements, find a good reseller that can answer your licensing questions,
and call MS if in doubt.
Thanks,
Chuck
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:OIZlu$dWHHA.528@.TK2MSFTNGP03.phx.gbl...
> If your SQL-Server can be accessed from a web site, you need a CPU license
> for it. The SQL-Server with a CPU license cost more than a license for
> SQL-Server with 25 user CALs but with it, you don't need any CAL anymore
> to access it (not only from the web site but also from any other user or
> device).
> In this case (at least one access from a web site), the use of a CPU
> license is mandatory; so you don't have any choice here.
> Finally, if you want an official answer from MS (because the cost of
> SQL-Server with a CPU license is high), you can call 1-800-426-9400 in the
> US or your regional Microsoft office in other countries.
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
> "Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
> news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
>