SQL Server JDBC Driver / Validation Failure

[DaNewt]

Hmmm... I posted earlier today, but the message naver made it to the forums.
I'll try again

We have been trying to install an app (prototype designed at another facility)
onto a test server environment in our data center. The equipment consists of
the following:
- Windows 2003 Server / IIS 6.0 / ColdFusion MX7 (with all current patches
upgrades and service packs).
- SAN running Win 2003 / MS SQL Server 2000 (again, all current)

I did a fresh install of IIS and CF on the app server, and have the dubious
honor of being the first app on this server. I have had a heck of a time
getting everything configured on this so the servers talk to each other, but
they do. There are many .NET projects accessing the SAN, and the SQL Server is
solid. The prototype db was backed up/restored/verified on the SAN.

And yet we cannot connect to the database using the SQL JDBC driver or even
the ODBC driver. This is the error from the page:

Error Executing Database Query.

[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot open database
requested in login 'Polaris'. Login fails.

In the CF Admin, we get a "connection verification failure" message, and
though the ODBC driver thinks it's connecting, a trip to the site using ODBC
fails as well (same message).

Permissions are correct. Mixed authentication is on (I know because I tried to
login to the db using the windows UID and it failed). I've been fighting this
for far too long. Any ideas?

ANYONE?

Dave Newton
NASA - Marshall Space Flight Center

[DaNewt]

Just wanted to post the solution to this in case someone else has this kind of
problem.

It was in fact a SQL permission problem - the database had been restored and
the SQL user that had been added for CF to talk to the database was no longer
there after the restore.

Dave-