MSSQL 2000 Standard Edition not utilizing Maximum Memory!

Hi All
Can anybody tell me why Memory is not utilized by MSSQL Service. The Environment as follows..
It is an Critical Web based Application with SQL 2000 Standard Edition + SP3 as backend
OS: Win 2000 Advanced Server + 3GB Memory + 2 CP
MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2 GB". This Server has Replication
Configuration also. During peak time or non-peak time, it always use 1 GB Memory only. Why MSSQL is not taking more than 1 GB, even though server has got 3 GB and database's max. memory configured as 2 GB
In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we will give /3GB in boot.ini. Similarly anything should be given for SQL 2000 Standard Edition. Right now, boot.ini doesn't contain this option
Appreciate your help on this
tks in advance
vasuAre you running other applications on the server besides SQL Server? SQL
Server will manage memory based on amount of free memory available.
Consequently, if other apps running on the same box (e.g. IIS) consume
significant amounts of memory, SQL Server won't acquire additional memory
because this would negatively impact performance.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"vasum" <anonymous@.discussions.microsoft.com> wrote in message
news:E2239F3D-53B5-4DA7-B7AC-280DC8B54ED7@.microsoft.com...
> Hi All,
> Can anybody tell me why Memory is not utilized by MSSQL Service. The
Environment as follows...
> It is an Critical Web based Application with SQL 2000 Standard Edition +
SP3 as backend .
> OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
> MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2
GB". This Server has Replication
> Configuration also. During peak time or non-peak time, it always use 1 GB
Memory only. Why MSSQL is not taking more than 1 GB, even though server has
got 3 GB and database's max. memory configured as 2 GB.
> In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we
will give /3GB in boot.ini. Similarly anything should be given for SQL 2000
Standard Edition. Right now, boot.ini doesn't contain this option.
> Appreciate your help on this.
> tks in advance,
> vasum
>|||Verify if your application is I/O bound or Memory Bound '
If your cpu utilization is fixed at 100%, then you should worry about
Memory.
Most of the performance problems in databases usually come from locks,
blocking, lot of IO read/writes, etc.
Check http://www.sql-server-performance.com/ for various ways to measure SQL
Server Performance.
Amol.
"vasum" <anonymous@.discussions.microsoft.com> wrote in message
news:E2239F3D-53B5-4DA7-B7AC-280DC8B54ED7@.microsoft.com...
> Hi All,
> Can anybody tell me why Memory is not utilized by MSSQL Service. The
Environment as follows...
> It is an Critical Web based Application with SQL 2000 Standard Edition +
SP3 as backend .
> OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
> MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2
GB". This Server has Replication
> Configuration also. During peak time or non-peak time, it always use 1 GB
Memory only. Why MSSQL is not taking more than 1 GB, even though server has
got 3 GB and database's max. memory configured as 2 GB.
> In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we
will give /3GB in boot.ini. Similarly anything should be given for SQL 2000
Standard Edition. Right now, boot.ini doesn't contain this option.
> Appreciate your help on this.
> tks in advance,
> vasum
>

MSSQL 2000 Standard Edition not utilizing Maximum Memory!

Hi All,
Can anybody tell me why Memory is not utilized by MSSQL Service. The Environment as follows...
It is an Critical Web based Application with SQL 2000 Standard Edition + SP3 as backend .
OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2 GB". This Server has Replication
Configuration also. During peak time or non-peak time, it always use 1 GB Memory only. Why MSSQL is not taking more than 1 GB, even though server has got 3 GB and database's max. memory configured as 2 GB.
In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we will give /3GB in boot.ini. Similarly anything should be given for SQL 2000 Standard Edition. Right now, boot.ini doesn't contain this option.
Appreciate your help on this.
tks in advance,
vasum
Are you running other applications on the server besides SQL Server? SQL
Server will manage memory based on amount of free memory available.
Consequently, if other apps running on the same box (e.g. IIS) consume
significant amounts of memory, SQL Server won't acquire additional memory
because this would negatively impact performance.
Hope this helps.
Dan Guzman
SQL Server MVP
"vasum" <anonymous@.discussions.microsoft.com> wrote in message
news:E2239F3D-53B5-4DA7-B7AC-280DC8B54ED7@.microsoft.com...
> Hi All,
> Can anybody tell me why Memory is not utilized by MSSQL Service. The
Environment as follows...
> It is an Critical Web based Application with SQL 2000 Standard Edition +
SP3 as backend .
> OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
> MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2
GB". This Server has Replication
> Configuration also. During peak time or non-peak time, it always use 1 GB
Memory only. Why MSSQL is not taking more than 1 GB, even though server has
got 3 GB and database's max. memory configured as 2 GB.
> In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we
will give /3GB in boot.ini. Similarly anything should be given for SQL 2000
Standard Edition. Right now, boot.ini doesn't contain this option.
> Appreciate your help on this.
> tks in advance,
> vasum
>
|||Verify if your application is I/O bound or Memory Bound ?
If your cpu utilization is fixed at 100%, then you should worry about
Memory.
Most of the performance problems in databases usually come from locks,
blocking, lot of IO read/writes, etc.
Check http://www.sql-server-performance.com/ for various ways to measure SQL
Server Performance.
Amol.
"vasum" <anonymous@.discussions.microsoft.com> wrote in message
news:E2239F3D-53B5-4DA7-B7AC-280DC8B54ED7@.microsoft.com...
> Hi All,
> Can anybody tell me why Memory is not utilized by MSSQL Service. The
Environment as follows...
> It is an Critical Web based Application with SQL 2000 Standard Edition +
SP3 as backend .
> OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
> MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2
GB". This Server has Replication
> Configuration also. During peak time or non-peak time, it always use 1 GB
Memory only. Why MSSQL is not taking more than 1 GB, even though server has
got 3 GB and database's max. memory configured as 2 GB.
> In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we
will give /3GB in boot.ini. Similarly anything should be given for SQL 2000
Standard Edition. Right now, boot.ini doesn't contain this option.
> Appreciate your help on this.
> tks in advance,
> vasum
>

