<div>
&gt;Is there a way to select a different user name for authentication?<br />
not when using windows authentication. using windows authentication means that your sql server will take your current windows login.<br />
<br />
if you want to use a different login, you have to login with a different windows account, or, which might be more useful, use the &quot;RunAs&quot; method to start your management studio with the credentials of another windows account:<br />
<a href="http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/runas.mspx?mfr=true" rel="ugc nofollow">http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/runas.mspx?mfr=true</a>
</div>


<div>
@ptjcb: a followup-question posted here:<br />
<a href="https://www.experts-exchange.com/questions/22872004/Username-grayed-out-in-SQL-2005-Management-Studio.html" rel="ugc">https://www.experts-exchange.com/questions/22872004/Username-grayed-out-in-SQL-2005-Management-Studio.html</a>
</div>


<div>
<div class="content wysiwyg-content">
I am running the Microsoft SQL Server Management Studio for SQL 2005 on my local workstation.<br />
<br />
When I start it, username is grayed out when choosing windows authentication as the Authentication mode.<br />
<br />
Is there a way to select a different user name for authentication?
</div>
</div>


I am running the Microsoft SQL Server Management Studio for SQL 2005 on my local workstation.

When I start it, username is grayed out when choosing windows authentication as the Authentication mode.

Is there a way to select a different user name for authentication?

&gt;Is there a way to select a different user name for authentication?
not when using windows authentication. using windows authentication means that your sql server will take your current windows login.

if you want to use a different login, you have to login with a different windows account, or, which might be more useful, use the &quot;RunAs&quot; method to start your management studio with the credentials of another windows account:
http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/runas.mspx?mfr=true

@ptjcb: a followup-question posted here:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_22872004.html

User name grayed out in SQL Server 2005 Server Management Studio

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.