SQL 2008 R2 Express Instance Connection Issue

Hello all.

I have a Windows SBS 2011 server on which I have installed SQL 2008 R2 Express and have an instance installed called testme.  I have installed a program on said server and have a database setup on that instance.  From the server, the program runs flawlessly.  

However, none of the 4 workstations in the domain can connect to the SQL instance.  The workstations are running XP pro, the workstations firewalls are off.  The server firewall is off.  When I try to connect using ODBC from the workstations to the instance SBSSERVER\testme, windows gives me an error saying the the server name is invalid or the username and password is incorrect.

In the SQL manager I have made sure that TCP/IP is Enabled in the Network connection area.  and I can connect to the DB from the server no problem with Windows Auth and the SA account.  neither accounts work from the workstations.


Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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.

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
bobbydall2000Author Commented:
Hello.  No resolution yet, but I have a work around via RDP to the server for the client to use the software.
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.