{"id":13373,"date":"2016-11-04T07:23:13","date_gmt":"2016-11-04T07:23:13","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=13373"},"modified":"2016-11-04T07:23:13","modified_gmt":"2016-11-04T07:23:13","slug":"information-on-database-configurations-in-sage-crm","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/","title":{"rendered":"Information on Database Configurations in Sage CRM"},"content":{"rendered":"

Upon installing Sage CRM apart from selecting the installation path we are required to provide instance name and SQL server connection details to proceed further with installation.
\nWhatever the instance name that we provide upon installation, the installation process will create a database in SQL with same name and required tables in the database. The database and SQL server details can be viewed from Sage CRM and in Registry.
\nNow in this blog we are going to discuss how Admin Users can configure database settings in Sage CRM post installation.
\nNew Stuff:<\/em><\/strong>\u00a0<\/span>Modify User Preferences from Info Manager user\u2019s Login<\/a><\/span>
\nSage CRM Admin Users can navigate to Administration<\/strong> |<\/strong> System | Databases<\/strong>
\n\"Database<\/a>
\nThis screen shows the default configured database details that were entered during installation. Admin User can edit these details. Let\u2019s go through individual details of the listed fields in above screenshot.
\nDatabase User ID<\/strong>:
\nUser id which will be used to connect to database.
\nPassword<\/strong>:
\nPassword of SQL Server user.
\nUse Integrated Windows NT Security<\/strong>:
\nThis option allows us to use the IUSR (if added) account to connect to the database by ignoring database user id and the password when checked.
\nIUSR is a built in account for all anonymous authentication.
\nThis option is suitable if SQL Server running on the same computer where IIS is installed.
\nDefault Database Driver<\/strong>:
\nThis option allows to set the type of driver we are connecting to using MDAC.
\nDefault Database Server<\/strong>:
\nServer name where database is located.
\nDefault Database<\/strong>:
\nDatabase name which you want to configure. We can change this option to set different database but need to ensure database exists in SQL and valid Sage CRM database.
\nAlways Use Default Database<\/strong>:
\nThis option allows Users the ability to define an alternative database to log into from the Sage CRM login screen if option is set to No.
\nIf option selected as\u00a0 ‘No’ then at the time of CRM login It will ask you to enter a database name which you want to login along with user name and password.\u00a0 Refer below Screen shot.
\n\"Logon_ChangeDB\"<\/a>
\nThis technique is mostly used for training the Users and testing purposes. Users can play around the system learning how to insert\/edit\/delete by using alternate database and knowing the fact they are not harming the actual Sage CRM database.
\nThis field setting controls the access to an alternative database and it does not control the loading of a separate Application Server. If live users accessing Sage CRM outside domain network then they will not have the ability to choose database on login screen. They will be entertained with default database connection.
\nIf selected option is set to Yes then default database will be used every time.
\nQuery Timeout<\/strong>:
\nSometimes SQL statement may take time to and resulting timeout errors in log files. We can control this timeout setting by increasing the Query Timeout field value. By default this option is set to 60 seconds.
\nPort Number<\/strong>:
\nSQL server port no.
\nAbout Us
\n<\/strong>Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.
\nGreytrix<\/a>\u00a0has some unique integration solutions for Sage CRM with Sage ERP\u2019s (Sage X3<\/a>,\u00a0Sage 100<\/a>,\u00a0Sage 500<\/a>\u00a0and\u00a0Sage 300<\/a>). It also offers best-in-class\u00a0Sage ERP customization and development services<\/a>\u00a0to\u00a0Business\u00a0Partners,\u00a0End\u00a0Users and Sage PSG worldwide.\u00a0Greytrix<\/a>\u00a0helps in\u00a0migrating to Sage CRM from ACT<\/a>,\u00a0Goldmine<\/a>\u00a0and other CRM\u2019s.
\nFor more information on our integration solutions, please contact us at\u00a0sage@greytrix.com<\/a>. We will be glad to assist you.
\nAlso Read:<\/em><\/strong><\/span>
\n<\/em><\/strong>1) IIS Configuration for Sage CRM<\/a>
\n<\/u>2) Interactive Dashboard refuses to work? This could be related to SQL Server Configuration error<\/a>
\n<\/u>3) Where to search for Sage CRM Configuration components
\n<\/a>4)\u00a0Cannot open database requested by the login. The login failed.
\n<\/a>5)\u00a0Steps to be remembered while moving Sage CRM database from one server to another<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Upon installing Sage CRM apart from selecting the installation path we are required to provide instance name and SQL server connection details to proceed further with installation. Whatever the instance name that we provide upon installation, the installation process will create a database in SQL with same name and required tables in the database. The\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,102,134,191,336,337,338,340,342,380,382,389,1],"tags":[923,941,1788,1847,2600],"class_list":["post-13373","post","type-post","status-publish","format-standard","hentry","category-administrator","category-database-sage-crm","category-enable","category-integrated","category-sage-crm-7-1-sp2","category-sage-crm-7-2","category-sage-crm-73","category-sage-crm-guide","category-sage-crm7-3","category-sql","category-sql-identity","category-synchronization","category-uncategorized","tag-database-driver","tag-default-database","tag-port-number","tag-query-timeout","tag-windows-nt-security"],"yoast_head":"\nInformation on Database Configurations in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components<\/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:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Information on Database Configurations in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Upon installing Sage CRM apart from selecting the installation path we are required to provide instance name and SQL server connection details to proceed further with installation. Whatever the instance name that we provide upon installation, the installation process will create a database in SQL with same name and required tables in the database. The\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2016-11-04T07:23:13+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/11\/Database-settings-1024x291.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\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:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/\",\"name\":\"Information on Database Configurations in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/11\/Database-settings-1024x291.jpg\",\"datePublished\":\"2016-11-04T07:23:13+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/11\/Database-settings-1024x291.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/11\/Database-settings-1024x291.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Information on Database Configurations in Sage CRM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Information on Database Configurations in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","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:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/","og_locale":"en_US","og_type":"article","og_title":"Information on Database Configurations in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Upon installing Sage CRM apart from selecting the installation path we are required to provide instance name and SQL server connection details to proceed further with installation. Whatever the instance name that we provide upon installation, the installation process will create a database in SQL with same name and required tables in the database. The\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2016-11-04T07:23:13+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/11\/Database-settings-1024x291.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/","name":"Information on Database Configurations in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/11\/Database-settings-1024x291.jpg","datePublished":"2016-11-04T07:23:13+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/11\/Database-settings-1024x291.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/11\/Database-settings-1024x291.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/11\/04\/information-on-database-configurations-in-sage-crm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Information on Database Configurations in Sage CRM"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/13373","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=13373"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/13373\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=13373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=13373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=13373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}