<div>
There is no sp_addsrvroleadmin in 2005<br />
<br />
I think you want <br />
<br />
sp_addsrvrolemember [ @loginame= ] 'login' <br />
&nbsp; &nbsp; , [ @rolename = ] 'role' <br />
<br />
Adds a login as a member of a fixed server role.
</div>


<div>
Hi,<br />
<br />
Thanks for your comment. &nbsp;So if want to add the 'sa' login name and the administrator role. &nbsp;Should I type the following:<br />
<br />
sp_addsrvrolemember @sa='login', @administrator='role'<br />
<br />
Thanks.<br />
<br />
Peter
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am using SQL Express 2005. &nbsp;I originally had the SQL server installed in Windows Authentication and now I want to change to SQL Authentication mode. I have changed the &nbsp;LoginMode in the registry to 2. Now, I am following the steps to create the SA account. &nbsp;I have gone throught the steps in T-SQL.<br />
1&gt; exec sp_addlogin 'username', 'password'<br />
2&gt; go<br />
And everything is fine.<br />
<br />
However when I type:<br />
1&gt; exec sp_addsrvroleadmin 'username', 'sysadmin'<br />
2&gt; go<br />
It tells me:<br />
Could not find stored procedure 'sp_addsrvroleadmin'
</div>
</div>


Hi,

I am using SQL Express 2005.  I originally had the SQL server installed in Windows Authentication and now I want to change to SQL Authentication mode. I have changed the  LoginMode in the registry to 2. Now, I am following the steps to create the SA account.  I have gone throught the steps in T-SQL.
1> exec sp_addlogin 'username', 'password'
2> go
And everything is fine.

However when I type:
1> exec sp_addsrvroleadmin 'username', 'sysadmin'
2> go
It tells me:
Could not find stored procedure 'sp_addsrvroleadmin'

There is no sp_addsrvroleadmin in 2005

I think you want 

sp_addsrvrolemember [ @loginame= ] &#39;login&#39; 
    , [ @rolename = ] &#39;role&#39; 

Adds a login as a member of a fixed server role.

Hi,

Thanks for your comment.  So if want to add the &#39;sa&#39; login name and the administrator role.  Should I type the following:

sp_addsrvrolemember @sa=&#39;login&#39;, @administrator=&#39;role&#39;

Thanks.

Peter

changing authentication mode and adding SA user for SQL Express 2005

Hi,

I am using SQL Express 2005.  I originally had the SQL server installed in Windows Authentication and now I want to change to SQL Authentication mode. I have changed the  LoginMode in the registry to 2. Now, I am following the steps to create the SA account.  I have gone throught the steps in T-SQL.
1&gt; exec sp_addlogin &#39;username&#39;, &#39;password&#39;
2&gt; go
And everything is fine.

However when I type:
1&gt; exec sp_addsrvroleadmin &#39;username&#39;, &#39;sysadmin&#39;
2&gt; go
It tells me:
Could not find stored procedure &#39;sp_addsrvroleadmin&#39;

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.

Microsoft SQL Server 2005

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.