Lost MSSQLSERVER Services in SQL 2008

Question

Post reply

Lost MSSQLSERVER Services in SQL 2008

Viewing 5 posts - 1 through 6 (of 6 total)

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

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

I'm confused, you say it only has SSRS on it, if that is true you shouldn't see the other services.

What are the file dates on those files?

CEWII

kri SSC Rookie Points: 45 More actions · Answer 2

Thanks for the reply,

Here is what i have done, we have to configure SQL 2008 for reporting services so i installed Database engine and Reporting services components on a Server which use to be on our domain(xy.com). This server was working fine, once we moved to DMZ (dbz.ab.com) i was told to check if everything is fine there i notice i cant see my SQL releated Services.

Please let me know if you need more info on this..

Thanks,

v

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

Ok, that is wierd. I've not heard of services disappearing like this.

Did the AD domain change or just the address it exists in..

I have to admit that nothing comes to mind that makes any real sense, I was grasping at permissions but even that doesn't feel right..

Sorry.

CEWII

kri SSC Rookie Points: 45 More actions · Answer 4

Thanks again,

I guess at this point i'll bailout this server and will do new SQL installation on DMZ.

Its really funny, Even my Domain Admin User account exists on DMZ Server with which it suppose run my SQL Services.

what if i try SPN on domain Controller using below cmd

setspn -A MSSQLSvc/myhost.dmz.ab.com:1433 accountname

and as i am running SQL Services under domain Admin will make sure this account is trusted for delegation in AD.

This is the last thing i can give a try, if it work awesome if not 🙁

Thanks,

V-

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 5

I was trying to avoid recommending a SQL re-install but I wouldn't be surprised if that is what it took..

CEWII