Web Wiz Forums - I can not install V8 to my SQL 2000

Print Page | Close Window

I can not install V8 to my SQL 2000

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=19339
Printed Date: 12 April 2026 at 6:11am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: I can not install V8 to my SQL 2000

Posted By: superlative
Subject: I can not install V8 to my SQL 2000
Date Posted: 16 April 2006 at 2:49pm

Hi Friends,

I want to upgrade my access 7.x forum to SQL 2000 V8. I upgrade first, access 7.x to access 8.x, Then I install v8 sql version. but when i use msSQL_server_setup.asp file, i see cong message but all tables created Master db.

Anyone see same result for SQL version?

-------------
http://www.knowhow.gen.tr" rel="nofollow">

Replies:

Posted By: WebWiz-Bruce
Date Posted: 16 April 2006 at 3:28pm

Have a look in the version 7.x support forum at the sticky topic for converting Access databases to SQL Sever databases.

Running the SQL Server setup file will just create a blank database.

Posted By: superlative
Date Posted: 16 April 2006 at 3:32pm

I know borg you said topic. But problem is different. I want to create a new empty SQL forum (First). But i can not create. I create a new db and give permission for a one user name. Then I use setup file, and i recieve cong message. I change my sql user default DB master to forumdb. Now I see forum tables in forumdb database. I think problem occur user default db selected master. I examine your setup file. you use ON [PRIMARY]. I examine my problem.

-------------
http://www.knowhow.gen.tr" rel="nofollow">

Posted By: superlative
Date Posted: 16 April 2006 at 3:55pm

setup file create tables in correct db. But i can not access my newest blank forum. I recieve this error :

Server Error in Forum Application
An error has occured while connecting to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_db_connection
File Name:- common.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid authorization specification

-------------
http://www.knowhow.gen.tr" rel="nofollow">

Posted By: WebWiz-Bruce
Date Posted: 16 April 2006 at 4:13pm

The error suggests that your connection setting for your SQL Server are incorrect.

Posted By: superlative
Date Posted: 16 April 2006 at 4:20pm

But borg my connection string connect sql and create tables. SQL server security : SQL and windows auth. And I try v7.9 sql version in the same server I didnt see any problem. I can install 7.9 SQL but i can not install v8 SQL

-------------
http://www.knowhow.gen.tr" rel="nofollow">

Posted By: WebWiz-Bruce
Date Posted: 16 April 2006 at 5:23pm

Check the database_connection.asp file again.

Nothing has changed in the way SQL Server is connected to, it still uses the same connection string and variables to initialise it.

Also make sure you have uncommented the SQL connection details by removing the ' single quote mark from in front of the variable you place your SQL Server connection details in.

If you still have issues try downloading version 8.01

Posted By: superlative
Date Posted: 16 April 2006 at 5:37pm

Yes,yes,yes

I download v8.01 SQL version and I change some SQL settings. currently no problem I installed v8.01 SQL to my server.

SQL Connection settings :

strSQLServerName = "81.213.111.xxx" 'Holds the name of the SQL Server (This is the name/location or IP address of

the SQL Server)
strSQLDBUserName = "sa" 'Holds the user name (for SQL Server Authentication)
strSQLDBPassword = "xxxxxx" 'Holds the password (for SQL Server Authentication)
strSQLDBName = "kaan"

And msSQL_server_setup.asp settings :

user : kaan (this is SQL user and it is db_owner group of kaan db and default db is kaan)

pass : I select blank password (i set this in enterprise manager)

owner : DBO (default)

I think sql user's default DB must selected forum db. Otherwise dont work.

-------------
http://www.knowhow.gen.tr" rel="nofollow">

Posted By: superlative
Date Posted: 16 April 2006 at 5:42pm

superlative wrote:

I think sql user's default DB must selected forum db. Otherwise dont work.

This is not true for v8.01. I test this :

I changed my SQL user's default db : master

And re-start installation process

I easly install true forum db. (Tables create in true db)

But v8.0 have bug. I can not install. v8.01 fixed. Thanks Borg

-------------
http://www.knowhow.gen.tr" rel="nofollow">

Posted By: WebWiz-Bruce
Date Posted: 16 April 2006 at 6:20pm

Nothing has changed in 8.01 that would effect the way the SQL Server is connected to, so I guess it may have just been some oversight or spelling mistake in the connection details.