disk crash and dwh recover

hi everybody.
A customer of mine has had a disk "crash" few days ago.
I wrote for him a dwh application and
of course the backup was not working...
now some "hardware guys" said that it is possible to recover most of
the files.
what I need to restore would be:
1- the sql server db
2- the sql server dts and jobs
3- the analysis service cube and dimensions
to do so is it enough for me to have:
1- the .mdf and .ldf files
2- the master.mdl /.ldf file
3- the .odb file and .dim* and .role .map ... files
right?
is it enough to recover everything?
if it is so, what would be the right processes to recover everything?
any help greatly appreciated!No RAID and no backups? So this data warehouse is really just a bunch of
data dumped on someone's PC with a few reports tacked onto it? ;-)
Assuming the hardware gurus can actually recover the .mdb (data) files
intact, they can be reattached once the SQL Server box is re-installed. The
.ldf files are the transaction logs, and in a bulk loaded data warehouse,
restoring these may not be important.
http://msdn2.microsoft.com/en-us/library/ms190794.aspx
http://support.microsoft.com/defaul...kb;en-us;224071
What will be a pain is restoring or re-building the master database and how
this affects logins/users for the user database(s). However, unlike
operational databases, most data warehousing databases only have a limited
number of users or profiles (ex: Admin and Reporting), so perhaps this won't
be too much of a deal.
Rebuilding the master Database:
http://msdn.microsoft.com/library/d... />
t_0cvm.asp
User logons and permissions on a database may be incorrect after the
database is restored:
http://support.microsoft.com/defaul...kb;en-us;168001
As for restoring the Analysis Services cubes, I assume you at least have a
backup of the development system which can be restored to production. OLAP
data is typically just derived and aggregated, so once AS is re-installed
and the cube files restored, just re-process and they will be re-loaded from
the source data warehouse tables.
Microsoft SQL Server 2000 Analysis Services Operations Guide:
http://www.microsoft.com/technet/pr...n/anservog.mspx
"ilkaos" <c.caoduro@.gmail.com> wrote in message
news:1138637846.479954.273090@.f14g2000cwb.googlegroups.com...
> hi everybody.
> A customer of mine has had a disk "crash" few days ago.
> I wrote for him a dwh application and
> of course the backup was not working...
> now some "hardware guys" said that it is possible to recover most of
> the files.
> what I need to restore would be:
> 1- the sql server db
> 2- the sql server dts and jobs
> 3- the analysis service cube and dimensions
> to do so is it enough for me to have:
> 1- the .mdf and .ldf files
> 2- the master.mdl /.ldf file
> 3- the .odb file and .dim* and .role .map ... files
> right?
> is it enough to recover everything?
> if it is so, what would be the right processes to recover everything?
> any help greatly appreciated!
>|||
> No RAID and no backups? So this data warehouse is really just a bunch of
> data dumped on someone's PC with a few reports tacked onto it? ;-)
>
kind of...it was my first attempt with analysis service and it did a
"little but good" job..

> Assuming the hardware gurus can actually recover the .mdb (data) files
> intact, they can be reattached once the SQL Server box is re-installed.
The
> .ldf files are the transaction logs, and in a bulk loaded data warehouse,
> restoring these may not be important.
> http://msdn2.microsoft.com/en-us/library/ms190794.aspx
> http://support.microsoft.com/defaul...kb;en-us;224071
I thought so

> What will be a pain is restoring or re-building the master database and
how
> this affects logins/users for the user database(s). However, unlike
> operational databases, most data warehousing databases only have a limited
> number of users or profiles (ex: Admin and Reporting), so perhaps this
won't
> be too much of a deal.
> Rebuilding the master Database:
>
http://msdn.microsoft.com/library/d... />
t_0cvm.asp
in fact there are no particular users or profiles

> User logons and permissions on a database may be incorrect after the
> database is restored:
> http://support.microsoft.com/defaul...kb;en-us;168001
I see...

> As for restoring the Analysis Services cubes, I assume you at least have a
> backup of the development system which can be restored to production. OLAP
> data is typically just derived and aggregated, so once AS is re-installed
> and the cube files restored, just re-process and they will be re-loaded
from
> the source data warehouse tables.
> Microsoft SQL Server 2000 Analysis Services Operations Guide:
>
http://www.microsoft.com/technet/pr...n/anservog.mspx
>
sorry but I do not understand what you mean with a "backup of the
development system which can be restored to production".
As I wrote in my previous message I can have back the files tjat were in the
..\analysis service\* folder...
in any case thanks a lot for your answer, it is a great help!
ciao.sql

Discrepancy in number of rows and size of database

I'm trying to help a customer extract some data out of their SQL Server
database and am confused as to what I see.
First of all, this is my second day working with MS SQL Server so I'm not at
all up to speed on it as I am with other RDBMs.
This database is almost a gigabyte is size. There are roughly 25 user
tables in it. None of these tables have more than 250 records and none of
these records are very large.
According to the customer they thousands of records when they run the
application tha tuses this database. But I don't see them.
Could they be under a different owner? I see all of the "DBO" owned tables.
Unfortunately this customer doesn't have any documentation on the system and
the consultant who sold the system to them is long gone.
Any ideas?
TIA
Scott Huerta
Distinctive Solutions
Scott,
Database has reserved space, it does not have to be full. So I guess this is
the discrepancy you see.
If you are a member of the sysadmin role, you see all objects, no matter of
owner.
Where are the missing rows? I don't know. Check the Profiler tool in Books
OnLine, with this tool you can catch all commands SQL Server is receiving.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Scott Huerta" <Scott Huerta@.discussions.microsoft.com> wrote in message
news:EDE920CD-F82C-48BC-AA10-FC5885BCC4D3@.microsoft.com...
> I'm trying to help a customer extract some data out of their SQL Server
> database and am confused as to what I see.
> First of all, this is my second day working with MS SQL Server so I'm not
at
> all up to speed on it as I am with other RDBMs.
> This database is almost a gigabyte is size. There are roughly 25 user
> tables in it. None of these tables have more than 250 records and none of
> these records are very large.
> According to the customer they thousands of records when they run the
> application tha tuses this database. But I don't see them.
> Could they be under a different owner? I see all of the "DBO" owned
tables.
> Unfortunately this customer doesn't have any documentation on the system
and
> the consultant who sold the system to them is long gone.
> Any ideas?
> TIA
> Scott Huerta
> Distinctive Solutions
|||Thanks for the reply Dejan.
How do I make sure that I'm a member of the SysAdmin role? I think I might
already be as I can see system (i.e. "SYS...") tables and objects.
"Dejan Sarka" wrote:

> Scott,
> Database has reserved space, it does not have to be full. So I guess this is
> the discrepancy you see.
> If you are a member of the sysadmin role, you see all objects, no matter of
> owner.
> Where are the missing rows? I don't know. Check the Profiler tool in Books
> OnLine, with this tool you can catch all commands SQL Server is receiving.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Scott Huerta" <Scott Huerta@.discussions.microsoft.com> wrote in message
> news:EDE920CD-F82C-48BC-AA10-FC5885BCC4D3@.microsoft.com...
> at
> tables.
> and
>
>
|||try sp_helpsrvrolemember @.srvrolename = 'sysadmin'
Bob Castleman
SuccessWare Software
"Scott Huerta" <Scott Huerta@.discussions.microsoft.com> wrote in message
news:76B2BB80-962A-4AE3-805A-3240D8EC5BCE@.microsoft.com...
> Thanks for the reply Dejan.
> How do I make sure that I'm a member of the SysAdmin role? I think I
> might
> already be as I can see system (i.e. "SYS...") tables and objects.
>

Discrepancy in number of rows and size of database

