Hi, is the site server in a group which is local admin on the sql? If so, did you reboot the site server after adding to the group? Is named pies enabled?
From: [email protected] [mailto:[email protected]] On Behalf Of Suzzi Williams Sent: 30 November 2014 18:11 To: [email protected] Subject: Re: [mssms] Install and remote SQL 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]<mailto:[email protected]>> wrote: ..and sysadmin on the SQL server On Fri, Nov 28, 2014 at 5:41 PM, Paul Winstanley <[email protected]<mailto:[email protected]>> wrote: Is the site server a local admin? On Fri, Nov 28, 2014 at 4:15 PM, Suzzi Williams <[email protected]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Suzzi Williams Sent: 28 November 2014 15:32 To: [email protected]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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
