<div>
you want full admin access to the database server? &nbsp;is that correct?<br />
<br />
if you could let us know exactly what you are attempting to do that would help us point you in the right direction<br />
<br />
let us know, thanks!
</div>


you want full admin access to the database server?  is that correct?

if you could let us know exactly what you are attempting to do that would help us point you in the right direction

let us know, thanks!

<div>
dn0rm<br />
Nothing really. I have to install MS SQL 2005 for this guy who needs to do some work. He claims he does not have full admin access to the database. FYI, MS SQL 2005 is running on a Window 2008 server and all i want to do is to ensure his domain account which is a member of the local admin group has full admin access. SQL was installed with the local admin account.
</div>


dn0rm
Nothing really. I have to install MS SQL 2005 for this guy who needs to do some work. He claims he does not have full admin access to the database. FYI, MS SQL 2005 is running on a Window 2008 server and all i want to do is to ensure his domain account which is a member of the local admin group has full admin access. SQL was installed with the local admin account.

<div>
use windows authentication mode which is full access to database.
</div>


use windows authentication mode which is full access to database.

<div>
You can use below sp to assign sysadmin server role to your desired account. The user will have all the admin rights.<br />
<br />
sp_addsrvrolemember 'youruserhere', 'sysadmin'
</div>


You can use below sp to assign sysadmin server role to your desired account. The user will have all the admin rights.

sp_addsrvrolemember 'youruserhere', 'sysadmin'

<div>
<div class="content wysiwyg-content">
hi<br />
I'm a newbie with MS SQL 2005. Could someone tell me how to grant FULL Admin access to a domain account?
</div>
</div>


hi
I'm a newbie with MS SQL 2005. Could someone tell me how to grant FULL Admin access to a domain account?

MS SQL 2005 Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.