Connect Client computer to server computer?

Salam

I have a Computer which running Sql express as server (FASTCOPY\SQLEXPRESS)

I went to SQL Server Suface Area

and click on surface area configuration

Then Choose Remote Connections
And click Local and remote connection

Then select SQL Server Browser , and startupType Automatic, and start it

Now for Client Computer
Start menu , Control Panel , then System and Maintenance
Then Administrative Tools
Then Computer Management ,
Then from Services and Applications ,
SQL Native Client Configuration , then Client Protocols
Then enabled each of  TCP/IP , Named Pipes and Shared Memory

and Now in the APP within VB2008

MyConnectionString = "Data Source=FASTCOPY\SQLEXPRESS;Initial Catalog=inventory;User ID=sa;Password=xxxxx"

but the problem doesn't work , and give error that may remote connection not selected.

Can any body help.
Ahmadal_najjar2003Asked:
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.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
You are missing few other steps in enabling remote connections and check this one out:

http://support.microsoft.com/kb/914277
http://www.linglom.com/2007/08/31/enable-remote-connection-to-sql-server-2005-express/
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
CodeCruiserCommented:
Try disabling the Firewall.
0
Ahmadal_najjar2003Author Commented:
First of all , I want to thanks all of you.

This problem happened on my client computer , I think the problem is from the firewall . Tomorrow I have appointment with him , so I will see what happen with him , and if some thing go wrong I will inform you.

By the way , I Made some test on my network , and because my firewall was off , It works with me fine , I tried to make it on , and same problem of my client come up. and after I made exceptions to both sqlservr.exe and sqlbrowser.exe . It works fine.  
0
CodeCruiserCommented:
It most probably is firewall problem.
0
Ahmadal_najjar2003Author Commented:
Thanks
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 2005

From novice to tech pro — start learning today.