Re: MS SQL Server Management Studio Express - Changing User at Windows Authentication

Peter Auerbacher schrieb:
Hello,

if i have 2 Computers in different domains (one with a SQL Server) and want to connect to the SQL Server with Windows authentication how can i change the login information in the "Connect to server" dialog. Only in "SQL Server Authentication" Mode login / pw are changeable. How can I do this in "Windows authentication" mode.
Thx

Peter

Sorry habs versehntlich in englisch geschrieben, hier in Deutsch:

wenn ich 2 Computer in unterschiedlichen Domänen habe (einer davon ist ein SQL SERVER) und mich mit diesen vom andren aus per Management Studio Express verbinden will kann ich bei der Windows Authentifizierung den Usernamen und das Passwort nicht ändern. Dies ist nur bei SQL SERVER Authentifizierung möglich. Was muss ich tun um die Windows Authentifizierung zu ändern.

Vielen Dank

Peter
.

Relevant Pages

  • Re: Very basic login question
    ... Both computers are NOT members of a domain. ... In order to use Windows Authentication the two computers have to be ... you should have a login at the SQL Server on the XP Pro ...
    (microsoft.public.sqlserver.security)
  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Authentication Question
    ... > I have two computers in a Workgroup. ... > still use Windows Authentication for SQL Server? ... Here is some background reading on SQL Server security best practices: ...
    (microsoft.public.sqlserver.setup)
  • Re: Very basic login question
    ... In order to use Windows Authentication the two computers have to be members of the same domain or trusted domains. ... you should have a login at the SQL Server on the XP Pro workstation. ...
    (microsoft.public.sqlserver.security)
  • Re: How to install and configure SQL Server 2005 on Net work and s
    ... database to backend and then link all table from front Access database to ... we never allowed user can login to sql server to do any thing, ... Each user they required Windows Authentication when they open they won ... install the sql server. ...
    (microsoft.public.sqlserver.security)