PROBLEM WITH SQL2000

hello..i have a really big problem with SQL2000 installation, i cant install it, some sql,odbc dll and other files left after i reinstalled OS without removing SQL,maybe 4 months ago and still have them in my pc, bought new HDD but they still exist in my pc :/ used full format of HDD but those files still left after all new installation of OS,i tryed to delete them but they appear again,deleted them from DOS but then i had to reinstall OS again coz windows dont started up.. what can i do ? plz help me some1 to solve this problem..i whant to install SQL2000 again but cant ((

hi keisa,

here's something to lighten up your day.

some versions of SQL server cannot be run on every OS

for example:

You cannot install a SQL server 2000 enterprise edition on windows Xp

because enterprise edition requires a windows server.

regards,

joey

|||

you never mentioned the OS. and sql server Edition and service pack.

please post back full info

Madhu

|||This sounds like a development or testing machine, if so why don't you simply refresh the complete installation from operating system to SQL Server.

Problem with SQL Server Managment Studio Express CTP

Hi, I have installed the product in subject but after installation if a click on program to use it, i have no result.

Someone can tell me how i can control why it no work?

The real problem is that it no give me an error code simply the program not start.?!?!?

Thank's for your attention.

By Fabrizio

I find...

When you downloaded the updated Management Studio Express, did you see it take some time to download it again, or did it start immediately? (If it starts immediately, you're running a cached copy of the Windows installer package for SSMSE.)

If you rename the "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell" registry key to "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellX" using regedit, SSMSE should start. This should not affect the stand-alone Books Online at all.

After you rename the registry key and then start Management Studio Express, does the splash Screen say "SQL Server Management Studio Express Edition" or just "Management Studio Express"? The November 11 download says "Management Studio Express."

Problem with SQL Server 2005 Standard Edition installation

Hello,

When I try to install SQL Server 2005 Standard Edition, Windows XP SP2, setup fails.

Please help!!!

This is log file:

..............................

Loaded DLL:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\DbgHelp.dll
Version:
6.5.3.7
MSI (s) (98:E8) [12:19:07:890]: Leaked MSIHANDLE (6010) of type 790531 for thread 2260
MSI (s) (98:E8) [12:19:07:890]: Leaked MSIHANDLE (6009) of type 790540 for thread 2260
MSI (s) (98:E8) [12:19:07:890]: Leaked MSIHANDLE (6008) of type 790541 for thread 2260
MSI (s) (98:E8) [12:19:07:890]: Leaked MSIHANDLE (5973) of type 790541 for thread 2260
MSI (s) (98:E8) [12:19:07:890]: Leaked MSIHANDLE (5970) of type 790531 for thread 2260
MSI (s) (98:E8) [12:19:07:890]: Note: 1: 2769 2: Write_sqlLocalServers.D20239D7_E87C_40C9_9837_E70B8D4882C2 3: 5

Info 2769.The installer has encountered an unexpected error. The error code is 2769. Custom Action Write_sqlLocalServers.D20239D7_E87C_40C9_9837_E70B8D4882C2 did not close 5 MSIHANDLEs.
MSI (s) (98:2C) [12:19:07:890]: Machine policy value 'DisableRollback' is 0
MSI (s) (98:2C) [12:19:07:890]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
Action ended 12:19:07: Write_sqlLocalServers.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.
MSI (s) (98:2C) [12:19:07:890]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (98:2C) [12:19:07:890]: No System Restore sequence number for this installation.
MSI (s) (98:2C) [12:19:07:890]: Unlocking Server
Action ended 12:19:07: INSTALL. Return value 3.
Property(S): ProductCode = {28B22773-100E-4AF2-A1C9-2F2EA8A35844}
Property(S): ProductLanguage = 1033

You did not say what version of XP you are running because you cannot install SQL Server 2005 Standard in XP Home, if you are running Media edition or Pro copy the content of the CDs/DVD into a folder in your C drive and run setup from your C drive. One more thing if you intend to install Reporting Services make sure IIS is running or the installer will skip it without telling you why. Hope this helps.

|||From the error message in the log, it appears that you have a setting on your machine which is preventing the systemstate backup to be rolled back. Check with your network administrator about disabling this setting.|||

I have Windows XP professional. IIS is running. Installation from C is also failed.

May be, I uninstalled incorrectly beta-version of Visual studio 2005 and/or SQL Server 2005.

I uninstalled all components and then cleaned register, but it didn't help.

Thanks.

Gato.

|||

Please comment what setting "is preventing the systemstate backup to be rolled back" , where and how can I check that?

I work without network administrator .

Thanks,

Gato.

|||

Gato wrote:

I have Windows XP professional. IIS is running. Installation from C is also failed.

May be, I uninstalled incorrectly beta-version of Visual studio 2005 and/or SQL Server 2005.

I uninstalled all components and then cleaned register, but it didn't help.

Thanks.

Gato.

Lets start with some WinXP system restore to the last available restore point and copy the files to the C and install from C drive. And I just noticed you are not running the standard setup, because I know the bootstrap setup runs for a short while and terminates. The 2005 installer is very easy I know because I had installed 2000 on all operating systems including 64bits except Vista and it was a pain but installing 2005 was a breeze. Keep me posted and pay attention to the installer don't answer questions not relevant to you.

Problem with Sql Server 2000 installation

Hi,
I'm not able to install Microsoft SQL Server 2000 on a Pentium 4 2.40 GHz
with Microsoft Windows 2003 Server.
The problem is:
I insert my SQL Server installation CD in the player. Main window opens up.
I click on "SQL Server 2000 Components", which brings me to the next window.
I click on "Install Database Server" and then window closes... and then
nothing! If I restart the installation, the same thing occurs.
Someone has an idea of what the problem might be?
Thanks!
David
How long do you wait after the click on Install? I seem to recall something
like this but if I waited long enough the next dialog window eventually came
up
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"GeckoNewsgroup" <gecko@.myToto.com> wrote in message
news:BCD3E3D3.1406%gecko@.myToto.com...
> Hi,
> I'm not able to install Microsoft SQL Server 2000 on a Pentium 4 2.40 GHz
> with Microsoft Windows 2003 Server.
> The problem is:
> I insert my SQL Server installation CD in the player. Main window opens
up.
> I click on "SQL Server 2000 Components", which brings me to the next
window.
> I click on "Install Database Server" and then window closes... and then
> nothing! If I restart the installation, the same thing occurs.
> Someone has an idea of what the problem might be?
> Thanks!
> David
>
|||David,
Please dont multipost.I answered this in.setup.
Dinesh
"GeckoNewsgroup" <gecko@.myToto.com> wrote in message
news:BCD3E3D3.1406%gecko@.myToto.com...
> Hi,
> I'm not able to install Microsoft SQL Server 2000 on a Pentium 4 2.40 GHz
> with Microsoft Windows 2003 Server.
> The problem is:
> I insert my SQL Server installation CD in the player. Main window opens
up.
> I click on "SQL Server 2000 Components", which brings me to the next
window.
> I click on "Install Database Server" and then window closes... and then
> nothing! If I restart the installation, the same thing occurs.
> Someone has an idea of what the problem might be?
> Thanks!
> David
>

Problem with Sql Server 2000 installation

Hi,
I'm not able to install Microsoft SQL Server 2000 on a Pentium 4 2.40 GHz
with Microsoft Windows 2003 Server.
The problem is:
I insert my SQL Server installation CD in the player. Main window opens up.
I click on "SQL Server 2000 Components", which brings me to the next window.
I click on "Install Database Server" and then window closes... and then
nothing! If I restart the installation, the same thing occurs.
Someone has an idea of what the problem might be?
Thanks!
DavidHow long do you wait after the click on Install? I seem to recall something
like this but if I waited long enough the next dialog window eventually came
up
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"GeckoNewsgroup" <gecko@.myToto.com> wrote in message
news:BCD3E3D3.1406%gecko@.myToto.com...
> Hi,
> I'm not able to install Microsoft SQL Server 2000 on a Pentium 4 2.40 GHz
> with Microsoft Windows 2003 Server.
> The problem is:
> I insert my SQL Server installation CD in the player. Main window opens
up.
> I click on "SQL Server 2000 Components", which brings me to the next
window.
> I click on "Install Database Server" and then window closes... and then
> nothing! If I restart the installation, the same thing occurs.
> Someone has an idea of what the problem might be?
> Thanks!
> David
>|||David,
Please dont multipost.I answered this in.setup.
--
Dinesh
"GeckoNewsgroup" <gecko@.myToto.com> wrote in message
news:BCD3E3D3.1406%gecko@.myToto.com...
> Hi,
> I'm not able to install Microsoft SQL Server 2000 on a Pentium 4 2.40 GHz
> with Microsoft Windows 2003 Server.
> The problem is:
> I insert my SQL Server installation CD in the player. Main window opens
up.
> I click on "SQL Server 2000 Components", which brings me to the next
window.
> I click on "Install Database Server" and then window closes... and then
> nothing! If I restart the installation, the same thing occurs.
> Someone has an idea of what the problem might be?
> Thanks!
> David
>sql

Problem with Sql Server 2000 installation

Hi,
I'm not able to install Microsoft SQL Server 2000 on a Pentium 4 2.40 GHz
with Microsoft Windows 2003 Server.
The problem is:
I insert my SQL Server installation CD in the player. Main window opens up.
I click on "SQL Server 2000 Components", which brings me to the next window.
I click on "Install Database Server" and then window closes... and then
nothing! If I restart the installation, the same thing occurs.
Someone has an idea of what the problem might be?
Thanks!
DavidHow long do you wait after the click on Install? I seem to recall something
like this but if I waited long enough the next dialog window eventually came
up
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"GeckoNewsgroup" <gecko@.myToto.com> wrote in message
news:BCD3E3D3.1406%gecko@.myToto.com...
> Hi,
> I'm not able to install Microsoft SQL Server 2000 on a Pentium 4 2.40 GHz
> with Microsoft Windows 2003 Server.
> The problem is:
> I insert my SQL Server installation CD in the player. Main window opens
up.
> I click on "SQL Server 2000 Components", which brings me to the next
window.
> I click on "Install Database Server" and then window closes... and then
> nothing! If I restart the installation, the same thing occurs.
> Someone has an idea of what the problem might be?
> Thanks!
> David
>|||David,
Please dont multipost.I answered this in.setup.
Dinesh
"GeckoNewsgroup" <gecko@.myToto.com> wrote in message
news:BCD3E3D3.1406%gecko@.myToto.com...
> Hi,
> I'm not able to install Microsoft SQL Server 2000 on a Pentium 4 2.40 GHz
> with Microsoft Windows 2003 Server.
> The problem is:
> I insert my SQL Server installation CD in the player. Main window opens
up.
> I click on "SQL Server 2000 Components", which brings me to the next
window.
> I click on "Install Database Server" and then window closes... and then
> nothing! If I restart the installation, the same thing occurs.
> Someone has an idea of what the problem might be?
> Thanks!
> David
>

Problem with SP4 installation and REPLSYS.SQL

I have a SQLServer 2000 SP3 running on Windows Server 2000 SP4. My
installation has 5 named instances. I was able to install SQLServer SP4
onto 4 of the named instances with out any problem. When I installed the
SP4 update I was logged on as the local administrator and used Windows
authentication.
When I attempted the install on the last instance, it failed running the
REPLSYS.SQL script. After some digging I found the REPLSYS.OUT file and it
told me that the error was with procedure sp_addextendedproc in the master
db. The script tried to execute the following command:
sp_addextendedproc 'xp_mergexpusage', 'xprepl.dll'
The error says that there is already an object named 'xp_mergexpusage' in
the database.
I have looked at the list of extended stored procedures listed in the Master
DB and I cannot see the xp_mergexpusage stored procedure anywhere. Is it
hidden somehow? I can see the stored procedure in the other instances that
were sucessfully updated but not in the instance that fails.
Has anyone else run into this problem when installing SP4?
Is there a way to attempt a delete of the xp_mergexpusage extended stored
procedure incase it is hidden somehow?
Any help would be greatly appreciated.
Greg Pagan
I found the answer to this issue myself.
Turns out the problem had nothing to do with SP4 at all. It just pointed
out the underlying issue.
I had corruption in the master data base that somehow messed with the
DBI_NextID. The value of that indicator was out of sync with the max(ID)
indicator. The DB_NextID as less than the Max(ID) which was telling the
system that the object already existed. The fix which came from
sqlforums.windowsitpro.com is to generate new DB_NextIDs by creating and
droping simple tables in master until the counter for DB_NextID grows larger
than max(ID). It took me over 700 table creates to get to that point.
After that the SP4 Update ran successfully.
Thanks anyway.
"Greg Pagan" <gpagan@.thehartford.com> wrote in message
news:O%23CHMX3VGHA.5692@.TK2MSFTNGP09.phx.gbl...
>I have a SQLServer 2000 SP3 running on Windows Server 2000 SP4. My
>installation has 5 named instances. I was able to install SQLServer SP4
>onto 4 of the named instances with out any problem. When I installed the
>SP4 update I was logged on as the local administrator and used Windows
>authentication.
> When I attempted the install on the last instance, it failed running the
> REPLSYS.SQL script. After some digging I found the REPLSYS.OUT file and
> it told me that the error was with procedure sp_addextendedproc in the
> master db. The script tried to execute the following command:
> sp_addextendedproc 'xp_mergexpusage', 'xprepl.dll'
> The error says that there is already an object named 'xp_mergexpusage' in
> the database.
> I have looked at the list of extended stored procedures listed in the
> Master DB and I cannot see the xp_mergexpusage stored procedure anywhere.
> Is it hidden somehow? I can see the stored procedure in the other
> instances that were sucessfully updated but not in the instance that
> fails.
> Has anyone else run into this problem when installing SP4?
> Is there a way to attempt a delete of the xp_mergexpusage extended stored
> procedure incase it is hidden somehow?
> Any help would be greatly appreciated.
> Greg Pagan
>
>

Problem with SP4 installation and REPLSYS.SQL

I have a SQLServer 2000 SP3 running on Windows Server 2000 SP4. My
installation has 5 named instances. I was able to install SQLServer SP4
onto 4 of the named instances with out any problem. When I installed the
SP4 update I was logged on as the local administrator and used Windows
authentication.
When I attempted the install on the last instance, it failed running the
REPLSYS.SQL script. After some digging I found the REPLSYS.OUT file and it
told me that the error was with procedure sp_addextendedproc in the master
db. The script tried to execute the following command:
sp_addextendedproc 'xp_mergexpusage', 'xprepl.dll'
The error says that there is already an object named 'xp_mergexpusage' in
the database.
I have looked at the list of extended stored procedures listed in the Master
DB and I cannot see the xp_mergexpusage stored procedure anywhere. Is it
hidden somehow? I can see the stored procedure in the other instances that
were sucessfully updated but not in the instance that fails.
Has anyone else run into this problem when installing SP4?
Is there a way to attempt a delete of the xp_mergexpusage extended stored
procedure incase it is hidden somehow?
Any help would be greatly appreciated.
Greg PaganI found the answer to this issue myself.
Turns out the problem had nothing to do with SP4 at all. It just pointed
out the underlying issue.
I had corruption in the master data base that somehow messed with the
DBI_NextID. The value of that indicator was out of sync with the max(ID)
indicator. The DB_NextID as less than the Max(ID) which was telling the
system that the object already existed. The fix which came from
sqlforums.windowsitpro.com is to generate new DB_NextIDs by creating and
droping simple tables in master until the counter for DB_NextID grows larger
than max(ID). It took me over 700 table creates to get to that point.
After that the SP4 Update ran successfully.
Thanks anyway.
"Greg Pagan" <gpagan@.thehartford.com> wrote in message
news:O%23CHMX3VGHA.5692@.TK2MSFTNGP09.phx.gbl...
>I have a SQLServer 2000 SP3 running on Windows Server 2000 SP4. My
>installation has 5 named instances. I was able to install SQLServer SP4
>onto 4 of the named instances with out any problem. When I installed the
>SP4 update I was logged on as the local administrator and used Windows
>authentication.
> When I attempted the install on the last instance, it failed running the
> REPLSYS.SQL script. After some digging I found the REPLSYS.OUT file and
> it told me that the error was with procedure sp_addextendedproc in the
> master db. The script tried to execute the following command:
> sp_addextendedproc 'xp_mergexpusage', 'xprepl.dll'
> The error says that there is already an object named 'xp_mergexpusage' in
> the database.
> I have looked at the list of extended stored procedures listed in the
> Master DB and I cannot see the xp_mergexpusage stored procedure anywhere.
> Is it hidden somehow? I can see the stored procedure in the other
> instances that were sucessfully updated but not in the instance that
> fails.
> Has anyone else run into this problem when installing SP4?
> Is there a way to attempt a delete of the xp_mergexpusage extended stored
> procedure incase it is hidden somehow?
> Any help would be greatly appreciated.
> Greg Pagan
>
>

Problem with SP4 installation and REPLSYS.SQL

I have a SQLServer 2000 SP3 running on Windows Server 2000 SP4. My
installation has 5 named instances. I was able to install SQLServer SP4
onto 4 of the named instances with out any problem. When I installed the
SP4 update I was logged on as the local administrator and used Windows
authentication.
When I attempted the install on the last instance, it failed running the
REPLSYS.SQL script. After some digging I found the REPLSYS.OUT file and it
told me that the error was with procedure sp_addextendedproc in the master
db. The script tried to execute the following command:
sp_addextendedproc 'xp_mergexpusage', 'xprepl.dll'
The error says that there is already an object named 'xp_mergexpusage' in
the database.
I have looked at the list of extended stored procedures listed in the Master
DB and I cannot see the xp_mergexpusage stored procedure anywhere. Is it
hidden somehow? I can see the stored procedure in the other instances that
were sucessfully updated but not in the instance that fails.
Has anyone else run into this problem when installing SP4?
Is there a way to attempt a delete of the xp_mergexpusage extended stored
procedure incase it is hidden somehow?
Any help would be greatly appreciated.
Greg PaganI found the answer to this issue myself.
Turns out the problem had nothing to do with SP4 at all. It just pointed
out the underlying issue.
I had corruption in the master data base that somehow messed with the
DBI_NextID. The value of that indicator was out of sync with the max(ID)
indicator. The DB_NextID as less than the Max(ID) which was telling the
system that the object already existed. The fix which came from
sqlforums.windowsitpro.com is to generate new DB_NextIDs by creating and
droping simple tables in master until the counter for DB_NextID grows larger
than max(ID). It took me over 700 table creates to get to that point.
After that the SP4 Update ran successfully.
Thanks anyway.
"Greg Pagan" <gpagan@.thehartford.com> wrote in message
news:O%23CHMX3VGHA.5692@.TK2MSFTNGP09.phx.gbl...
>I have a SQLServer 2000 SP3 running on Windows Server 2000 SP4. My
>installation has 5 named instances. I was able to install SQLServer SP4
>onto 4 of the named instances with out any problem. When I installed the
>SP4 update I was logged on as the local administrator and used Windows
>authentication.
> When I attempted the install on the last instance, it failed running the
> REPLSYS.SQL script. After some digging I found the REPLSYS.OUT file and
> it told me that the error was with procedure sp_addextendedproc in the
> master db. The script tried to execute the following command:
> sp_addextendedproc 'xp_mergexpusage', 'xprepl.dll'
> The error says that there is already an object named 'xp_mergexpusage' in
> the database.
> I have looked at the list of extended stored procedures listed in the
> Master DB and I cannot see the xp_mergexpusage stored procedure anywhere.
> Is it hidden somehow? I can see the stored procedure in the other
> instances that were sucessfully updated but not in the instance that
> fails.
> Has anyone else run into this problem when installing SP4?
> Is there a way to attempt a delete of the xp_mergexpusage extended stored
> procedure incase it is hidden somehow?
> Any help would be greatly appreciated.
> Greg Pagan
>
>

Problem with SP installation (report server)

Hi all
I face a weird problem with the installation of SP1/SP2. The scenario
is that the report designer gets updated with the SPs that i apply. But
the problem is with the report server. The installation is successful
but the version number in my report server is still 8.00.743.00 even
after applying the SPs.
I have windows 2003 server with latest SP and SQL server (i'm using
MSDE) with latest SP. I do have local admin rights in my machine.
Am i missing something '
Please suggest some solutions.
Thanks in advance.
Regards,
Prathima.CYes, I don't see how Reports are working for you at all since MSDE is not
supported. It should never have installed in the first place with it. MSDE
is not supported and Personal Edition is not supported.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<prathima.chandramouli@.gmail.com> wrote in message
news:1115571565.489275.126090@.z14g2000cwz.googlegroups.com...
> Hi all
> I face a weird problem with the installation of SP1/SP2. The scenario
> is that the report designer gets updated with the SPs that i apply. But
> the problem is with the report server. The installation is successful
> but the version number in my report server is still 8.00.743.00 even
> after applying the SPs.
> I have windows 2003 server with latest SP and SQL server (i'm using
> MSDE) with latest SP. I do have local admin rights in my machine.
> Am i missing something '
> Please suggest some solutions.
> Thanks in advance.
> Regards,
> Prathima.C
>