I accidentally disabled my Windows Authentication login and I don't have sa login (or other login).
Windows Authentication
sa
How can I log in to SQL Server 2008?
Do the following: Troubleshooting: Connecting to SQL Server while blocking system administrators :
ResolutionStart the instance of SQL Server in single user mode using either the -m or -f options. Any member of the local computer Then the group of administrators can connect to the instance of SQL Server as a member of the sysadmin fixed server role.
Resolution
Start the instance of SQL Server in single user mode using either the -m or -f options. Any member of the local computer Then the group of administrators can connect to the instance of SQL Server as a member of the sysadmin fixed server role.
-m
-f
Source: https://habr.com/ru/post/1383484/More articles:How to reorder items in TCollection? - delphiSilverlight HttpWebRequest SecurityException - c #calling external websites from silverlight - c #iOS - buying an application - price of products - iosSecurityException from using the HttpWebRequest cross-domain domain in Silverlight 4 - securityHow to create a Bold Label control? - c #Using Boost.GIL to convert an image to raw bytes - c ++How to sort iList (with or without linq) - sortingContent Provider Announcement - androidtrack pixel by pixel in android - androidAll Articles