{"id":325,"date":"2010-01-26T23:13:13","date_gmt":"2010-01-26T23:13:13","guid":{"rendered":"http:\/\/ravtrack.com\/GPStracking\/?p=325"},"modified":"2010-01-26T23:38:37","modified_gmt":"2010-01-26T23:38:37","slug":"microsoft-sql-server-user-logins","status":"publish","type":"post","link":"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/","title":{"rendered":"Microsoft SQL Server User Logins"},"content":{"rendered":"

When you choose to use Microsoft SQL Server for your RavTrack PC database, all of the location information of the GPS tracked vehicles will be stored in the SQL database called “RavTrack<\/strong>“.\u00a0\u00a0 You must create this database manually using Micrtosoft’s Management Studio software program, and then assign the user login rights to the database.\u00a0 RavTrack PC<\/em> will create the tables within the database.\u00a0<\/p>\n

The steps to take to setup the RavTrack SQL database in SQL Server 2005 or 2008 are as follows:<\/p>\n

    \n
  1. Using the Management studio, create a database with the name \u201cRavTrack<\/strong>\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
  2. Using Management Studio<\/em>, create security login accounts for the users that will be using RavTrack PC<\/em> on the network.\u00a0 Right click on Databases > Security > Logins > New Login\u2026\u00a0 to create a new login account for each user. Set the Server Role to \u201cserveradmin\u201d.\u00a0
    \n\"S1\"<\/li>\n
  3. Using Management Studio<\/em>, assign the new user login to the RavTrack database.\u00a0 Right click on Databases > RavTrack > Security > Users . Add User\u2026\u00a0 to add the new user to the database.\u00a0 Set the Role Members\u201d to db_datawriter and db_datareader.\u00a0\"S2\"<\/li>\n<\/ol>\n

    Management Studio<\/em>is a very good tool to use not only for configuring SQL Server, but also to verify that connections to the RavTrack database are OK.\u00a0\u00a0 On any workstation that you feel there is a login problem with the database, login to that workstation with the user name and password, run Management Studio<\/em>, and try to access the RavTrack<\/strong> database.\u00a0 If you can access it and list the tables, then the user name and password has the proper rights configured on the server.\u00a0<\/p>\n

    There is a verion of Microsoft SQL Management Studio for every version of their SQL Server program.<\/p>\n","protected":false},"excerpt":{"rendered":"

    When you choose to use Microsoft SQL Server for your RavTrack PC database, all of the location information of the GPS tracked vehicles will be stored in the SQL database called “RavTrack“.\u00a0\u00a0 You must create this database manually using Micrtosoft’s…<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39],"tags":[],"yoast_head":"\nMicrosoft SQL Server User Logins - 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\/microsoft-sql-server-user-logins\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft SQL Server User Logins - GPS Tracking - RavTrack Complete Real Time Tracking\" \/>\n<meta property=\"og:description\" content=\"When you choose to use Microsoft SQL Server for your RavTrack PC database, all of the location information of the GPS tracked vehicles will be stored in the SQL database called “RavTrack“.\u00a0\u00a0 You must create this database manually using Micrtosoft’s…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/\" \/>\n<meta property=\"og:site_name\" content=\"GPS Tracking - RavTrack Complete Real Time Tracking\" \/>\n<meta property=\"article:published_time\" content=\"2010-01-26T23:13:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2010-01-26T23:38:37+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/ravtrack.com\/GPStracking\/wp-content\/uploads\/2010\/01\/S1.jpg\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/\",\"url\":\"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/\",\"name\":\"Microsoft SQL Server User Logins - GPS Tracking - RavTrack Complete Real Time Tracking\",\"isPartOf\":{\"@id\":\"https:\/\/ravtrack.com\/GPStracking\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/ravtrack.com\/GPStracking\/wp-content\/uploads\/2010\/01\/S1.jpg\",\"datePublished\":\"2010-01-26T23:13:13+00:00\",\"dateModified\":\"2010-01-26T23:38:37+00:00\",\"author\":{\"@id\":\"https:\/\/ravtrack.com\/GPStracking\/#\/schema\/person\/a5c8be48c037158a55b9d456dd065931\"},\"breadcrumb\":{\"@id\":\"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/#primaryimage\",\"url\":\"https:\/\/ravtrack.com\/GPStracking\/wp-content\/uploads\/2010\/01\/S1.jpg\",\"contentUrl\":\"https:\/\/ravtrack.com\/GPStracking\/wp-content\/uploads\/2010\/01\/S1.jpg\",\"width\":\"548\",\"height\":\"503\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ravtrack.com\/GPStracking\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft SQL Server User Logins\"}]},{\"@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":"Microsoft SQL Server User Logins - 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\/microsoft-sql-server-user-logins\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft SQL Server User Logins - GPS Tracking - RavTrack Complete Real Time Tracking","og_description":"When you choose to use Microsoft SQL Server for your RavTrack PC database, all of the location information of the GPS tracked vehicles will be stored in the SQL database called “RavTrack“.\u00a0\u00a0 You must create this database manually using Micrtosoft’s…","og_url":"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/","og_site_name":"GPS Tracking - RavTrack Complete Real Time Tracking","article_published_time":"2010-01-26T23:13:13+00:00","article_modified_time":"2010-01-26T23:38:37+00:00","og_image":[{"url":"http:\/\/ravtrack.com\/GPStracking\/wp-content\/uploads\/2010\/01\/S1.jpg"}],"author":"JS","twitter_card":"summary_large_image","twitter_misc":{"Written by":"JS","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/","url":"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/","name":"Microsoft SQL Server User Logins - GPS Tracking - RavTrack Complete Real Time Tracking","isPartOf":{"@id":"https:\/\/ravtrack.com\/GPStracking\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/#primaryimage"},"image":{"@id":"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/#primaryimage"},"thumbnailUrl":"http:\/\/ravtrack.com\/GPStracking\/wp-content\/uploads\/2010\/01\/S1.jpg","datePublished":"2010-01-26T23:13:13+00:00","dateModified":"2010-01-26T23:38:37+00:00","author":{"@id":"https:\/\/ravtrack.com\/GPStracking\/#\/schema\/person\/a5c8be48c037158a55b9d456dd065931"},"breadcrumb":{"@id":"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/#primaryimage","url":"https:\/\/ravtrack.com\/GPStracking\/wp-content\/uploads\/2010\/01\/S1.jpg","contentUrl":"https:\/\/ravtrack.com\/GPStracking\/wp-content\/uploads\/2010\/01\/S1.jpg","width":"548","height":"503"},{"@type":"BreadcrumbList","@id":"https:\/\/ravtrack.com\/GPStracking\/microsoft-sql-server-user-logins\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ravtrack.com\/GPStracking\/"},{"@type":"ListItem","position":2,"name":"Microsoft SQL Server User Logins"}]},{"@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\/325"}],"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=325"}],"version-history":[{"count":3,"href":"https:\/\/ravtrack.com\/GPStracking\/wp-json\/wp\/v2\/posts\/325\/revisions"}],"predecessor-version":[{"id":327,"href":"https:\/\/ravtrack.com\/GPStracking\/wp-json\/wp\/v2\/posts\/325\/revisions\/327"}],"wp:attachment":[{"href":"https:\/\/ravtrack.com\/GPStracking\/wp-json\/wp\/v2\/media?parent=325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ravtrack.com\/GPStracking\/wp-json\/wp\/v2\/categories?post=325"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ravtrack.com\/GPStracking\/wp-json\/wp\/v2\/tags?post=325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}