Cannot Authenticate User to Database SQL SERVER 2005
Posted on 2008-06-18
I have a SQL Sserver 2005 Database that was created on another system... It is authenticating with the sa password.
When I attach the databse to the new SQL Server, My application (accessing the DB with OleDB SQL Native Client) cannot log onto the SQL Server databse.
When I go to sa properties, and the User Mapping page, I am unable to map to the desired database. If I create a new database I can map to it. This feels like a SID issue.
Does anyone know how to get around this??