SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


70-462 Trainning Kit: Cannot connect from SQL-A to SQL-CORE


70-462 Trainning Kit: Cannot connect from SQL-A to SQL-CORE

Author
Message
varoon.missir
varoon.missir
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 13
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.
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27287 Visits: 13268
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
varoon.missir
varoon.missir
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 13
The issue is resolve.

I re-create SQL-Core VM from scratch and re-install the SQL Server and it work.:-D
Chauncey Gardiner
Chauncey Gardiner
SSC-Enthusiastic
SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)

Group: General Forum Members
Points: 184 Visits: 255
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.
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27287 Visits: 13268
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 :-D


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

MCSE Business Intelligence - Microsoft Data Platform MVP
Chauncey Gardiner
Chauncey Gardiner
SSC-Enthusiastic
SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)

Group: General Forum Members
Points: 184 Visits: 255
!! :-) 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.
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27287 Visits: 13268
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
dan-572483
dan-572483
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1326 Visits: 1997
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.
Chauncey Gardiner
Chauncey Gardiner
SSC-Enthusiastic
SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)

Group: General Forum Members
Points: 184 Visits: 255
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search