Hi All,
I understand this has probably asked a gazillion times... BUT I have issue with the solution... ( I DO NOT WANT TO ENABLE SQL Server Authentication)
I have developers that need to manage MANY SQL Servers.. some in domains some not.. some develpers boxes are in domains.. some not.
I DO NOT want to have sa or any other password for that matter flying around the net in the clear (i.e. SQL Server Authentication). I would like for the developers to be able to connect to servers using Enterprise Manager (SQL 2000 sp4) by entering their windows userid and password for that particular server.
For the life of me I cannot figure out how to get Enterprise Manager to prompt (i.e. Domain\usernam) for the windows ID and password.
Seem rather silly to me that I can map to the C$ share on a machine if I have an admin account .. but I cant connect to the database server !!!!!!
HELP! !!!!!
Login failed for user 'username'. The user is not associated with a trusted SQL Server connection
bmilliron
The only possible solution for me is to start the Management Console with the runas command specifying the account you want to logon. In EM you can specify a Windows logon, because it’s using implicit *integrated* authentication rather than *prompted* authentication.
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
Jose Fco Castano
Have you tried with letting your developers enter the domain account credentials in the Windows XP user account password list Even if you like the stored password possibility or not it works when I use it to connect to Integration Services even when I'm not part of the domain. Thus if you register the SQL server with integrated security after you have entered the credentials in XPs user account password list it might work.
/Johan
Ghassan Tadros
croarty
I have developers that need to manage MANY SQL Servers.. some in domains some not..
Common way is to enable SQL Server Authentication.
MSSQL connectivity libraries don't provide the feature to pass any windows id's through connection string. And that's good for security reasons.