asked on

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

Guy Hengel [angelIII / a3]

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

Tasburath

ASKER

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.

Tasburath

ASKER

Another note. The machine itself is not part of the domain, although the user is.

Guy Hengel [angelIII / a3]

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

ASKER CERTIFIED SOLUTION

Yveau

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ptjcb

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.

ptjcb

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

Tasburath

ASKER

The machine is a standalone windows machine. I joined it to the domain and it resolved the issue.

Yveau

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

Yveau

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

ptjcb

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

Yveau

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

ptjcb

Laughing...bon chance avec la.

Yveau

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 !