Issues in creating SQL Server Database (on other machine) with C# windows Application

[mohan93]

Hey Guys,

I have my SQL Server Database on machineX i name that as "OtherMachine"
I have installed my visual Studio on current machine i name that as "MyMachine".
I created windows forms on MyMachine and try to connect with Database on "OtherMachine"

View-->Server Explorer-->Add Connection-->Choose Microsoft SQL Server
In Add Connection window:
when i give Server name as

Scenario1:

OtherMachine\SQLEXPRESS
i could not find any database in the dropdown list. i get an error (Provider: SQL Network Interfaces, error:26 - Error Locating Server/Instance Specified)
But the Database are present in "OtherMachine"

Scenario2:
MyMachine\SQLEXPRESS (connecting to local database on MYMachine)
in dropdown list i get the datbase listed. its successfull.

Issue: am not able to connect to database on OtherMachine.

Please assist.

[Arjay]

You need to enable the remote connection. Here's how to do it on SQL Express 2008:

http://www.linglom.com/it-support/en...-2008-express/