August 19, 2024 at 2:26 pm
Hi we just stood up a vm in azure and one of our network guys installed most of the sql stack.
He gave me local admin on the box. Is that sufficient for me to muddle thru gaining access to sql server there? if yes how? "Probably" doesnt cut it.
August 20, 2024 at 10:24 am
probably.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 20, 2024 at 3:05 pm
Well there is a lot to be desired by the question, so Johan's answer is technically right.
We don't know anything about the setup only that you have been given local admin, this may or it may not be enough to get access, depends what the other person has done to setup SQL.
Did they grant the local admin group sysadmin permission or any permissions for that fact.
What account did they give SQL sysadmin rights too, did they enable SQL auth too and if so what is the SA password.
If you can't get in to SQL by any means, then we will need a lot more info.
What you have tried, what errors you are getting etc etc so we can see the actual issue in front of you and assist appropriately.
But what you probably want is "how to login to sql when all admins are locked out"
Again this probably will work depending what level of access you where given, but it probably wont work.
Try it and feedback with greater detail and error messages so we know the immediate pressing issue and we can be more specific on fixing said issue.
August 20, 2024 at 4:11 pm
thx ant-green, good point. i should have mentioned i noticed one of our guys figured it out but because he's so hard to understand sometimes and i really wanted to know, i posted it here. its possible though that he's in a group that i'm not.
Did they grant the local admin group sysadmin permission or any permissions for that fact NO, as i couldn't connect
What account did they give SQL sysadmin rights too, did they enable SQL auth too and if so what is the SA password I wouldn't have asked the question if that was provided before.
i'll read that article to see if perhaps there is a learning opportunity here.
August 20, 2024 at 5:55 pm
You would actually be surprised how many people get others to setup SQL and they setup SA account and just toss the password away, leaving the DBAs up poop creek.
So you could be in the same boat, try and find the SA password they used or restart the server in master mode and reset it.
Failing that as it’s a new machine just trash it and start again.
August 22, 2024 at 6:59 am
This was removed by the editor as SPAM
August 22, 2024 at 2:07 pm
thx, got the sa pswd eventually as expected anyway. But was looking at the rest of this as a learning experience. will read that link soon.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply