Anybody seen this error? - 37000 - Storage Allocation record not available

Hi all,
I have a problem with a SQL Server database throwing an error I have
never seen before, and cannot remember ever seeing anywhere else either
(even a google search doesn't throw anything up).
Here's the exact text...
37000
[Microsoft][ODBC SQL Server Driver][SQL Server]Storage Allocation
record not available
The error was originally caused by the database server running out of
space on the system volume (containing the log files), but that has now
been rectified, and we have confirmed that the growth rate of the log
files are smaller than the amount of free space.
What on earth does it mean anyway - "storage allocation record not
available" ?Hi Jonathan
I am not familiar with the error message, but is there any more information
in the SQL Server error log. Does Stopping/Starting SQL server help? Have you
tried defragmenting the disc? Are you using a fixed value for file growth on
all the databases (including tempdb).
John
"jonathan.beckett" wrote:
> Hi all,
> I have a problem with a SQL Server database throwing an error I have
> never seen before, and cannot remember ever seeing anywhere else either
> (even a google search doesn't throw anything up).
> Here's the exact text...
> 37000
> [Microsoft][ODBC SQL Server Driver][SQL Server]Storage Allocation
> record not available
> The error was originally caused by the database server running out of
> space on the system volume (containing the log files), but that has now
> been rectified, and we have confirmed that the growth rate of the log
> files are smaller than the amount of free space.
> What on earth does it mean anyway - "storage allocation record not
> available" ?
>|||First, what version of SQL server are you using?
2nd, is the the error still recurring?
I never seen it before but i expect it has to do wit the SQL engine- which
generates this message when the log was full.
Greetz,
Fling Dutch men.|||> I am not familiar with the error message, but is there any more information
> in the SQL Server error log. Does Stopping/Starting SQL server help? Have you
> tried defragmenting the disc? Are you using a fixed value for file growth on
> all the databases (including tempdb).
> John
It's SQL Server 7 on NT.
Stopping and starting SQL Server does not resolve the problem.
Defragmentation is not an issue either. We're really stumped, and have
opened a call with the makers of the software that is reporting the
error from SQL Server.
> "jonathan.beckett" wrote:
> > Hi all,
> >
> > I have a problem with a SQL Server database throwing an error I have
> > never seen before, and cannot remember ever seeing anywhere else either
> > (even a google search doesn't throw anything up).
> >
> > Here's the exact text...
> > 37000
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Storage Allocation
> > record not available
> >
> > The error was originally caused by the database server running out of
> > space on the system volume (containing the log files), but that has now
> > been rectified, and we have confirmed that the growth rate of the log
> > files are smaller than the amount of free space.
> >
> > What on earth does it mean anyway - "storage allocation record not
> > available" ?
> >
> >|||Hate_orphaned_users wrote:
> First, what version of SQL server are you using?
> 2nd, is the the error still recurring?
> I never seen it before but i expect it has to do wit the SQL engine- which
> generates this message when the log was full.
SQL Server 7 on NT
The error is still recurring, but only for a specific operation within
the software that uses the database. Everything else appears to be
fine.
It is very, very strange - we have opened a call with the makers of the
software that is reporting the error (annoyingly it does not appear in
their knowledgebase, and Microsoft have no information on this specific
error from SQL Server either).|||Hi Jonathan,
This is a memory storage allocation error. You can get more details by
running the DBCC MEMORYSTATUS command. For more info go to:
http://support.microsoft.com/kb/907877/en-us
The first I'd check is to make sure you haven't run out if space on
TempDB.
On 27 Dec 2006 03:08:11 -0800, "jonathan.beckett"
<jonathan.beckett@.gmail.com> wrote:
>Hi all,
>I have a problem with a SQL Server database throwing an error I have
>never seen before, and cannot remember ever seeing anywhere else either
>(even a google search doesn't throw anything up).
>Here's the exact text...
>37000
>[Microsoft][ODBC SQL Server Driver][SQL Server]Storage Allocation
>record not available
>The error was originally caused by the database server running out of
>space on the system volume (containing the log files), but that has now
>been rectified, and we have confirmed that the growth rate of the log
>files are smaller than the amount of free space.
>What on earth does it mean anyway - "storage allocation record not
>available" ?

any user access audit programs available?

Hello all, does anyone know of a SS2005RS user audit program that an administrator can run on a RS server to show which userids have access to folders? I have in mind a pgm that would show:

folder users

Home user01, user02, user03

folderA user01,user02, user05

folderB user02, user06

Is there a pgm available as a download, or does someone have a home-grown pgm whose source they would let out?

Has anyone else faced this need?

Thanks in advance

I don't know of such a program but writing your own shouldn't be that difficult. You can call ReportingService2005.GetPolicies method to obtain the secuity polices per folder.|||Mr. Lachev, thanks so much, I'll do that. P.S. I like your website.

Any third-party freebies to administer MSDE?

Are there any third party freebies available to administer MSDE? I'm looking
to replace Interbase with MSDE, but I'll need some sort of Query Analyzer /
Admin interface to replace IBConsole which is free with Interbase. Is
anything like this available?
Thanks for your help,
Joe Geretz
This link may help.
http://www.microsoft.com/sql/msde/partners/default.asp
Jim
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:u91ZuEDGEHA.3856@.TK2MSFTNGP12.phx.gbl...
> Are there any third party freebies available to administer MSDE? I'm
looking
> to replace Interbase with MSDE, but I'll need some sort of Query Analyzer
/
> Admin interface to replace IBConsole which is free with Interbase. Is
> anything like this available?
> Thanks for your help,
> Joe Geretz
>
|||http://www.aspfaq.com/2442
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:u91ZuEDGEHA.3856@.TK2MSFTNGP12.phx.gbl...
> Are there any third party freebies available to administer MSDE? I'm
> looking
> to replace Interbase with MSDE, but I'll need some sort of Query Analyzer
> /
> Admin interface to replace IBConsole which is free with Interbase. Is
> anything like this available?
> Thanks for your help,
> Joe Geretz
>
|||Joseph,

> Are there any third party freebies available to administer MSDE?
There aren't only 3rd party tools, have a look at MS Web Administrator:
http://www.microsoft.com/downloads/d...displaylang=en
The only disadvantage I can see is the poor performance.
I have also tested DbaMgr (http://www.asql.biz/DbaMgr.shtm) and the free
version of myLittleAdmin (http://www.mylittletools.net/scripts/en/mla_sql/).
For having a quick look at your databases, myLittleAdmin is very good.
Bye,
mm

Any SQL 64 bit Webcasts available ?

Any SQL 64 bit Webcasts available ?There's a flash-demo at
http://www.microsoft.com/sql/64bit/productinfo/demo.asp and a Support
WebCast: Microsoft SQL Server 2000: An Introduction to SQL Server 2000
(64-bit) and Analysis Services (64-bit) at
http://support.microsoft.com/default.aspx?kbid=817280. I'm not aware of any
others but that might just be because a quick TechNet search didn't find
them. :-)
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OjxXfGZXEHA.3716@.TK2MSFTNGP11.phx.gbl...
>
>
|||There's a flash-demo at
http://www.microsoft.com/sql/64bit/productinfo/demo.asp and a Support
WebCast: Microsoft SQL Server 2000: An Introduction to SQL Server 2000
(64-bit) and Analysis Services (64-bit) at
http://support.microsoft.com/default.aspx?kbid=817280. I'm not aware of any
others but that might just be because a quick TechNet search didn't find
them. :-)
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OjxXfGZXEHA.3716@.TK2MSFTNGP11.phx.gbl...
>
>

Any SQL 64 bit Webcasts available ?

Any SQL 64 bit Webcasts available ?There's a flash-demo at
http://www.microsoft.com/sql/64bit/productinfo/demo.asp and a Support
WebCast: Microsoft SQL Server 2000: An Introduction to SQL Server 2000
(64-bit) and Analysis Services (64-bit) at
http://support.microsoft.com/default.aspx?kbid=817280. I'm not aware of any
others but that might just be because a quick TechNet search didn't find
them. :-)
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OjxXfGZXEHA.3716@.TK2MSFTNGP11.phx.gbl...
>
>

Any SQL 64 bit Webcasts available ?

Any SQL 64 bit Webcasts available ?There's a flash-demo at
http://www.microsoft.com/sql/64bit/productinfo/demo.asp and a Support
WebCast: Microsoft SQL Server 2000: An Introduction to SQL Server 2000
(64-bit) and Analysis Services (64-bit) at
http://support.microsoft.com/default.aspx?kbid=817280. I'm not aware of any
others but that might just be because a quick technet search didn't find
them. :-)
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OjxXfGZXEHA.3716@.TK2MSFTNGP11.phx.gbl...
>
>

Any equivalent to Oracle RAC available for SQL Server?

Using Windows clustering requires too long a failover time for my company's
uptime requirements. While SQL 2005's mirroring decreases the failover
time, it also only allows me to mirror to one server, thus putting me in a
rough spot for DR.
Is there any Oracle RAC type equivalent functionality (i.e. shared cache)
planned for future versions of SQL 2005, or available via some 3rd party
today for use with SQL 2005 today? The net is, I need as little downtime as
possible, both within a site, and across to my DR site (and as little to no
data loss as possible to that DR site)...all the while (of course)
minimizing the perf hit all of this requires...though while perf needs to
still fall in acceptable ranges, better perf is not as important as faster
failover and no data loss.
Any help is appeciated.
Thanks
RAC is by no means a High Availability feature so I am confused as to the
subject. There is no SQL Server RAC equivalent in the current release for a
read write database. However there are several HA / DR features that SQL
Server has that people use every day to satisfy their HA / DR needs. How
fast the recovery and how little down time is usually more a factor of how
much money you wish to spend. For instance you can do mirroring to get fast
up time and use the SAN's features to do DR. This is just a simple example
and it will really depend on what you want, what you have to work with and
how much time and money youa re willing to put into it. You might want to
start here:
http://www.microsoft.com/sql/technologies/highavailability/default.mspx
Andrew J. Kelly SQL MVP
"Jim" <ilmm555@.yahoo.com> wrote in message
news:uimO$QJhHHA.4980@.TK2MSFTNGP02.phx.gbl...
> Using Windows clustering requires too long a failover time for my
> company's uptime requirements. While SQL 2005's mirroring decreases the
> failover time, it also only allows me to mirror to one server, thus
> putting me in a rough spot for DR.
> Is there any Oracle RAC type equivalent functionality (i.e. shared cache)
> planned for future versions of SQL 2005, or available via some 3rd party
> today for use with SQL 2005 today? The net is, I need as little downtime
> as possible, both within a site, and across to my DR site (and as little
> to no data loss as possible to that DR site)...all the while (of course)
> minimizing the perf hit all of this requires...though while perf needs to
> still fall in acceptable ranges, better perf is not as important as faster
> failover and no data loss.
> Any help is appeciated.
> Thanks
|||OK, while RAC's original intent is to be a scale out feature, it's also very
much an HA feature...as if a node dies, other nodes press on...there's no
notion of "failover", thus eliminating the need to failover.
I disagree with it being "a factor of how much money you wish to spend"...as
regardless of how much you spend, the best you'll get SQL to is seconds of
downtime (with mirroring, likely 10s of seconds-minutes with
clustering)...thus, if you were to patch once a month (between SQL and
Windows this is certainly not out of the realm of possibility), that's
twelve failovers per year, at (at best...10 seconds of downtime each
failover)...so you're at 120 seconds a year...99.999% availability is 52.256
seconds...so you're already down to under 5 9's availability for the year.
In this shop, there's no notion of "unplanned downtime"...we're 24x7...it's
ALL downtime.
As for mirroring with SAN replicaiton for DR...below I mention no data loss,
so you'd be talking about synchronous mirroing WITH synchronous SAN
replication...while I said perf isn't the highest priority...I wonder how
slow it would be with effectively 3 writes for each write (one to the
primary SQL, one to the secondary SQL, one to the DR site...and since this
is all synchronous...all writes have to be completed before the
transaction's commited)...plus, now you're using SQL failover functionality
and SAN failover functionality...I certainly wonder how (operationally)
feasible this all will be...I'm sure it will be feasible, but certainly not
seamless...
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uPErZcShHHA.4064@.TK2MSFTNGP02.phx.gbl...
> RAC is by no means a High Availability feature so I am confused as to the
> subject. There is no SQL Server RAC equivalent in the current release for
> a read write database. However there are several HA / DR features that SQL
> Server has that people use every day to satisfy their HA / DR needs. How
> fast the recovery and how little down time is usually more a factor of how
> much money you wish to spend. For instance you can do mirroring to get
> fast up time and use the SAN's features to do DR. This is just a simple
> example and it will really depend on what you want, what you have to work
> with and how much time and money youa re willing to put into it. You might
> want to start here:
> http://www.microsoft.com/sql/technologies/highavailability/default.mspx
>
> --
> Andrew J. Kelly SQL MVP
> "Jim" <ilmm555@.yahoo.com> wrote in message
> news:uimO$QJhHHA.4980@.TK2MSFTNGP02.phx.gbl...
>
|||While RAC does give some flexibility in terms of a single node failure there
are still plenty of places that are close to single point of failure without
additional effort. And it does nothing for DR. Oracle or anyother rdbms has
no magic solution to guarantee 0 down time. It really boils down to the
limitations of hardware. You are not the 1st company looking for 24X7
operation. Hundreds if not thousands of companies use SQL Server every day
for 5 nines of availability. I disagree with the down time for the number
of patches. How often you patch is often up to you. I had a system running
for almost 3 years. It was secure and did what we wanted so we choose not to
patch it.
Andrew J. Kelly SQL MVP
"Jim" <ilmm555@.yahoo.com> wrote in message
news:eMz1vgVhHHA.1388@.TK2MSFTNGP05.phx.gbl...
> OK, while RAC's original intent is to be a scale out feature, it's also
> very much an HA feature...as if a node dies, other nodes press
> on...there's no notion of "failover", thus eliminating the need to
> failover.
> I disagree with it being "a factor of how much money you wish to
> spend"...as regardless of how much you spend, the best you'll get SQL to
> is seconds of downtime (with mirroring, likely 10s of seconds-minutes with
> clustering)...thus, if you were to patch once a month (between SQL and
> Windows this is certainly not out of the realm of possibility), that's
> twelve failovers per year, at (at best...10 seconds of downtime each
> failover)...so you're at 120 seconds a year...99.999% availability is
> 52.256 seconds...so you're already down to under 5 9's availability for
> the year. In this shop, there's no notion of "unplanned downtime"...we're
> 24x7...it's ALL downtime.
> As for mirroring with SAN replicaiton for DR...below I mention no data
> loss, so you'd be talking about synchronous mirroing WITH synchronous SAN
> replication...while I said perf isn't the highest priority...I wonder how
> slow it would be with effectively 3 writes for each write (one to the
> primary SQL, one to the secondary SQL, one to the DR site...and since this
> is all synchronous...all writes have to be completed before the
> transaction's commited)...plus, now you're using SQL failover
> functionality and SAN failover functionality...I certainly wonder how
> (operationally) feasible this all will be...I'm sure it will be feasible,
> but certainly not seamless...
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uPErZcShHHA.4064@.TK2MSFTNGP02.phx.gbl...
>
|||Hello Jim,
I am interested you say that SQL clustering is to slow. I run 8 production
clusters of various sizes, one is 300 GB just for data and fail over takes
about 30 seconds. Is 30 seconds to slow? If so then using a database mirror
would be the way to go. You will need to ensure that the client is using
ADO.NET 2.0 so that your failover is supported. However, there will be no
need to handle the failover as there is when using TAF on RAC.
Having said that currently SQL server has no RAC equivalency for scaling
out. If this is a requirement I would go with a HP Itanium system such as
the 6840 this would allow you to scale up over time rather than scaling out.
Let me know if you need clarification
John Vandervliet.
"Jim" <ilmm555@.yahoo.com> wrote in message
news:uimO$QJhHHA.4980@.TK2MSFTNGP02.phx.gbl...
> Using Windows clustering requires too long a failover time for my
> company's uptime requirements. While SQL 2005's mirroring decreases the
> failover time, it also only allows me to mirror to one server, thus
> putting me in a rough spot for DR.
> Is there any Oracle RAC type equivalent functionality (i.e. shared cache)
> planned for future versions of SQL 2005, or available via some 3rd party
> today for use with SQL 2005 today? The net is, I need as little downtime
> as possible, both within a site, and across to my DR site (and as little
> to no data loss as possible to that DR site)...all the while (of course)
> minimizing the perf hit all of this requires...though while perf needs to
> still fall in acceptable ranges, better perf is not as important as faster
> failover and no data loss.
> Any help is appeciated.
> Thanks
|||Do you run 8 production clusters where all of them are single instance
cluster..i.e one active and one passive or do you have a multi instance
cluster say more than 2 active nodes with 1 passive node for any of the
active nodes to failover.
"John Vandervliet" <jvandervliet@.SJRB.AD> wrote in message
news:7FE2AB87-4B70-44A0-8400-85B209FC6626@.microsoft.com...
> Hello Jim,
> I am interested you say that SQL clustering is to slow. I run 8 production
> clusters of various sizes, one is 300 GB just for data and fail over takes
> about 30 seconds. Is 30 seconds to slow? If so then using a database
> mirror would be the way to go. You will need to ensure that the client is
> using ADO.NET 2.0 so that your failover is supported. However, there will
> be no need to handle the failover as there is when using TAF on RAC.
> Having said that currently SQL server has no RAC equivalency for scaling
> out. If this is a requirement I would go with a HP Itanium system such as
> the 6840 this would allow you to scale up over time rather than scaling
> out.
> Let me know if you need clarification
> John Vandervliet.
>
> "Jim" <ilmm555@.yahoo.com> wrote in message
> news:uimO$QJhHHA.4980@.TK2MSFTNGP02.phx.gbl...
>
|||We run a combination most the instances are active/passive setups, howerver
we have 3 clusters that each of 2 instances of SQL. the servers are exact
matches of each other and can handle the load for both instances when needed.
"Hassan" wrote:

> Do you run 8 production clusters where all of them are single instance
> cluster..i.e one active and one passive or do you have a multi instance
> cluster say more than 2 active nodes with 1 passive node for any of the
> active nodes to failover.
>
> "John Vandervliet" <jvandervliet@.SJRB.AD> wrote in message
> news:7FE2AB87-4B70-44A0-8400-85B209FC6626@.microsoft.com...
>
>
|||On Apr 26, 5:12 pm, John Vandervliet
<JohnVandervl...@.discussions.microsoft.com> wrote:
> We run a combination most the instances are active/passive setups, howerver
> we have 3 clusters that each of 2 instances of SQL. the servers are exact
> matches of each other and can handle the load for both instances when needed.
>
> "Hassan" wrote:
>
>
>
>
>
> - Show quoted text -
Hassan,
My employer SteelEye Technology has a solution called LifeKeeper for
SQL Server. With our solution we can cluster 2-nodes locally with
either shared storage or syncronous host based replication and also
support a 3rd node in the DR site with either sync or async
replication. Of course sync replication will impact performance if
done across a WAN, but it is the only way to guarantee no data loss.
Failover time is similar to MSCS, so if that is too long, you will
have to look elsewhere.
Here is some information.
www.steeleye.com/pdf/literature/lifekeeper_for_sql_server.pdf
David A. Bermingham, MCSE, MCSA:Messaging
Director of Product Management
www.steeleye.com

any dba checklist

hi,
1. any dba checklist information available on the net, e.g. daily operation,
weekly or monthly
2. will the dba switch on the server-side trace during product to monitor
any abnormal behaviour? if yes, any examples?
thanks a lot!
Hi
To some extent your check list will be determined by the system you are
running and how it is configured.
This site is a good resource of information
http://www.sql-server-performance.co...l_by_date.asp, You may also
want to look at the operations guide at
http://www.microsoft.com/technet/pro...n/sqlops0.mspx
A list of useful resources can be found at
http://www.aspfaq.com/show.asp?id=2423
Books online is also a valuable resource and if you look up sqldiag and
blackbox you may find the answer to your second question.
John
"Mullin Yu" <mullin_yu@.ctil.com> wrote in message
news:uo2kmFC5EHA.2540@.TK2MSFTNGP09.phx.gbl...
> hi,
> 1. any dba checklist information available on the net, e.g. daily
> operation,
> weekly or monthly
> 2. will the dba switch on the server-side trace during product to monitor
> any abnormal behaviour? if yes, any examples?
> thanks a lot!
>
>
>

any dba checklist

hi,
1. any dba checklist information available on the net, e.g. daily operation,
weekly or monthly
2. will the dba switch on the server-side trace during product to monitor
any abnormal behaviour? if yes, any examples?
thanks a lot!Hi
To some extent your check list will be determined by the system you are
running and how it is configured.
This site is a good resource of information
http://www.sql-server-performance.com/articles_all_by_date.asp, You may also
want to look at the operations guide at
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx
A list of useful resources can be found at
http://www.aspfaq.com/show.asp?id=2423
Books online is also a valuable resource and if you look up sqldiag and
blackbox you may find the answer to your second question.
John
"Mullin Yu" <mullin_yu@.ctil.com> wrote in message
news:uo2kmFC5EHA.2540@.TK2MSFTNGP09.phx.gbl...
> hi,
> 1. any dba checklist information available on the net, e.g. daily
> operation,
> weekly or monthly
> 2. will the dba switch on the server-side trace during product to monitor
> any abnormal behaviour? if yes, any examples?
> thanks a lot!
>
>
>

Any available solution do creat 3 databases correspondence?

Hi,

we have three dabases:

1. Two localDatabases in two offices, Main Office & Branch Office, each office in a diffrent city!!

2. One remoteDatabes exist in on the internet server.

all of it are with the same exact architecture, we are planning to upload and download to & from remoteDatabase to get the same data in all of them.

any available solution to do this with SQL Server 2005 ?

You may wish to investigate the use of Replication (see Books Online).

A couple of other options include: database mirroring and log shipping.

My guess (based on scant information) is that one of the Replication schemes is most likely what you seek.

|||Thanks Arnie,,

any *simple* external activation examples available?

BOL only seems to say that you can do it w/o really showing how, and the ExternalActivator sample at gotdotnet.com contains so much functionality I'm not sure what's required just for the external activation. Are there any docs or samples out there that focus on how to do it w/o obscuring the matter with a bunch of other functionality? (I prefer docs to project samples, b/c the samples tend to have hacks like hardcoded paths and connection strings so that they rarely work correctly right out of the box.)

TIA

The sample tries to do it correctly. That is, it must gaurantee that it will try to launch the process even under memory pressure and process failure. If it didn't, there is the danger of orphaning messages in the application queue. In order to provide this gaurantee, it must implement basic recovery logging. That adds to the complexity.

Answer Re: SQL Server 2000 DTS Tools Web Download

Is the Web Download to install SQL Server 2000 DTS tools available yet? If so where?

Thanks

DarrenIf I answer my own question, at least I'll get one right.

SQL 2000 DTS tools are now available as part of the -

Download details: Feature Pack for SQL Server 2005 Nov 2005
(http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en)

The direct link to the MSI-

http://www.microsoft.com/downloads/info.aspx?na=46&p=16&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2f4%2f4%2fd%2f44dbde61-b385-4fc2-a67d-48053b8f9fad%2fSQLServer2005_DTS.msi&oRef=http%3a%2f%2fforums.microsoft.com%2fMSDN%2fShowPost.aspx%3fPostID%3d126513%26SiteID%3d1|||

I have downloaded the dts tools and when I try to edit a dts package on a SQL2000 instance using the new SQL Server Management Studio, I still get the following errors:

Package Error
Error Source : Microsoft Data Transformation Services (DTS) Package
Errir Description : The DTS host failed to load or save the package properly.
<hit ok>
DTS Designer Error
The selected package cannot be opened. The DTS Designer has been closed.
<hit ok>
SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)
<hit ok>
it takes me to the dts designer (it doesn't close it like it says) and all of the icons in the workspace look like a default windows form icon. I can click on each of them to get the properties, transformations, etc. But I dare not save them.

Any idea how to fix this? Or am I not supposed to be able to manage SQL 2000 instances with this tool.

|||I'm experiencing the very same problem. It occurs even if you right-click on Data Transformation Services and select Open package file..., so it's not a server instance issue. Perhaps it requires the latest MDAC and/or SQL Server Native Client to be installed on the accessed server? Feels a bit buggy to me.|||The designer download does require MDAC 2.6 sp2 or newer, but you're likely to have that already.

-Doug
|||Can we install the SQL Native Client on a SQL2000 box? would that make any difference to the Management Studio?
|||You can install SNAC on SQL 2000 machines, after all that is what happens in side by side installations of SQL 2000 and SQL2005, but it is not requrired for DTS.

I can happily edit most 2000 packages (through the web download designer) on a clean SQL 2005 machine, pointing at an existing SQL 2000 instance. Sometimes I get invalid class string errors, since the SQL 2005 machine lacks some custom tasks I used with DTS. I do sometimes get a similar error to you, but haven't got around to seeing which components are used in a good package and a problem package. I suspect there may be a problem task. AS processing tasks gave some problems, but I skipped around it and haven't had time to work it yet.|||

After uninstalling the entire CTP (including the beta .NET framework) and reinstalling SQL 2005 enterprise I also downloaded and installed the S2k DTS designer web pack.

Now I can't create or save DTS packages in SQL 2000 without getting the same error. In SQL 2005 using the legacy designer I get mixed results.
So I created a new and very simple DTS package on a different (and clean) SQL 2000 machine that has never had SQL 2005 components installed. It worked fine on the SQL 2000 machine. But when I try to open it using the SQL 2005 designer that I downloaded I get the same annoying error. HOWEVER, certain older packages from that same clean SQL 2000 server CAN be edited and saved using the SQL 2005 designer.

This is WAY buggy. Am I missing a download? What about the backwards-compatible pack I saw with all of the (daunting) SQL 2005 downloads? Is there a sequence to doing this? Do I need to fully uninstall all SQL 2000 components first? Can I then reinstall them?

|||

I'm having the same problem. I never had SQL Server 2000 installed, I installed SQL Server 2005 & Visual Studio 2005, then the SQL Server 2000 DTS Designer Component package, but still get error message to install component when trying to open SQL Server 2000 DTS package.

I unintalled SQL Server 2005, then installed SQL Server 2000, ran Enterprise Manager ok, then installed SQL Server 2005, and then SQL 2000 Enterprise Manager will not run now, then installed DTS Component package, and still get same error message to install component when trying to open SQL Server 2000 DTS package.

Tom E.

|||

I get exactly the same errors and here's what I found... After trying to migrate a DTS package that failed to open I got a somewhat more informative error message out of the report. It stated that the package name cannot contain any of the following characters: / \ : [ ] . =.

It so happens many of my packages have ':', '.' in the names and so apparently they have changed this aspect as well (thanks Bill for the lack of documentation). Anyhow, after renaming the packages I was able to open them (still with errors but it worked) and migrate them. What a pain in the a**!!!

Hope this helps...

|||

I was also having same problem

error message was

SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)

The resolution

First download and install SQLServer2005_BC component for backward compatibility from microsoft

Then Install SQLServer2005_DTS component.

http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en)

It should work.In my case it was successfully leting me edit DTS package developed in SQL Server 2000 version

Thankx

|||

So what is the correct anwer here. It looks like it works for some but not for others. I happen to be one of the others that this does not work for. I've been working with a new box, clean install of the latest and greatest. ( a number of times, by the way. )

Sorry, but this is driving me nuts. Microsoft Support where are you?

|||

Scott,

There is no documented resolution from Microsoft that these forums will be frequented by MS staff.

You should seek support via your MSDN subscription and then PSS as far as I know.

-Jamie

|||

In case somebody else still experience the same problems...

I found help at:

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

-duke63

|||

Sometimes happen the same and even only appears the arrows. I had a lot of problems with this messing up my Sql2k Entreprise Manager.