> We have an server (w2k) which amongst other things hosts out
> intranet. The intranet site is partially DB-driven, but the DB was
> hosted on a different server (w2k/w2k3).
> We had to do some maintenance on the SQL Server machine, so we
> temporarily copied the DB to a 3rd server (w2k), which is at a
> different site connected by a decent microwave link.
> Obviously, simply changing the name of the server in the ASP
> connection string was sufficient to redirect to the 3rd server.
> However, having rebuilt the original SQL Server (now w2k3), and
> changed the connection string back, the web server cannot seem to
> 'see' the SQL server:
> "Microsoft OLE DB Provider for SQL Server error '80004005'
> [DBNMPNTW]Specified SQL server not found. "
> My first thoughts were that there were problems with the rebuilt w2k3
> machine. However, let me introduce machine #4 - my development PC (XP
> Pro). My PC holds a copy of the intranet, and a copy of the DB. Not
> only can my machine successfully feed off the rebuilt SQL Server, but
> nor can the original Web Server read my copy of the database either.
> The original web server is showing it's age. Although it has recently
> been upgraded to 1Gb of memory, it only has a 800Mhz processor. It's
> also quite a busy machine.
> I was wondering what I can do to solve this problem? Why can't the
> original server see the SQL Server??