MS SQL Server 2000 Enterprise Edition installation error

My laptop has VS 2005 installed. I am trying to install MS SQL Server 2000 Enterprise Edition, when i run "install database components", it gave error: "MS SQL Server 2000 Enterprise Edition component is not supported on this operating system. Only client components will be available for installation". then when i click on "ok", then "next", when i click on "next" on the "computer name" page, it gave another error: "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup". I restarted my laptop following the instruction, but same thing happened when i run the installation. Plz help

Enterprise edition will only install on Server Operating systems, so it won't install on XP.

Any application can set a pending reboot flag in the operating system through a registry key. Sometimes a reboot does not clear the flag. This is what setup is detecting.

To work around the pending reboot issue:
1/ Open Regedit
2/ Find the key "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager"
3/ Rename the "PendingFileRenameOperations" value to "PendingFileRenameOperations2"

|||

thx Jeffery for the quick reply, I was able to install the client components by following your instruction. thx for your help and good luck for 2006 :)

|||Really this was helped very much after changing the registry smoothly sql 2000 installed and working smoothly , thanks ton.|||I've checked that registry location and can't find the listed key in the path listed. Yet, the error persists. I'd love to solve this. If I do I'll edit this post if I can with the results.|||

hi Bob, when u go to "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager", just click on the "Session Manager" folder on the left hand side treeview, then u will find "PendingFileRenameOperations"

|||

I understand what I'm looking for but it's not there at all. There is no 'PendingFileRenameOperations' folder under Session Manager.

I've even did a 'find' for 'PendingFileRenameOperations'. It returned an entry under HKLM\System\ControlSet001\Control\BackupRestore\KeysNotToRestore.

I checked another XP Pro machine I have an it doesn't have the key either.

Got any other clues?

Thanks for your help

|||'PendingFileRenameOperations' is not a folder, it's just a value name. when u left-click on the Session Manager folder on the left, there will be a list shown on the right, u can find the 'PendingFileRenameOperations' in the list.|||

I can't find it as a value in SessionManager or as a folder or anywhere other than in the location indicated above. It's just not there.

I can't seem to find it anywhere. So, I guess what I'm saying is that since it is not 'required' (which it seems to the case since renaming it allows the SQL server to install) and I don't have one, why is it still that I can't install?

|||

Well, that is only for the error "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup".

Is that what you are seeing? If not, could you start a *different* thread describing the error that you are seeing?

|||I'm sorry. I checked the KB and these two errors seemed to be lumpped together. I'll start another thread.|||This was a fantastic help! I had this same problem and tried all sorts to solve.
This worked a treat! Cheers :)|||

Thank you, Thank you. This solved my problem. I'm so glad I found you and this posting on Microsoft TechNet. I wasn't even sure how to describe this problem, but am so thankful for your help.

Now, I can finish installing SQL Server and the upgrade Service Packs. Thanks again.

Gary

|||gracias...|||I have tried to change the name of the file in the regedit and I am still receiving the same error that a previous program installtion created pending file operations on the installation machine. You must restart computer before running setup. What do I do now? i ahve restarted 3 times.

MS SQL Server 2000 Enterprise Edition installation error

My laptop has VS 2005 installed. I am trying to install MS SQL Server 2000 Enterprise Edition, when i run "install database components", it gave error: "MS SQL Server 2000 Enterprise Edition component is not supported on this operating system. Only client components will be available for installation". then when i click on "ok", then "next", when i click on "next" on the "computer name" page, it gave another error: "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup". I restarted my laptop following the instruction, but same thing happened when i run the installation. Plz help

Enterprise edition will only install on Server Operating systems, so it won't install on XP.

Any application can set a pending reboot flag in the operating system through a registry key. Sometimes a reboot does not clear the flag. This is what setup is detecting.

To work around the pending reboot issue:
1/ Open Regedit
2/ Find the key "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager"
3/ Rename the "PendingFileRenameOperations" value to "PendingFileRenameOperations2"

|||

thx Jeffery for the quick reply, I was able to install the client components by following your instruction. thx for your help and good luck for 2006 :)

|||Really this was helped very much after changing the registry smoothly sql 2000 installed and working smoothly , thanks ton.|||I've checked that registry location and can't find the listed key in the path listed. Yet, the error persists. I'd love to solve this. If I do I'll edit this post if I can with the results.|||

hi Bob, when u go to "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager", just click on the "Session Manager" folder on the left hand side treeview, then u will find "PendingFileRenameOperations"

|||

I understand what I'm looking for but it's not there at all. There is no 'PendingFileRenameOperations' folder under Session Manager.

I've even did a 'find' for 'PendingFileRenameOperations'. It returned an entry under HKLM\System\ControlSet001\Control\BackupRestore\KeysNotToRestore.

I checked another XP Pro machine I have an it doesn't have the key either.

Got any other clues?

Thanks for your help

|||'PendingFileRenameOperations' is not a folder, it's just a value name. when u left-click on the Session Manager folder on the left, there will be a list shown on the right, u can find the 'PendingFileRenameOperations' in the list.|||

