User setup problems in SQL Server 2005 installation on Windows 2003
Problem:
ODBC authentication problems for user and password embedded in SQL db
Solution:
1. You must set SQL server security to use both SQL Server and Windows authentication modes. To do this: Use SQL Server management studio. Go to security properties of the SQL server, i.e. properties of the top most node, then choose security settings. Set the server authentication mode to use both SQL server and Windows authentication.
2. A user must also be defined in the Databases -> security --> users portion of the SQL server studio. This use must also be a valid windows user. The password is derived from the windows password for the same user. That win user must also be in the SQL server user group (verify this using Admin tools -> computer management console)
ODBC authentication problems for user and password embedded in SQL db
Solution:
1. You must set SQL server security to use both SQL Server and Windows authentication modes. To do this: Use SQL Server management studio. Go to security properties of the SQL server, i.e. properties of the top most node, then choose security settings. Set the server authentication mode to use both SQL server and Windows authentication.
2. A user must also be defined in the Databases -> security --> users portion of the SQL server studio. This use must also be a valid windows user. The password is derived from the windows password for the same user. That win user must also be in the SQL server user group (verify this using Admin tools -> computer management console)