I'm trying to help a customer extract some data out of their SQL Server
database and am confused as to what I see.
First of all, this is my second day working with MS SQL Server so I'm not at
all up to speed on it as I am with other RDBMs.
This database is almost a gigabyte is size. There are roughly 25 user
tables in it. None of these tables have more than 250 records and none of
these records are very large.
According to the customer they thousands of records when they run the
application tha tuses this database. But I don't see them.
Could they be under a different owner? I see all of the "DBO" owned tables.
Unfortunately this customer doesn't have any documentation on the system and
the consultant who sold the system to them is long gone.
Any ideas?
TIA
Scott Huerta
Distinctive SolutionsScott,
Database has reserved space, it does not have to be full. So I guess this is
the discrepancy you see.
If you are a member of the sysadmin role, you see all objects, no matter of
owner.
Where are the missing rows? I don't know. Check the Profiler tool in Books
OnLine, with this tool you can catch all commands SQL Server is receiving.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Scott Huerta" <Scott Huerta@.discussions.microsoft.com> wrote in message
news:EDE920CD-F82C-48BC-AA10-FC5885BCC4D3@.microsoft.com...
> I'm trying to help a customer extract some data out of their SQL Server
> database and am confused as to what I see.
> First of all, this is my second day working with MS SQL Server so I'm not
at
> all up to speed on it as I am with other RDBMs.
> This database is almost a gigabyte is size. There are roughly 25 user
> tables in it. None of these tables have more than 250 records and none of
> these records are very large.
> According to the customer they thousands of records when they run the
> application tha tuses this database. But I don't see them.
> Could they be under a different owner? I see all of the "DBO" owned
tables.
> Unfortunately this customer doesn't have any documentation on the system
and
> the consultant who sold the system to them is long gone.
> Any ideas?
> TIA
> Scott Huerta
> Distinctive Solutions|||Thanks for the reply Dejan.
How do I make sure that I'm a member of the SysAdmin role? I think I might
already be as I can see system (i.e. "SYS...") tables and objects.
"Dejan Sarka" wrote:
> Scott,
> Database has reserved space, it does not have to be full. So I guess this is
> the discrepancy you see.
> If you are a member of the sysadmin role, you see all objects, no matter of
> owner.
> Where are the missing rows? I don't know. Check the Profiler tool in Books
> OnLine, with this tool you can catch all commands SQL Server is receiving.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Scott Huerta" <Scott Huerta@.discussions.microsoft.com> wrote in message
> news:EDE920CD-F82C-48BC-AA10-FC5885BCC4D3@.microsoft.com...
> > I'm trying to help a customer extract some data out of their SQL Server
> > database and am confused as to what I see.
> >
> > First of all, this is my second day working with MS SQL Server so I'm not
> at
> > all up to speed on it as I am with other RDBMs.
> >
> > This database is almost a gigabyte is size. There are roughly 25 user
> > tables in it. None of these tables have more than 250 records and none of
> > these records are very large.
> >
> > According to the customer they thousands of records when they run the
> > application tha tuses this database. But I don't see them.
> >
> > Could they be under a different owner? I see all of the "DBO" owned
> tables.
> >
> > Unfortunately this customer doesn't have any documentation on the system
> and
> > the consultant who sold the system to them is long gone.
> >
> > Any ideas?
> >
> > TIA
> >
> > Scott Huerta
> > Distinctive Solutions
>
>|||try sp_helpsrvrolemember @.srvrolename = 'sysadmin'
Bob Castleman
SuccessWare Software
"Scott Huerta" <Scott Huerta@.discussions.microsoft.com> wrote in message
news:76B2BB80-962A-4AE3-805A-3240D8EC5BCE@.microsoft.com...
> Thanks for the reply Dejan.
> How do I make sure that I'm a member of the SysAdmin role? I think I
> might
> already be as I can see system (i.e. "SYS...") tables and objects.
>

Disaster Recovery With SQL 8.0

