|
|
|
Junior Member
 
Group: Forum Members
Last Login: 8/14/2009 1:34:41 PM
Posts: 6,
Visits: 13
|
|
| When I went to SQL 2005, I wanted to do a fresh install then copy my databases over from SQL 2000. This was not possible because it caused the security on timeless to blow up. (I emailed in a few questions on this at the time). I got around this by upgrading my SQL 2000 to SQL 2005 instead of doing a side by side install. I still want to do a fresh install of SQL 2005 when I move to longhorn server but there appears to be no process for moving timeless in this way.
|
|
|
|
|
Support Staff
Group: Administrators
Last Login: 1/23/2011 10:48:04 PM
Posts: 273,
Visits: 1,543
|
|
SQL 2005 by default has stronger requirements on passwords than SQL 2000. The most likely reason for the problem is that the TTEGuest user id has a blank password. In SQL 2000, you can change this before moving the database. You will also need to run the moved database in compatibility mode due to deprecated SQL. The Enterprise Web installation changes the database to address both these issues.
It is likely you also needed to reset the users once you move the database as the user ids will not exist on your new server. This can be done by running the "Reset TT&E SQL Server (or MSDE) Database" utility from our downloads page.
Mark Griebling
MAG Softwrx, Inc.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/9/2008 12:33:59 AM
Posts: 2,
Visits: 4
|
|
| I tried with SQL Express 2005. I first tried the default Windows Authentication mode with default instance "SQLEXPRESS", didn't work. I installed another instance, "TIMELESS", in Mixed Mode. I ran the "Reset TT&E SQL Server (or MSDE) Database" utility. Nothing seems to work, I can't connect. I was already running The Enterprise Web version as well on the previous server. About the only thing I can think left to try is to uninstall it all on the new server, reinstall the default SQLEXPRESS instance on the new server in Mixed Mode. Thoughts? (It would be nice if the correct info on this was added to the How to move db kb entry).
|
|
|
|
|
Support Staff
Group: Administrators
Last Login: 1/23/2011 10:48:04 PM
Posts: 273,
Visits: 1,543
|
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/9/2008 12:33:59 AM
Posts: 2,
Visits: 4
|
|
| Yeah, I had forgotten about "Surface Area Configuration", a dopey name and dopey place to configure a common parameter. Thanks. But, it still didn't work, even on the server to local. Eventually, I installed without instance support and it works. I think.
|
|
|
|