[SQL Server Service Manager Help]

Godricc · 05/21/2010, 21:09

Okay so here's my problem.

I went to bed and then woke up to find that my SQL Server Service Manager wont start. It sits there saying "Starting" and I haven't changed anything. The server is the same and the service too. Here's a pic.

Okay so I need to know why It would start before and now it's not.

If you know something I don't, Please leave the solution here.

~Thanks for reading my post!~
Nate...

naruto820 · 05/21/2010, 21:44

Was ur password for the user in computer changed? for example if you are using administrator did u change the password for that account?

Godricc · 05/21/2010, 21:52

Nope there no pass for the user so that could not be the problem.

I think it may be because of the router. I forgot to add that we changed routers and the local ip is different. 127.0.0.1 is normal and the newer router has 10.0.0.1. So I replaced the new router with the old one and Its still not working so I think I need to do something but idk what it is...

Zombe · 05/21/2010, 22:09

I had that problem before. Took me ages to find out why that's happening.

I don't know if this will fix the problem for you, since I feel that this might be caused by many different problems, but here's what was happening for me: The database's evaluation period has expired, so what you have to do is re-install your MSSQL with another installation file, because the same one won't work ^^

Godricc · 05/21/2010, 22:12

Wait wait...So how long is the trial period and also I thought that all you have to do is install the trial version and after it ends you will still have the needed programs to run the server...

Zombe · 05/21/2010, 22:25

Quote:

Originally Posted by ansem774

Wait wait...So how long is the trial period and also I thought that all you have to do is install the trial version and after it ends you will still have the needed programs to run the server...

After it runs out, it simply won't start, and it won't give any error, which is really annoying... And I think the trial/evaluation period is 90 days.

Godricc · 05/21/2010, 22:29

Then there shouldn't be a problem -.-

I have only had this trial for like 12-16 days...

Zombe · 05/21/2010, 22:32

Hmm, well then...

Restarting your program helps 40% of the time.
Restarting your PC helps 50% of the time.
Reinstalling the program helps 70% of the time.
Reinstalling your OS helps 90% of the time.

So try re-installing MSSQL anyway

Godricc · 05/21/2010, 22:38

Will do and also Zombie I have liked you for just one reason, that which I don't know

Also May I add that To save my server files and accounts created I just re paste the database files that I sent to my C: drive?

Zombe · 05/21/2010, 23:41

Quote:

Originally Posted by ansem774

Will do and also Zombie I have liked you for just one reason, that which I don't know

Also May I add that To save my server files and accounts created I just re paste the database files that I sent to my C: drive?

Well, You should try that, since you can't start your server, you can't make a backup, but that might work, so give it a try

Godricc · 05/21/2010, 23:51

i did and now it's working again. Big thanks zombe. Once again my questions where answered. It very nice to have people as nice as you and there are a bit of them but on the other hand there are alot of those that dont.

Thanks zombe I will give big thanks...

+Request a close

~~silkbotter~~ · 05/21/2010, 23:52

to backup your databases without a running database.
dave the .mdf,.ldf files somewhere.

reinstalll the mssql server, restore the dataabses of some old backups you find on my post for example, STOP the sql server, drag the files you saved into the same folder where the other files are, replace the copied ones with the new ones, and then start your sql server again.
liek that you'll have the databases you had before

#edit: one second after you posting it

Godricc · 05/21/2010, 23:57

Thanks silkbotter but all I do is jsut copy the files with the database files and then when I make a new database I just paste them over and It works so.

~~silkbotter~~ · 05/22/2010, 00:03

exactly.i had to do it as well.and it worked fine.
let me know if you need assistance.

Godricc · 05/22/2010, 00:07

You had to do what?

Also I have mine working already and its up. So basically ill have to do this every time it does that...PAIN IN THE ****