{"id":7623,"date":"2013-04-16T10:57:20","date_gmt":"2013-04-16T15:57:20","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=7623"},"modified":"2013-07-22T16:30:47","modified_gmt":"2013-07-22T21:30:47","slug":"sql-server-management-studio-2008-r2","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=7623","title":{"rendered":"SQL Server Management Studio 2008 R2"},"content":{"rendered":"
\n

Contents<\/h2>\n
    \n\t
  1. \n\t\tConnect to Database<\/a>\n\t\t
      \n\t\t\t
    1. \n\t\t\t\tWindows Authentication<\/a>\n\t\t\t<\/li>\n\t\t\t
    2. \n\t\t\t\tSQL Server Authentication<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
    3. \n\t\tAdd New Database User: SQL Server Authentication<\/a>\n\t\t
        \n\t\t\t
      1. \n\t\t\t\tAdd New Login<\/a>\n\t\t\t<\/li>\n\t\t\t
      2. \n\t\t\t\tTurn on SQL Server Authentication Mode<\/a>\n\t\t\t<\/li>\n\t\t\t
      3. \n\t\t\t\tAdd Login as Database User<\/a>\n\t\t\t<\/li>\n\t\t\t
      4. \n\t\t\t\tAdd Permission on Database Objects to User<\/a>\n\t\t\t<\/li>\n\t\t\t
      5. \n\t\t\t\tLogin Database as New User<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
      6. \n\t\tCreate New SQL Server Compact Database<\/a>\n\t\t
          \n\t\t\t
        1. \n\t\t\t\t<\/a>\n\t\t\t<\/li>\n<\/ol>\n<\/ol>\n<\/ol>\n<\/div>\n
           <\/div>\n

          Connect to Database<\/h2><\/span>\n

          Windows Authentication<\/h3><\/span>\n
          \"\"<\/a><\/h6><\/span>\n

          SQL Server Authentication<\/h3><\/span>\n
          \"\"<\/a><\/h6><\/span>\n

          Add New Database User: SQL Server Authentication<\/h2><\/span>\n

          Add New Login<\/h3><\/span>\n

          * Login as a privileged user, e.g. sa
          \n* Right click Database Connection > Security<\/em> folder (Note: not <\/strong>the Security folder under individual database)
          \n* Select New > Login…<\/em><\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * On Login – New<\/em> screen, enter:
          \n– Login name: test_user<\/strong>
          \n– Select SQL Server authentication<\/em>
          \n– Password:
          \n– Confirm password:
          \n– Default database: test_db<\/strong><\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * Click OK<\/em>.<\/p>\n

          Turn on SQL Server Authentication Mode<\/h3><\/span>\n

          * Right Database Connection<\/em> and select Properties<\/em><\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * On Server Properties<\/em> screen, select Security<\/em>:
          \n* Select SQL Server and Windows Authentication mode<\/em><\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * Click OK<\/em>.<\/p>\n

          Add Login as Database User<\/h3><\/span>\n

          * Right click Database Name > Security<\/em> folder (Note: not <\/strong>the Security folder under database server)
          \n* Select New > User…<\/em><\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * On Database User – New screen<\/em>, enter:
          \n– User name: test_user
          \n– Login name: (browser for Login name and select test_user)
          \n– Database role membership: db_datareader, db_datawriter (as needed)<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * Click OK<\/em>.<\/p>\n

          Add Permission on Database Objects to User<\/h3><\/span>\n

          * Open Database Name > Security<\/em> folder (Note: not <\/strong>the Security folder under database server)
          \n* Right click the user name and select Properties…<\/em>
          \n* Select Securables<\/em>
          \n* Search and browse for Database objects to grant permissions, e.g. Stored Procedures
          \n* Select database object, e.g. sp_ActiveDirectory_obj and check the Execute Grant permission<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * Click OK<\/em>.<\/p>\n

          Login Database as New User<\/h3><\/span>\n

          * Right click Database Connection and select Connect…<\/em>
          \n* Select Authentication: SQL Server Authentication<\/em>
          \n* Enter:
          \n– Login: test_user<\/strong>
          \n– Password:<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * Click Connect<\/em>.<\/p>\n

          Create New SQL Server Compact Database<\/h2><\/span>\n

          * Start SQL Server Management Studio
          \n* On Connect to Server screen, select
          \n– Server type: SQL Server Compact
          \n– Database file:
          \n* On Create New SQL Server Compact Database screen,
          \n– Enter database file name: D:\\Users\\Jianming.Li\\Documents\\SqlSvrCompact
          \n– New password: Welcome1<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * Back on Connect to Server screen, click Connect:<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * Connected to new db:<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          <\/h3><\/span>\n
          <\/h6><\/span>\n","protected":false},"excerpt":{"rendered":"

          Connect to Database Windows Authentication SQL Server Authentication Add New Database User: SQL Server Authentication Add New Login * Login as a privileged user, e.g. sa * Right click Database Connection > Security folder (Note: not the Security folder under … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[17],"tags":[373,313],"class_list":["post-7623","post","type-post","status-publish","format-standard","hentry","category-sqlserver","tag-connection","tag-sqlserver-2"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-1YX","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/7623","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7623"}],"version-history":[{"count":8,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/7623\/revisions"}],"predecessor-version":[{"id":7875,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/7623\/revisions\/7875"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7623"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7623"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7623"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}