SQL Server login authenticity ID???

[troop49]

When i try to connect thru the ODBC Data Source Administrator
is it asking me to enter a :
SQL Server authenticity of the login id?

where on the SQL server do i set the user name and password to that instance or database?

 

[mrdenny]

If you are connecting through SQL Server Management Studio, within the object explorer connect to the instance, then navigate to security > Logins and there you can create a new login to use to connect to the database.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Blog