Connect to Microsoft SQL server 2008 (enterprise) database from Visual C# 2008 Express (Test connection failed)
Posted on 2008-11-07
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.