Tasburath
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
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
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.
ASKER
Another note. The machine itself is not part of the domain, although the user is.
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
sorry
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
Is the machine on a separate domain? Is there a trust relationship between the domains? Is the machine a standalone?
ASKER
The machine is a standalone windows machine. I joined it to the domain and it resolved the issue.
as we said: it won't work when the machine is outside the domain ...
Glad it turned out that easy to solve !
Glad it turned out that easy to solve !
oops, ptjcb showed that it will work ... ?! I'm going to try that ...
Hmmm, I found someone else that said it would work. I only have one domain at work, so I have no place to experiment.
I'll get back on this one ptjcb. I'm the lucky DBA that has two domains at work :-)
Laughing...bon chance avec la.
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 !
Glad I could be of any help though !
C:\Windows\System32\runas.
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShe
please put in the correct path in your case