Cannot Remote Connect to SQL Server
-
I almost feel like noob for posting this but poking around and searching for an answer hasn't solved my problem.
It's been about 3 years or more since I set up a new SQL server. I've done that now and it works fine but I cannot remote to it via another application that wants to set up a DB to it or via SQL Management Studio.
I've opened suggested ports of 1433 and 1434. The named instances is set to allow remote connections and it is set for SQL and Windows Authentication. I've looked at over 10 website with suggestions and I still can't get that remote connection open.
No anti-virus or third party firewall on the SQL server either.
Almost hate to press Submit because I know it may be a "duh" answer but can't for the life of me remember how to get this going.
Thanks...
-
Can you disable the firewall on the SQL server temporarily and try it? You might fine that it needs more configuration.
-
@Dashrender said:
Can you disable the firewall on the SQL server temporarily and try it? You might fine that it needs more configuration.
Yep...got in that way...I knew it was a "duh" moment...but now to find out what else to allow in the Firewall.
-
@garak0410 said:
@Dashrender said:
Can you disable the firewall on the SQL server temporarily and try it? You might fine that it needs more configuration.
Yep...got in that way...I knew it was a "duh" moment...but now to find out what else to allow in the Firewall.
Sorry, can't help you there.
-
Editing title to reflect the question and took out quotes that were breaking Twitter.
-
You should be able to allow the application rather than just opening ports. That is a more advanced and secure firewall methodology.
-
Have you gone through the processing for Allow SQL Server Through the Windows Firewall?
-
These directions are even more specific to the remote access of SQL Server .
-
@scottalanmiller said:
You should be able to allow the application rather than just opening ports. That is a more advanced and secure firewall methodology.
Yeah, sorry...one of the first things I did...I removed it and re-added it and now it works...go figure...
-
At least it is working now!
-
@scottalanmiller said:
At least it is working now!
For sure...and I don't get frustrated or angry...it was just "bugging" me...LOL
-
Great!
