We help IT Professionals succeed at work.

Username grayed out in SQL 2005 Management Studio

Tasburath
Tasburath asked
on
937 Views
Last Modified: 2008-01-09
I'm reposting this question because the solution accepted originally didn't work.

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?

I tried using runas both by right clicking the shortcut and selecting run as, and by creating a new shortcut using the runas parameters to specify a domain name.  In both instances, the studio still started with the local login account.  Any other ides?

Thanks
Comment
Watch Question

Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
this is the way it has to be coded:

C:\Windows\System32\runas.exe /netonly /user:domainx\myusername
   "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"

please put in the correct path in your case

Author

Commented:
I used the syntax as you stated.  It gave me a prompt for the user password, which I entered.  The studio started, but it still asks for authentication and defulats to local username with it grayed out and no way to change it.

Author

Commented:
Another note.  The machine itself is not part of the domain, although the user is.
Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
that is a scenario that I did not yet "test", so I won't be able to tell you if that can work or not...
sorry
Top Expert 2007
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Commented:
This might help. From http://www.sqlservercentral.com/Forums/Topic397973-149-1.aspx

steps:

Disconnect all network connections to the server -
Open a command prompt (start-> run->enter "cmd")
type: "net use \\[servername]"
if you see any connections to the server, you must disconnect each one first with "net use /d \\[servername]\sharename"

now run:
net use \\[servername] /user[domain\[username]
you'll be prompted for your password. enter it. if you get a message about not being able to connect with different credentials, you didn't disconnect all other connections first.

Now just run SSMS as usual, and connect with windows auth. This works even if the machine you are connecting with isn't on the domain.

Commented:
Is the machine on a separate domain? Is there a trust relationship between the domains? Is the machine a standalone?

Author

Commented:
The machine is a standalone windows machine.  I joined it to the domain and it resolved the issue.
Top Expert 2007

Commented:
as we said: it won't work when the machine is outside the domain ...
Glad it turned out that easy to solve !
Top Expert 2007

Commented:
oops, ptjcb showed that it will work ... ?! I'm going to try that ...

Commented:
Hmmm, I found someone else that said it would work. I only have one domain at work, so I have no place to experiment.
Top Expert 2007

Commented:
I'll get back on this one ptjcb. I'm the lucky DBA that has two domains at work :-)

Commented:
Laughing...bon chance avec la.
Top Expert 2007

Commented:
I did try, turned out there is a trust between the two domains ... so it works anyway :-\
Glad I could be of any help though !

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.