Username grayed out in SQL 2005 Management Studio

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
TasburathAsked:
Who is Participating?
 
YveauCommented:
If the machine is ot part of the domain, Windows Authentication will not work.
Windows Authentication only works for machines that are part of the domain.

... I think ...

Hope this helps ...
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
0
 
TasburathAuthor 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.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
TasburathAuthor Commented:
Another note.  The machine itself is not part of the domain, although the user is.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
0
 
ptjcbCommented:
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.
0
 
ptjcbCommented:
Is the machine on a separate domain? Is there a trust relationship between the domains? Is the machine a standalone?
0
 
TasburathAuthor Commented:
The machine is a standalone windows machine.  I joined it to the domain and it resolved the issue.
0
 
YveauCommented:
as we said: it won't work when the machine is outside the domain ...
Glad it turned out that easy to solve !
0
 
YveauCommented:
oops, ptjcb showed that it will work ... ?! I'm going to try that ...
0
 
ptjcbCommented:
Hmmm, I found someone else that said it would work. I only have one domain at work, so I have no place to experiment.
0
 
YveauCommented:
I'll get back on this one ptjcb. I'm the lucky DBA that has two domains at work :-)
0
 
ptjcbCommented:
Laughing...bon chance avec la.
0
 
YveauCommented:
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 !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.