need help

[eman619]

Hello all, I wanted to see if anyone can help. I'm not a web dev, but know a little bit.

We had this site on an old godaddy server, then it got upgraded to II7, and we had to delete and restore the database.

When we did, it still gets this error:


I keep on getting this error:


Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'centurionadmin'.

the global file has this (with the correct password, db name, and user):


<!-- METADATA TYPE="typelib" FILE="C:\Program Files\Common Files\System\ADO\MSADO27.TLB" NAME="ADO 2.7 Type Library" -->

<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Application_OnStart
'==Visual InterDev Generated - startspan==
'--Project Data Connection
Application("CenturionCounsel_ConnectionString") = "Driver={SQL Server};Server=centurionadmin.db.2690855.hostedresource.com;Database=MYDBNAME;Uid=centurionadmin;Pwd=MYPASSWORD;"
Application("CenturionCounsel_ConnectionTimeout") = 15
Application("CenturionCounsel_CommandTimeout") = 30
Application("CenturionCounsel_CursorLocation") = 3
Application("CenturionCounsel_RuntimeUserName") = ""
Application("CenturionCounsel_RuntimePassword") = ""
'-- Project Data Environment
'Set DE = Server.CreateObject("DERuntime.DERuntime")
'Application("DE") = DE.Load(Server.MapPath("Global.ASA"), "_private/DataEnvironment/DataEnvironment.asa")
'==Visual InterDev Generated - endspan==
End Sub
</SCRIPT>

Is there anything wrong with this, or is there something different from an older database to a SQL 2005? I believe it's 2005 is what is in use. Any help is appreciated.