Hi,
We are trialling a disaster recovery for a new customer who has been assured
his SQL is being backed up and can be recovered with the minimum of fuss. I
immediately found that his Master and Model were not being backed up, not
the end of the world but not what they were expecting either. Anyway, their
SQL is backed up a coupld of times per day via a Maintenance Plan. I have
completely restored his server to a new box and everything, apart from SQL,
is up and running. The situation is, I have the databases in *.bak format,
but because the Master and Model are missing, I cannot start SQL to
re-attach the databases. I have since copied a backup of Master and Model
taken since the original backup, copied them into place and tried to start
the service. No joy. No error. No nothing.
I've hunted high and low to find some documentation for my current scenario,
but not found any. Can somebody please point me in the right direction.
Many thanks
Hi
You can not attach a *.bak file. It's a backup you need to restore it. As
you say you don't need the master and model. However if you have a lot of
individual users with standard accounts it might take a while to get the
master up to date.
Here are some links to a lot of articles about moving/restoring databases to
another server. they should help you understand and resolve your issues.
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases to a
New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission Issues
When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf http://www.support.microsoft.com/?id=307775 Disaster
Recovery Articles for SQL Server
Good Luck
John
|||By the way when i said you don't need to master and model database I did of
course mean you don't need to original. You definately need a master and
model database.
|||"John Bandettini" <JohnBandettini@.discussions.microsoft.com> wrote in
message news:AB7C8416-35B2-4233-8D4B-FE39CC2CCC9F@.microsoft.com...
> Hi
> You can not attach a *.bak file. It's a backup you need to restore it. As
> you say you don't need the master and model. However if you have a lot of
> individual users with standard accounts it might take a while to get the
> master up to date.
> Here are some links to a lot of articles about moving/restoring databases
> to
> another server. they should help you understand and resolve your issues.
> http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
> http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases to
> a
> New Location with Detach/Attach
> http://support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
> http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
> Restore http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 How to Resolve Permission
> Issues
> When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scri...p?scriptid=599
> Restoring a .mdf http://www.support.microsoft.com/?id=307775 Disaster
> Recovery Articles for SQL Server
> Good Luck
> John
Thanks for the reply. A quick look through these, and they all rely on the
SQL server actually starting. My problem is, I can't start it! I've tried
rebuilding the Master but I get a message telling me there are no suitable
instances of SQL available..
|||Hi
I dont have access to your server and i don't know how you restored it, so I
can not comment on those issues. However from my experiences it is very hard
to restore a server including SQL Server files and then get it to work.
You would find it a lot easier to install SQL Server from scratch and then
restore your databases.
What tends to happen when you restore the entire Server is that SQL Server
does not respond well. (As you have found out). Usual reason is that the
backup software cannot backup in-use files. So you have things missing, most
significantly the .mdf and .ldf files.
With copies of the Master and Model and MSDB from another server and a good
bit of hacking into the register you may be able to bring it up, but what
state it would be in I don't know. Not a good one I'm sure.
I would advise you to rebuild the server, Install the operating system and
SQL Server and then follow the articles I first posted. Trying to proceed
from your current position is not going to work.
Regards
John
|||"John Bandettini" <JohnBandettini@.discussions.microsoft.com> wrote in
message news:31C3562B-D4B3-44FA-96AA-C6E8856FFDE3@.microsoft.com...
> Hi
> I dont have access to your server and i don't know how you restored it, so
> I
> can not comment on those issues. However from my experiences it is very
> hard
> to restore a server including SQL Server files and then get it to work.
> You would find it a lot easier to install SQL Server from scratch and then
> restore your databases.
> What tends to happen when you restore the entire Server is that SQL Server
> does not respond well. (As you have found out). Usual reason is that the
> backup software cannot backup in-use files. So you have things missing,
> most
> significantly the .mdf and .ldf files.
> With copies of the Master and Model and MSDB from another server and a
> good
> bit of hacking into the register you may be able to bring it up, but what
> state it would be in I don't know. Not a good one I'm sure.
> I would advise you to rebuild the server, Install the operating system and
> SQL Server and then follow the articles I first posted. Trying to proceed
> from your current position is not going to work.
> Regards
> John
Done it. Managed to get rebuildm.exe working after all kinds of traumas, and
once I had master back in place, it was as easy as I was hoping it would be!
Thanks for you help.
Matt

Disaster Recovery With SQL 8.0

