| Author |
 Topic  |
|
|
Curmudgeon
Starting Member
17 Posts |
 Posted - 08 March 2005 : 19:12:21
|
I am a 3-year moderator/admin of a Snitz Forums 2000 (Version 3.3.03) using SQL Server. I did not install it, so have no experience to draw on there.
I am trying to install SNITZ 3.4.05 on my XP machine (IIS enabled) so that I can move the mods made to the old version into the newest version for testing prior to installation on a different host.
I have scoured the various SNITZ forums and threads for information on this error, but cannot find anything to help.
What I did find was a reference on www.dougscode.com that tells me what I already know. Error 80040E4D says: "Login failed for user 'COMPUTERNAME\IUSR_COMPUTERNAME'." When I try to add this user, XP tells me the user is there, and Enterprise manager says it isn't. When I change the connection string to include a user that EM says I have, I get the same error.
Intuition tells me the problem is in my conn string - but I can't figure out how/what.
One could easily harbor ill will toward connection strings.
Anybody got ideas as to what is wrong and how to fix it?
The Curmudgeon |
Edited by - Curmudgeon on 08 March 2005 19:18:03 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 March 2005 : 19:50:35
|
Is IIS configured to allow anonymous access? If it is not you should configure it so. It seems to me that it is configured for integrated windows authentication, and it seems like SQL Server is also configured to use Windows authentication. That means that when you try to access the forum, the user Windows uses is the anonymous internet user (IUSR_COMPUTERNAME) but if you have not created a login for that user in EM.
You have one of two ways to handle that:
1. Configure IIS to use anonymous access and configure SQL Server to use SQL Server authentication. Create a login (using EM) to use SQL Server authentication, assign it dbowner role for the forum DB and use that user access data in the SNitz connection string.... OR
2. Let IIS be as it is and use Enterprise Manager to add a login for 'COMPUTERNAME\IUSR_COMPUTERNAME'. Assign dbowner role to this user for the forum DB.
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
Curmudgeon
Starting Member
17 Posts |
Posted - 09 March 2005 : 12:24:30
|
Thanks for the hints, ruirib & podge - but something else must be wrong, because I still get the same error. FWIW, I confirmed the settings that both of you suggested.
This time around, I will paste in the connection string (substituting "CPUNAME" for my computer name). Note that the password is null - could THAT be the problem?
strConnString = "DRIVER=SQL Server;SERVER=CPUNAME;UID=CPUNAME\IUSR_CPUNAME;PWD=;DATABASE=snitzforum"
Also - I have already "restored" the database on my development system from the version 3.3.03 install on the original host. This db consists of 6257 Posts in 1289 Topics and 1652 Users. The database appears to be ok. Is it possible that there is a problem here? Is the schema for v3.3.03 the same as that for v3.4.05?
The Curmudgeon |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 March 2005 : 13:02:03
|
That cannot be your connection string. If you plan to use integrated security, you need to do as I wrote above and create a login in SQL Server for the anonymous internet user (IUSR_... account). Then the connection string should be similar to:
"Provider=sqloledb;Data Source=CPUNAME;Initial Catalog=DATABASENAME;Integrated Security=SSPI;"
No username and password should specified in the connection.
If you plan to use SQL Server security, then you need to specify username and password, but the username cannot definitely be something of the type CPUNAME\userName.
How is your SQL Server configured? To use Windows or Windows and SQL Server security? What exactly do you want to use?
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Curmudgeon
Starting Member
17 Posts |
Posted - 09 March 2005 : 18:14:02
|
ruirib,
Thanks for your connection string suggestion as well as the comments in your earlier post. I have implemented them as faithfully as I know how. However, I must be missing something, since I still cannot login with setup.asp.
All I want to do is set up the forum on my development system so that I can test source changes migrated from the earlier install on another host. When those changes all work, I will migrate the modified app to the production server. This is my only use for SQL Server at this time.
No matter what I do, when I run setup.asp, I still get the same error message: "Login failed for user 'CPUNAME\IUSR_CPUNAME'." The message is the same EVEN IF this user is missing from the list in EM.
Settings:
1. EM will not allow me to enter "IUSR_CPUNAME" - but accepts "CPUNAME\IUSR_CPUNAME". This user has dbowner privileges, as does other users.
2. IIS is set up for anonymous access, with "Allow IIS to control password" checked. The anonymous user is "IUSR_CPUNAME", and the password field is blank.
3. SQL Server is configured for both Windows and SQL Server authentication with Audit level set to "None"
The connection string in use is the one you suggested earlier today, with appropriate system name and database name changes.
What am I missing here?!
Thanks - - - Again. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 March 2005 : 18:41:10
|
Ok, here is what I suggest:
1. Using EM create a new login, configured to use SQL Server authentication.
2. Using EM assign a dbowner role to the user associated with the login created in 1.
3. Change config.asp to use a connection string like this one:
strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;"
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 09 March 2005 18:42:24 |
|
|
|
Curmudgeon
Starting Member
17 Posts |
Posted - 14 March 2005 : 15:41:45
|
Ruirib:
Thanks for your help and patience with my obtuse questions!!
FYI, I finally solved the problem by going to the tree branch: EM/Console/.../Security and adding in the appropriate user, with all privileges. I then changed the conn string to:
"Provider=SQLOLEDB;Data Source=SERVER_NAME;database=SNITZFORUM;Trusted_Connection=yes"
All is well, and running.
Now, I am on to the next layer of issues - - - you will probably see me again.
Once again - Thanks! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
.