Hey Paul Port set to 1433 and I can telnet to it and SQL is set to allow remote connections. I will check the service pack version now
On Fri, Nov 28, 2014 at 2:23 PM, Paul Winstanley <[email protected]> wrote: > Have you set to run TCP on port 1433 - can you telnet to the server on > that port? Have you set the SQL server properties to allow remote > connections? What version of SQL 2012? Must be CU2 for non SP or SP1 no > min CU. > > On Fri, Nov 28, 2014 at 2:17 PM, Suzzi Williams <[email protected]> > wrote: > >> Arghh >> >> No, what wasn't it. Still the same error. Any one have any ideas? >> >> Suz xx >> >> On Fri, Nov 28, 2014 at 1:34 PM, Suzzi Williams <[email protected]> >> wrote: >> >>> I have fixed it, yay >>> >>> It was dynamic port settings >>> >>> Suz xx >>> >>> On Fri, Nov 28, 2014 at 12:51 PM, Suzzi Williams < >>> [email protected]> wrote: >>> >>>> I need your help again as this is really doing my head in. >>>> >>>> I am installing SCCM 2012 with a remote SQL 2012 server. >>>> >>>> The account I am using has local admin rights on the remote SQL server >>>> and full access to the SQL instance. >>>> >>>> But I am getting the following error >>>> >>>> Setup is unable to connect to SQL Server with connection information >>>> provided. Verify the following: >>>> The SQL Server and instance names are entered correctly >>>> The specified SQL Server instance is not configured to use dynamic ports >>>> If a firewall is enable on the SQL Server, inbound rules exist to allow >>>> connections to the correct ports >>>> The account used to run Setup has permissions to connect to the >>>> specified SQL Server instances >>>> >>>> I have disable all the firewalls, I can connect to the SQL server and >>>> instance with management studio. >>>> >>>> The error appears very quickly and there is nothing in the SQL server >>>> logs about a failed login. >>>> >>>> Please help I have run out of ideas >>>> >>>> Suz xx >>>> >>>> >>> >>> >> >> > >
