• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 622
  • Last Modified:

Installation of MS-SQL 2000.

I am "brand" new to SQL and I need some help with the installation of MS-SQL 2000.  I have gone through the setup process and followed all the directions, but it keeps hanging up on me in the installation process.  I get to a part where it says, "setup starting the server and installing your chosen configuration" but it just sits in this mode until I finally have to "CTR, ALT, DELETE" to get out.  Can someone help me out, or point me to some trouble shooting guide for MS-SQL 2000.  I am guessing this has something to do with my server set up, but I am not sure if it even gave me an option to pick which server I wanted.  Heck I don't really know, all I know is that I have tried this for 2 days, now I have about 6 different instances of SQL on my pc and none of them work, or at least none of them will go all the way through the setup process.  Anyway, please help!!!
0
MSAJM
Asked:
MSAJM
  • 4
  • 2
  • 2
1 Solution
 
MSAJMAuthor Commented:
OK, I have everything installed, but I am getting an error message now when I bring up the SQL server... "connection failed, check SQL server Registration Properties"  Any ideas???  Guess if I sit here long enought I will figure this out myself... :o)
0
 
DanRollinsCommented:
Start Enterprise Manager
Drill down to the "local" server group.
Right-click and see various options

If you have several unwanted (perhaps partially-completed) registrations, you can delete them here.  You can use the "Edit Registration" cmd to change some settings.

I have installed SQL Server 2000 many times and never experienced such problems.
Some long delays can be caused by network latency and also by security/authorization issue.  If this is a simple installation of an instance of the software on the local box, then I do not recognize the symptoms.

-- Dan
0
 
MSAJMAuthor Commented:
I don't suppose you would know what I would need to change the setting to would you??  It's the Developer Edition and it says Windows NT, but I have XP, does that matter??
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
DanRollinsCommented:
The settings under the "Security" and "Connections" tabs would be a place to start.

But assuming a simple install, these will be at defaults, so they should be fine.

The issue might be about any partially-completed registrations.  If there are multiple registrations, you should consider removing all of the ones you don't need.  Even rmove them all and then add back just the one.

Also, go to the
    Windows Control Panel / Administration Tools / Data Sources (ODBC)
and attempt to create a new DSN to access the data.  The final step of the wizard lets you check the connection and the diagnostic messages may make more sense.
0
 
andrewbleakleyCommented:
If it is XP SP2 you may have firewall issues. This has hung us up several times. Go to control panel and disable the firewall and check Client Network Utility. In Client Network Utility add all the possible options you installed. This should get you started, obviously you will need to clean and tighten it up when you finish. Start the server from Control Panel - Administrator Tools - Services
Alternativley nuke all the instances of SQL Server, kill the firewall (yes it will affect you on your own machine because it will block port 1433 on you, go figure).
SQL Dev edition runs perfectly on XP by the way, when you install double check that you used mixed mode authentication.
What was posted in the windows error log as the reason ? If your PC is a member of a domain make sure you are connected to the domain or you will go in circles for days trying unsuccessfully to authenticate (hence using mixed mode)
0
 
MSAJMAuthor Commented:
OK, I have another question... what if it won't let me "nuke" all instances?  I keep getting an error message saying, "Unable to locate the installation log file, C:\Program Files....Uninstallation will not continue."  What do I need to do about this?  I will try checking the mixed mode, but I am also getting error "1060 The specified service does not exist as an installed service."  What about this?  How can I totally wipe this off of my system and start all over?
0
 
andrewbleakleyCommented:
A. A. If the standard un-install utility doesn't do the trick for some reason :-

Remove the <sql> directory and everything under it
Remove the <sql> dir from the path (use control panel/system for this)
Remove the SQL registry entries using regedt32/regedit. These are :-

(All versions)

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

(7.0 and above)

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLServerAgent
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server 7
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServ65

You also might give this a try - http://support.microsoft.com/default.aspx?scid=kb;en-us;290301 for a further clean up. You really have nothing to loose here because SQL doesn't work anyway. If you Anti virus software disable it before you do the install and close any unnecessary programs
0
 
MSAJMAuthor Commented:
The mixed mode option did the trick!  Thank you one trillion times!  THANK YOU!!!!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now