I can't find it as a value in SessionManager or as a folder or anywhere other than in the location indicated above. It's just not there.

I can't seem to find it anywhere. So, I guess what I'm saying is that since it is not 'required' (which it seems to the case since renaming it allows the SQL server to install) and I don't have one, why is it still that I can't install?

|||

Well, that is only for the error "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup".

Is that what you are seeing? If not, could you start a *different* thread describing the error that you are seeing?

|||I'm sorry. I checked the KB and these two errors seemed to be lumpped together. I'll start another thread.|||This was a fantastic help! I had this same problem and tried all sorts to solve.

This worked a treat! Cheers :)|||

Thank you, Thank you. This solved my problem. I'm so glad I found you and this posting on Microsoft TechNet. I wasn't even sure how to describe this problem, but am so thankful for your help.

Now, I can finish installing SQL Server and the upgrade Service Packs. Thanks again.

Gary

|||gracias...|||I have tried to change the name of the file in the regedit and I am still receiving the same error that a previous program installtion created pending file operations on the installation machine. You must restart computer before running setup. What do I do now? i ahve restarted 3 times.

MS SQL Server 2000 Enterprise Edition installation error

My laptop has VS 2005 installed. I am trying to install MS SQL Server 2000 Enterprise Edition, when i run "install database components", it gave error: "MS SQL Server 2000 Enterprise Edition component is not supported on this operating system. Only client components will be available for installation". then when i click on "ok", then "next", when i click on "next" on the "computer name" page, it gave another error: "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup". I restarted my laptop following the instruction, but same thing happened when i run the installation. Plz help

Enterprise edition will only install on Server Operating systems, so it won't install on XP.

Any application can set a pending reboot flag in the operating system through a registry key. Sometimes a reboot does not clear the flag. This is what setup is detecting.

To work around the pending reboot issue:
1/ Open Regedit
2/ Find the key "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager"
3/ Rename the "PendingFileRenameOperations" value to "PendingFileRenameOperations2"

|||

thx Jeffery for the quick reply, I was able to install the client components by following your instruction. thx for your help and good luck for 2006 :)

|||Really this was helped very much after changing the registry smoothly sql 2000 installed and working smoothly , thanks ton.|||I've checked that registry location and can't find the listed key in the path listed. Yet, the error persists. I'd love to solve this. If I do I'll edit this post if I can with the results.|||

hi Bob, when u go to "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager", just click on the "Session Manager" folder on the left hand side treeview, then u will find "PendingFileRenameOperations"

|||

I understand what I'm looking for but it's not there at all. There is no 'PendingFileRenameOperations' folder under Session Manager.

I've even did a 'find' for 'PendingFileRenameOperations'. It returned an entry under HKLM\System\ControlSet001\Control\BackupRestore\KeysNotToRestore.

I checked another XP Pro machine I have an it doesn't have the key either.

Got any other clues?

Thanks for your help

|||'PendingFileRenameOperations' is not a folder, it's just a value name. when u left-click on the Session Manager folder on the left, there will be a list shown on the right, u can find the 'PendingFileRenameOperations' in the list.|||

I can't find it as a value in SessionManager or as a folder or anywhere other than in the location indicated above. It's just not there.

I can't seem to find it anywhere. So, I guess what I'm saying is that since it is not 'required' (which it seems to the case since renaming it allows the SQL server to install) and I don't have one, why is it still that I can't install?

|||

Well, that is only for the error "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup".

Is that what you are seeing? If not, could you start a *different* thread describing the error that you are seeing?

|||I'm sorry. I checked the KB and these two errors seemed to be lumpped together. I'll start another thread.|||This was a fantastic help! I had this same problem and tried all sorts to solve.
This worked a treat! Cheers :)|||

Thank you, Thank you. This solved my problem. I'm so glad I found you and this posting on Microsoft TechNet. I wasn't even sure how to describe this problem, but am so thankful for your help.

Now, I can finish installing SQL Server and the upgrade Service Packs. Thanks again.

Gary

|||gracias...|||I have tried to change the name of the file in the regedit and I am still receiving the same error that a previous program installtion created pending file operations on the installation machine. You must restart computer before running setup. What do I do now? i ahve restarted 3 times.

MS SQL Server 2000 Enterprise Edition installation error

My laptop has VS 2005 installed. I am trying to install MS SQL Server 2000 Enterprise Edition, when i run "install database components", it gave error: "MS SQL Server 2000 Enterprise Edition component is not supported on this operating system. Only client components will be available for installation". then when i click on "ok", then "next", when i click on "next" on the "computer name" page, it gave another error: "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup". I restarted my laptop following the instruction, but same thing happened when i run the installation. Plz help

Enterprise edition will only install on Server Operating systems, so it won't install on XP.

Any application can set a pending reboot flag in the operating system through a registry key. Sometimes a reboot does not clear the flag. This is what setup is detecting.

To work around the pending reboot issue:
1/ Open Regedit
2/ Find the key "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager"
3/ Rename the "PendingFileRenameOperations" value to "PendingFileRenameOperations2"

|||

thx Jeffery for the quick reply, I was able to install the client components by following your instruction. thx for your help and good luck for 2006 :)

|||Really this was helped very much after changing the registry smoothly sql 2000 installed and working smoothly , thanks ton.|||I've checked that registry location and can't find the listed key in the path listed. Yet, the error persists. I'd love to solve this. If I do I'll edit this post if I can with the results.|||

hi Bob, when u go to "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager", just click on the "Session Manager" folder on the left hand side treeview, then u will find "PendingFileRenameOperations"

|||

I understand what I'm looking for but it's not there at all. There is no 'PendingFileRenameOperations' folder under Session Manager.

I've even did a 'find' for 'PendingFileRenameOperations'. It returned an entry under HKLM\System\ControlSet001\Control\BackupRestore\KeysNotToRestore.

I checked another XP Pro machine I have an it doesn't have the key either.

Got any other clues?

Thanks for your help

|||'PendingFileRenameOperations' is not a folder, it's just a value name. when u left-click on the Session Manager folder on the left, there will be a list shown on the right, u can find the 'PendingFileRenameOperations' in the list.|||

I can't find it as a value in SessionManager or as a folder or anywhere other than in the location indicated above. It's just not there.

I can't seem to find it anywhere. So, I guess what I'm saying is that since it is not 'required' (which it seems to the case since renaming it allows the SQL server to install) and I don't have one, why is it still that I can't install?

|||

Well, that is only for the error "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup".

Is that what you are seeing? If not, could you start a *different* thread describing the error that you are seeing?

|||I'm sorry. I checked the KB and these two errors seemed to be lumpped together. I'll start another thread.|||This was a fantastic help! I had this same problem and tried all sorts to solve.

This worked a treat! Cheers :)|||

Thank you, Thank you. This solved my problem. I'm so glad I found you and this posting on Microsoft TechNet. I wasn't even sure how to describe this problem, but am so thankful for your help.

Now, I can finish installing SQL Server and the upgrade Service Packs. Thanks again.

Gary

|||gracias...|||I have tried to change the name of the file in the regedit and I am still receiving the same error that a previous program installtion created pending file operations on the installation machine. You must restart computer before running setup. What do I do now? i ahve restarted 3 times.sql

MS SQL Parts Database

I am a newbie to the world of SQL Server and I am trying to develop a parts database for computer components. I need tables for each component type (mobo, cpu, memory, hard drives etc.) but I also want to show relation between compatible components (i.e. sata harddrives for mobos that support sata as an example) in my queries and stored views so that if a user selected a Motherboard they can recieve a list of compatible components with that Motherboard. So far I have setup tables for each component, each table has a comp_id (where comp is the component type) and I have a comp_type_id table that stores all of the component id's. Each component table's comp_id column is the primary key relating to the comp_type_id table (which has the foreign key. Is this the way to go or am I completly out of the ball park. Any suggestions or guidence will be greatly apprieciated.I'd recomment NOT creating separate tables for each component. That would be a nightmare to maintain.

Instead, create a single table for storing all components and assigne each component a unique ID. Then have a second table for storing compatibilities with two fields as the primary key: Comp_ID and Compatible_Comp_ID.

This is an ambitious project, and your real challenge will be getting people to enter data religiously. You may think you are making the database more powerful by adding functionality, but you may end up making it such a pain to use and update that the data is never reliable. Just a word to the wise: keep it simple!

blindman|||I see what you mean. I will work that idea out on paper. What kind of index would you use on a table that massive? Also, how do I indicate two primary keys for one table.

Thank you for your suggestions|||You are not assigning two primary keys. You can only have one primary key (the clustered index) because this dictates the order that the data is actually stored in SQL server. Other keys (non-clustered indexes) are stored as separate invisible tables that contain pointers to your actual data. This is why they are slightly slower than clustered indexes in queries, and they also take up additional space.

What you need to do is make the clustered index contain both fields. You can do this easily in Enterprise manager's table designer by selecting both fields and then clicking on the KEY icon.

Some people create a single compound keyfield by concatenating the data from both fields into a third field, but I would recommend against this for a lot of reasons.

As far as the kind of index to use, I like UniqueIdentifers, which are GUIDs (Globally unique IDs). They aren't the shortest type of ID, and they are no fun to type in, but they are efficient and ensure that if you ever have to merge data from multiple databases (production, test, backup, etc) you won't have to worry about duplicate data.

Since you are creating a parts database, I doubt you are going to be dealing with millions of rows of data, so the efficiency of the index is not nearly as important as the functionality and clarity of the design.

blindman

MS SQL C# Extended Stored Procedures

Hello, I have wiriten several components in c# that do some simple HTML manupilation. I was wondering if it is possible to make these c# components into extended stored procedures? From my understanding an extended stored procedure must support several methods so that MS SQL can interact with it ... is there a template in c# for making extended stored procedures ... is it even possible. Thanks in advance.I think if you made a [URL=http://www.dnzone.com/ShowDetail.asp?NewsId=126] com callable wrapper [/url] it would work.