Re: Windows Authentication Question

From: Steve Thompson (stevethompson_at_nomail.please)
Date: 08/10/04

  • Next message: ehank: "Media to install Standard Edition under MSDN" 
    Date: Tue, 10 Aug 2004 15:44:04 -0400

    "G. Dean Blake" <Dean@nospam.com> wrote in message
    news:urDw5ymfEHA.3556@TK2MSFTNGP12.phx.gbl...
    > I have two computers in a Workgroup. Since I don't run a Domain, can I
    > still use Windows Authentication for SQL Server?

    Windows Authenication only applies to login credentials that were
    authenticated on a domain level, or logging on a stand-alone server.

    >How can I assign dbo
    > permission to my user account on each computer in the workgroup?

    Hmmm, I really cannot think of any secure way to do that.

    Here is some background reading on SQL Server security best practices:
    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sp3sec01.mspx
    Also, check BOL under "authentication modes".

    Steve

  • Next message: ehank: "Media to install Standard Edition under MSDN"

    Relevant Pages

    • 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: 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: MS SQL Server Management Studio Express - Changing User at Windows Authentication
      ... 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. ... wenn ich 2 Computer in unterschiedlichen Domänen habe 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. ...
      (microsoft.public.de.german.entwickler.dotnet.datenbank)
    • Re: MS SQL Server Management Studio Express - Changing User at Windows Authentication
      ... 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. ... wenn ich 2 Computer in unterschiedlichen Domänen habe 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. ...
      (microsoft.public.de.german.entwickler.dotnet.datenbank)
    • Re: Login failed for user . The user is not associated with a tru
      ... You can use Windows authentication in a workgroup, ... logged in to SQL Server, and is not a matter here. ... Books Online for SQL Server 2005 at ...
      (microsoft.public.sqlserver.security)