Is the SQL Browser service started? ________________________________ From: listsad...@lists.myitforum.com <listsad...@lists.myitforum.com> on behalf of Duncan McAlynn <duncan.mcal...@heatsoftware.com> Sent: Wednesday, January 4, 2017 12:55:28 PM To: mssms@lists.myitforum.com Subject: [mssms] RE: SQL Server Tcp is enabled and set to Static port
See my last bullet item in the Configuration. Duncan McAlynn, Solutions Director, Americas HEAT Software M: +1.512.391.9111 | duncan.mcal...@heatsoftware.com<mailto:duncan.mcal...@heatsoftware.com> HEAT Software | 490 N McCarthy Blvd. Suite 100 | Milpitas, CA 95035 From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Kamerman, Sol Sent: Wednesday, January 04, 2017 12:51 To: mssms@lists.myitforum.com Subject: [mssms] RE: SQL Server Tcp is enabled and set to Static port One more thing... When I had this setup, I had to make the SCCM server object an ADMINISTRATOR on the SQL box. From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of Duncan McAlynn Sent: Wednesday, January 4, 2017 12:32 PM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: [mssms] SQL Server Tcp is enabled and set to Static port I'm about to go mental over this one! Any help would be greatly appreciated, y'all! Thanks in advance. Configuration: * New CB1606 site installation on CM01 * Remote SQL 2014 default instance on SQL01 * Both servers are Windows Server 2012 R2. (Fully patched) * *ALL* SQL IPs are enabled and configured for port 1433 * Setup executed as a Domain Admin * CM01$ is local admin on SQL01 and SysAdmin in SQL Issue: This prerequisite checker fails on the SQL validation. The exact error message is: "Configuration Manager primary site and central administration site require SQL Server Tcp is enabled and set to Static port." Relative Log Entries from ConfigMgrPreReq.log: ?<01-04-2017 10:47:35> SQL01.patchlink.corp; SQL Server version; Passed ?<01-04-2017 10:47:35> ERROR:Can not get sql instance regkey. ?<01-04-2017 10:47:35> ERROR:Failed to get Sql edition, Sql Server:SQL01.patchlink.corp, instance:. ?<01-04-2017 10:47:35> SQL01.patchlink.corp; SQL Server Edition; Passed ?<01-04-2017 10:47:35> INFO: Checking Tcp is enabled to Static port, SQL Server:SQL01.patchlink.corp, Instance:. ?<01-04-2017 10:47:35> ERROR: SQL TCP is not enabled. ?<01-04-2017 10:47:35> SQL01.patchlink.corp; SQL Server Tcp Port; Error; Configuration Manager primary site and central administration site require SQL Server Tcp is enabled and set to Static port. ?<01-04-2017 10:47:35> INFO: Checking if SQL Server memory is limited. ?<01-04-2017 10:47:35> WARN: SQL Server memory is set to unlimited. ?<01-04-2017 10:47:35> SQL01.patchlink.corp; Configuration for SQL Server memory usage; Warning; SQL Server is configured for unlimited memory usage. You should configure SQL Server memory to have a maximum limit. ?<01-04-2017 10:47:35> INFO: Checking if SQL Server memory is configured to reserve minimum memory. ?<01-04-2017 10:47:35> INFO: Installing the central administration site or primary site, requires SQL Server to reserve a minimum of 8 gigabytes (GB) of memory. ?<01-04-2017 10:47:35> WARN: SQL Server minimum memory is 8 MB. ?<01-04-2017 10:47:35> SQL01.patchlink.corp; SQL Server process memory allocation; Warning; Configuration Manager requires SQL Server to reserve a minimum of 8 gigabytes (GB) of memory for the central administration site and primary site and a minimum of 4 gigabytes (GB) for the secondary site. This memory is reserved by using the Minimum server memory setting under Server Memory Options and is configured by using SQL Server Management Studio. For more information about how to set a fixed amount of memory, see http://go.microsoft.com/fwlink/p/?LinkId=233759. ?<01-04-2017 10:47:35> SQL01.patchlink.corp; Case-insensitive collation on SQL Server; Passed ?<01-04-2017 10:47:35> INFO: Check Machine FQDN: <SQL01.patchlink.corp>. ?<01-04-2017 10:47:35> INFO: getaddrinfo returned success. ?<01-04-2017 10:47:35> SQL01.patchlink.corp; Validate FQDN of SQL Server Computer; Passed ?<01-04-2017 10:47:35> INFO:CheckSupportedFQDNFormat <SQL01.patchlink.corp> ?<01-04-2017 10:47:35> INFO: NetBIOS <SQL01> ?<01-04-2017 10:47:35> SQL01.patchlink.corp; Primary FQDN; Passed Duncan McAlynn, Solutions Director, Americas HEAT Software M: +1.512.391.9111 | duncan.mcal...@heatsoftware.com<mailto:duncan.mcal...@heatsoftware.com> HEAT Software | 490 N McCarthy Blvd. Suite 100 | Milpitas, CA 95035
