| Author |
 Topic Search  Topic Options
|
NShel 
Groupie
Joined: 23 September 2006
Location: United States
Status: Offline
Points: 49
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: New installation in progress
Posted: 09 December 2007 at 6:49pm |
|
Hello: I've just installed all the files, to the best of my knowledge, but don't have things working properly yet.
I've just discovered the sentence, "
This may not be the same user that you have used in your SQL Server connection string!" on the msSQL_server_setup.asp page however, I did try to use the same user to login with the form on this page.
Would merely trying to log in corrupt anything? I'm waiting for help from my web host in creating the new, blank database.
|
 |
NShel
Groupie
Joined: 23 September 2006
Location: United States
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 December 2007 at 7:09pm |
|
Disregard
|
|
NShel
Groupie
Joined: 23 September 2006
Location: United States
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 December 2007 at 7:18pm |
|
I guess I'm not finished after all.
Regarding msSQL_server_setup.asp
I tried the passwords for the database that I know, that is, the ones for the existing database I'm upgrading from. At first, I copied the password wrong, but after I got it right, one time only, I got the message Congratulating me. However, it wouldn't let me into the database setup, so I'm uncertain of what to do.
When you say, "This may not be the same user that you have used in your SQL Server connection string!" do you mean you may, or you may not? or do you mean you CAN not?
|
|
Jono
Mod Builder Group
Joined: 18 September 2006
Location: United Kingdom
Status: Offline
Points: 100
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 December 2007 at 8:26pm |
When you create you database, you also create a database user to connect to that database. This user *may* just have data read/write access, so cannot create tables, etc.
The message you see is warning you that should use an account that has sufficient privilages.
If you have configured the user on SQL server and given database owner rights, then it should work.
Hope this helps.
|
|
NShel
Groupie
Joined: 23 September 2006
Location: United States
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 December 2007 at 9:09pm |
|
I did, thank you.
I think that I must have made some mistake, when I try to long in subsequently, I get the messages
"...Cannot insert duplicate key row in object 'tblAuthor' with unique index 'User_code'. SQL Server database is set up, but with Error!"
Should I delete the contents of the database directory, then restore it and run the database server setup again?
|
|
Jono
Mod Builder Group
Joined: 18 September 2006
Location: United Kingdom
Status: Offline
Points: 100
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 December 2007 at 10:40pm |
|
If it a new install, then yes. Sounds like it's half worked and when you run the set up script again it trying to install the default admin and guest accounts again (hence the duplicates).
|
|
NShel
Groupie
Joined: 23 September 2006
Location: United States
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 December 2007 at 12:48am |
It's not a new install exactly, that is I'm upgrading and the database I'm going to is a used one. I did delete the database and ran the setup program and got the message: Congratulations, the SQL Server Forum database is set up and Ready to Go :)
but when I try to open my forum I ge the message:
Microsoft VBScript runtime error '800a01f4'
Variable is undefined: 'strAppPrefix'
/functions/functions_date_time_format.asp, line 57
|
|
NShel
Groupie
Joined: 23 September 2006
Location: United States
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 December 2007 at 2:39am |
|
Okay, I got it. That is, I have a forum online. That is, I have a forum online at my website that doesn't include any of my version 7 forums or topics. How to I restore those? I backed everything up, but I don't know how to find what I want.
Edited by NShel - 10 December 2007 at 3:21am
|
|
