authentication - Creating/Accessing new database -
i have created new database in sql server 2008 r2 on local machine.
the problem reason can't seem can use sql server authentication. able log in windows authentication.
would describe steps can access database created newly created account?
this happen when not install sql server under mixed mode authentication. change this:
- open sql server management studio (ssms)
- right click server
- click properties
- click security
- under "server authentication" select "sql server , windows authentication mode"
see docs complete details: http://msdn.microsoft.com/en-us/library/ms188670(v=sql.105).aspx
Comments
Post a Comment