Database connection problem

Hi, I have install the forum on my DEV machine and it works fine with the SQL settings and stuff.

However, when I try to run the setup to create the table, it gave me error when I run it so I displayed out the codes to generate the tables and use that in the Query Analyzer.

However, the info that is in the SQL_server_connection.asp file doesn't gives me error when I try to access the forum.

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBXXXXXX]ConnectionOpen (CreateFile()).

/ctpdev/forum/common.asp, line 261

The login info is the same as those I used for my root site and the root site has no problem accessing the SQL server.

Anyone has any ideas?

Hi, no I am not trying to re-create the table. This message shows up when I am trying to access the forum page.

I tried it locally and it was alright.

Yes, I know I shouldn't use the Query Analizer (QA), but the thing is that the msSQL_server_setup.asp doesn't run with the ID/password we were supplied. The ID/password works for the main site which the forum is also installed in.

So in the end, I output the codes onscreen and dump it into QA to create the tables/relationships and stored procedures.

I edited the SQL_server_connection.asp to connect via DSN and it works, but if I use SQLOLEDB as the provider, it gives me the error.