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 |
|
btamulis
Yak Posting Veteran
64 Posts |
 Posted - 2011-02-14 : 07:31:53
|
| I have a fresh install of SQL2008 R2 on a new server.I installed SQL2008 R2 - chose mixed mode for authentication. After install I can login to database engine using windows authentication (administrator) but can not log in as 'sa'.I get message error 15535 can not set credential for 'sa'.I also can not map the sa account to a couple of ERP databases I copied over from SQL2005 Express Edition......Any thoughts? |
|
|
btamulis
Yak Posting Veteran
64 Posts |
Posted - 2011-02-14 : 08:01:22
|
| Never Mind - I found a MSDN article - the 'Map to Credential' checkbox must be checked on the general tab under properties......... |
 |
|
|
|
|
|
New SQL2008 Install - 'sa' login doesn't work