SQL server authentication

• Davant Stewart

  SSC Rookie

  Points: 41

  More actions

  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

• brianreisch

  Mr or Mrs. 500

  Points: 557

  More actions

  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.