Can''t create local DB (SQL 2k)

Question

Post reply

Can''t create local DB (SQL 2k)

Mike-338295

SSC Rookie

Points: 30
More actions
July 12, 2006 at 10:51 am

#171584

I cannot seem to create a local database. I have used sql server 2000 for years on a remote server but now I would like to create some local databases for development.
I have the 2000 developer version installed and the enterprise manager connects to the remote databases but fails when I try to create a local database.
Where to I go for very basic set up info?
Mike
Thank you for your patience,
Mike

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

John Rowan SSC Guru Points: 56440 More actions · Answer 1

When you open EM and look at your SQL Server Groups, does it show a 'Local' server registration?

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Mike-338295 SSC Rookie Points: 30 More actions · Answer 2

yes. I can add others but they do not connect (error 1069 and sql server does not exist error).

Thank you for your patience,

Mike

John Rowan SSC Guru Points: 56440 More actions · Answer 3

So what I'm hearing is that you can add other registrations to your EM if they are remote SQL instances, but when you attempt to register your local instance, it is telling you that it cannot find it. If this is true then you probably need to reinstall SQL Server on your local machine because either you only have the client tools loaded locally, or there is something wrong with your local instance.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Mike-338295 SSC Rookie Points: 30 More actions · Answer 4

un-installed re-installed, same issue, same error messages.

Thank you for your patience,

Mike

John Rowan SSC Guru Points: 56440 More actions · Answer 5

I'm not trying to sound condescending here, but make sure when you install, that you do not select client tools only and make sure that the SQL Server service is started up on your local machine. Also, check this MS KB: http://support.microsoft.com/kb/328306/en-us

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Mike-338295 SSC Rookie Points: 30 More actions · Answer 6

No problem-o with the condescending. I feel that it has to be something simple/basic.

I selected "server and client tools" during the install dialog. I find the database files and sqlserveragent in component services but cannot start it manually.

The log file last entry says:

"SQL Server is terminating due to 'stop' request from Service Control Manager."

I have IIS installed with Inetpub on c:\ (default) but have all web projects on a separate drive (g:\) mapped (virtual directory) from IIS to each project. SQL server is installed on g:\ and I've selected windows and sql server sql server authentication (mixed mode) during install.

The program is a "retail box" developer edition and the machine is running XP-pro (which this should run under).

This has had me stumped for about a week now.

Thank you for your patience,

Mike

John Rowan SSC Guru Points: 56440 More actions · Answer 7

What about the MSSQLSERVER service? This is the one you need to be concerned with. Make sure it is running. If it cannot start or is not running, that is your problem.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Mike-338295 SSC Rookie Points: 30 More actions · Answer 8

can't seem to manually start it.

Thank you for your patience,

Mike

John Rowan SSC Guru Points: 56440 More actions · Answer 9

What is the error message that you are getting (exact syntax). Also, check the account that it is trying to start up under, is it a local account, localsystem account, domain account?

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Mike-338295 SSC Rookie Points: 30 More actions · Answer 10

If I remove the password requirement it starts. Will see if I can add local databases....

Thank you for your patience,

Mike

Mike-338295 SSC Rookie Points: 30 More actions · Answer 11

local instance is running but other attempts to created additional local databases fail.

Thank you for your patience,

Mike

John Rowan SSC Guru Points: 56440 More actions · Answer 12

It looks like you have been attempting to cut/paste or attach screen shots to your posts. Can you post your exact error message that you are getting now. What account is your MSSQLSERVER service starting under? If you need to send screenshots, send them to john.rowan@dmpinc.com.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Mike-338295 SSC Rookie Points: 30 More actions · Answer 13

Yes, I have been trying to use the image attachment in here for small gifs (9-10k)... here is a URL where I uploaded the last 3 screenshots.

http://www.moosepucky.com/sql_issues/

#1 is the error message I get when I try to create (or register) a new database. I am using the client network utility to create the database then trying to register it with enterprise manager.

I am not sure what you mean by what account SQL server is started under. I do not have any separate accounts in XP on this system and run as administrator if that is what you are talking about.

I have no idea why sql server starts if I set it to not use a password in component services (gif showing CF palette is titled removePassword.gif in the folder)

Thank you for your patience,

Mike

Mike-338295 SSC Rookie Points: 30 More actions · Answer 14

Been playing around with so many things that I have no idea what I have changed BUT I can now create and register new data bases. Now to see how everything works so that I can formulate some NEW questions.

Thank you for your patience,

Mike