{"id":312,"date":"2010-01-18T17:49:32","date_gmt":"2010-01-18T17:49:32","guid":{"rendered":"http:\/\/ravtrack.com\/GPStracking\/?p=312"},"modified":"2010-05-12T12:48:17","modified_gmt":"2010-05-12T12:48:17","slug":"configuring-a-microsoft-sql-server-installation","status":"publish","type":"post","link":"https:\/\/ravtrack.com\/GPStracking\/configuring-a-microsoft-sql-server-installation\/","title":{"rendered":"Configuring a Microsoft SQL Server Installation"},"content":{"rendered":"

With release of RavTrack PC vesion 3.1, RavTrack PC supports Microsoft’s SQL Server 2005 and 2008.\u00a0 By default, RavTrack PC uses Microsoft Access databases and tables to store its inforamtion.\u00a0 Access is a very good choice for a database when RavTrack PC software is ging to be run on a single workstation, in a vehicle, or when the number of concurrent users is small.\u00a0<\/p>\n

But, when the number of users running RavTrack PC increases, or when the size of the Log table is large, Microsoft’s SQL Server is a superior product, albeit a bit more complex to install and manage.\u00a0<\/p>\n

You can download RavTrack PC evaluation copy free as well as the technical manual from Ravoen’s web site at: http:\/\/ravtrack.com\/RavTrack-PC-Software.html<\/a>\u00a0<\/p>\n

If you are going to use a Microsoft SQL Server 2005 or SQL Server 2008 database with RavTrack PC,<\/em> then you will need to prepare the SQL Server first, before running RavTrack PC.\u00a0 Perform the following steps:<\/p>\n

SQL Server Installation<\/h3>\n
    \n
  1. Install Microsoft SQL Server or SQL Server Express.\u00a0 SQL Server Express is available from Microsoft at no charge. It may be downloaded at: http:\/\/www.microsoft.com\/Sqlserver\/2005\/en\/us\/express.aspx<\/a><\/li>\n
  2. Use the \u201cSQL Server Configuration Manager<\/em>\u201d software program that is installed with MS SQL Server to configure the server.<\/li>\n
  3. Using the SQL Server Configuration Manager, e<\/em>nable the TCP\/IP Client Protocol (SQL Server Configuration Manager > SQL Natice Client Configuration > Client Protocols > TCP\/IP<\/em>).<\/li>\n
  4. Also download and install the \u201cManagement Studio<\/em>\u201d for SQL Server.\u00a0 The Express version may be downloaded at the same website as the SQL Server Express is downloaded from.<\/li>\n
  5. Set the default transaction time-out of Management Studio<\/em> to 1000 seconds (Tools> Options> Designers> Transaction Timeout)<\/li>\n
  6. Using the Management studio, create a database with the name \u201cRavTrack<\/span>\u201d. You do not need to create any tables in the database, as RavTrack PC<\/em> will create them the first time it connects to this database.<\/li>\n
  7. Using Management Studio, create Login accouts for all users what will be accessing the SQL database using RavTrack PC.\u00a0<\/li>\n<\/ol>\n

    Troubleshooting:<\/strong><\/h3>\n

    If you are having trouble connecting RavTrack PC<\/em> to your SQL server installation, check the following items:<\/p>\n

      \n
    1. Shut down RavTrack PC<\/em> using FIle > Exit, and restart it.\u00a0 Whenever the database type is changed in RavTrack PC, <\/em>you should restart the application.<\/li>\n
    2. Install Microsoft’s Management Studio<\/em> <\/em>applicationon the computer running RavTrack PC<\/em>.\u00a0 Use Management Studio to connect to the server to verify that the SQL Server is running properly and accessible from the workstation.<\/li>\n
    3. Make sure the the TCP\/IP Client Protocol is enabled on the SQL Server.<\/li>\n
    4. Make sure you are logged into RavTrack PC as an administrator with the ADMIN account.<\/li>\n
    5. Make sure you have purchased and installed an “Unlimited<\/em>” license on RavTrack PC<\/em>. The “Limited<\/em>” version will not connect to an SQL Server.<\/li>\n
    6. Make sure you created a database on the SQL server named “RavTrack”.\u00a0 The RavTrack database needs to be on the server before running the RavTrack PC<\/em> program.\u00a0 Yse the Management Studio to create the “RavTrack” database on the server.<\/li>\n
    7. You should have an account on the SQL Server computer with the same name and password as the name\/password that you used to log onto Windows on the RavTrack PC<\/em> computer. If you have not done this, create a Windows user account and password on the SQL Server computer to match the Windows user\/password on the RavTrack PC<\/em> Windows login account.<\/li>\n
    8. Make sure the rights assigned to the login account are at least db_reader, db_writer, and db_admin.\u00a0<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      With release of RavTrack PC vesion 3.1, RavTrack PC supports Microsoft’s SQL Server 2005 and 2008.\u00a0 By default, RavTrack PC uses Microsoft Access databases and tables to store its inforamtion.\u00a0 Access is a very good choice for a database when…<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44,39],"tags":[],"yoast_head":"\nConfiguring a Microsoft SQL Server Installation - GPS Tracking - RavTrack Complete Real Time Tracking<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ravtrack.com\/GPStracking\/configuring-a-microsoft-sql-server-installation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Configuring a Microsoft SQL Server Installation - GPS Tracking - RavTrack Complete Real Time Tracking\" \/>\n<meta property=\"og:description\" content=\"With release of RavTrack PC vesion 3.1, RavTrack PC supports Microsoft’s SQL Server 2005 and 2008.\u00a0 By default, RavTrack PC uses Microsoft Access databases and tables to store its inforamtion.\u00a0 Access is a very good choice for a database when…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ravtrack.com\/GPStracking\/configuring-a-microsoft-sql-server-installation\/\" \/>\n<meta property=\"og:site_name\" content=\"GPS Tracking - RavTrack Complete Real Time Tracking\" \/>\n<meta property=\"article:published_time\" content=\"2010-01-18T17:49:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2010-05-12T12:48:17+00:00\" \/>\n<meta name=\"author\" content=\"JS\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"JS\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ravtrack.com\/GPStracking\/configuring-a-microsoft-sql-server-installation\/\",\"url\":\"https:\/\/ravtrack.com\/GPStracking\/configuring-a-microsoft-sql-server-installation\/\",\"name\":\"Configuring a Microsoft SQL Server Installation - GPS Tracking - RavTrack Complete Real Time Tracking\",\"isPartOf\":{\"@id\":\"https:\/\/ravtrack.com\/GPStracking\/#website\"},\"datePublished\":\"2010-01-18T17:49:32+00:00\",\"dateModified\":\"2010-05-12T12:48:17+00:00\",\"author\":{\"@id\":\"https:\/\/ravtrack.com\/GPStracking\/#\/schema\/person\/a5c8be48c037158a55b9d456dd065931\"},\"breadcrumb\":{\"@id\":\"https:\/\/ravtrack.com\/GPStracking\/configuring-a-microsoft-sql-server-installation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ravtrack.com\/GPStracking\/configuring-a-microsoft-sql-server-installation\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ravtrack.com\/GPStracking\/configuring-a-microsoft-sql-server-installation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ravtrack.com\/GPStracking\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Configuring a Microsoft SQL Server Installation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ravtrack.com\/GPStracking\/#website\",\"url\":\"https:\/\/ravtrack.com\/GPStracking\/\",\"name\":\"GPS Tracking - RavTrack Complete Real Time Tracking\",\"description\":\"GPS Tracking System Blogs Articles News\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ravtrack.com\/GPStracking\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/ravtrack.com\/GPStracking\/#\/schema\/person\/a5c8be48c037158a55b9d456dd065931\",\"name\":\"JS\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ravtrack.com\/GPStracking\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/81e959a1edf11a7ce64aef82d8c9c5e7?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/81e959a1edf11a7ce64aef82d8c9c5e7?s=96&r=g\",\"caption\":\"JS\"},\"url\":\"https:\/\/ravtrack.com\/GPStracking\/author\/js\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Configuring a Microsoft SQL Server Installation - GPS Tracking - RavTrack Complete Real Time Tracking","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ravtrack.com\/GPStracking\/configuring-a-microsoft-sql-server-installation\/","og_locale":"en_US","og_type":"article","og_title":"Configuring a Microsoft SQL Server Installation - GPS Tracking - RavTrack Complete Real Time Tracking","og_description":"With release of RavTrack PC vesion 3.1, RavTrack PC supports Microsoft’s SQL Server 2005 and 2008.\u00a0 By default, RavTrack PC uses Microsoft Access databases and tables to store its inforamtion.\u00a0 Access is a very good choice for a database when…","og_url":"https:\/\/ravtrack.com\/GPStracking\/configuring-a-microsoft-sql-server-installation\/","og_site_name":"GPS Tracking - RavTrack Complete Real Time Tracking","article_published_time":"2010-01-18T17:49:32+00:00","article_modified_time":"2010-05-12T12:48:17+00:00","author":"JS","twitter_card":"summary_large_image","twitter_misc":{"Written by":"JS","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ravtrack.com\/GPStracking\/configuring-a-microsoft-sql-server-installation\/","url":"https:\/\/ravtrack.com\/GPStracking\/configuring-a-microsoft-sql-server-installation\/","name":"Configuring a Microsoft SQL Server Installation - GPS Tracking - RavTrack Complete Real Time Tracking","isPartOf":{"@id":"https:\/\/ravtrack.com\/GPStracking\/#website"},"datePublished":"2010-01-18T17:49:32+00:00","dateModified":"2010-05-12T12:48:17+00:00","author":{"@id":"https:\/\/ravtrack.com\/GPStracking\/#\/schema\/person\/a5c8be48c037158a55b9d456dd065931"},"breadcrumb":{"@id":"https:\/\/ravtrack.com\/GPStracking\/configuring-a-microsoft-sql-server-installation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ravtrack.com\/GPStracking\/configuring-a-microsoft-sql-server-installation\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ravtrack.com\/GPStracking\/configuring-a-microsoft-sql-server-installation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ravtrack.com\/GPStracking\/"},{"@type":"ListItem","position":2,"name":"Configuring a Microsoft SQL Server Installation"}]},{"@type":"WebSite","@id":"https:\/\/ravtrack.com\/GPStracking\/#website","url":"https:\/\/ravtrack.com\/GPStracking\/","name":"GPS Tracking - RavTrack Complete Real Time Tracking","description":"GPS Tracking System Blogs Articles News","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ravtrack.com\/GPStracking\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ravtrack.com\/GPStracking\/#\/schema\/person\/a5c8be48c037158a55b9d456dd065931","name":"JS","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ravtrack.com\/GPStracking\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/81e959a1edf11a7ce64aef82d8c9c5e7?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/81e959a1edf11a7ce64aef82d8c9c5e7?s=96&r=g","caption":"JS"},"url":"https:\/\/ravtrack.com\/GPStracking\/author\/js\/"}]}},"_links":{"self":[{"href":"https:\/\/ravtrack.com\/GPStracking\/wp-json\/wp\/v2\/posts\/312"}],"collection":[{"href":"https:\/\/ravtrack.com\/GPStracking\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ravtrack.com\/GPStracking\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ravtrack.com\/GPStracking\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ravtrack.com\/GPStracking\/wp-json\/wp\/v2\/comments?post=312"}],"version-history":[{"count":11,"href":"https:\/\/ravtrack.com\/GPStracking\/wp-json\/wp\/v2\/posts\/312\/revisions"}],"predecessor-version":[{"id":316,"href":"https:\/\/ravtrack.com\/GPStracking\/wp-json\/wp\/v2\/posts\/312\/revisions\/316"}],"wp:attachment":[{"href":"https:\/\/ravtrack.com\/GPStracking\/wp-json\/wp\/v2\/media?parent=312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ravtrack.com\/GPStracking\/wp-json\/wp\/v2\/categories?post=312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ravtrack.com\/GPStracking\/wp-json\/wp\/v2\/tags?post=312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}