<div>
Hi<br />
<br />
Actually it is pretty simple to correct IF SQL is operating in Mixed mode as described <a href="http://v-consult.be/2011/05/26/recover-sa-password-microsoft-sql-server-2008-r2/" rel="ugc">here</a>.
</div>


<div>
Patricksr1972's post is exactly how to do it. &nbsp;You don't need to have SQL Server in mixed mode, though, as long as the account you are logged in as is a member of the local admin group you can log in while SQL Server is in single user mode (you may have to run SSMS or SQLCMD as administrator to properly pass your token, by the way).<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/dd207004.aspx" rel="ugc nofollow">http://msdn.microsoft.com/<wbr />en-us/libr<wbr />ary/dd2070<wbr />04.aspx</a>
</div>


<div>
I suspect the author is asking because he does not have any login that belong to the sysadmin role including the sa login. &nbsp;chaituu, is that correct?
</div>


<div>
as per the link i have completed these tasks and logged in as 'Administrator' but could n't perform the tasks.its saying &quot;it is in single mode&quot;<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/dd207004.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/dd207004.aspx</a><br />
<br />
<br />
In SQL Server Configuration Manager, in the left pane, select SQL Server Services. In the right-pane, find your instance of SQL Server. (The default instance of SQL Server includes (MSSQLSERVER) after the computer name. Named instances appear in upper case with the same name that they have in Registered Servers.) Right-click the instance of SQL Server, and then click Properties.<br />
On the Startup Parameters tab, in the Specify a startup parameter box, type -m and then click Add. (That's a dash then lower case letter m.)<br />
Note Note<br />
For some earlier versions of SQL Server there is no Startup Parameters tab. In that case, on the Advanced tab, double-click Startup Parameters. The parameters open up in a very small window. Be careful not to change any of the existing parameters. At the very end, add a new parameter ;-m and then click OK. (That's a semi-colon then a dash then lower case letter m.)<br />
Click OK, and after the message to restart, right-click your server name, and then click Restart.<br />
After SQL Server has restarted your server will be in single-user mode. Make sure that that SQL Server Agent is not running. If started, it will take your only connection.
</div>


<div>
in the above link i didnt understand the step-8.whats is the meaning of &nbsp;double-click your own login.i didnt find the Administrator login in Security-Logins..<br />
<br />
8.On the Windows 8 start screen, right-click the icon for Management Studio. At the bottom of the screen, select Run as administrator. (This will pass your administrator credentials to SSMS.)<br />
Note Note<br />
For earlier versions of Windows, the Run as administrator option appears as a sub-menu.<br />
In some configurations, SSMS will attempt to make several connections. Multiple connections will fail because SQL Server is in single-user mode. You can select one of the following actions to perform. Do one of the following.<br />
Connect with Object Explorer using Windows Authentication (which includes your Administrator credentials). Expand Security, expand Logins, and double-click your own login. On the Server Roles page, select sysadmin, and then click OK.
</div>


<div>
now i am able to login as 'sa' user.but how to login as administrator as windows authentication?
</div>


<div>
You will probably have to run SSMS as an administrator if you add the domain admins group in order to pass your admin token that will authenticate against that group. &nbsp;I usually recommend creating a SQL sysadmin group and adding that group in instead.
</div>


<div>
<div class="content wysiwyg-content">
hi,<br />
<br />
by mistake i have deleted administrator user through Security---&gt;Logins in SQL server Management Studio.in the beginning i used to login as Administor as windows authentication.now after deleting that user &nbsp;i could not login &nbsp;to db as Administrator as WINDOWS AUTHENTICATION .how to revive the administrator login in sql server 2008 R2?
</div>
</div>


hi,

by mistake i have deleted administrator user through Security--->Logins in SQL server Management Studio.in the beginning i used to login as Administor as windows authentication.now after deleting that user  i could not login  to db as Administrator as WINDOWS AUTHENTICATION .how to revive the administrator login in sql server 2008 R2?

how to revive the administrator login in sql server 2008 R2?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

IIS is Internet Information Services, the web server included with Windows Server operating systems. All current versions are built on a modular architecture; modules can be added or removed individually so that those required for specific functionality are installed. The full installation of IIS includes HTTP, security, content, compression, caching, logging and diagnostics.