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!!!
MSAJMAsked:
Who is Participating?
 
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 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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.