Thursday, March 8, 2012
Another licensing question...
Here is a brief intro about our application.
1) The client is a Borland C++ application acting as the front
end.
2) The client sends requests to our web server (IIS) over HTTPS.
3) The web server invokes a windows service.
4) The windows service calls a COM+ component.
5) The COM+ component accesses a SQL Server 2000 EE (Cluster). We
have 4 processor licenses.
6) There are few other applications, which run on another server,
accessing the SQL server also.
7) The COM+ component forwards client requests (after some
processing) to these applications.
8) These applications send the requests to external parties,
usually over one/two (not more) TCP connections.
9) The external parties send the responses to our requests
10) The responses from the external parties are routed back to the
clients thru the COM+ component.
When the client is started on the end user's desktop, it throws up
a logon screen where the user enters his user ID and password. This is
the first request from the client to the web server. If the
authentication (the user IDs and paasswords are stored in the SQL
server) is successful, he can send more requests (order entry
application). We have about 20 users right now who access the system
this way.
The client software is available for free download, but the user
ID/password is handed over only to a very restricted set of people. We
charge certain $$ per user per month.
We are duplicating this environment in another data center.
Now my question is since we have only about 20 users accessing the
SQL server, is it enough to get 1 server license and 20 CALs? There
may be other users, who might connect but fail to authenticate, though
that is a very very rare case. Even though they are invalid users, do
they make a genuine case for going for processor licenses?
Thanks & regards
zrb
I suggest you consult a Microsoft representative about this. What you
have described *may* constitute hosting. The standard retail licence
has a "no commercial hosting" clause so you may need to purchase a
service provider licence.
I say "may" because I have no real idea what Microsoft classes as
commercial hosting. In any case an authorised rep should be able to
give you a definitive answer.
David Portas
SQL Server MVP
|||Thanks. I am thoroughly confused now. :-) I'll contact a MS rep on
this.
David Portas wrote:
> I suggest you consult a Microsoft representative about this. What you
> have described *may* constitute hosting. The standard retail licence
> has a "no commercial hosting" clause so you may need to purchase a
> service provider licence.
> I say "may" because I have no real idea what Microsoft classes as
> commercial hosting. In any case an authorised rep should be able to
> give you a definitive answer.
> --
> David Portas
> SQL Server MVP
> --
|||Also, if I have 4 processor licenses (we paid $80,000 for them), but
have 2 Dual Processor servers, does this entitle me to install SQL
server on the two servers? In the same vein, can I go for 4 single
processor servers? :-)
|||Yes. A processor licence is just that - per processor. You just need a
licence for each processor in each server.
David Portas
SQL Server MVP
Another licensing question...
Here is a brief intro about our application.
1) The client is a Borland C++ application acting as the front
end.
2) The client sends requests to our web server (IIS) over HTTPS.
3) The web server invokes a windows service.
4) The windows service calls a COM+ component.
5) The COM+ component accesses a SQL Server 2000 EE (Cluster). We
have 4 processor licenses.
6) There are few other applications, which run on another server,
accessing the SQL server also.
7) The COM+ component forwards client requests (after some
processing) to these applications.
8) These applications send the requests to external parties,
usually over one/two (not more) TCP connections.
9) The external parties send the responses to our requests
10) The responses from the external parties are routed back to the
clients thru the COM+ component.
When the client is started on the end user's desktop, it throws up
a logon screen where the user enters his user ID and password. This is
the first request from the client to the web server. If the
authentication (the user IDs and paasswords are stored in the SQL
server) is successful, he can send more requests (order entry
application). We have about 20 users right now who access the system
this way.
The client software is available for free download, but the user
ID/password is handed over only to a very restricted set of people. We
charge certain $$ per user per month.
We are duplicating this environment in another data center.
Now my question is since we have only about 20 users accessing the
SQL server, is it enough to get 1 server license and 20 CALs? There
may be other users, who might connect but fail to authenticate, though
that is a very very rare case. Even though they are invalid users, do
they make a genuine case for going for processor licenses?
Thanks & regards
zrbI suggest you consult a Microsoft representative about this. What you
have described *may* constitute hosting. The standard retail licence
has a "no commercial hosting" clause so you may need to purchase a
service provider licence.
I say "may" because I have no real idea what Microsoft classes as
commercial hosting. In any case an authorised rep should be able to
give you a definitive answer.
David Portas
SQL Server MVP
--|||Thanks. I am thoroughly confused now. :-) I'll contact a MS rep on
this.
David Portas wrote:
> I suggest you consult a Microsoft representative about this. What you
> have described *may* constitute hosting. The standard retail licence
> has a "no commercial hosting" clause so you may need to purchase a
> service provider licence.
> I say "may" because I have no real idea what Microsoft classes as
> commercial hosting. In any case an authorised rep should be able to
> give you a definitive answer.
> --
> David Portas
> SQL Server MVP
> --|||Also, if I have 4 processor licenses (we paid $80,000 for them), but
have 2 Dual Processor servers, does this entitle me to install SQL
server on the two servers? In the same vein, can I go for 4 single
processor servers? :-)|||Yes. A processor licence is just that - per processor. You just need a
licence for each processor in each server.
David Portas
SQL Server MVP
--
Sunday, February 12, 2012
Analysis Services end-user frontend
Hi,
I've developped a simple testing SQL Server 2005 Analysis Services solution.
I tried with Excel 2003 and pivot tables for accessing the cubes, because end users are very used to that enviroment.
The problem is that selection of dimensions and measures is dificult because there are too many, and not arranged into folders. All attributes of all the dimensions and all the measures are displayed in a -plain- format (as far as I know). That's very frustrating, because is difficult for the user to select the correct dimensions, attributes, and measures.
I tried with XLAddinSetup.msi, but I didn't like it, because I think that isn't so powerful and easy to use than pivot tables.
What can I do?
Do you recommend to use another frontend, not Excel?
Many thanks.
This is a very difficult time to recommend a front-end to Analysis Services given Microsoft's recent acquisition of Proclarity:
http://www.microsoft.com/presspass/press/2006/apr06/04-03ProClarityPR.mspx
There are a lot of good tools on the market, but no-one knows how many will be around this time next year! Obviously Proclarity will be in some shape or form, though it might make sense to wait and see what Microsoft's plans are for it. It's probably a good idea to contact your local Proclarity office and ask them what is going to happen in the short-term; if there's someone from Proclarity reading this, perhaps they can make a public statement here?
Chris
|||Chris Webb wrote:
This is a very difficult time to recommend a front-end to Analysis Services given Microsoft's recent acquisition of Proclarity:
http://www.microsoft.com/presspass/press/2006/apr06/04-03ProClarityPR.mspx
There are a lot of good tools on the market, but no-one knows how many will be around this time next year! Obviously Proclarity will be in some shape or form, though it might make sense to wait and see what Microsoft's plans are for it. It's probably a good idea to contact your local Proclarity office and ask them what is going to happen in the short-term; if there's someone from Proclarity reading this, perhaps they can make a public statement here?
Chris
Ok, I think I can wait.
On the other hand, I still think that Excel is enough for the moment, but my problem is, as I said before, that accessing to dimensions and measures of OLAP cubes is messy, because the list isn't hierarchy organized in folders.
Does anybody know how to do that?
|||I don't think you will be able to do this with any current version of Excel, although Excel 2007 will be able to do it.
Chris
|||As Chris mentions ProClarity might be a good bet for you. However, I can also recommend the Danish front-end TARGIT, which has some very compelling and user-friendly features. You can download a 30-day demo version from http://www.targit.com/Products/Demo_and_Videos/Download_30_days_trial_demo.aspx
TARGIT is able to handle the meta data from AS 2005 and present this in a nice manner.
|||I also recommend that you look into the upcoming Office 2007 release. Excel has many enhancements specifically targetted at AS 2005.
http://www.microsoft.com/presspass/press/2005/oct05/10-23BiLaunchPR.mspx
|||If you can't wait for Excel 2007 there are some 3rd party add-ins for Excel currently available:
XLCubed
BIXL
O2OLAP
If you want to move away from Excel and don't like ProClarity look at ExecutiveViewer from www.temtec.com. Have you tried Reporting Services with SSAS? Microsoft is pushing this very hard (but it is more a developer tool than an end-user solution).
Dr Cube