Post reply

Lost MSSQLSERVER Services in SQL 2008

  • June 9, 2010 at 11:28 am

    #233623

    Hello Everyone,

    we have a SQL Server 2008 64bit, all it has is SSRS within our domain (New Installation) now after couple of days it has been moved to DMZ. I was told to check if everything is back as normal but when i checked i dont see SQL Services under both SQL Server Configuration manager and WINDOWS Services.

    I also checked my drives and i can see my .mdf\.ldf file for both system\User Database. I can also see MSSQL folders C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER and C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn

    Server Info:

    SQL Server 2008 64bit ENT,

    Windows Server 2008 R2 STD 64bit

    SQL Services run under domain administrator account, this account exist under Admin group on the server.

    NET START MSSQLSERVER it did not work,

    I've been looking for a way to figure it out what went wrong why i cant see SQL (MSSQLSERVER) Services on DMZ Server.

    Hope someone can help me out.

    thanks,

    V-

  • June 9, 2010 at 11:51 am

    #1178157

    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

  • June 9, 2010 at 11:58 am

    #1178162

    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

  • June 9, 2010 at 12:46 pm

    #1178183

    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

  • June 9, 2010 at 12:59 pm

    #1178192

    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-

  • June 9, 2010 at 2:09 pm

    #1178241

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

    CEWII

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

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