| Author |
 Topic  |
|
manta777
Starting Member
3 Posts |
 Posted - 02 July 2002 : 17:55:54
|
Thanks in advance for helping.
I created an empty DB on my SQL Server, added my standard user to the DB, changed all of the settings in the config.asp file as directed in the readme.txt file and then went to setup.asp?RC=5.
I get the following:
Please Wait until the installation has been completed !
[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT permission denied on object 'FORUM_CATEGORY', database 'Snitz', owner 'WebUser'.
INSERT FORUM_CATEGORY(CAT_STATUS, CAT_NAME) VALUES(1, 'Snitz Forums 2000')
And it repeats this every time an Insert is tried. At the bottom of the page it says:
The Installation has NOT been completed !
There were 5 Critical Errors...
I looked at the SQL server and the tables are setup, but there is no data. Any idea how to fix this???
Thanks!
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 02 July 2002 : 18:23:09
|
Looks like you may be having permissions problems. Make sure the user you specify at the login page, at the start of the setup (not the Admin, the "SQL user") has dbowner rights, at least while the tables are created...
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
 |
|
|
manta777
Starting Member
3 Posts |
Posted - 02 July 2002 : 19:49:47
|
Thanks..I'm at home now..but I'll try when I get to work tomorrow. I think that I gave that user access to everything (I know I checked all the boxes). But let me check and I'll let you know.
|
|
|
|
manta777
Starting Member
3 Posts |
Posted - 03 July 2002 : 09:09:08
|
Yes...the user has dbowner rights...Any other ideas??
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 03 July 2002 : 09:34:11
|
That definetely looks weird. I never experienced anything like that. Assign that user (WebUser) the dbdatawriter role and try again.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 03 July 2002 : 09:57:53
|
You can also try another thing, if the previous one does not work. At the page where you're asked for the name/password of a user with table modification rights, use sa and its password. DO not change the connection string. Just specifiy them at this page.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 03 July 2002 09:59:10 |
|
|
|
wasim
Junior Member
USA
121 Posts |
Posted - 08 July 2002 : 14:49:40
|
I am trying to get this working with SQL on my local host machine. Everything seems to be in order. SQL Server is installed. My SQL Server driver is setup with the empty snitz table as the default table.
My config file is proper.
when i do the setup i get to the panel that asks whether i have sql 6.5 or 7/2000
I check 2000 and enter my username and password which is the username and password that i am logged in under which is the admin and db owner priveleges are set in the user area in enterprise manager.
when i put in my name and password in setup?RC=5 after selecing SQL server 2000 i get
The database could not be opened !!
Code : 80040E4D
help please.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 July 2002 : 15:45:51
|
Post your connection string. Is your server configured to support SQL Server authentication?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
wasim
Junior Member
USA
121 Posts |
Posted - 08 July 2002 : 20:35:42
|
strConnString = "SQL Server;server=PIKEHAN;uid=wahili;pwd=********;database=snitz" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
i have sql server installed on my windows 2000 machine.what more can i do to check to see if its configred corrently
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 July 2002 : 20:51:20
|
quote:
strConnString = "SQL Server;server=PIKEHAN;uid=wahili;pwd=********;database=snitz" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
i have sql server installed on my windows 2000 machine.what more can i do to check to see if its configred corrently
This post will tell how you can check/change the authentication mode for SQL Server: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=26346#123103
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
wasim
Junior Member
USA
121 Posts |
Posted - 08 July 2002 : 21:40:06
|
i did that exact process.
I get this message in a status window.
A connection could not be established to PIKEHAN-Timeout expired
Please verify SQL is running and check your SQL server registration properties.
Then the server started running again suddenly.
Then when i check the host it says this..
HTTP 403.9 - Access Forbidden: Too many users are connected
Internet Information Services
I am on a local machine that does not host any websites.
What happened?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 July 2002 : 21:42:46
|
Open a DOS prompt and type this: iisreset /RESTART. Once the command is finished try again.
Did you restart SQL Server after changing the Authentication configuration?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
wasim
Junior Member
USA
121 Posts |
Posted - 08 July 2002 : 21:53:47
|
ok so i get to the setup page same panel and same eror.
The database could not be opened !!
Code : 80004005
|
|
|
|
wasim
Junior Member
USA
121 Posts |
Posted - 08 July 2002 : 21:54:55
|
what about Audit Level and the Startup account..
the login and password in This Account which is what is checked is the same as the one in my conn string.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 July 2002 : 22:07:34
|
As you haven't stated it, I assume that your SQL Server is already allowing SQL Server authentication. How was it configured before?
Have you created a new login, since you changed the authentication mode, and set it up to use SQL Server authentication? Have you created a new user for the Snitz database associated with that login? Does this user have the dbowner role for that database?
All answers must be yes.If they are no, then make the necessary operations (create login, create associated user, assign dbowner role).
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
wasim
Junior Member
USA
121 Posts |
Posted - 08 July 2002 : 22:16:56
|
Well I just set security to allow sql server authentication.
I didnt have to set a new user for the database because its the same as before..same login and password as the admin password for my computer with dbowner rights. As for the new login no i havent set one but do u mean from the Users Setup in my control panel on the computer or some way through Enterprise manager.
|
|
|
|
Topic |
|
Topic Locked
