Microsoft SQL Server client license costs

I have three questions: Could anyone help.
1. How much does a Microsoft SQL Server client license cost?
2. If we have web interface as the front end and SQL server as the back end,
do we need client licenses for those accessing their databases via the web?
3. Also if we have people accessing the server with Access,do we need
licenses for those?
"bgm" <bgm@.discussions.microsoft.com> wrote in message
news:17913AFE-A04D-47B3-96A7-C4216A68E6D8@.microsoft.com...
> I have three questions: Could anyone help.
> 1. How much does a Microsoft SQL Server client license cost?
http://www.microsoft.com/sql/howtobuy/default.asp

> 2. If we have web interface as the front end and SQL server as the back
end,
> do we need client licenses for those accessing their databases via the
web?
It's better to buy a per-processor licence because you do not know the
number of users (or you have developed a database access componenet and you
need to limit the number of concurrent users).

> 3. Also if we have people accessing the server with Access,do we need
> licenses for those?
It's an extra connection.
|||>> 2. If we have web interface as the front end and SQL server as the back
> end,
> web?
> It's better to buy a per-processor licence because you do not know the
> number of users (or you have developed a database access componenet and
> you
> need to limit the number of concurrent users).
the only option is per processor license! You can't use per user connection
license.

Microsoft SQL Server client license costs

