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