Hi,
We are trialling a disaster recovery for a new customer who has been assured
his SQL is being backed up and can be recovered with the minimum of fuss. I
immediately found that his Master and Model were not being backed up, not
the end of the world but not what they were expecting either. Anyway, their
SQL is backed up a coupld of times per day via a Maintenance Plan. I have
completely restored his server to a new box and everything, apart from SQL,
is up and running. The situation is, I have the databases in *.bak format,
but because the Master and Model are missing, I cannot start SQL to
re-attach the databases. I have since copied a backup of Master and Model
taken since the original backup, copied them into place and tried to start
the service. No joy. No error. No nothing.
I've hunted high and low to find some documentation for my current scenario,
but not found any. Can somebody please point me in the right direction.
Many thanksHi
You can not attach a *.bak file. It's a backup you need to restore it. As
you say you don't need the master and model. However if you have a lot of
individual users with standard accounts it might take a while to get the
master up to date.
Here are some links to a lot of articles about moving/restoring databases to
another server. they should help you understand and resolve your issues.
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases to a
New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission Issues
When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf http://www.support.microsoft.com/?id=307775 Disaster
Recovery Articles for SQL Server
Good Luck
John|||By the way when i said you don't need to master and model database I did of
course mean you don't need to original. You definately need a master and
model database.|||"John Bandettini" <JohnBandettini@.discussions.microsoft.com> wrote in
message news:AB7C8416-35B2-4233-8D4B-FE39CC2CCC9F@.microsoft.com...
> Hi
> You can not attach a *.bak file. It's a backup you need to restore it. As
> you say you don't need the master and model. However if you have a lot of
> individual users with standard accounts it might take a while to get the
> master up to date.
> Here are some links to a lot of articles about moving/restoring databases
> to
> another server. they should help you understand and resolve your issues.
> http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
> http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases to
> a
> New Location with Detach/Attach
> http://support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
> http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
> Restore http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 How to Resolve Permission
> Issues
> When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
> Restoring a .mdf http://www.support.microsoft.com/?id=307775 Disaster
> Recovery Articles for SQL Server
> Good Luck
> John
Thanks for the reply. A quick look through these, and they all rely on the
SQL server actually starting. My problem is, I can't start it! I've tried
rebuilding the Master but I get a message telling me there are no suitable
instances of SQL available..|||Hi
I dont have access to your server and i don't know how you restored it, so I
can not comment on those issues. However from my experiences it is very hard
to restore a server including SQL Server files and then get it to work.
You would find it a lot easier to install SQL Server from scratch and then
restore your databases.
What tends to happen when you restore the entire Server is that SQL Server
does not respond well. (As you have found out). Usual reason is that the
backup software cannot backup in-use files. So you have things missing, most
significantly the .mdf and .ldf files.
With copies of the Master and Model and MSDB from another server and a good
bit of hacking into the register you may be able to bring it up, but what
state it would be in I don't know. Not a good one I'm sure.
I would advise you to rebuild the server, Install the operating system and
SQL Server and then follow the articles I first posted. Trying to proceed
from your current position is not going to work.
Regards
John|||"John Bandettini" <JohnBandettini@.discussions.microsoft.com> wrote in
message news:31C3562B-D4B3-44FA-96AA-C6E8856FFDE3@.microsoft.com...
> Hi
> I dont have access to your server and i don't know how you restored it, so
> I
> can not comment on those issues. However from my experiences it is very
> hard
> to restore a server including SQL Server files and then get it to work.
> You would find it a lot easier to install SQL Server from scratch and then
> restore your databases.
> What tends to happen when you restore the entire Server is that SQL Server
> does not respond well. (As you have found out). Usual reason is that the
> backup software cannot backup in-use files. So you have things missing,
> most
> significantly the .mdf and .ldf files.
> With copies of the Master and Model and MSDB from another server and a
> good
> bit of hacking into the register you may be able to bring it up, but what
> state it would be in I don't know. Not a good one I'm sure.
> I would advise you to rebuild the server, Install the operating system and
> SQL Server and then follow the articles I first posted. Trying to proceed
> from your current position is not going to work.
> Regards
> John
Done it. Managed to get rebuildm.exe working after all kinds of traumas, and
once I had master back in place, it was as easy as I was hoping it would be!
Thanks for you help.
Matt

DisableNetAccess

Windows98 machine and when installing MSDE we (our customer) gets an error
on DisableNetAccess. I have no idea what they should do and I can't find
anything in google with the word disablenetaccess so I'm hoping somebody out
there has some info. Below is the relevant info from the log file when
trying to install.
MSI (c) (F9:49): Executing op:
ActionStart(Name=DisableNetAccess.2D02443E_7002_4C 0B_ABC9_EAB2C064397B,,)
Action 1:56:36: DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.
MSI (c) (F9:49): Executing op:
CustomActionSchedule(Action=DisableNetAccess.2D024 43E_7002_4C0B_ABC9_EAB2C06
4397B,ActionType=1025,Source=BinaryData,Target=Dis ableNetAccess,)
MSI (c) (F9:49): Creating MSIHANDLE (216) of type 790536 for thread -624311
MSI (c) (F9:49): Closing MSIHANDLE (216) of type 790536 for thread -624311
MSI (c) (F9:49): Note: 1: 1723 2:
DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B 3: DisableNetAccess 4:
C:\WINDOWS\TEMP\MSI8240.TMP
Error 1723. There is a problem with this Windows Installer package. A DLL
required for this install to complete could not be run. Contact your support
personnel or package vendor. Action
DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B, entry:
DisableNetAccess, library: C:\WINDOWS\TEMP\MSI8240.TMP
MSI (c) (F9:49): Product: Microsoft SQL Server Desktop Engine -- Error 1723.
There is a problem with this Windows Installer package. A DLL required for
this install to complete could not be run. Contact your support personnel or
package vendor. Action Di
sableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C064397 B, entry:
DisableNetAccess, library: C:\WINDOWS\TEMP\MSI8240.TMP
Action ended 2:00:51: InstallFinalize. Return value 3.
Too hard to tell from the log excerpt. You probably have to know what these log entries mean in detail. And frankly, it looks like a Windows Installer problem.
Some suggestions:
1) Let us know what version of MSDE this is, what other instances have been installed. MSDE 2000A is free and available for download from MS.
2) Check the MS SQL Server 2000 books online for info about Win 98. There will be authetication issues with the OS.
3) Please be sure that your OS has all the latest patches installed.
Lou Arnold
Ottawa, Canada
"Lance Johnson" wrote:

