Web Wiz 8x -- Access to MS SQL success

We use the 8.04 access database edition and trying to convert mssql database. That operation total 3 days cuz "support forum", "support pages", "support email" and google cant be explain convert document or wrong documents/technics.

3 days trying and we successfuly convert the db's. Correct technic explanation step by step guide;
Recommended softwares, office 2003 pro, sql 2000/2005

01-) Stop the webwiz forum "web site" and stop the your site "application pool" on iis. (Recommended, cuz if you copy the database file and site is open database possible corroupted)
01a-) Install office 2003 pro
01b-) Intall sql 2000/2005 server, !WARNING! if your forum language different of english; install screen select the "custom" installion method and select correct language configs.
01b Custom - example-) collation designator: Turkish - sort order: checked, accent sensitive.
02-) "Must" backup or different location to copy access db.
03-) Open office professional 2003 access.
04-) File - open - select the yours database file and click ok.
05-) If popup appears the security warning click open and see the title "xxxxxxxx: datasabe (Access 2000 file format)".
06-) Tools - database utilities - upsizing wizard - create new database - next.
07-) Select the sql server machine name or ip address (local, xxx, n.n.n.n) - checked, use trusted connection or u/p - name of the new database or same name old database - next.
08-) Available tables, click ">>" - next.
09-) Don't change anything (checkout timestamp field is "no, never") - next.
10-) Don't change anything - next.
11-) Don't change anything - finish.
12-) Security warning screen appears 2-3 times click open - waiting the sending data screen/s... (1-30 mins.)
13-) Check/see/find the errors in the upsizing report screen 30 pages.
14-) Close the access.
15-) Open enterprise manager under the sql server program groups.
16-) Expand the tree and select the database name (item 07).
17-) !WARNING! Different language users (forum, username is "not only" english character set) right click - properties checkout the "collation name: xxxx".
17a-) If collation name is "Latin", members different chacarter set usernames cannot login the forum! and/or administrator cannot login the "admin section" and/or members section only search english character set members.
17b-) Solve the problem is; close the properties screen - select the database name (item 07) - tools - sql query analyzer - now you can see the button bar your database name or select the database name.
17c-) Close the "sql server manager", not "sql query analyzer" window.
17d-) Write the following commands;
USE tempdb
GO
ALTER DATABASE your-database-name COLLATE your-language_CI_AS
GO
17e-) Do not change the "tempdb" and "_CI_AS".
17f-) Click the execute icon on button bar ">" (color is green) and waiting 0-5 mins.
17g-) Checkout the bottom window "the command(s) completed successfully." message.
17h-) Open the "sql server manager" go to (item 15).
18-) Now your new database is ready.
19-) Download the "web wiz forum sql server version" and follow the install/upgrade instructions. REMEMBER, Do not overwrite the "forum_images, language_files, uploads, css_styles" directorys. :-)
20-) If forum members can't be login and/or admin section can't be login; "functions/functions_session_data.asp" edit the file "Const blnDatabaseHeldSessions = False" and change the True.
21-) If forum session timeout problems appears and/or search section sometimes "permission error" messages appears, change the common.asp "Session.Timeout = 20" to 60.
22-) Done. Thank's the TurkClubber web/forum hosting provider AGG.



Edited by kkimber - 03 February 2007 at 7:27am

This works for v8.05?

thank you very much

With SQL Express make sure you install it in mixed mode with TCP/IP connections enabled.

Then to connect to it using the default instance from localhost use:-

localhost\SQLEXPRESS