Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TomKattt
Starting Member
1 Post |
 Posted - 2011-03-11 : 23:39:58
|
| I am a software developer, not a DB admin. I want to get SQL Server 2008 working on my home machine so I can have it available for studying for my mCP certifications.I have a new Win 7 64 bit laptop, and I installed SQL Server 2008 on it. I am trying to apply the SP2 update (SQLServer2008SP2-KB2285068-x64-ENU.exe". I think this is the right download for my 64 bit machine (I hope.) I get an error saying there are no SQL instances or shared features to update. I can't check the check boxes.I also have an instance of SQLServerExpress running.The configuration manager shows SQLExpress is running, but my instance of SQL Server is not. I can't get it to start. It seems to time out and says I should check a log or event viewer, but I don't really know what to check or where to find it.I just managed to connect to SqlExpress. Apparently I didn't know I needed to use the name 'OWNER-PC\SQLEXPRESS', but I just found that and it works, which resolves one of my problems, but I still don't know what's wrong with MSSQLSERVER.So things are clearly not right. I need to find out why my regular SQL Server instance won't start as well as why I can't connect to the Express instance. I would appreciate any help I can get. Thx.Carpe Cerevisi; Seize the Beer |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-03-12 : 06:00:03
|
| The log you are looking for is the windows application log. Start-> Administrative Tools-> Event Viewer--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Newbie, need help, can't get anything to work