This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 24%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDO%3C/text%3E%3C/svg%3E)
I have a problem with permmisions. IN company we must changed our computer name and settings after migration to active directory. But I forget that my old PC name is admin in sql express. And I do not know sa password becouse in time of instalation I didn´t care of it and also dont have set option login by username and pass only win authentication. Now is the problem I can log in into server but Í cannot do anything even select. I try to add sysadmin to new PC but it always tells me you do not have permission. DO you have any idea how to get into this server or atleast get some backup of DB
Additional SQL Server features and topics not covered by specific categories
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
2 deleted commentsComments have been turned off. Learn more
If you have local Windows admin permissions, then you can fix it on your own (restore backup wouldn't help)
See Connect to SQL Server when system administrators are locked out