| Author |
 Topic Search  Topic Options
|
Shaun 
Groupie
Joined: 24 February 2006
Status: Offline
Points: 78
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 15 March 2006 at 10:59pm |
|
Many thanks Scott (top car, top help)!
I'll probably get back in touch at some point LOL.
Just one final question, which I've asked a few times but haven't had the answer as yet.
Which file do I need to change (and how), to point the forum to the new SQL database and location etc?
Cheers again,
Shaun
|
 |
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 March 2006 at 11:58am |
|
As far as I can recall, in version 7.x it should be 'admin/SQL_server_connection.asp'
|
|
rx7tt
Groupie
Joined: 25 October 2004
Location: United States
Status: Offline
Points: 53
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 March 2006 at 1:25pm |
Sorry I missed that as well. Change
strSQLServerName = "" 'Holds the name of the SQL Server |
to (local) in the file boRg stated.
Another cool thing that I'm not sure is possible with MSDE but works with SQL express is using Windows authentication for the forum instead of sql server authentication. Might be something to add to V8, as it would only add one line.
-Scott
|
|
|
|
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 March 2006 at 1:39pm |
|
I do plan on having support for Windows Authentication in version 8 for db versions, but as I want to get version 8 out as soon as possible it will have to wait now till version 8.1
|
|
Shaun
Groupie
Joined: 24 February 2006
Status: Offline
Points: 78
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 March 2006 at 12:59am |
|
Talk about weird?
I've looked at that file and in that exact location etc.
BUT
The details for our current MSSQL database are incorrect.
It's been filled in with something different, definately not the MSSQL DB I've been using.
Anywhere else I should be looking?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 March 2006 at 11:54am |
|
Not in a standard installation.
It sounds like someone may have modified the code, have a look in both the common.asp files as this is where the connection string is used to connect to the database, someone may have modified the code in these files.
|
|
Ozoyo
Newbie
Joined: 28 January 2004
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 March 2006 at 9:18am |
This is maddening...
SO there is no import tool in SQL 2005  .
I have installed 2005 express locally on the server but I can't import my SQL 2000 DB which is on a distant server.
I have found a way to import a DB from MSDE to SQL 2005 (not tested
though). But my main issue is that I can't install MSDE on my server
(something about SA password), I have tried to change the password as
told on the Microsoft site but no success...  .
I have few questions:
1. Can you have SQL 2005 and MSDE on the same server? Is that why I have the password issue?
2. Does MSDE have an import wizzard that I can use to import my DB from the distant server?
Thanks
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 March 2006 at 10:59am |
|
1. Yes you can, I have SQL Express, SQL 2005 Developer Edition, and SQL 2000 Developer Edition all install on this computer at the moment, just installed under different instance names.
2. Enterprise Manager and the full SQL Server Management studio both come with DTS import export tools for moving SQL Databases, the only version that is not compatible with these tools in SQL 2005 Express which is limited. But you can detach and attach databases in SQL Express 2005 which would help in moving databases.
|
|
