• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

SQL conectivity

I have installed an application on my SBS2011 environment that requires MSSQL to work.  However, when trying to connect from the clients the connection fails.
I have created a UDL file and at first I couldn't browse the Instances.  I then opened port 1433 on the server for both, In/Out, and still no change. I then opened 1434 and I could then see the instances from the client using the UDL. - it maybe I did this the other way round but you get the picture.  I also opened the ports on the client AV.
However, eventhough I could see the instances, I couldn't see the database on the instance.  I had the same problme last week when trouble shooting and at one stage I did manage to see the database but I can't rememeber what I had done...!!

I tried to use SSMS to connect but it just failed to connect.

So, all I want to do is know how to permission the server to allow the clients to connect and read/write to the SQL server.

I would be grateful for any enlightenment.

NB the Application manager connects without a problem locally on the server.
  • 2
1 Solution
David ToddSenior DBACommented:

In SQL Configuration Manager, is the SQL Server service started?

In SQL Configuration Manager, what network protocols are in use?

TMSAuthor Commented:
Hi David.  
I have actually managed to get it all working.  I had to open ports 1433 & 1434 for both TCP and UPD on the firewall.  I also hadn't restarted the service once enabling the netcard in the Config manager.  Then a small syntax error in the instance name didn't help...!!
Thanks again.
David ToddSenior DBACommented:
Hi Graeme,

Any reason for the C grade? Given what you said above, and that I didn't have a chance to comment before grading, a B would have been more in line with expectations and EE guidelines.


PS and a restart after changing some of the above is often necessary.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now