Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jwoodsford
Starting Member
1 Post |
 Posted - 2010-10-15 : 12:07:01
|
| I created a new user in SQL server 2005 db called “afmacdev”. On every other sql server installation giving the user the default role of public will allow them to log in. For some reason, this sql server will not allow the user to log in and I have to give the user SYSADMIN role in order to log into sql server.the error message i see in the logs are:09/18/2010 09:31:26,,Error,[382] Logon to server 'VM-AFMAC-SQL\AFMAC' failed (DisableAgentXPs)09/18/2010 09:31:26,,Error,[165] ODBC Error: 0<c/> Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]09/18/2010 09:31:25,,Error,[382] Logon to server 'VM-AFMAC-SQL\AFMAC' failed (SaveAllSchedules)09/18/2010 09:31:25,,Error,[165] ODBC Error: 0<c/> Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]Jason |
|
|
|
|
|
another login issue