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 >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> >> > >
