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

Peter Auerbacher schrieb:
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

Hallo Peter,

beim Anmelden gibt es den Punkt "Authentifizierung".

Diesen kann man umstellen auf "SQL Server-Authentifizierung".

Wenn das umgestellt wurde, dann wird nach Anmeldename und Kennwort gefragt.

Gruß

Micha
.

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: asp.net sql trusted connections between machines
    ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
    (microsoft.public.dotnet.framework.aspnet)
  • 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)