I have three questions here:Could anyone help.
1.How much does a Microsoft SQL Server client license cost?
2.If we have web interface as the front end and SQL server as the back
end,do we need client licenses for those accessing the databases via the web?
3.If we have people accessing the server with Access,do we need licenses for
those?
Hi,
You can check the following whitepaper and article for information on SQL
Server licensing and prices
http://www.microsoft.com/sql/howtobu...licensing.asp.
http://www.microsoft.com/sql/howtobuy/faq.asp
You can also call (800) 426-9400 to clarify your doubts on the licensing.
Regards,
Gayathri Rau [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
sql

Microsoft DevDays 2004 - Smart Client 3 - Security session

Hi there,
Have you guys watched the Smart Client 3: Developing Secure Smart Client
Applications by a presenter called Jeff Levinson
(http://msdn.microsoft.com/events/devdays/sessions/).
I have got a really really quick question regarding the security hole he
found on the demo...
(you need to have watched it to understand the following)
He said he decrypted his credential on the database server and upload his
database connection string in clear text' And then he can patcket sniff all
the traffic in between teh application server and the database server...
(Sorry, I may have heard it incorrectly as I was watching the webcast on the
net and English is not my mother tongue.)
Can someone explain to me a little more on what exactly did he mean.
Thanks heaps!!I have not watched this particular event but I have taught it. He is
probably talking about using IPSEC between the app server and database
server. This insures that you cannot use a packet sniffer to see the
unencrypted data on the network.
"one" <one@.discussions.microsoft.com> wrote in message
news:8E074D9C-184B-42BA-BFD8-FF33B3C1A659@.microsoft.com...
> Hi there,
> Have you guys watched the Smart Client 3: Developing Secure Smart Client
> Applications by a presenter called Jeff Levinson
> (http://msdn.microsoft.com/events/devdays/sessions/).
> I have got a really really quick question regarding the security hole he
> found on the demo...
> (you need to have watched it to understand the following)
> He said he decrypted his credential on the database server and upload his
> database connection string in clear text' And then he can patcket sniff
all
> the traffic in between teh application server and the database server...
> (Sorry, I may have heard it incorrectly as I was watching the webcast on
the
> net and English is not my mother tongue.)
> Can someone explain to me a little more on what exactly did he mean.
> Thanks heaps!!|||Thanks Chris. You are right. After reading your post, I went back and
listening to the webcast again and I found the transcript. And here is what
he said:
<snip>... There's one small problem, and that problem exists right here.
See I've gone and decrypted my database credentials, and then I've sent my
connection string to the database in plain text. Oops! With all this
security- all I need to do is drop a listener or somewhere on the network to
listen in between those two machines, and I'm going to pull back every piece
of data that you've put across the network we've gone through all this
trouble to secure... </snip>
And to resolve this issue, he suggested using IPSec.
Thanks again Chris.
"Chris Rolon" wrote:

> I have not watched this particular event but I have taught it. He is
> probably talking about using IPSEC between the app server and database
> server. This insures that you cannot use a packet sniffer to see the
> unencrypted data on the network.
>
> "one" <one@.discussions.microsoft.com> wrote in message
> news:8E074D9C-184B-42BA-BFD8-FF33B3C1A659@.microsoft.com...
> all
> the
>
>sql

Microsoft Client Utilities

Is there a separate installation or download that can be used to install the
Microsoft SQL Client Utilities on a machine to provide the ability for a
client application to communicate with the Microsoft SQL Server Database. I
know the Tools and Utilities are included on the SQL Server CD but we need
to give the utilities to our customer so that they can access our SQL Server
database (i.e. they do not own Microsoft SQL).
Regards,
Randall
Randall,
If all they need is connectivity, one option is the sqlredis
executable. It's on your SQL CD. There is more info on it in
books online but basically it's just an exe you can give to
the customers that will install the client connectivity
components.
-Sue
On Thu, 25 Mar 2004 15:24:02 -0800, "Microsoft Newsreader"
<newsreader@.ivr.com> wrote:

>Is there a separate installation or download that can be used to install the
>Microsoft SQL Client Utilities on a machine to provide the ability for a
>client application to communicate with the Microsoft SQL Server Database. I
>know the Tools and Utilities are included on the SQL Server CD but we need
>to give the utilities to our customer so that they can access our SQL Server
>database (i.e. they do not own Microsoft SQL).
>Regards,
>Randall
>
|||Thank you very much for the information and the prompt response.
Regards,
Randall
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:rns660ljcpppteh9hponhc5ha0khgv3v44@.4ax.com...
> Randall,
> If all they need is connectivity, one option is the sqlredis
> executable. It's on your SQL CD. There is more info on it in
> books online but basically it's just an exe you can give to
> the customers that will install the client connectivity
> components.
> -Sue
> On Thu, 25 Mar 2004 15:24:02 -0800, "Microsoft Newsreader"
> <newsreader@.ivr.com> wrote:
the
I
need
Server
>

Metadata Inheritance

Hello,
I have written a mechanism which returns meta data back to a client for
different views. For example, one meta data item on a column is the Display
Name.
Now, so I don't have to keep attaching meta data to a particular column
every time I create a new view, I "inherit" the meta data from a parent view
or table by looking at all the same named columns in any views or tables
that the table depends (sysdepends) on.
The problem is, sometimes it make sense to change the name of a column in a
view from the underlying table (e.g. company table has a "name" column, but
in the view, you want to call it "company_name").
My question is, is there an easy way to determine where a view's column
really came from?
Thanks,
-PaulNever mind, I forgot to look at the depnumber column in sysdepends!
"Paul" <a@.b.com> wrote in message
news:eWN9knVCFHA.3940@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I have written a mechanism which returns meta data back to a client for
> different views. For example, one meta data item on a column is the
> Display Name.
> Now, so I don't have to keep attaching meta data to a particular column
> every time I create a new view, I "inherit" the meta data from a parent
> view or table by looking at all the same named columns in any views or
> tables that the table depends (sysdepends) on.
> The problem is, sometimes it make sense to change the name of a column in
> a view from the underlying table (e.g. company table has a "name" column,
> but in the view, you want to call it "company_name").
> My question is, is there an easy way to determine where a view's column
> really came from?
> Thanks,
> -Paul
>|||Okay, now the hard question.
How do I correlate a column in the sysdepends table back to a column in the
resulting view's columns?
Thanks,
-Paul
"Paul" <a@.b.com> wrote in message
news:OBXyfyVCFHA.1836@.tk2msftngp13.phx.gbl...
> Never mind, I forgot to look at the depnumber column in sysdepends!
>
> "Paul" <a@.b.com> wrote in message
> news:eWN9knVCFHA.3940@.TK2MSFTNGP09.phx.gbl...
>|||On Wed, 2 Feb 2005 15:27:44 -0500, Paul wrote:

>Okay, now the hard question.
>How do I correlate a column in the sysdepends table back to a column in the
>resulting view's columns?
Hi Paul,
You don't.
You are probably thinking right now of fairly straight-forward views,
where such a mapping would be viable. But views can be fairly complex!
CREATE VIEW test
AS SELECT Col1 - Col2 AS A,
Col1 + Col2 AS B,
CASE WHEN EXISTS (SELECT *
FROM YZ
WHERE Foo = SomeTable.Bar)
THEN 1
ELSE 2
END AS C,
'Constant value' AS D,
Col3 + 1 AS E,
Col3 - 1 AS F
FROM SomeTable
How should each of the view's columns be correlated to each of the
underlying table's columns? And remember that this is also a fairly simple
example - I could come up with much more contrived views (some of my real
views for projects I do are much more contrived!)
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

Messge to specified Client

I know that SQL has many ways to send message to Current Connection, but I wonder is there any way to Send Message to an Other, specified Connection.

Let suppose ther is an application that makes an inserts in a table (for example cash transfers) and I need a tool to pring all new row via other application that should receive a message that a new row is added (fired by trigger, for example) but problem is that entry and printing applications arenn't same applications and they have separate connections to the SQLI'm not certain that this is what you are looking for, but you might be able to use xp_cmdshell to NET SEND a message to the users machine name. That raises some security issues since to invoke xp_cmdshell you need sysadmin role (or you need to config the sql agent proxy account, which in itself can be problematic).

Aren't there some other options? Perhaps having the process that invokes the print job write a record to a table (with the necessary user info) and then reading that info from the process that actually prints the job?

Dunno, I think we'd need to see a bit more info about what you are trying to do to help you...

Regards,

hmscott|||xp_cmdshell is the way that I've thought about, but problem is that by design the printing app should be runing on client's computer and don't shared via network, also I don't want to run exe app each time a row is added, it may slow down the server. better way is to have a bit field in the supposed table , that is reset by dedault and design printing app to check unset rows by timer , print them and set to 1.
But this isn't the best way out too for me, If i could make SQL to send messages to other connection, I wouldn't have needed to check flag fileds to print them time by time.|||Sorry; outside of xp_cmdshell, I'm not certain of other alternatives. I'm not sure I see what's wrong with setting a flag in the table to be checked by the printing process; it should not be a huge performance hit and if properly indexed and used with an SP, it should execute pretty cleanly.

Regards,

hmscott|||seems flagging is the only way (maybe not bad) for me
thanks anyway.

Message Type and Message Body..............

Hello,

I am having trouble specifying a message body that is valid. I mean for the client to send. If I leave it as null then everything is ok but if I create a memorystream and add a line of text it reports back it did not pass validation. I do not understand this and am not sure what to do. I need to send a message based on a code and text but do not know the format of the body that is allowed. The code I am refering to comes out of HelloWord_CLR because that is what I am formating my sample after. I call it the same way it calls the return message done in ServiceProc. I need to know the message format including body since this does not seem to work. A sample of the call is bellow.

// Create an empty request message

string Msg = "Hello";

MemoryStream body = new MemoryStream(Encoding.ASCII.GetBytes(Msg));

Message request = new Message("Request", body);

Thanks,

Scott Allison...

You set the validation of your Request message to be 'Empty'. Hence Service Broker is making sure that you do not attempt to send a message with a non-empty body. If you want to sent arbitrary bytes, set validation to 'None'. If you want to send XML and have it validated set it to 'Well_Formed_XML' or 'XML with schema validation'.