> Windows98 machine and when installing MSDE we (our customer) gets an error
> on DisableNetAccess. I have no idea what they should do and I can't find
> anything in google with the word disablenetaccess so I'm hoping somebody out
> there has some info. Below is the relevant info from the log file when
> trying to install.
> MSI (c) (F9:49): Executing op:
> ActionStart(Name=DisableNetAccess.2D02443E_7002_4C 0B_ABC9_EAB2C064397B,,)
> Action 1:56:36: DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.
> MSI (c) (F9:49): Executing op:
> CustomActionSchedule(Action=DisableNetAccess.2D024 43E_7002_4C0B_ABC9_EAB2C06
> 4397B,ActionType=1025,Source=BinaryData,Target=Dis ableNetAccess,)
> MSI (c) (F9:49): Creating MSIHANDLE (216) of type 790536 for thread -624311
> MSI (c) (F9:49): Closing MSIHANDLE (216) of type 790536 for thread -624311
> MSI (c) (F9:49): Note: 1: 1723 2:
> DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B 3: DisableNetAccess 4:
> C:\WINDOWS\TEMP\MSI8240.TMP
> Error 1723. There is a problem with this Windows Installer package. A DLL
> required for this install to complete could not be run. Contact your support
> personnel or package vendor. Action
> DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B, entry:
> DisableNetAccess, library: C:\WINDOWS\TEMP\MSI8240.TMP
> MSI (c) (F9:49): Product: Microsoft SQL Server Desktop Engine -- Error 1723.
> There is a problem with this Windows Installer package. A DLL required for
> this install to complete could not be run. Contact your support personnel or
> package vendor. Action Di
> sableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C064397 B, entry:
> DisableNetAccess, library: C:\WINDOWS\TEMP\MSI8240.TMP
> Action ended 2:00:51: InstallFinalize. Return value 3.
>
>
|||This is the latest msde version sp3a I believe. So they are installing the
latest. I'll check to make sure they have all the latest patches for
windows. Any other suggestions are welcome.
Thanks,
Lance Johnson
"Lou Arnold" <Lou_Arnold@.nospam.com> wrote in message
news:3AC49276-818A-446B-BEE4-30B8EF2DD695@.microsoft.com...
> Too hard to tell from the log excerpt. You probably have to know what
these log entries mean in detail. And frankly, it looks like a Windows
Installer problem.
> Some suggestions:
> 1) Let us know what version of MSDE this is, what other instances have
been installed. MSDE 2000A is free and available for download from MS.
> 2) Check the MS SQL Server 2000 books online for info about Win 98. There
will be authetication issues with the OS.[vbcol=seagreen]
> 3) Please be sure that your OS has all the latest patches installed.
> --
> Lou Arnold
> Ottawa, Canada
>
> "Lance Johnson" wrote:
error[vbcol=seagreen]
find[vbcol=seagreen]
out[vbcol=seagreen]
ActionStart(Name=DisableNetAccess.2D02443E_7002_4C 0B_ABC9_EAB2C064397B,,)[vbcol=seagreen]
CustomActionSchedule(Action=DisableNetAccess.2D024 43E_7002_4C0B_ABC9_EAB2C06[vbcol=seagreen]
thread -624311[vbcol=seagreen]
thread -624311[vbcol=seagreen]
DisableNetAccess 4:[vbcol=seagreen]
DLL[vbcol=seagreen]
support[vbcol=seagreen]
1723.[vbcol=seagreen]
for[vbcol=seagreen]
personnel or[vbcol=seagreen]