MSSQL 2000 Standard Edition not utilizing Maximum Memory!

Hi All,
Can anybody tell me why Memory is not utilized by MSSQL Service. The Environ
ment as follows...
It is an Critical Web based Application with SQL 2000 Standard Edition + SP3
as backend .
OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2 GB
". This Server has Replication
Configuration also. During peak time or non-peak time, it always use 1 GB Me
mory only. Why MSSQL is not taking more than 1 GB, even though server has go
t 3 GB and database's max. memory configured as 2 GB.
In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we w
ill give /3GB in boot.ini. Similarly anything should be given for SQL 2000 S
tandard Edition. Right now, boot.ini doesn't contain this option.
Appreciate your help on this.
tks in advance,
vasumAre you running other applications on the server besides SQL Server? SQL
Server will manage memory based on amount of free memory available.
Consequently, if other apps running on the same box (e.g. IIS) consume
significant amounts of memory, SQL Server won't acquire additional memory
because this would negatively impact performance.
Hope this helps.
Dan Guzman
SQL Server MVP
"vasum" <anonymous@.discussions.microsoft.com> wrote in message
news:E2239F3D-53B5-4DA7-B7AC-280DC8B54ED7@.microsoft.com...
> Hi All,
> Can anybody tell me why Memory is not utilized by MSSQL Service. The
Environment as follows...
> It is an Critical Web based Application with SQL 2000 Standard Edition +
SP3 as backend .
> OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
> MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2
GB". This Server has Replication
> Configuration also. During peak time or non-peak time, it always use 1 GB
Memory only. Why MSSQL is not taking more than 1 GB, even though server has
got 3 GB and database's max. memory configured as 2 GB.
> In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we
will give /3GB in boot.ini. Similarly anything should be given for SQL 2000
Standard Edition. Right now, boot.ini doesn't contain this option.
> Appreciate your help on this.
> tks in advance,
> vasum
>|||Verify if your application is I/O bound or Memory Bound '
If your cpu utilization is fixed at 100%, then you should worry about
Memory.
Most of the performance problems in databases usually come from locks,
blocking, lot of IO read/writes, etc.
Check http://www.sql-server-performance.com/ for various ways to measure SQL
Server Performance.
Amol.
"vasum" <anonymous@.discussions.microsoft.com> wrote in message
news:E2239F3D-53B5-4DA7-B7AC-280DC8B54ED7@.microsoft.com...
> Hi All,
> Can anybody tell me why Memory is not utilized by MSSQL Service. The
Environment as follows...
> It is an Critical Web based Application with SQL 2000 Standard Edition +
SP3 as backend .
> OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU
> MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2
GB". This Server has Replication
> Configuration also. During peak time or non-peak time, it always use 1 GB
Memory only. Why MSSQL is not taking more than 1 GB, even though server has
got 3 GB and database's max. memory configured as 2 GB.
> In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we
will give /3GB in boot.ini. Similarly anything should be given for SQL 2000
Standard Edition. Right now, boot.ini doesn't contain this option.
> Appreciate your help on this.
> tks in advance,
> vasum
>

MSSQL 2000 memory leaks

Hi,
I have one application in two different companies with MSSQL2000 running on Windows2000 Server and Windows2003 Server.
It seems that memory needed for MSSQL2000 as displayed in task manager is increased every day.
Does anybody knows anything regarding memory leaks in MSSQL2000?

How can I find what version of service pack have I installed in a MSSQL2000 server machine?

Regards,
ManolisSQL Server is designed to take up as much memory as it needs. See the article titled "Server Memory Options" in BOL.|||SQL 2000 is sensistive to "Memory Pressure" where other applications request memory from the host operating system. As other apps request more memory, SQL 2000 will free up some of the memory that it is using. In general though, SQL 2000 will tend to "camp" on memory until it percieves pressure from other applications, so it has a reputation as a "memory hog" that I don't feel is justified.

