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.