When I open SQL Command Line, I write `CONNECT username/password@[//]host[:port][/service_name]` and it connects me to the database just fine. However, I'm unable to connect from a .NET project using a connection string. I have tried many things such as `<add name="ConnectionString" connectionString="Data Source=username/password@[//]host[:port][/service_name];" />` and `<add name="ConnectionString" connectionString="server=tcp:host;Initial Catalog=service_name; user id=username; password=password; Connection Timeout=180;" providerName="System.Data.OracleClient" />`, but nothing worked so far. Whenever I get to `sconn.Open();` in the following:

```
var CurrentConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection sconn = new SqlConnection(CurrentConnectionString);
sconn.Open();

```

I practically always get the following error:

> 
> 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: 25 - Connection string is not valid)
> 
> 
> 

How can I connect to the database properly?