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.
TMSAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David ToddSenior DBACommented:
Hi,

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

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

Regards
  David
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
Graeme
0
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.

Regards
  David

PS and a restart after changing some of the above is often necessary.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.