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:

  1. open sql server management studio (ssms)
  2. right click server
  3. click properties
  4. click security
  5. 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

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

c++ - qgraphicsview horizontal scrolling always has a vertical delta -