May 6, 2005 at 8:49 am
I am trying to get into a server where i dont have a login setup nor do i know the SA password. Is there a way i could login as myself in that box and reset the password thru osql or any other means. I tried logging in as me (although i am not the administrator on that PC) and thru cmd prompt tried
osql -Q"exec sp_password @new = '<new_password>',@loginname = 'sa'.
I dont know the old sa password on thsi machine either. Can someone help me out how i could get onto this server?
Any help will be greatly appreciated.
TIA
May 6, 2005 at 8:51 am
You can get admin privilege on the machine and if you have not revoked access to the BUILTIN\ADMIN group, you should be able to get into SQL server and then reset the password for sa.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply