| Author |
 Topic  |
|
pgoudswa
Starting Member
16 Posts |
 Posted - 20 April 2006 : 20:07:57
|
First off, hello, my 2nd post (1st one I did a paste and my IE locked up) 
Fresh install on Windows 2000 server/MS SQL 2000/Active Directory. SQL Server is set to use both AD+MSSQL authentication.
Followed the instructions to a T, forum searched until my mouse1 wore out, tried everything I could think of, so here I am!
Alright, I logged in as AD administrator, created an empty database named "arrowforum", modified the configuration file to use MS SQL, also set the connection string to:
strConnString = "Provider=SQLOLEDB;Data Source=10.0.1.10;database=arrowforum;uid=XXX;pwd=ZZZ;"
and I even discovered that I need to use "...?RC=5" for the setup. (This should be added to the instructions!) I enter my DB version, enter the db administrator info and a forum admin user/pwd. But then I get this error:
quote:
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right
databasetype.
Code : 80040E4D
Error Description :
Login failed for user 'Administrator'.
The IP address I'm using above is the local IP of the db server, and is confirmed correct. The web server is a separate server on the same LAN where I have snitz installed. Also the servers are using Active Directory.
Part of my confusion stems from the user/pwd that I have to enter in the strConnString. I used the AD administrator user/pwd in there, because that's what I used to create the db. Is that right?
Any suggestions on how to correct this error?
cheers
Peter |
http://www.techforthetimid.com | http://greatfreeware.blogspot.com | http://www.MySteamID.com |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 April 2006 : 20:27:43
|
So the login data you used is for SQL or Windows authentication? IIS is configured for anonymous access or something else?
P.S.: Setup info is fine, with 3.4.x there is no need for RC=5. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
pgoudswa
Starting Member
16 Posts |
Posted - 20 April 2006 : 20:37:58
|
Thanks for the quick reply ruirib. I'm no SQL guru, so you may have to speak slowly for me!
When I created the empty database, I logged into the machine using the Active Directory Administrator user/password. As this user, I ran the SQL Server MMC console and created the database. All I did was create an empty database. I created no users for it, or assigned any other existing users rights on it.
So when I entered the strConnString details, I again used the AD Administrator user/password, so I think the answer to your question is that the login data is for Windows authentication.
I'm not sure what you mean by IIS being configured for anonymous access, but in order to get to the snitz forum folder, I have to actually log in first to AD; when I type the address, a login box appears. This is how I require it, because the only users of the forums will be authenticated users (there will be no public users). It is required because the database and IIS server are for use in a secure government environment.
|
http://www.techforthetimid.com | http://greatfreeware.blogspot.com | http://www.MySteamID.com |
|
|
|
pgoudswa
Starting Member
16 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 April 2006 : 20:49:40
|
Well I would guess that the AD administrator login data you used is using Windows authentication, so that could explain why you are not logging in.
You can try to change your connection string to use this:
strConnString = "Provider=SQLOLEDB;Data Source=10.0.1.10;database=arrowforum;uid=XXX;pwd=ZZZ;Integrated Security=SSPI"
This may or may not work, depending on how IIS is configured, but you can give it a try...
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
pgoudswa
Starting Member
16 Posts |
Posted - 21 April 2006 : 03:03:29
|
Okay, made the change. If I simply run setup.asp, I get this:
quote:
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code : 80004005
Error Description :
Cannot open database requested in login 'arrowforum'. Login fails.
Maybe a little more understanding of MS SQL will help me solve my own problem here. I've used MySQL under Linux before, and normally one would log into a workstation, but also have to log into mysql as an administrator-type user to create a new database.
Under MS SQL, I log into my workstation as an AD administrator, and I can just fire up SQL console without a username/password presumably because I'm verified as Administrator through the fact that it is configured to use MSSQL + AD authentication, correct?
So my question is, should I be creating a separate database administrator user in AD instead of using the AD administrator account? Then use that to create the snitz db? And put it in config.asp in the connection string?
I'm not familiar enough with the resultant error message above to know where exactly the problem lies.
|
http://www.techforthetimid.com | http://greatfreeware.blogspot.com | http://www.MySteamID.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 21 April 2006 : 06:00:15
|
Well I don't know whether that is exactly what you want, since the desired combination between SQL Server and IIS can vary.
What I would suggest is that you add another login to the SQL Server, this one using SQL Server authentication. Then add that login as a user in the Snitz database, giving him the dbo role until you create the tables. After that, I you can change the dbo role into db_datareader and db_datawriter.
After adding this login and user, change the connection string to use the user's name and password and run setup.asp again.
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
pgoudswa
Starting Member
16 Posts |
Posted - 21 April 2006 : 18:17:02
|
Put simply, all I want is to set up the forums! Realistically, access will be limited by AD authentication (as well as SSL, once I get that set up next week). I really don't care how it is done, I just want it set up.
So what I did was play around a little more with the SQL enterprise manager. I read my documentation and learned that there exists a user called "dbo" whose login happens to be MYDOMAIN/Administrator. So what I did was assume that dbo would be the best user to try it with.
So I changed my connection string to:
strConnString = "Provider=SQLOLEDB;Data Source=10.0.1.10;database=arrowforum;uid=MYDOMAIN/Administrator;pwd=ZZZ;Integrated Security=SSPI"
Then ran the setup script. Where it prompts me, I entered the same user as above. I think I got a little further, because this time I get over 50 critical error #2147217900, "create table permission denied in db "arrowforum"".
So at least it is seeing the database that I created, I think?
NEXT STEP
So at this point I thought I'd try your suggestion, so I created a new user called "forumdbo", assigned him to the "arrowforum" db with all the administrative rights. When I do this, I get the same critical errors as above. Am I on the right track?
|
http://www.techforthetimid.com | http://greatfreeware.blogspot.com | http://www.MySteamID.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 21 April 2006 : 18:59:40
|
| Seems like you have a permissions issue now... You were able to login, but seems like you cannot create the tables... Have assigned the dbo role to that user, for the arrowforum database? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
pgoudswa
Starting Member
16 Posts |
Posted - 23 April 2006 : 00:28:03
|
I deleted the forumdbo user from SQL entirely. Then, following my SQL Server book, followed the instructions 1 step at a time (all the while consulting with online help for verification!) and re-created the forumdbo user, and assigned it db_owner role to the arrowforum database. From what I can tell, the db_owner role should be sufficient to create tables, yes? I went back and re-checked my config.asp file and confirmed the info. Well unfortunately I got the same error#2147217900, "create table permission denied in db "arrowforum"".
I don't know what I am doing wrong. Does SQL need to be restarted for the changes to take effect? (should be No), should I be assigning a different role to that user?
...stumped but haven't given up hope!
|
http://www.techforthetimid.com | http://greatfreeware.blogspot.com | http://www.MySteamID.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
pgoudswa
Starting Member
16 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 April 2006 : 03:16:10
|
The problem may lie with the account being used by IIS, which I'm not sure about, cause I don't know how IIS is configured. Let's try a different approach:
1. Create a login using SQL Server authentication;
2. Add a user associated with that login to the database and assign him dbo role;
3. Change your connection string by removing the "Integrated Security=SSPI" part;
Try to create the tables then. Let me know how it goes. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
pgoudswa
Starting Member
16 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
pgoudswa
Starting Member
16 Posts |
|
|
Topic |
|
Topic Locked
