{"id":20863,"date":"2016-03-17T16:00:09","date_gmt":"2016-03-17T09:00:09","guid":{"rendered":"http:\/\/tom.ji42.com\/?p=20863"},"modified":"2016-03-17T16:00:09","modified_gmt":"2016-03-17T09:00:09","slug":"configure-ms-sql-server-2005-remote-access-mixed-mode","status":"publish","type":"post","link":"https:\/\/tom.tomwork.net\/?p=20863","title":{"rendered":"Configure MS SQL Server 2005 Remote Access ( mixed mode )"},"content":{"rendered":"

MS SQL Server 2005 remote access configuration is different from MS SQL Server 2000. Remote access to MS SQL Server 2005 with user and password is required and necessary for any database applications. If MS SQL Server 2005 is originally configured for windows authentication, configuration for remote access ( mixed mode or SQL Server authentication ) needs a little more extra work to get it done.<\/p>\n

Here is how to get this done.<\/p>\n

    \n
  1. Configuration in SQL Server Management Studio<\/strong><\/li>\n<\/ol>\n

    <\/p>\n

    Click \u201cAll Programs\u201d -> Click \u201cMicrosoft SQL Server 2005\u201d -> click \u201cMicrosoft SQL Server Management Studio\u201d<\/p>\n

    Log in to SQL Server 2005 with windows authentication or sa user;<\/p>\n

    Highlight the server and right click \u201cProperties\u201d;<\/p>\n

    Highlight \u201cSecurity\u201d\u00a0 -> Under \u201cServer authentication\u201d,\u00a0 choose \u201cSQL Server and Windows authentication mode\u201d;<\/p>\n

    Highlight \u201cConnections\u201d -> Under \u201cRemote server connections\u201d,\u00a0 choose \u201cAllow remote connections to this server\u201d;<\/p>\n

     <\/p>\n

    Click OK to save the settings.<\/p>\n

      \n
    1. Configuration in SQL Server Surface Area Configuration<\/strong><\/li>\n<\/ol>\n

      Click \u201cAll Programs\u201d -> Click \u201cMicrosoft SQL Server 2005\u201d -> click \u201cConfiguration Tools\u201d -> click \u201cSQL Server 2005 Surface Area Configuration\u201d<\/p>\n

      Click \u201cSurface Area Configuration for Services and Connections\u201d -> click \u201cMSSQLSERVER\u201d -> click \u201cDatabase engine\u201d -> click \u201cRemote connections \u201d -> Under \u201cLocal and remote connections\u201d, choose \u201cUsing TCP\/IP only\u201d or other protocols.<\/p>\n

      Click \u201cApply\u201d to save the settings.<\/p>\n

        \n
      1. Stop SQL server and restart SQL server<\/strong><\/li>\n<\/ol>\n

        Use \u201cSQL Server Management Studio\u201d or Services in Control Panel to stop SQL Server and then restart the SQL Server. This process is used to initialize the change settings.<\/p>\n

          \n
        1. Test the changes
          \n<\/strong>-Create the user through \u201cSecurity\u201d -> \u201cLogins\u201d -> \u201cNew Logins\u2026\u201d
          \n-log in with the newly created user when \u201cAuthentication\u201d is \u201cSQL Server authentication\u201d under local SQL server or under remote SQL server.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

          MS SQL Server 2005 remote access configuration is different from MS SQL Server 2000. Remote access to MS SQL Server 2005 with user and password is required and necessary for any database applications. If MS SQL Server 2005 is originally configured for windows authentication, configuration for remote access ( mixed mode or SQL Server authentication […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_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":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[13],"tags":[],"class_list":["post-20863","post","type-post","status-publish","format-standard","hentry","category-13"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6cOVM-5qv","_links":{"self":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/20863","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=20863"}],"version-history":[{"count":1,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/20863\/revisions"}],"predecessor-version":[{"id":20864,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/20863\/revisions\/20864"}],"wp:attachment":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20863"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}