{"id":12,"date":"2009-05-27T12:19:13","date_gmt":"2009-05-27T10:19:13","guid":{"rendered":"http:\/\/www.caw.co.za\/?p=12"},"modified":"2014-11-07T07:33:48","modified_gmt":"2014-11-07T05:33:48","slug":"cannot-connect-to-the-database-after-installing-sms-client","status":"publish","type":"post","link":"https:\/\/www.caw.co.za\/?p=12","title":{"rendered":"Cannot connect to the database after installing SMS Client"},"content":{"rendered":"<p>The SMS Client software uses a Microsoft SQL Compact Edition database to store customer and SMS history data. If the Microsoft SQL Server Compact Edition Runtime is not installed the SMS Client software cannot access the database.<\/p>\n<p><em>Resolution<\/em><br \/>\nCheck that the correction version of Microsoft SQL Server Compact Edition Runtime is installed. <\/p>\n<ul>\nSMSClient 2x requires Microsoft SQL Server Compact Edition Runtime 3.5 SP1<\/ul>\n<ul>\nSMSClient 3x requires Microsoft SQL Server Compact Edition Runtime 3.5 SP2\n<\/ul>\n<p>The versions of Microsoft SQL Server Compact Edition Runtime 3.5 cannot be mixed. Use the same version for all installations of SMSClient.<\/p>\n<p>Download the Microsoft SQL Server Compact Edition Runtime from <a href=\"http:\/\/www.caw.co.za\/smsclient\/download\/SSCERuntime-ENU.exe\">here<\/a> and install the package.<br \/>\nThe SMS Client software should now be able to connect to the database.<\/p>\n<p><strong>If you are using Windows Vista\/Windows 7\/Windows 8\/Windows 8.1<\/strong><br \/>\nWindows UAC (user access control) prevents software from updating configuration settings if the user is not running the software under elevated privilege. The first time after installing or upgrading SMSClient you may receive a message that SMSClient could not connect to the database.<\/p>\n<p><em>Resolution<\/em><br \/>\nRight click on the SMSClient icon and select &#8216;Run as administrator&#8217; from the popup menu (see below). This will allow SMSClient to update its configuration settings. You should only be required to do this once. Under normal conditions the elevated security is not required.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-34\" title=\"faq-0001\" src=\"http:\/\/www.caw.co.za\/wp-content\/uploads\/2009\/05\/faq-00012.png\" alt=\"faq-0001\" width=\"201\" height=\"161\" \/><\/p>\n<p>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The SMS Client software uses a Microsoft SQL Compact Edition database to store customer and SMS history data. If the Microsoft SQL Server Compact Edition Runtime is not installed the SMS Client software cannot access the database. Resolution Check that the correction version of Microsoft SQL Server Compact Edition Runtime is installed. SMSClient 2x requires&hellip;&nbsp;<a href=\"https:\/\/www.caw.co.za\/?p=12\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Cannot connect to the database after installing SMS Client<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-12","post","type-post","status-publish","format-standard","hentry","category-sms-client"],"_links":{"self":[{"href":"https:\/\/www.caw.co.za\/index.php?rest_route=\/wp\/v2\/posts\/12","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.caw.co.za\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.caw.co.za\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.caw.co.za\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.caw.co.za\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12"}],"version-history":[{"count":6,"href":"https:\/\/www.caw.co.za\/index.php?rest_route=\/wp\/v2\/posts\/12\/revisions"}],"predecessor-version":[{"id":197,"href":"https:\/\/www.caw.co.za\/index.php?rest_route=\/wp\/v2\/posts\/12\/revisions\/197"}],"wp:attachment":[{"href":"https:\/\/www.caw.co.za\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.caw.co.za\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.caw.co.za\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}