To find your present patch level, execute:SELECT ServerProperty('ProductLevel')-PatP|||Link http://www.sqljunkies.com/Article/7F8518F9-FDAA-4FF3-8FC5-25E8946C8D0C.scuk to investigate & resolve the performance issues.

MSOLAP 2000 SP4 and Pertlib errors

Hi all,

I just installed MSOLAP 2000 SP4, and now every 4 seconds or so I'm seeing 2 new messages in the Application log.

This first one is from MSSQLServerOLAPService:

The description for Event ID ( 2003 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: The event log file is corrupt..

The Second is from Perflib:

The description for Event ID ( 2003 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: The event log file is corrupt..

Any ideas on what might be happening?

Thank you all.

Try first to install the hotfix, there was a problem with the Service Pack 4 more information see below.

This article lists the hotfixes that were originally released for Microsoft SQL Server 2000 Analysis Services Service Pack 3 (SP3), but that were not included in Service Pack 4 (SP4). These hotfixes are now available in a downloadable post-SP4 hotfix rollup package for SQL Server 2000 Analysis Services.

Hotfix rollup package for SQL Server 2000 Analysis Services Service Pack - Build 2174

MS SQL Server Analysis Services 2000:

http://support.microsoft.com/?kbid=907323&SD=tech

MS SQL Server 2000:

http://support.microsoft.com/kb/904660/en-us

|||I installed the hotfix, I'm still getting the same 2 event log messages every 5 seconds.|||

Chris,

Where did you get SP 4 for OLAP ? Where can you download it? (I′ve saw the download place only for the SP 4 of SQL 2000)

Do you still have problems with SP 4, also after the install of the Hot Fixes ?

greetings,

Laura

mso9.dll

Hello everyone! This is my first post so please bear with me. We have
recently re-vamped an Access application such that in each of our 5 locations
a local SQL server receives published updates from our main office server.
Remote servers also send their local updates to the master and they are in
turn propogated to all of the other remote servers. The new design works
great except for one annoying bug we have been chasing for two weeks:
"Faulting application msaccess.exe, version 9.0.0.2719, faulting module
mso9.dll, version 9.0.0.2720, fault address 0x0007ee2d." When a user gets the
error, they hit close and it terminates Access. If they move the error off
the screen and continue working the application continues. They have
discovered this and have been doing so but the fact that the error appears
must be fixed. If anyone can point me in the right direction it would be
muchly appreciated. Thanks in advance!
- Mark
mweber@.warrenlumber.com
Hi Mark,
That's pretty good information for your first post - it
always help when people post the steps related to the
problem, the exact error message (that's a big one), etc.
mso9.dll is an Office 2000 dll and the error is with
Microsoft Access (msaccess.exe). So you are probably better
off posting this in one of the access newsgroups. You can
try
microsoft.public.access.setupconfig
or the link to the web interface (watch out for line wrap on
the link) is:
http://support.microsoft.com/newsgro...-us;newsgroups
-Sue
On Thu, 9 Sep 2004 06:53:09 -0700, "Mark Weber"
<MarkWeber@.discussions.microsoft.com> wrote:

>Hello everyone! This is my first post so please bear with me. We have
>recently re-vamped an Access application such that in each of our 5 locations
>a local SQL server receives published updates from our main office server.
>Remote servers also send their local updates to the master and they are in
>turn propogated to all of the other remote servers. The new design works
>great except for one annoying bug we have been chasing for two weeks:
>"Faulting application msaccess.exe, version 9.0.0.2719, faulting module
>mso9.dll, version 9.0.0.2720, fault address 0x0007ee2d." When a user gets the
>error, they hit close and it terminates Access. If they move the error off
>the screen and continue working the application continues. They have
>discovered this and have been doing so but the fact that the error appears
>must be fixed. If anyone can point me in the right direction it would be
>muchly appreciated. Thanks in advance!
>- Mark
>mweber@.warrenlumber.com
|||Thanks very much for the reply Sue! I have posted it there and hopefully
someone can help us since the error is choking us!
Take care,
- Mark
"Sue Hoegemeier" wrote:

> Hi Mark,
> That's pretty good information for your first post - it
> always help when people post the steps related to the
> problem, the exact error message (that's a big one), etc.
> mso9.dll is an Office 2000 dll and the error is with
> Microsoft Access (msaccess.exe). So you are probably better
> off posting this in one of the access newsgroups. You can
> try
> microsoft.public.access.setupconfig
> or the link to the web interface (watch out for line wrap on
> the link) is:
> http://support.microsoft.com/newsgro...-us;newsgroups
> -Sue
> On Thu, 9 Sep 2004 06:53:09 -0700, "Mark Weber"
> <MarkWeber@.discussions.microsoft.com> wrote:
>
>

msmerge_contents doesn't get deleted

Hi all,
I'm having a problem with my sql server. I've an application where
several subscribers synchronize with a sql server publisher for some
tables of a database and a batch process also interacts with those
tables (basically updates data as a batch process from a SAP)
The problem I have is that data of actualizations made to the table
from the batch process (in msmerge_contents) is never cleaned up and
the table keeps growing without limit. In a couple of weeks the
synchronization process gives timeout errors to devices.
I've the property -MetaDataRetentionCleanUp set to 1 and data from
subscriber's synchronization gets cleaned up after retention period
expires. This aparently works well but how is data actualizations
coming from the batch process supposed to get deleted if it doesn't
have a Merge Agent ?
Actually I'm running the stored procedure sp_mergecleanupmetadata
after some days to clean up the merge tables but this is giving a lot
of synchronization problems with subscribers.
Could anybody give an advice on how should this problem be solved ?
any help will be appreciated.
thx in advance,
ori
Ok, I've accepted that this behaviour is by design. If you have an
external source updating a publicated table, that will generate
tracking rows in the msmerge_contents table and that rows will never
be cleaned up because there's no Merge Agent associated with the
source.
Now, what I'd like to do is to find a way to remove manually that
rows. I thought it would be possible to generate a script that would
delete all the rows inserted by the external source in the table
msmerge_contents with a date prior to two times the retention date set
on the publication. This way, I can assure that all the subscribers
are synchronizated or will be marked for reinitialization so they'll
be up to date.
Could anybody help me with that script ? Is it a good solution ? can
it be done ?
Any help will be appreciated, thx in advance.
ori

MSEE 2005 Storage Capacity

Hi Friends,

I am Gokul, I am using SQL Server MSEE 2005 (Free ware). Currently I am involved in the development of an application where I am using SQL Server MSEE 2005 and VB.Net. My incomming data size ranges from 5 GB to 7 GB per day. Can I use SQL Server MSEE 2005 as Data base with any licensing or have to get any license for storing larger capacity data.

Can any body please help me.

Thanks,

Gokul.G

Hi,

SSEE is limited to 4GB database capacity, due to the volume that you posted, I would say that this is already right now to big for SQL Server Express (and frommy experience database normally grow rather than shrink :-) ). SO you should consider taking a Full Edition like Standard / Enterprise Edition, tehy don′t have the limitation to 4GB and are full scalable.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

MSDTC?

I keep getting this message on my application server.
The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The
local computer may not have the necessary registry information or message DLL
files to display messages from a remote computer. The following information
is part of the event: Failed to enlist in DTC: SQL state 37000, native error
8501, error message [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on
server 'PROSQL' is unavailable..
what does this mean?...thanks
-Jim
Check to see if DTC is running on PROSQL.
-Sue
On Mon, 16 Oct 2006 14:14:02 -0700, Jim
<Jim@.discussions.microsoft.com> wrote:

>I keep getting this message on my application server.
>The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The
>local computer may not have the necessary registry information or message DLL
>files to display messages from a remote computer. The following information
>is part of the event: Failed to enlist in DTC: SQL state 37000, native error
>8501, error message [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on
>server 'PROSQL' is unavailable..
>what does this mean?...thanks
>-Jim

MSDTC?

I keep getting this message on my application server.
The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The
local computer may not have the necessary registry information or message DL
L
files to display messages from a remote computer. The following information
is part of the event: Failed to enlist in DTC: SQL state 37000, native error
8501, error message [Microsoft][ODBC SQL Server Driver][SQL Serv
er]MSDTC on
server 'PROSQL' is unavailable..
what does this mean?...thanks
-JimCheck to see if DTC is running on PROSQL.
-Sue
On Mon, 16 Oct 2006 14:14:02 -0700, Jim
<Jim@.discussions.microsoft.com> wrote:

>I keep getting this message on my application server.
>The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The
>local computer may not have the necessary registry information or message D
LL
>files to display messages from a remote computer. The following information
>is part of the event: Failed to enlist in DTC: SQL state 37000, native erro
r
>8501, error message [Microsoft][ODBC SQL Server Driver][SQL Ser
ver]MSDTC on
>server 'PROSQL' is unavailable..
>what does this mean?...thanks
>-Jim

MSDTC?

I keep getting this error on my application server...what does it mean?

The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found.
The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer. The
following information is part of the event: Failed to enlist in DTC:
SQL state 37000, native error 8501, error message [Microsoft][ODBC SQL
Server Driver][SQL Server]MSDTC on server 'PROSQL' is unavailable..

any help would be appreciated...thanks

-Jim
On Oct 16, 2:09 pm, "Jimbo" <jim.fer...@.motorola.comwrote:

Quote:

Originally Posted by

I keep getting this error on my application server...what does it mean?
>
The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found.
The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer. The
following information is part of the event: Failed to enlist in DTC:
SQL state 37000, native error 8501, error message [Microsoft][ODBC SQL
Server Driver][SQL Server]MSDTC on server 'PROSQL' is unavailable..
>
any help would be appreciated...thanks
>
-Jim

It seems you're trying to run global/XA transactions including the
SQLServer as one resource, and in order to do XA, MS SQLServer
needs it's MSDTC running. (MS Distributed Transaction Coordinator).
Joe Weinstein at BEA Systems

MSDTC, Active Diretory, DAO, And Transactions

If this is in the wrong forum, my apologies.
Here is the situation. We have a .Net application that someconsultants developed several years ago. They made use of DAO fordatabase access, using some inbuilt classes like ContextUtil to get atransation environment.
Until last weekend, the envorinment was:
Web application on IIS5 / Windows 2000 Advanced Server
Database on SQL2000 on Windows 2000 Advanced Server
We switched over to a new database server environment - a cluster oftwo Windows 2003 servers wth SQL Server 2000. This requiredActive Directory to be set up on the two database server machines.
Everything worked but this particular application - where it goes toupdate the database. It appears (but since I haven't yet beenable to rebuild the .Net solution) that the error - "Object referencenot set to an instance of object." is in fact a spurious error causedwhen the transation tries to roll back.
I have spent about 10 hours on this, and have come to the conclusionthat the fact I have MSDTC involved on a database server that is in anAD domain, while the web server that is issuing the transaction isoutside that domain is the cause of the problem. Now, I don'twant to put AD on the IIS 5 web server - we are migrating this to a newWin2k3/IIS6 server in 5 or 6 weeks time.
Any suggestions? If I have to, I can move the database for thisparticular app back to the non-clustered Windows 2000 server (which isalso outside the AD domain).
Thanks for your indulgance.
Microsoft requirement and good practice is a database Server is just a member server, it should not have anything to do with AD users. If your application is using DAO(data Access object) which was obselete in 1998 you may need MSDTC, the error could be you have not properly configured distributed transaction in SQL Server. Run a search for distributed transaction in the BOL(books online). The advice keep your application from none database users and AD. Hope this helps.

MSDTC Unavailable Windows 2003

Hi
I have a VB6 windows app which calls a VB6 COM+ application (both running on
machine CHOPGBCOM001) which in turn calls a stored procedure on a remote
machine CANSUR001 but it keeps failing with error "MSDTC on server
'CANSUR001' is unavailable". The COM+ application is configured with
Transaction Support=Required and isolation level set to the default of
serialised (the COM+
app changes it to Read Committed)
* CHOPCOM001 and CANSUR001 both have Windows 2003 SP1 and CANSUR001
is running SQL Server 2000.
* MSDTC is started on both machines
* I have Installed/enabled windows components "Enable network COM+ access"
and "Enable network DTC access" on both machines
* I have configured MSDTC in Component services to use "Network DTC access",
allow outbound and inbound on "Transaction Manager Communication" and set
to "No authentication required"
* Both machines are in the same domain
* No local firewalls are installed
* I've rebooted both machines but same result
* CANSUR001 is NOT part of a cluster
* I've tried running
BEGIN distributed transaction
select * from cansur001.leisure.dbo.member
from SQL Analyser in CHOPCOM001 but get the same result
Any help would be gratefully received
God Bless
RonanMSDTC is turned off by default in Windows 2003. Have you enabled it in
Windows?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Ronan" <Ronan@.discussions.microsoft.com> wrote in message
news:F77ECB86-A5E1-42CC-9D02-51CEBFDED779@.microsoft.com...
> Hi
> I have a VB6 windows app which calls a VB6 COM+ application (both running
> on
> machine CHOPGBCOM001) which in turn calls a stored procedure on a remote
> machine CANSUR001 but it keeps failing with error "MSDTC on server
> 'CANSUR001' is unavailable". The COM+ application is configured with
> Transaction Support=Required and isolation level set to the default of
> serialised (the COM+
> app changes it to Read Committed)
>
> * CHOPCOM001 and CANSUR001 both have Windows 2003 SP1 and CANSUR001
> is running SQL Server 2000.
> * MSDTC is started on both machines
> * I have Installed/enabled windows components "Enable network COM+ access"
> and "Enable network DTC access" on both machines
> * I have configured MSDTC in Component services to use "Network DTC
> access",
> allow outbound and inbound on "Transaction Manager Communication" and
> set
> to "No authentication required"
> * Both machines are in the same domain
> * No local firewalls are installed
> * I've rebooted both machines but same result
> * CANSUR001 is NOT part of a cluster
> * I've tried running
> BEGIN distributed transaction
> select * from cansur001.leisure.dbo.member
> from SQL Analyser in CHOPCOM001 but get the same result
>
> Any help would be gratefully received
> God Bless
> Ronan|||Distributed Transaction Coordinator service is enabled and started on both
machines
--
Ronan
"Ronan" wrote:

> Hi
> I have a VB6 windows app which calls a VB6 COM+ application (both running
on
> machine CHOPGBCOM001) which in turn calls a stored procedure on a remote
> machine CANSUR001 but it keeps failing with error "MSDTC on server
> 'CANSUR001' is unavailable". The COM+ application is configured with
> Transaction Support=Required and isolation level set to the default of
> serialised (the COM+
> app changes it to Read Committed)
>
> * CHOPCOM001 and CANSUR001 both have Windows 2003 SP1 and CANSUR001
> is running SQL Server 2000.
> * MSDTC is started on both machines
> * I have Installed/enabled windows components "Enable network COM+ access"
> and "Enable network DTC access" on both machines
> * I have configured MSDTC in Component services to use "Network DTC access
",
> allow outbound and inbound on "Transaction Manager Communication" and s
et
> to "No authentication required"
> * Both machines are in the same domain
> * No local firewalls are installed
> * I've rebooted both machines but same result
> * CANSUR001 is NOT part of a cluster
> * I've tried running
> BEGIN distributed transaction
> select * from cansur001.leisure.dbo.member
> from SQL Analyser in CHOPCOM001 but get the same result
>
> Any help would be gratefully received
> God Bless
> Ronan|||One thing I forgot to mention is that the remote server CANSUR001 is a
Domain Contoller, anyone come across problems running distributed
transactions against
servers which are also doiman controllers?
Ronan
"Ronan" wrote:
> Distributed Transaction Coordinator service is enabled and started on both
> machines
> --
> Ronan
>
> "Ronan" wrote:
>

MSDTC message

I have SQL 2000 running on Windows 2000 server and I several entires in the
application event view as follow:
"string message session idle timeout over tearing down the session"
What does this mean?
Thank You,
PIt means it took too long for all of the participants in the transaction to
commit or rollback their piece of the transaction or to communicate such
activity. MSDTC is rolling back the changes.
This usually will come up whenever there is a service restart on one of the
participants also.
Sincerely,
Anthony Thomas
"p" <p@.discussions.microsoft.com> wrote in message
news:AEB53470-938A-4F7C-AF69-878D1FC864D3@.microsoft.com...
I have SQL 2000 running on Windows 2000 server and I several entires in the
application event view as follow:
"string message session idle timeout over tearing down the session"
What does this mean?
Thank You,
P

MSDTC fails on Windows 2000 Advanced Server SP4

I have a VB6 application that uses MTS in a COM+ package for
transaction based processing over MSDTC. This application was working
fine when run from the SQL Server machine on Windows 2000 Advanced
Server until the latest security updates were installed. Now the
application fails to connect to SQL Server when the call is made inside
a transaction context within MTS/COM+
I have verified that MSDTC is started
The DTCTester tool runs successfully
RPC port 135 is open
This application runs fine on a Windows 2000 Server machine with SP4.
What is different about Windows 2000 Advanced Server such that it no
longer works after applying security updates (SP4)?
?s your SQL server and application server are in same domain, do you have
firewall etc between SQL Server and appl. server?
We had problems after we install Windows 2003 SP1 with MSDTC, we select No
Authantication Required and the problem is gone. Maybe because of you have
applied security patches you are having the same problem.
Check out:
http://support.microsoft.com/?id=883960
Hope this helps.
"dhalb@.comcast.net" wrote:

> I have a VB6 application that uses MTS in a COM+ package for
> transaction based processing over MSDTC. This application was working
> fine when run from the SQL Server machine on Windows 2000 Advanced
> Server until the latest security updates were installed. Now the
> application fails to connect to SQL Server when the call is made inside
> a transaction context within MTS/COM+
> I have verified that MSDTC is started
> The DTCTester tool runs successfully
> RPC port 135 is open
> This application runs fine on a Windows 2000 Server machine with SP4.
> What is different about Windows 2000 Advanced Server such that it no
> longer works after applying security updates (SP4)?
>

MSDTC fails on Windows 2000 Advanced Server SP4

I have a VB6 application that uses MTS in a COM+ package for
transaction based processing over MSDTC. This application was working
fine when run from the SQL Server machine on Windows 2000 Advanced
Server until the latest security updates were installed. Now the
application fails to connect to SQL Server when the call is made inside
a transaction context within MTS/COM+
I have verified that MSDTC is started
The DTCTester tool runs successfully
RPC port 135 is open
This application runs fine on a Windows 2000 Server machine with SP4.
What is different about Windows 2000 Advanced Server such that it no
longer works after applying security updates (SP4)'Ä°s your SQL server and application server are in same domain, do you have
firewall etc between SQL Server and appl. server?
We had problems after we install Windows 2003 SP1 with MSDTC, we select No
Authantication Required and the problem is gone. Maybe because of you have
applied security patches you are having the same problem.
Check out:
http://support.microsoft.com/?id=883960
Hope this helps.
"dhalb@.comcast.net" wrote:
> I have a VB6 application that uses MTS in a COM+ package for
> transaction based processing over MSDTC. This application was working
> fine when run from the SQL Server machine on Windows 2000 Advanced
> Server until the latest security updates were installed. Now the
> application fails to connect to SQL Server when the call is made inside
> a transaction context within MTS/COM+
> I have verified that MSDTC is started
> The DTCTester tool runs successfully
> RPC port 135 is open
> This application runs fine on a Windows 2000 Server machine with SP4.
> What is different about Windows 2000 Advanced Server such that it no
> longer works after applying security updates (SP4)'
>

MSDTC fails on Windows 2000 Advanced Server SP4

I have a VB6 application that uses MTS in a COM+ package for
transaction based processing over MSDTC. This application was working
fine when run from the SQL Server machine on Windows 2000 Advanced
Server until the latest security updates were installed. Now the
application fails to connect to SQL Server when the call is made inside
a transaction context within MTS/COM+
I have verified that MSDTC is started
The DTCTester tool runs successfully
RPC port 135 is open
This application runs fine on a Windows 2000 Server machine with SP4.
What is different about Windows 2000 Advanced Server such that it no
longer works after applying security updates (SP4)'?s your SQL server and application server are in same domain, do you have
firewall etc between SQL Server and appl. server?
We had problems after we install Windows 2003 SP1 with MSDTC, we select No
Authantication Required and the problem is gone. Maybe because of you have
applied security patches you are having the same problem.
Check out:
http://support.microsoft.com/?id=883960
Hope this helps.
"dhalb@.comcast.net" wrote:

> I have a VB6 application that uses MTS in a COM+ package for
> transaction based processing over MSDTC. This application was working
> fine when run from the SQL Server machine on Windows 2000 Advanced
> Server until the latest security updates were installed. Now the
> application fails to connect to SQL Server when the call is made inside
> a transaction context within MTS/COM+
> I have verified that MSDTC is started
> The DTCTester tool runs successfully
> RPC port 135 is open
> This application runs fine on a Windows 2000 Server machine with SP4.
> What is different about Windows 2000 Advanced Server such that it no
> longer works after applying security updates (SP4)'
>

MSDTC Event ID 53286

I have a SQL Server that keeps throwing errors in the Application Log.
I cannot seem to track these down, and I have checked Microsoft and
EventID for information. Here is the event:
Event Type: Warning
Event Source: MSDTC
Event Category: XATM
Event ID: 53286
Description:
The XA Transaction Manager called the "GetXaSwitch" function in the XA
resource manager DLL. The call to the "GetXaSwitch" function failed:
File=.\xarmdir.cpp Line=580.
Can someone shed some light on what I need to do to resolve this
problem?
Thanks in advance,
J Wolfgang GoerlichI do not know what that DLL is used for, but I would first verify using SQL
Profiler if the XA transaction makes it all the way to SQL Server, by
looking at the Distributed Transaction Event Class
BTW: If you are using Oracle 8 or 9 you should be using: "Oracle Services
for MTS in Oracle9i"
http://otn.oracle.com/tech/windows/ora_mts/htdocs/oramtsfov9i.html
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2003 All rights reserved.
"jwgoerlich" <jwgoerlich@.quantaonline.com> wrote in message
news:9c87d620.0308290628.5843fe3e@.posting.google.com...
> Funny thing. I solved this one by recreating the DTC log (msdtc
> -resetlog). Now I am no longer getting that error. I did notice that
> the MTC is trying to load a ENUdtcl.dll file from the Oracle folder,
> and this file does not exist. Any one have an idea on what this is
> used for, or should I not worry about it?
> Thanks in advance,
> J Wolfgang Goerlich

MSDTC error

Hi guys,
Im new to SQL Server development in general...Well, I've been trying to
work on an existing application that uses both ASP and SQL Server that
happened to be raising an error that is logged on the Event Viewer 15
minutes after closing the browser. Here it is:
Event Type: Information
Event Source: MSDTC
Event Category: (3)
Event ID: 4156
Date: 09/08/2005
Time: 12:56:28 PM
User: N/A
Description:
String message: Session idle timeout over, tearing down the session.
As it looks, it seems like a uncleared session state upon exiting the
ASP page. I then tried using Session.Contents.RemoveAll and
Session.Abandon methods but still got no luck on the ASP side...Is there
anyway this Informational Message won't get logged into the Event
Viewer? I dont really know if its ASP or SQL problem! hehe...
Your help will greatly be appreciated. Thanks!
*** Sent via Developersdex http://www.examnotes.net ***Hope this helps.
Dan Guzman
SQL Server MVP
"jules remoreras" <losevilla@.yahoo.com> wrote in message
news:uQYosRRvFHA.2504@.tk2msftngp13.phx.gbl...
> Hi guys,
> Im new to SQL Server development in general...Well, I've been trying to
> work on an existing application that uses both ASP and SQL Server that
> happened to be raising an error that is logged on the Event Viewer 15
> minutes after closing the browser. Here it is:
> Event Type: Information
> Event Source: MSDTC
> Event Category: (3)
> Event ID: 4156
> Date: 09/08/2005
> Time: 12:56:28 PM
> User: N/A
> Description:
> String message: Session idle timeout over, tearing down the session.
> As it looks, it seems like a uncleared session state upon exiting the
> ASP page. I then tried using Session.Contents.RemoveAll and
> Session.Abandon methods but still got no luck on the ASP side...Is there
> anyway this Informational Message won't get logged into the Event
> Viewer? I dont really know if its ASP or SQL problem! hehe...
> Your help will greatly be appreciated. Thanks!
>
>
> *** Sent via Developersdex http://www.examnotes.net ***|||Check out http://support.microsoft.com/defaul...kb;en-us;290334 for
more information on the error. AFAIK, the message can't be suppressed.
Hope this helps.
Dan Guzman
SQL Server MVP
"jules remoreras" <losevilla@.yahoo.com> wrote in message
news:uQYosRRvFHA.2504@.tk2msftngp13.phx.gbl...
> Hi guys,
> Im new to SQL Server development in general...Well, I've been trying to
> work on an existing application that uses both ASP and SQL Server that
> happened to be raising an error that is logged on the Event Viewer 15
> minutes after closing the browser. Here it is:
> Event Type: Information
> Event Source: MSDTC
> Event Category: (3)
> Event ID: 4156
> Date: 09/08/2005
> Time: 12:56:28 PM
> User: N/A
> Description:
> String message: Session idle timeout over, tearing down the session.
> As it looks, it seems like a uncleared session state upon exiting the
> ASP page. I then tried using Session.Contents.RemoveAll and
> Session.Abandon methods but still got no luck on the ASP side...Is there
> anyway this Informational Message won't get logged into the Event
> Viewer? I dont really know if its ASP or SQL problem! hehe...
> Your help will greatly be appreciated. Thanks!
>
>
> *** Sent via Developersdex http://www.examnotes.net ***|||Session is holding an object it should not hold. If it is database related,
it is likely a connection opened when a session starts that is never killed.
It is not necessarily SQL Server related.
I would post in the ASP group:
microsoft.public.inetserver.asp.general
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"jules remoreras" wrote:

> Hi guys,
> Im new to SQL Server development in general...Well, I've been trying to
> work on an existing application that uses both ASP and SQL Server that
> happened to be raising an error that is logged on the Event Viewer 15
> minutes after closing the browser. Here it is:
> Event Type: Information
> Event Source: MSDTC
> Event Category: (3)
> Event ID: 4156
> Date: 09/08/2005
> Time: 12:56:28 PM
> User: N/A
> Description:
> String message: Session idle timeout over, tearing down the session.
> As it looks, it seems like a uncleared session state upon exiting the
> ASP page. I then tried using Session.Contents.RemoveAll and
> Session.Abandon methods but still got no luck on the ASP side...Is there
> anyway this Informational Message won't get logged into the Event
> Viewer? I dont really know if its ASP or SQL problem! hehe...
> Your help will greatly be appreciated. Thanks!
>
>
> *** Sent via Developersdex http://www.examnotes.net ***
>|||Gee...thanks to both of you (Dan and Cowboy) for the input!!! :) At
least the input/link you posted somehow enlighten my heavily burden
mind. hehehe. Thanks again!
*** Sent via Developersdex http://www.examnotes.net ***

MSDTC configuration problem

Hi.
My application needs to do distributed transaction on remote Sql server.My
application can be run from workstations(XP professional) or from SQL server
2000...
Limitations for this application are
Worksations wont be having SQL server installed.
I cannot give administrative rights on the SQL server 2000 system( i can
give administrative rights in the SQL server itself but not for the whole
server system)
I created a sample application which has a class for doing distributed
transactions which is derived from ServicedComponent. This application when
run on SQL server 2000 runs fine.It runs fine when worksation also has SQl
server.
But i tried to run this application from a worksation where SQL server is
not installed it doesnt work.Then i configured workstations MTC to point to
remote server and when i created workstaion's login on the server machine as
administrator then the application works...but if i remove the administrator
rights on the system it doesnt...I read in the article TO CONFIGURE MSDTC
needs administrative rights on the server as well as the client.But after
configuration is over i removed the administrative right and kept it as
Standard user or restricted user it doesnt work.But since Our system cannot
give administrative logins for all the clients this would not work.

> is there any other way to make this work!!
Hello,
Did you give the workstation login the appropriate permisssions in SQL
Server? Did you tried to use SQL account to login?
Thanks,
Mohamed Sharaf
MEA Developer Support Center
ITWorx on behalf Microsoft EMEA GTSC