Sql server not installing properly

[fleurhema]

i newly tried to install sql server 2008 but when i install i got a error message

The sql server encountered the following error:
The System database file Master.mdf already exists in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.

Error code 0x84b40000.

i tried to delete the folder but i can't .. what shall i do now...

 

[szaboaz]

The file/folder is there because you had installed it before, but failed to uninstall properly, I guess. It's possible that the service from the previous install is still running, so you should
- uninstall it correctly, or at least
- stop the service. If you can't find it, then you can
- restart in Safe Mode, and delete those files. But things are a little messy there, because who knows if they will be missed next time you start normal...

 

[fleurhema]

can u tell me some small tips thro' which i can find a solution

 

[szaboaz]

So I have the hypothesis that you have a running sql server process. Let's see if it's true.

Look around in your Services Manager (write services.msc in the Run box), to see if you can identify any running sql server process.
Alternatively, open a command window, and issue
net stop MSSQLSERVER
just as it's described at
http://msdn.microsoft.com/en-us/library/ms190236(v=sql.105).aspx

After you stopped the service, you should be able to delete those files.

Then you could delete that service altogether:
http://www.howtogeek.com/howto/windows-vista/how-to-delete-a-windows-service-in-vista-or-xp/

 

[fleurhema]

thankyou its really helpfull thankyou alot..... and my SQL server is now working.....

 

[kiara]

When i typed "net stop MSSQLSERVER", error message "The service name is invalid"

When i typed "net stop MSSQL$SQLSERVER", error message "The service name is invalid"

More help is avaialble by typing NET HELPMSG 2185

When i typed "net stop SQL SERVER", error message "The syntax of th command is :

NET STOP
Service"



My service name is : MSSQL$SQLEXPRESS