Frustrated programmer wants to create a SQL server database

SQL server 2000 (developer edition) has been installed and uninstalled
(although it still ran even after it said that it was uninstalled) multiple
times. The "create database" button is grayed out and the wizard doesn't
exist.
Curious, is there a super-secret-special hand-shake/password that I should
be using to make the SQl server enterprise allow me to create a database?
Any help/insight would be greatly appreciated.
Thanks,
--Michael
(Please forgive if I sound ... frustrated. It's been 7 hours of
install/uninstall torment with absolutely no headway since the first install.
I hope this isn't a sign of what the new year is to bring...!!)
Hi Michael
You don't say who you are logging in as or what tools you are using? If you
are a local administrator and log in using windows authentication then you
should be able to create a database. If you are in Enterprise Manager then
you should have the local instance registered, if not check out Books Online
regarding registering an instance in EM. Then you should be able to open the
tree up to see the Database branch under which are the master/model/tempdb
databases etc. Right Click the Database branch and see if you can create a
database from the menu options.
Failing that use Query Analyser and issue a CREATE DATABASE command, the
full syntax is in Books Online.
John
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)
|||No, theres no secret thingy. However, if you have permissions to create
database, try using query analyser and CREATE DATABASE statement. If
statement fails, at least youll get an error and try to find out whats
wrong.
MC
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)