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: 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)
    • Windows Authentication Question
      ... I have two computers in a Workgroup. ... still use Windows Authentication for SQL Server? ... How can I assign dbo ...
      (microsoft.public.sqlserver.setup)
    • Re: Q: Named pipes and Windows (integrated) authentication
      ... SQL Tools - he's referring to SQL Query Analyzer and SQL Enterprise Manager ... If you don't have a full copy of SQL Server 2K you're not ... but you'll replace the Domain with the Workgroup name. ... >>his windows authentication to connect to the server. ...
      (microsoft.public.sqlserver.connect)