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