Post reply

SQL server authentication

  • April 3, 2006 at 12:44 pm

    #167550

    I have always used SQL server authentication. I am now trying to use windows authentication between the web server and the database.

    In the SQL Server Management Studio, I have tried to add a login for the web server but have had no success.  I have an article from Microsoft that says I can specify the domain\machine$ and that should work.  I’ve noticed in the search option for adding logins the only object types for logins that are available are "users", "groups" and “Built-in security principals”.  It does not specify servers or computers. 

    It seems like this should be easy. I feel like I am going to the wrong “Add Login” page or something.

    Thanks for the help.

    Davant

     

  • April 6, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • April 7, 2006 at 11:48 am

    #631563

    Let me know if I have this right.  Are you trying to add a login that is refered as the actual server?  If so you can't.  Using Windows Authentication you have to use either a domain group, domain user, or local user that would be connecting to sql server.  SQL is autherticating that user against the database/server.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply