August 10, 2016 at 12:10 pm
Sean Lange (8/10/2016)
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
Thanks, Sean. Not sure that link would have helped since my login apparently wasn't on the SQL instance at all and no account that I knew the password to (or anyone knew the password to) was on it either. But I appreciate the reference.
August 10, 2016 at 3:13 pm
Brandie Tarvin (8/10/2016)
Sean Lange (8/10/2016)
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
Thanks, Sean. Not sure that link would have helped since my login apparently wasn't on the SQL instance at all and no account that I knew the password to (or anyone knew the password to) was on it either. But I appreciate the reference.
No account needed on the instance for that first one to work. It's a nice little backdoor.
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 11, 2016 at 4:09 am
SQLRNNR (8/10/2016)
Brandie Tarvin (8/10/2016)
Sean Lange (8/10/2016)
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
Thanks, Sean. Not sure that link would have helped since my login apparently wasn't on the SQL instance at all and no account that I knew the password to (or anyone knew the password to) was on it either. But I appreciate the reference.
No account needed on the instance for that first one to work. It's a nice little backdoor.
Huh. I'll have to keep that in mind.
Of course, now I've got another interview question on my list. "Name one or more ways to log into SSMS using an account other than your current login." I think that's a nice one to separate out the beginners from the intermediates from the experts (who would probably know about these two options).
August 11, 2016 at 8:23 am
Brandie Tarvin (8/11/2016)
SQLRNNR (8/10/2016)
Brandie Tarvin (8/10/2016)
Sean Lange (8/10/2016)
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
Thanks, Sean. Not sure that link would have helped since my login apparently wasn't on the SQL instance at all and no account that I knew the password to (or anyone knew the password to) was on it either. But I appreciate the reference.
No account needed on the instance for that first one to work. It's a nice little backdoor.
Huh. I'll have to keep that in mind.
Of course, now I've got another interview question on my list. "Name one or more ways to log into SSMS using an account other than your current login." I think that's a nice one to separate out the beginners from the intermediates from the experts (who would probably know about these two options).
Know about them, yes. Explain them, no; Know that the instructions exist for them out on the Internet and get to them, again yes.
August 11, 2016 at 9:55 am
Lynn Pettis (8/11/2016)
Brandie Tarvin (8/11/2016)
SQLRNNR (8/10/2016)
Brandie Tarvin (8/10/2016)
Sean Lange (8/10/2016)
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
Thanks, Sean. Not sure that link would have helped since my login apparently wasn't on the SQL instance at all and no account that I knew the password to (or anyone knew the password to) was on it either. But I appreciate the reference.
No account needed on the instance for that first one to work. It's a nice little backdoor.
Huh. I'll have to keep that in mind.
Of course, now I've got another interview question on my list. "Name one or more ways to log into SSMS using an account other than your current login." I think that's a nice one to separate out the beginners from the intermediates from the experts (who would probably know about these two options).
Know about them, yes. Explain them, no; Know that the instructions exist for them out on the Internet and get to them, again yes.
either you are thinking of comething too complex or I don't understand the question: to me it seems obvous (and trivial) that you select either Active Directory Authentication or WindowsSQL Authentication (instead of Window Authentication or Active Directory Integrated Authentication) in the login dialogue so that you can specify the account to be used.
edit: fix stupid copy and paste error
Tom
August 11, 2016 at 10:32 am
SQLRNNR (8/10/2016)
Brandie Tarvin (8/10/2016)
Sean Lange (8/10/2016)
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
Thanks, Sean. Not sure that link would have helped since my login apparently wasn't on the SQL instance at all and no account that I knew the password to (or anyone knew the password to) was on it either. But I appreciate the reference.
No account needed on the instance for that first one to work. It's a nice little backdoor.
Used it so many times now I can do it from memory 🙂
August 11, 2016 at 11:29 am
Minor Update: The plan to replace the forums is proceeding. We've narrowed down to a couple companies, though the upgraded version of this forum is really winning. It's vastly improved, and moved from VB to C#, which makes developers happy. On pace for a final review of the plan when I go in Sept and hopefully an integration/upgrade/replacement in a month or two.
HOWEVER
Part of the process noted that we have a few "how to post code, how to ask a question, how to format code" articles. We do not have a "how to answer a question" article, which I think is a good idea.
I'd like to see some general rules and decorum in play here. I know some of you get frustrated, annoyed, etc by posters, but a few nice rules might help remind us of professional behavior.
Any takers on writing? If not, I can tackle it, but I am looking for feedback and ideas on what rules make sense.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
August 11, 2016 at 12:20 pm
First he doesn't post enough data to get from his sample data to his expected results, then when I post as much of a solution as possible given the sparse data, he can't make the logical leap of using a simple join. :crazy:
http://qa.sqlservercentral.com/Forums/Topic1808824-2799-1.aspx
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
August 11, 2016 at 12:25 pm
TomThomson (8/10/2016)
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.
Edinburgh until Monday morning (though planning to spend part of Sunday at St Andrews), then Stornoway for a week.
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
August 11, 2016 at 1:41 pm
Steve Jones - SSC Editor (8/11/2016)
Minor Update: The plan to replace the forums is proceeding. We've narrowed down to a couple companies, though the upgraded version of this forum is really winning. It's vastly improved, and moved from VB to C#, which makes developers happy. On pace for a final review of the plan when I go in Sept and hopefully an integration/upgrade/replacement in a month or two.
That's fantastic. Do they have a database migration script or is the one you have in place too old? Please understand I mean no offense in asking; we have a number of packages that are too old.
Part of the process noted that we have a few "how to post code, how to ask a question, how to format code" articles. We do not have a "how to answer a question" article, which I think is a good idea.
I'd like to see some general rules and decorum in play here. I know some of you get frustrated, annoyed, etc by posters, but a few nice rules might help remind us of professional behavior.
Any takers on writing? If not, I can tackle it, but I am looking for feedback and ideas on what rules make sense.
I think there are multiple approaches to helping someone and it depends on the OP.
1. There's the well-posted question, complete with DDL, test data and expected results, which results in a more direct answer.
2. Then there's the post where someone posts code with no data and may or may not ask a question. That's an approach where you have to pull the actual question out of them.
3. There are also those homework posts where you want to direct them to the answer without giving it to them. After all, if the goal of the class is to learn something, then giving them an answer to copy/paste won't help them with anything except a grade.
4. There's the OP who views the site as an answer machine: insert question---get answer. They aren't interested in learning anything.
5. Lastly, there's the OP who's irate from the get-go. Better to just walk away.
I don't think I'm the right person to tackle this one.
Edit: Added #4 and #5.
August 11, 2016 at 2:17 pm
Ed Wagner (8/11/2016)
Steve Jones - SSC Editor (8/11/2016)
Minor Update: The plan to replace the forums is proceeding. We've narrowed down to a couple companies, though the upgraded version of this forum is really winning. It's vastly improved, and moved from VB to C#, which makes developers happy. On pace for a final review of the plan when I go in Sept and hopefully an integration/upgrade/replacement in a month or two.That's fantastic. Do they have a database migration script or is the one you have in place too old? Please understand I mean no offense in asking; we have a number of packages that are too old.
Part of the process noted that we have a few "how to post code, how to ask a question, how to format code" articles. We do not have a "how to answer a question" article, which I think is a good idea.
I'd like to see some general rules and decorum in play here. I know some of you get frustrated, annoyed, etc by posters, but a few nice rules might help remind us of professional behavior.
Any takers on writing? If not, I can tackle it, but I am looking for feedback and ideas on what rules make sense.
I think there are multiple approaches to helping someone and it depends on the OP.
1. There's the well-posted question, complete with DDL, test data and expected results, which results in a more direct answer.
2. Then there's the post where someone posts code with no data and may or may not ask a question. That's an approach where you have to pull the actual question out of them.
3. There are also those homework posts where you want to direct them to the answer without giving it to them. After all, if the goal of the class is to learn something, then giving them an answer to copy/paste won't help them with anything except a grade.
4. There's the OP who views the site as an answer machine: insert question---get answer. They aren't interested in learning anything.
5. Lastly, there's the OP who's irate from the get-go. Better to just walk away.
I don't think I'm the right person to tackle this one.
Edit: Added #4 and #5.
If you aren't the right person who is? You bring up some excellent points about trying to properly deal with the kind of OP.
_______________________________________________________________
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/
August 11, 2016 at 2:32 pm
Sean Lange (8/11/2016)
Ed Wagner (8/11/2016)
Steve Jones - SSC Editor (8/11/2016)
Minor Update: The plan to replace the forums is proceeding. We've narrowed down to a couple companies, though the upgraded version of this forum is really winning. It's vastly improved, and moved from VB to C#, which makes developers happy. On pace for a final review of the plan when I go in Sept and hopefully an integration/upgrade/replacement in a month or two.That's fantastic. Do they have a database migration script or is the one you have in place too old? Please understand I mean no offense in asking; we have a number of packages that are too old.
Part of the process noted that we have a few "how to post code, how to ask a question, how to format code" articles. We do not have a "how to answer a question" article, which I think is a good idea.
I'd like to see some general rules and decorum in play here. I know some of you get frustrated, annoyed, etc by posters, but a few nice rules might help remind us of professional behavior.
Any takers on writing? If not, I can tackle it, but I am looking for feedback and ideas on what rules make sense.
I think there are multiple approaches to helping someone and it depends on the OP.
1. There's the well-posted question, complete with DDL, test data and expected results, which results in a more direct answer.
2. Then there's the post where someone posts code with no data and may or may not ask a question. That's an approach where you have to pull the actual question out of them.
3. There are also those homework posts where you want to direct them to the answer without giving it to them. After all, if the goal of the class is to learn something, then giving them an answer to copy/paste won't help them with anything except a grade.
4. There's the OP who views the site as an answer machine: insert question---get answer. They aren't interested in learning anything.
5. Lastly, there's the OP who's irate from the get-go. Better to just walk away.
I don't think I'm the right person to tackle this one.
Edit: Added #4 and #5.
If you aren't the right person who is? You bring up some excellent points about trying to properly deal with the kind of OP.
I agree. Except I apply the 'Walk away; there are more rewarding ways of spending my time' rule to those in category 4, too :hehe:
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
August 11, 2016 at 2:37 pm
Phil Parkin (8/11/2016)
Sean Lange (8/11/2016)
Ed Wagner (8/11/2016)
Steve Jones - SSC Editor (8/11/2016)
Minor Update: The plan to replace the forums is proceeding. We've narrowed down to a couple companies, though the upgraded version of this forum is really winning. It's vastly improved, and moved from VB to C#, which makes developers happy. On pace for a final review of the plan when I go in Sept and hopefully an integration/upgrade/replacement in a month or two.That's fantastic. Do they have a database migration script or is the one you have in place too old? Please understand I mean no offense in asking; we have a number of packages that are too old.
Part of the process noted that we have a few "how to post code, how to ask a question, how to format code" articles. We do not have a "how to answer a question" article, which I think is a good idea.
I'd like to see some general rules and decorum in play here. I know some of you get frustrated, annoyed, etc by posters, but a few nice rules might help remind us of professional behavior.
Any takers on writing? If not, I can tackle it, but I am looking for feedback and ideas on what rules make sense.
I think there are multiple approaches to helping someone and it depends on the OP.
1. There's the well-posted question, complete with DDL, test data and expected results, which results in a more direct answer.
2. Then there's the post where someone posts code with no data and may or may not ask a question. That's an approach where you have to pull the actual question out of them.
3. There are also those homework posts where you want to direct them to the answer without giving it to them. After all, if the goal of the class is to learn something, then giving them an answer to copy/paste won't help them with anything except a grade.
4. There's the OP who views the site as an answer machine: insert question---get answer. They aren't interested in learning anything.
5. Lastly, there's the OP who's irate from the get-go. Better to just walk away.
I don't think I'm the right person to tackle this one.
Edit: Added #4 and #5.
If you aren't the right person who is? You bring up some excellent points about trying to properly deal with the kind of OP.
I agree. Except I apply the 'Walk away; there are more rewarding ways of spending my time' rule to those in category 4, too :hehe:
And my all-time favorites are those who are very solidly in both 2 and 5 at the same time. :w00t:
_______________________________________________________________
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/
August 11, 2016 at 3:02 pm
Ed Wagner (8/11/2016)
That's fantastic. Do they have a database migration script or is the one you have in place too old? Please understand I mean no offense in asking; we have a number of packages that are too old.
Data migration is under investigation now. I'll post some notes in another forum across the next few weeks.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
August 11, 2016 at 3:18 pm
Steve Jones - SSC Editor (8/11/2016)
Ed Wagner (8/11/2016)
That's fantastic. Do they have a database migration script or is the one you have in place too old? Please understand I mean no offense in asking; we have a number of packages that are too old.Data migration is under investigation now. I'll post some notes in another forum across the next few weeks.
Yes, we must maintain The Thread.
Viewing 15 posts - 55,291 through 55,305 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply