Connect to Microsoft SQL server 2008 (enterprise) database from Visual C# 2008 Express (Test connection failed)

Hope someone can help with this problem...

Using Visual C# 2008 express and SQL Server enterprise 2008
running on a laptop (vista home .premium)

i've created a new database using SQL server managment studio with no problem.
database via Management Studio there is no problem, the
database appears in the Explorer.

however, in Visual C# Express, when I try to 'Add Connection' as follows

Data source - MS SQL Server Database File
Database File Name - browse to appropriate folder and select
Log in using WIndows Authentification

and use the same database I receive the message (after a while):
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"

and yes i did detach the database / disable windows firewall / shutdown anti-virus sw before i try to connect.

* also, let me say i manage to connect for OLE DB (Access 2007) with no problems

does visual c# express edtion got to do with this problem, i mean if full version of visual studio can solve the problem ?

Looking for a solution if possible for the SQL server 2008.

Thanks
turki_00Asked:
Who is Participating?

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

x
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.

alex_pavenCommented:
Usually you should choose SQL Server, not SQL Server Database File, as the data source, and choose the instance name you've installed; that way you shouldn't have a problem. The 'database file' option is used in other cases (attach a file to a server instance).
turki_00Author Commented:
Alex,

i only have 3 choices for the data source:
1. Microsoft Access Database File (OLE DB)
2. Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5)
3. Microsoft SQL Server Database File (SqlClient)

this is why i did chose the 3rd option (MS SQL server databse file)
is there a (driver) i need to install for SQL server 2008 ?  (i did mention that i've installed sql server 2008 enterprice edtion on my machine)
turki_00Author Commented:
this is a snap shot of the problem
err-msg.jpg
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

grayeCommented:
The Express Editions doesn't support a connection to a "real" SQL Server.  
However, you can still connect to SQL Server if  you code all of the pieces "by hand".   Admittantly, you won't be able to use the newer TableAdapters, etc.
 
turki_00Author Commented:
Graye,

so you are saying that to connect to sql server (i don't know why did u refere to it as "real") i have to get rid of the express edition and get the full version of visual studio. right ?




grayeCommented:
The full version of Visual Studio provides support to SQL Server, so an upgrade will definitely solve the problem.
The comment about "Real" SQL Server, means that you can connect to the server itself (rather than just the SQL Server files)
I have heard of folks who just bypass the connection wizard and code the connection to the SQL Server "by hand".   Using this technique,  you *can* use C# Express to connect to a SQL Server... but you've got to do all the work.

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
turki_00Author Commented:
Thank you for the help
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
.NET Programming

From novice to tech pro — start learning today.