|
|
Posted by Erland Sommarskog on 09/19/06 21:12
ziottt (t.giommi@gmail.com) writes:
> My problem with sql server is the following one:
> I've got my backoffice manager application done with asp technology
> that works on sql server installed on Win2000 and running on IIS5.
> what I've done is simply doing a backup of my db and moving the asp
> application on another server: Windows 2003 with IIS6 and sql server
> vers.8.
> Then I tried to set up everything as in the beginning on the previous
> machine(Win2K), but I'm getting this error:
>
> Microsoft OLE DB Provider for SQL Server error '80004005'
> [DBNETLIB][ConnectionOpen (Connect()).]Server SQL inesistente o accesso
> negato.
> (translated would be "SQL Server doesn't exist or access denied")
> /sitowebsite/bom/login.asp, line 13
This error message that the application cannot reach the SQL Server
you are trying to connect to. Thus, users or backups have no importance,
because you don't reach that far.
> ...where in the line 13 is set the connection to the database:
> Conn.Open Application("DBsource")
>
> which should be driven by what is set inside the global.asa file:
>
>Application("DBsource")="Provider=SQLOLEDB;server=127.0.0.1;database=db_nam
>e;uid=db_uid;pwd=db_pwd;"
And SQL Server is running on the same server as the web server? Have you
verified that SQL Server is actually running?
Diclaimer: I don't know ASP, so if there are any problems with that
global.asa, I can't tell.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|