Re: How to implement Windows Authentication?

Peter
Sorry for asking you, but why would you want that app creates a login ?
Why not create a login (whatever) in the first place
Everytime you launch the application it needs to check whether or not a
login already created?

Logins are for access to the SERVER
Users are for access to the DATABASE




"Peter" <Peter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5CD9DD04-318A-4803-B120-3E26F49DCFD3@xxxxxxxxxxxxxxxx
I want to create an application which can work with SQL Server 2005/2008
using Windows Authentication or SQL Authenticaton.

If the application is configured to use SQL Authentication (SQL Server is
configured to use SQL Server and Windows Authentication mode), the
application will create a SQL Login which has enough permission to create
databases used by the application and that SQL Login will also be used by
the
application to access the databases. In order to create the SQL Login,
the
application will ask for a login which has enough permissions to create
the
SQL login needed by the application.

If the application is configured to use Windows Authentication, what
should
the application do? For sure, the application will not create Windows
groups/users in Active Directory. Should the application add Windows
groups/users as SQL Logins? Is there any guideline in creating
application
to access SQL Server using Windows Authentication from having no user
databases in SQL Server to having user databases in SQL Server?


.

Relevant Pages

  • 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: Parameterized query problem
    ... Microsoft OLE DB Provider for SQL Server error '80004005' ... Cannot open database "Mydb" requested by the login. ... EXEC sp_helplogins 'aspuser' ...
    (microsoft.public.inetserver.asp.db)
  • 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: dsn-less connection
    ... It worked pretty much as I was hoping in prompting the user for a SQL ... Server login and was able to remove the specific dsn that's in the odbc ... straight to the SQL Server login prompt? ... with the login prompt but the Use Trusted Connection is checked on. ...
    (microsoft.public.access.security)
  • Re: Logging in irrespective of database access
    ... My problem is that in the Login section of Enterprise Manger I have to ... like there used to be in SQL 6.5. ... What's the point in having the Database Access section if the System Admin ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)