|
Comments
|
|
The video is very demonstrative
It needs few adjustment in the case of named instance. For example the options -s to sqlservr.exe and -S to sqlcmd.
Also, instead of [BUILTIN\administrator], I used [SERVERXX\administrator]
(SERVERXX is the name of my server)
In short, it was very useful.
Best Regards
Roger
|
|
|
thanks a lot
|
|
|
ive been searching the net for days on how to solve this problem!.. thanks!
|
|
|
Very Helpful,,Once asked me this question on interview.
|
|
|
great!!
|
|
|
I never had this problem, but I'm happy to know you provided us with a solution. Thank you very much
|
|
|
This is certainly good news for domain admins, but perhaps bad news for managers concerned about separation of duties. Is there any way to truly restrict domain admins from accessing SQL server with sa privileges, other than removing their access to the server itself(which does not seem to be a good idea)?
|
|
mike stucchi on
9/16/2009
great, really great
|
|
|
Awesome!!!!
|
|
|
For people from another coutry who doesn´t speak english,you have to speak more slowly,but the ideia of the video was perfect,thanks.
|
|
|
Cool! I enjoyed this short video saving weeks of heartache,
John
|
|
|
Good one..
|
|
|
Clear and concise. Thanks.
|
|
|
Nice, but don't speek so fast!
Kjell
|
|
|
Another excellent tutorial from Brian - Please keep them coming!!!
Pete
|
|
|
Yea very nice tricky solutions, thanks for sharing!
|
|
|
Very Informative video
|
|
|
Very Informative video
|
|
|
Excellent! Slow enough. What about 2008 ??
|
|
|
Nice and concise.
|
|
|
Doesn't the -E of sqlcmd indicate that i am a trusted account? How can i be a trusted account and not be able to authenticate?
|
|
|
I have had to do this before. Thanks for the demo
|
|
|
This actually happened to me about a month ago. Wish I had this video then. I ended up reinstalling to get around it. Thanks!
|
|
|
best video to learn !
|
|
|
Great video, I have recently been locked out on a server for same issue but didn't bother fixing it as I know the sa password, but this correction will help me save time when I am directly on the server and not needed to type the sa password.
Thanks.
|
|
|
cool.
|
|
|
Great video! Everything keyed up and ready to go. Clear explainations. Doesn't get any better than that!
|
|
|
awesome
|
|
|
very useful
|
|
Mark Sopczak on
9/25/2009
Great
|
|
|
very nice...
|
|
|
nice video but could contian a little more specific information.
|
|
Lars Mikkelsen on
11/16/2009
Excellent video. I've been stupid enough to have this problem a couple of times :D
|
|
|
Awesome video! u saved me =D
|
|
|
THANKS!
|
|
|
Excellent video!! Many people for yesrs to come will use this.
|
|
|
what credentials are needed for the user logging in when connecting via sqlcmd since you are connecting with a trusted connection?
|
|
|
Gracias!
No te imaginas cuanto me sirvió.
|
|
Lonely Rogue on
4/30/2010
Well, will this trick works on SQL Server 2008 also?
|
|
|
Interesting technique.
|
|
|
good one
|
|
|
good one
|
|
|
great
|
|
|
Great stuff. A must-have skillset for all DBA's in their arsenal. Well done Brian.
|
|
|
This 'trick' works on an instance of MSSQL 2008, I can confirm. Thank you Mr. Kelley, your video turned a difficult situation into an almost trivial one.
|
|
|
Great Video.
|
|
|
good video.. informative
|
|
Jamshid Nouri on
1/31/2012
excellent demo!
|
|
Steve Culshaw on
1/31/2012
Excellent tip, you hope you never need it, but you know you will :-)
|
|
|
Excellent
|
|
|
Excellent ....
|
|
|
you rock buddy
|
|
Charlie Bruno on
1/31/2012
Very informative video.
|
|
|
Awesome thank you. May I never need this info.
|
|
|
I would have liked more explanation on why this works.
|
|
|
Perfect video
|
|
|
Literally, a life-saver!
|
|
Dexter Jones on
1/31/2012
How about a 2008/R2 version?
|
|
James Bishop on
1/31/2012
Nice job
|
|
Max Turavani on
1/31/2012
One of our 3rd party vendors did EXACTLY what you described. I followed your video and I am back in control. Thank you!!!
|
|
|
Excellent! Maybe a follow up video explaining more uses for sqlcmd?
|
|
|
Very Cool!!!!
|
|
|
Excellent.
|
|
|
This is cool!
|
|
|
Excellent
|
|
|
Great lesson. Thank you!
|
|
|
I really wish you would have a way to grab the commands shown on the screen. It'd save a lot of time trying to find the right commands and syntax.
|
|
|
Pretty interested
|
|
|
Thanks Brian! Good info.
|
|
|
Excelent advice
|
|
|
Too fast
|
|
|
Thanks for the Video..
|
|
|
Very useful
|
|
|
Very helpful, thank you.
|
|
|
excellent!
|
|
|
good article
|
|
|
Great demo!! Got me out of a bind with a Production server that I inherited! Thanks!
|
|
|
Amazing job. Tks
|
|
|
Excellent video!!!!
Can we follow the same steps for SQL 2008\R2?
thanks for sharing.
|
|
|
fantastic!!
|