Install Question

Hello, if my company owns 6 processor licenses for Sql Server, am I able to
utilize Reporting Services or is their a separate license?Whether you need another license depends if you are installing RS on a box
that has SQL Server DB installed on it. You need a license for the box which
has RS installed. For instance, let's say I have a web farm with 3 IIS
servers all of which are using a single DB on another box. I need an
additional 3 SQL Server server licenses.
On the other hand, if I have IIS and RS running on the same box as SQL
Server DB, then RS falls under the license for the DB.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tcs" <tcs@.discussions.microsoft.com> wrote in message
news:D677E056-F2A3-4373-812B-38480F0B0F39@.microsoft.com...
> Hello, if my company owns 6 processor licenses for Sql Server, am I able
> to
> utilize Reporting Services or is their a separate license?|||Right, so if I split out RS onto a different box, I am ok as long as I have a
license to cover it. So right now if we have 6 enterprise licenses, i could
farm it out over two boxes if desired?
"Bruce L-C [MVP]" wrote:
> Whether you need another license depends if you are installing RS on a box
> that has SQL Server DB installed on it. You need a license for the box which
> has RS installed. For instance, let's say I have a web farm with 3 IIS
> servers all of which are using a single DB on another box. I need an
> additional 3 SQL Server server licenses.
> On the other hand, if I have IIS and RS running on the same box as SQL
> Server DB, then RS falls under the license for the DB.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "tcs" <tcs@.discussions.microsoft.com> wrote in message
> news:D677E056-F2A3-4373-812B-38480F0B0F39@.microsoft.com...
> > Hello, if my company owns 6 processor licenses for Sql Server, am I able
> > to
> > utilize Reporting Services or is their a separate license?
>
>|||Definitely. What are you are talking about is a web farm. Several IIS
servers all using the same database for its object caching and metadata
storage. This is an enterprise feature. You need to have a SQL Server
Enterprise license for each IIS box that is running Reporting Services.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tcs" <tcs@.discussions.microsoft.com> wrote in message
news:DFA03ABE-38AE-4CD3-B681-7535DF67A8DB@.microsoft.com...
> Right, so if I split out RS onto a different box, I am ok as long as I
> have a
> license to cover it. So right now if we have 6 enterprise licenses, i
> could
> farm it out over two boxes if desired?
>
> "Bruce L-C [MVP]" wrote:
>> Whether you need another license depends if you are installing RS on a
>> box
>> that has SQL Server DB installed on it. You need a license for the box
>> which
>> has RS installed. For instance, let's say I have a web farm with 3 IIS
>> servers all of which are using a single DB on another box. I need an
>> additional 3 SQL Server server licenses.
>> On the other hand, if I have IIS and RS running on the same box as SQL
>> Server DB, then RS falls under the license for the DB.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "tcs" <tcs@.discussions.microsoft.com> wrote in message
>> news:D677E056-F2A3-4373-812B-38480F0B0F39@.microsoft.com...
>> > Hello, if my company owns 6 processor licenses for Sql Server, am I
>> > able
>> > to
>> > utilize Reporting Services or is their a separate license?
>>sql

Installation

Our company is thinking of installing the BizTalk demo but they are already
setting this up to fail. Here is my question: can you install the BizTalk,
IIS and SQL Server all on one box? I had read someplace that you run into p
ermission problems if you d
o this.Here's some kb articles that may address your concern.
834390 Supportability of BizTalk Server on computers that are running SQL
Server
http://support.microsoft.com/?id=834390
838166 You must install the SQL Server 2000 update that KB article 831950
http://support.microsoft.com/?id=838166
829325 PRB: BizTalk Server 2002 SP1 Cannot Update the BizTalk Databases
http://support.microsoft.com/?id=829325
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Inserts failed sometimes ...

We have installed a package developed by another company and sometimes
(when the server is with a big rate of transactions), we are seeing
the following messages in package debug file:

2004-04-22 14:23:27 3056:
------------------

2004-04-22 14:23:27 3056: rlm03000: ls_PutOneRecord: Failed inserting
[04113SO07236054]
2004-04-22 14:23:27 3056: ODBCSetCursorName[3056]: Failed specifying
cursor concurrency to statement handle 1 for 'ls_rep_add'

2004-04-22 14:23:27 3056: dbc01003: ODBCSetCursorName[3056]:
ls_rep_add generated SQL error state: 24000
2004-04-22 14:23:27 3056: dbc01002: [Microsoft][ODBC Driver Manager]
Invalid cursor state
2004-04-22 14:23:27 3056: odbcFilterConnectErrors[3056]: set the
iState to ODBC_DISCONNECT for <24000>
2004-04-22 14:23:27 3056: Function Return Code [00001] ODBC_ERROR

2004-04-22 14:23:27 3056: Operation [00000] ls_PutOneRecord

2004-04-22 14:23:27 3056: Primary Return Code [00000] 00000

2004-04-22 14:23:27 3056: Secondary Return Code [0000000001] 00000

2004-04-22 14:23:27 3056:
------------------

When this message appears in the app debug file we are loosing some
inserts that the application do in the database.

The MS SQL server configuration is:
4 Pentium 760Mhz 4 GB RAM

SQL 2000 Standard Edition 8.00.760 SP 4
MDAC 2.7 driver ODBC SQLSRV32.dll 2000.81.9031.14 15/11/2002

Any tip will be welcome,

Thanks in advance,
ReisRobson Reis (reisrf@.yahoo.com) writes:
> We have installed a package developed by another company and sometimes
> (when the server is with a big rate of transactions), we are seeing
> the following messages in package debug file:

I'm afraid that this is not an issue that is easy resolved over a
newsgroup. The best would of course be to open a support case with
that vendor. If you don't have a support contract or that vendor
has gone bust, you may have to find some who can reverse-engineer
the package, or who can dig up the source code.

Judging from the log and your mentioning of heavy stress, I would
guess that there is poor error handling in conjunction with deadlocks.

A poor workaround could be to run this package against an idle
environment, and then replicate from that environment in your live
environment.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"Robson Reis" <reisrf@.yahoo.com> wrote in message
news:33bf8ee4.0405061045.7cab35af@.posting.google.c om...
> We have installed a package developed by another company and sometimes
> (when the server is with a big rate of transactions), we are seeing
> the following messages in package debug file:
>
> 2004-04-22 14:23:27 3056:
> ------------------
> 2004-04-22 14:23:27 3056: rlm03000: ls_PutOneRecord: Failed inserting
> [04113SO07236054]
> 2004-04-22 14:23:27 3056: ODBCSetCursorName[3056]: Failed specifying
> cursor concurrency to statement handle 1 for 'ls_rep_add'
> 2004-04-22 14:23:27 3056: dbc01003: ODBCSetCursorName[3056]:
> ls_rep_add generated SQL error state: 24000
> 2004-04-22 14:23:27 3056: dbc01002: [Microsoft][ODBC Driver Manager]
> Invalid cursor state
> 2004-04-22 14:23:27 3056: odbcFilterConnectErrors[3056]: set the
> iState to ODBC_DISCONNECT for <24000>
> 2004-04-22 14:23:27 3056: Function Return Code [00001] ODBC_ERROR
> 2004-04-22 14:23:27 3056: Operation [00000] ls_PutOneRecord
> 2004-04-22 14:23:27 3056: Primary Return Code [00000] 00000
> 2004-04-22 14:23:27 3056: Secondary Return Code [0000000001] 00000
> 2004-04-22 14:23:27 3056:
> ------------------
> When this message appears in the app debug file we are loosing some
> inserts that the application do in the database.
> The MS SQL server configuration is:
> 4 Pentium 760Mhz 4 GB RAM
> SQL 2000 Standard Edition 8.00.760 SP 4
> MDAC 2.7 driver ODBC SQLSRV32.dll 2000.81.9031.14 15/11/2002
>
> Any tip will be welcome,
> Thanks in advance,
> Reis

As I understand it, the error messages you've listed come from your
application log, not from SQL Server, so the first place to go for support
should be the application vendor.

You might get more information in microsoft.public.sqlserver.odbc or
..jdbcdriver, but without more knowledge of what the application is, what the
code looks like, and what the app is doing when this error occurs, it's
almost impossible to give more help.

Simon