Personal Web Site Kit

14 Sep 2006 4:49 PM

Christopher Brandsdal

Hi!

Have set up a personal web site with the kit available from visual studio
2005. I use XP on my workstation. When I run the page on my localhost,
everything works great!

But when I publish it on my webserber(win2k3, sql express, asp2.0) I get an
error when the page tryes to insert data into the database, or when I try to
log in on the page. It works fine to read from the database. All the
galleries is viewed fine. Take a look at www.cwb.no

The error I get looks like this:

An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating
Server/Instance Specified)

This is not right, because I use the sql express from other remote pages I
have made from scratch myself. I also did check the settings for remote
connections, and it all looks fine.

Any ideas?

Best regards,
Christopher Brandsdal

14 Sep 2006 7:43 PM

Mike McIntyre

The site at the link below has helped many folks with the type of issues you
described.

http://www.edream.org/BlogArticle.aspx?RecordID=115

--
Mike

Mike McIntyre [MVP]
http://www.getdotnetcode.com

Show quoteHide quote

"Christopher Brandsdal" <brands***@binaer.no> wrote in message
news:u1%239w2B2GHA.324@TK2MSFTNGP05.phx.gbl...
> Hi!
>
> Have set up a personal web site with the kit available from visual studio
> 2005. I use XP on my workstation. When I run the page on my localhost,
> everything works great!
>
> But when I publish it on my webserber(win2k3, sql express, asp2.0) I get
> an error when the page tryes to insert data into the database, or when I
> try to log in on the page. It works fine to read from the database. All
> the galleries is viewed fine. Take a look at www.cwb.no
>
> The error I get looks like this:
>
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> (provider: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance Specified)
>
> This is not right, because I use the sql express from other remote pages I
> have made from scratch myself. I also did check the settings for remote
> connections, and it all looks fine.
>
> Any ideas?
>
> Best regards,
> Christopher Brandsdal
>