Paul It is SQL 2012 SP1
Andrew Yes dynamic set to blank and 1433 on all IPs On Fri, Nov 28, 2014 at 2:43 PM, Andrew Craig <[email protected]> wrote: > Hi Suzzi, > > > > Did you set dynamic to blank and 1433 on all IPs not just the IPAll? > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Suzzi Williams > *Sent:* 28 November 2014 15:32 > *To:* [email protected] > *Subject:* Re: [mssms] Install and remote SQL > > > > 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 > > > > > > > > > > > > > > > > > > > >
