TMS
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
Regards
David
PS and a restart after changing some of the above is often necessary.
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.
Regards
David
PS and a restart after changing some of the above is often necessary.
ASKER
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.
Graeme