Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

70-462 Trainning Kit: Cannot connect from SQL-A to SQL-CORE Expand / Collapse
Author
Message
Posted Monday, April 14, 2014 3:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 18, 2014 10:16 AM
Points: 2, Visits: 9
70-462 Training Kit : Cannot connect from SQL-A to SQL-Core

Currently, I have set up lab environment on my lap top (like example in 70-462 Training Kit)
After exercise 1, which is to test connectivity between machine in domain, I cannot connect from SQL-A to SQL-Core

It show error
Message :
Cannot connect to SQL-CORE
A network related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configure to allow remote connections (provider: Named pipes Provider. Error 40 – Could not open a connection to SQL Server (.net SQLClient Data provider)
Error Number: 53
Severity:20
State: 0

In the set up phase, I can success fully join SQL-A,SQL-B,SQL-C,SQL-D and SQL-Core to DC.
Anyone has experience in this, please help.

Post #1561403
Posted Monday, April 14, 2014 12:28 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Sunday, July 20, 2014 11:20 PM
Points: 13,252, Visits: 10,133
What helped when I was doing the exercise was turning off the firewall.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1561633
Posted Monday, April 14, 2014 9:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 18, 2014 10:16 AM
Points: 2, Visits: 9
The issue is resolve.

I re-create SQL-Core VM from scratch and re-install the SQL Server and it work.
Post #1561733
Posted Thursday, July 10, 2014 3:18 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 4:47 PM
Points: 151, Visits: 137
Hi Koen, I did the same thing turned off the firewall(s), but isn't the purpose of the inbound rule created in chapter 1 supposed to make that unnecessary??

................................................................................
First comes spring and summer, but then we have fall and winter. And then we get spring and summer again.
Post #1591343
Posted Thursday, July 10, 2014 3:24 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Sunday, July 20, 2014 11:20 PM
Points: 13,252, Visits: 10,133
Chauncey Gardiner (7/10/2014)
Hi Koen, I did the same thing turned off the firewall(s), but isn't the purpose of the inbound rule created in chapter 1 supposed to make that unnecessary??


Yes. It still didn't work for me, so I shut the whole thing down




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1591344
Posted Thursday, July 10, 2014 4:03 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 4:47 PM
Points: 151, Visits: 137
!! do you think that was detrimental to your learning administration i.e. GPO etc.? I ask as I'm almost where you were when you started this a year + ago and am just trying to follow the book, which has surprisingly little errata. Is it better to just blow off that part (inbound rules) open the firewalls and keep moving or will it come back and bite me in later chapters? When something doesn't work I always assume user error (me) and can spend days researching and tweaking it.

................................................................................
First comes spring and summer, but then we have fall and winter. And then we get spring and summer again.
Post #1591356
Posted Friday, July 11, 2014 12:14 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Sunday, July 20, 2014 11:20 PM
Points: 13,252, Visits: 10,133
Chauncey Gardiner (7/10/2014)
!! do you think that was detrimental to your learning administration i.e. GPO etc.? I ask as I'm almost where you were when you started this a year + ago and am just trying to follow the book, which has surprisingly little errata. Is it better to just blow off that part (inbound rules) open the firewalls and keep moving or will it come back and bite me in later chapters? When something doesn't work I always assume user error (me) and can spend days researching and tweaking it.


It didn't have any impact at all, if I recall correctly.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1591439
Posted Wednesday, July 16, 2014 11:54 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 10:29 PM
Points: 528, Visits: 1,555
Turning off all firewalls will allow you to move through the exercises more quickly because you won't have to deal with firewall issues. I believe for the most part windows firewall is outside the scope of the MSSQL certification exams. However, I suggest you do know the default ports used by SQL services (1433, etc.).

However working through these firewall issues will be beneficial should you find yourself in the job where you need to get servers talking to each other while leaving firewalls up.
Post #1593225
Posted Wednesday, July 16, 2014 4:50 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 4:47 PM
Points: 151, Visits: 137
Thanks for the input, it's appreciated!

................................................................................
First comes spring and summer, but then we have fall and winter. And then we get spring and summer again.
Post #1593321
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse