I also have the developer's edition, but mine listens on 1433. This is what Books On Line (BOL) says:

The default number for a default instance is 1433, the official IANA socket number for SQL Server. The port for a named instance is dynamically assigned when the instance is first started, unless you set an alternate port during setup.

If I search for 1039 in BOL, I get no hits. If I search for 1433, I get a number of hits.

Could you have already had something on port 1433 when you installed it? Maybe you had another instance of SQL Server installed at one time?

My hosted site uses a non-standard port, but that's because they have several instances of SQL Server on the same computer.

Eric

Hi,

I've tried the DSN mode in every .config file using

sqlConnectionstring="DSN=MyConnection;"
(previously I tested that System DSN on my machine with standard ASP)

But does not work; I get the error:
"key word not admitted: 'dsn'"

System.ArgumentException: Palabra clave no admitida: 'dsn'.
   at System.Data.Common.DBConnectionString.ParseInterna l(Char[] connectionString, UdlSupport checkForUdl, NameValuePair& keychain)
   at System.Data.Common.DBConnectionString..ctor(String connectionString, UdlSupport checkForUdl)
   at System.Data.SqlClient.SqlConnectionString..ctor(St ring connectionString)
   at System.Data.SqlClient.SqlConnectionString.ParseStr ing(String connectionString)
   at System.Data.SqlClient.SqlConnection.set_Connection String(String value)
   at System.Data.SqlClient.SqlConnection..ctor(String connectionString)
   at Wrox.WebModules.Data.DbObject..ctor(String newConnectionString) in C:\Inetpub\wwwroot\plataforma\wrox\website\ThePhil eVB\WebModules\Core\DBObject.vb:line 32
   at Wrox.WebModules.Polls.Data.Questions..ctor(String newConnectionString) in C:\Inetpub\wwwroot\plataforma\wrox\website\ThePhil eVB\WebModules\Polls\Polls.Data\Questions.vb:line 33
   at Wrox.WebModules.Polls.Business.Question.GetCurrent Id() in C:\Inetpub\wwwroot\plataforma\wrox\website\ThePhil eVB\WebModules\Polls\Polls.Business\Question.vb:li ne 227
   at Wrox.WebModules.Polls.Web.Controls.User.Poll.DataB ind() in C:\Inetpub\wwwroot\plataforma\wrox\website\ThePhil eVB\WebModules\Polls\Poll.ascx.vb:line 260
   at Wrox.WebModules.Polls.Web.Controls.User.Poll.Page_ Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\plataforma\wrox\website\ThePhil eVB\WebModules\Polls\Poll.ascx.vb:line 62
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain()

What's wrong with that?

thanks
L.

>sqlConnectionstring="DSN=MyConnection;"

Everything is wrong with this. Where did you get this code from?

Are you putting this into the config files?

Did you read the earlier messages in this thread?

Eric