Share via

Windows Authentication: User name & Password area grayed out and unusable...

  • Article

Question

Thursday, August 2, 2007 10:42 PM

I'm trying to connect to a SQL Server 2005 database engine on a local network server.  When I am presented with the Connect to Server dialog box, if I select Windows Authentication from the Authentication drop-down, the User name & Password area is grayed out and unusable.  The domain user account I'm authenticated with is visible, but grayed out, and the password field is blank and unusable.  I'd like to be able to connect as described in help:

 

User name
Enter the user name to connect with. This option is only available if you have selected to connect using Windows Authentication.

 

I can connect with either SQL Server or Windows authentication... but with Windows Authentication I'd love to be able to type a specific user name to select with :-)

All replies (3)

Friday, August 3, 2007 12:14 AM âś…Answered

This is by design. The username / password combination is only for SQL Server Authentication. if you want to connect to a server using Windows authentication, you will either have to predefine the credentials in the Store usernames and password" Section of Windows XP / Windows 2003 Server / Windows Vista or use the Runas command to start the process with another user.

Jens K. Suessmeyer

http://www.sqlserver2005.de

Wednesday, August 8, 2007 6:57 PM | 1 vote

Thanks Jens!

 

To solve my problem, I did 2 things on my XP Pro laptop that is not logged into any domain...

 

1) Click start/control panel/user accounts/click on my user account/manage my network passwords:

  • I made an entry for the SQL Server computer hostname... FOOXXX
  • I entered the specific domain account to connetc with, and it's password...  DOMAINSERVERNAME\SoCalSam     Passw0rd

2) launch SQL Server Management Studio with command line switches to specify the server and to use Windows Authentication (the domain user and password info is picked up for that server from the entry in step 1):

  • "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe" -S FOOXXX -E

 

Take care...

SoCalSam

 

Friday, February 24, 2012 6:37 PM

Well its a crummy design.

Situation:

I have a SQL Server from a 3rd party.  Because its owned by a 3rd party it's not joined to the domain.  I need to access it from my workstation which is on the domain.  SQL authentication is not turned on the 3rd party server.  I can turn it on but the poor design of the product requires you to restart the SQL service.  Something that cannot be done in the middle of a workday.