Post reply

Are the posted questions getting worse?

  • August 9, 2016 at 11:32 am

    #1894614

    Sigh.

    I am experiencing that sinking feeling one gets when one realizes an instance of SQL was installed without a sysadmin account.

    To be fair, I don't know for sure that the tech installing stuff on my new box forgot the sysadmin account. But after neither me nor he could log into it... I'm thinking he may have to schedule an uninstall / reinstall (hopefully with the proper permissions this time).

    EDIT: Fortunately it's just a Dev edition on my personal box, not an edition on one of our servers.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • August 9, 2016 at 12:02 pm

    #1894620

    Brandie Tarvin (8/9/2016)

    Sigh.

    I am experiencing that sinking feeling one gets when one realizes an instance of SQL was installed without a sysadmin account.

    To be fair, I don't know for sure that the tech installing stuff on my new box forgot the sysadmin account. But after neither me nor he could log into it... I'm thinking he may have to schedule an uninstall / reinstall (hopefully with the proper permissions this time).

    EDIT: Fortunately it's just a Dev edition on my personal box, not an edition on one of our servers.

    you can save yourself the uninstall/reinstall.

    Restart dev edition in minimal configuration and add your personal account as a sysadmin that way.

    http://www.practicalsqldba.com/2012/08/sql-server-lost-all-administrator.html

    Or you can hack it without the restart and add your personal account as a sysadmin.

    http://sqlblog.com/blogs/argenis_fernandez/archive/2012/01/12/leveraging-service-sids-to-logon-to-sql-server-2012-instances-with-sysadmin-privileges.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 9, 2016 at 12:20 pm

    #1894623

    SQLRNNR (8/9/2016)

    Restart dev edition in minimal configuration and add your personal account as a sysadmin that way.

    http://www.practicalsqldba.com/2012/08/sql-server-lost-all-administrator.html

    Minimum config isn't necessary. SQL just has to be started in single user mode.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 9, 2016 at 5:09 pm

    #1894680

    GilaMonster (8/9/2016)

    SQLRNNR (8/9/2016)

    Restart dev edition in minimal configuration and add your personal account as a sysadmin that way.

    http://www.practicalsqldba.com/2012/08/sql-server-lost-all-administrator.html

    Minimum config isn't necessary. SQL just has to be started in single user mode.

    Beat me to it.....

  • August 10, 2016 at 7:31 am

    #1894772

    GilaMonster (8/9/2016)

    SQLRNNR (8/9/2016)

    Restart dev edition in minimal configuration and add your personal account as a sysadmin that way.

    http://www.practicalsqldba.com/2012/08/sql-server-lost-all-administrator.html

    Minimum config isn't necessary. SQL just has to be started in single user mode.

    There we go. I don't go that route typically, but when I do, I do both minimal and single user -d'oh. I usually use the service hack to prevent an outage alert. 😀

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 10, 2016 at 7:48 am

    #1894775

    SQLRNNR (8/10/2016)

    GilaMonster (8/9/2016)

    SQLRNNR (8/9/2016)

    Restart dev edition in minimal configuration and add your personal account as a sysadmin that way.

    http://www.practicalsqldba.com/2012/08/sql-server-lost-all-administrator.html

    Minimum config isn't necessary. SQL just has to be started in single user mode.

    There we go. I don't go that route typically, but when I do, I do both minimal and single user -d'oh. I usually use the service hack to prevent an outage alert. 😀

    I have to read all this stuff about SQL, when all I want is a cheap kitchen.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • August 10, 2016 at 7:54 am

    #1894780

    Phil Parkin (8/10/2016)

    SQLRNNR (8/10/2016)

    GilaMonster (8/9/2016)

    SQLRNNR (8/9/2016)

    Restart dev edition in minimal configuration and add your personal account as a sysadmin that way.

    http://www.practicalsqldba.com/2012/08/sql-server-lost-all-administrator.html

    Minimum config isn't necessary. SQL just has to be started in single user mode.

    There we go. I don't go that route typically, but when I do, I do both minimal and single user -d'oh. I usually use the service hack to prevent an outage alert. 😀

    I have to read all this stuff about SQL, when all I want is a cheap kitchen.

    You mean you don't have one by now? :w00t: I don't either. 😉

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • August 10, 2016 at 8:36 am

    #1894808

    Phil Parkin (8/10/2016)

    SQLRNNR (8/10/2016)

    GilaMonster (8/9/2016)

    SQLRNNR (8/9/2016)

    Restart dev edition in minimal configuration and add your personal account as a sysadmin that way.

    http://www.practicalsqldba.com/2012/08/sql-server-lost-all-administrator.html

    Minimum config isn't necessary. SQL just has to be started in single user mode.

    There we go. I don't go that route typically, but when I do, I do both minimal and single user -d'oh. I usually use the service hack to prevent an outage alert. 😀

    I have to read all this stuff about SQL, when all I want is a cheap kitchen.

    And here's me, coming here to find out how to watch some sportsball event or other while curing my toenail fungus.

    Toenail fungus.

    Bleah.

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • August 10, 2016 at 9:25 am

    #1894823

    Sometimes sarcasm is the only option http://www.sqlservercentral.com/Forums/FindPost1808418.aspx.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • August 10, 2016 at 9:40 am

    #1894828

    If any of you want to write up solutions to some of the questions you've answered, and explain in some detail, we're looking for some T-SQL content to publish. Really just a 2-3 pager or so, taking a problem, analyzing, giving a code solution with a short explanation on why it works.

  • August 10, 2016 at 10:00 am

    #1894836

    First time in years that I'm flying somewhere just for a vacation, no conferences involved. Scotland, to save anyone from wondering.

    Someone please keep an eye on the corruption forums, I've seen really weird replies there recently

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 10, 2016 at 10:06 am

    #1894844

    GilaMonster (8/10/2016)

    First time in years that I'm flying somewhere just for a vacation, no conferences involved. Scotland, to save anyone from wondering.

    Someone please keep an eye on the corruption forums, I've seen really weird replies there recently

    If you enjoy a little green wilderness, you can't go far wrong with Morayshire.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • August 10, 2016 at 10:50 am

    #1894857

    GilaMonster (8/10/2016)

    First time in years that I'm flying somewhere just for a vacation, no conferences involved. Scotland, to save anyone from wondering.

    Any particular place in Scotland? I'm mostly (not always) not in Scotland these days, but maybe we could meet up for a chat and a drink if you would like that provided your location and mine match at some point.

    Tom

  • August 10, 2016 at 11:54 am

    #1894865

    SQLRNNR (8/9/2016)

    Brandie Tarvin (8/9/2016)

    Sigh.

    I am experiencing that sinking feeling one gets when one realizes an instance of SQL was installed without a sysadmin account.

    To be fair, I don't know for sure that the tech installing stuff on my new box forgot the sysadmin account. But after neither me nor he could log into it... I'm thinking he may have to schedule an uninstall / reinstall (hopefully with the proper permissions this time).

    EDIT: Fortunately it's just a Dev edition on my personal box, not an edition on one of our servers.

    you can save yourself the uninstall/reinstall.

    Restart dev edition in minimal configuration and add your personal account as a sysadmin that way.

    http://www.practicalsqldba.com/2012/08/sql-server-lost-all-administrator.html

    And I get "Sorry, the page you were looking for in this blog does not exist."

    Or you can hack it without the restart and add your personal account as a sysadmin.

    http://sqlblog.com/blogs/argenis_fernandez/archive/2012/01/12/leveraging-service-sids-to-logon-to-sql-server-2012-instances-with-sysadmin-privileges.aspx

    SWEETNESS! Thank you so very much for that. It worked WONDERS.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • August 10, 2016 at 12:04 pm

    #1894868

    Brandie Tarvin (8/10/2016)

    SQLRNNR (8/9/2016)

    Brandie Tarvin (8/9/2016)

    Sigh.

    I am experiencing that sinking feeling one gets when one realizes an instance of SQL was installed without a sysadmin account.

    To be fair, I don't know for sure that the tech installing stuff on my new box forgot the sysadmin account. But after neither me nor he could log into it... I'm thinking he may have to schedule an uninstall / reinstall (hopefully with the proper permissions this time).

    EDIT: Fortunately it's just a Dev edition on my personal box, not an edition on one of our servers.

    you can save yourself the uninstall/reinstall.

    Restart dev edition in minimal configuration and add your personal account as a sysadmin that way.

    http://www.practicalsqldba.com/2012/08/sql-server-lost-all-administrator.html

    And I get "Sorry, the page you were looking for in this blog does not exist."

    Look close at the actual URL. Seems that often the URL gets a bit weird on SSC. Here is the correct one.

    http://www.practicalsqldba.com/2012/08/sql-server-lost-all-administrator.html

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Viewing 15 posts - 55,276 through 55,290 (of 66,712 total)

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