As New SqlConnection( **problem

I am very new to ASP.NET, just started my training yesterday, and the examples point to this connection string.

Dim cnn As New SqlConnection( "Data Source=(local);Initial Catalog=Northwind;User ID=sa;Password=;")

And I would like it to point to my sql server. Which is called 'sql' and obviously has the Northwind database.

I attempted many different things but nothing.

Dim cnn As New SqlConnection( "server=(sql);database=Northwind;User ID=sa;Password=;")

Dim cnn As New SqlConnection( "Data Source=(sql);Initial Catalog=Northwind;User ID=sa;Password=;")

What am I doing wrong?

Any help would be greatly appreciated.