Hmm. Running out of options here. Is named pipes enabled? Can you connect yourself to the instance from a remote server? Here's a cool way to test your connection http://blogs.msdn.com/b/steverac/archive/2010/12/14/test-remote-sql-connectivity-easily.aspx
On Sun, Nov 30, 2014 at 5:10 PM, Suzzi Williams <[email protected]> wrote: > Paul, YES, the site server is local admin on the SQL server and sysadmin > on the sql instance. > > Suz x > > On Fri, Nov 28, 2014 at 6:35 PM, Paul Winstanley <[email protected]> > wrote: > >> ..and sysadmin on the SQL server >> >> On Fri, Nov 28, 2014 at 5:41 PM, Paul Winstanley <[email protected]> >> wrote: >> >>> Is the site server a local admin? >>> >>> On Fri, Nov 28, 2014 at 4:15 PM, Suzzi Williams <[email protected] >>> > wrote: >>> >>>> Paul >>>> >>>> Yes, restarted the services and rebooted the server, my account is >>>> local admin and sysadmin and the sccm server is local admin and sysadmin >>>> >>>> Suz x >>>> >>>> On Fri, Nov 28, 2014 at 4:09 PM, Paul Winstanley <[email protected] >>>> > wrote: >>>> >>>>> Did you restart sql services after setting the ports on the tcp >>>>> config. Is your account a sysadmin in the sql server as well as local >>>>> admin. >>>>> >>>>> >>>>> >>>>> On 28 Nov 2014, at 15:16, Suzzi Williams <[email protected]> >>>>> wrote: >>>>> >>>>> Paul. >>>>> >>>>> Yes, collation is correct, and the sql services are using a domain >>>>> account >>>>> >>>>> On Fri, Nov 28, 2014 at 3:13 PM, Paul Winstanley < >>>>> [email protected]> wrote: >>>>> >>>>>> Have you set the collation correctly? SQL_Latin1_General_CP1_CI_AS >>>>>> >>>>>> On Fri, Nov 28, 2014 at 2:58 PM, Suzzi Williams < >>>>>> [email protected]> wrote: >>>>>> >>>>>>> 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 >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
