| Author |
 Topic Search  Topic Options
|
superlative 
Groupie
Not Comparative, I m Superlative :)
Joined: 26 November 2004
Location: Turkey
Status: Offline
Points: 125
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: I can not install V8 to my SQL 2000
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? |
|
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
superlative
Groupie
Not Comparative, I m Superlative :)
Joined: 26 November 2004
Location: Turkey
Status: Offline
Points: 125
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
superlative
Groupie
Not Comparative, I m Superlative :)
Joined: 26 November 2004
Location: Turkey
Status: Offline
Points: 125
|
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 April 2006 at 4:13pm |
|
The error suggests that your connection setting for your SQL Server are incorrect.
|
|
superlative
Groupie
Not Comparative, I m Superlative :)
Joined: 26 November 2004
Location: Turkey
Status: Offline
Points: 125
|
Post Options
Thanks(0)
Quote Reply
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 
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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
|
|
superlative
Groupie
Not Comparative, I m Superlative :)
Joined: 26 November 2004
Location: Turkey
Status: Offline
Points: 125
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
