| Author |
 Topic  |
|
|
tinker
Starting Member
4 Posts |
 Posted - 27 June 2004 : 14:43:17
|
I have a curious problem - others have had it as well. I have read other related posts that I can find and the problem persists. I've run Snitz forums before without problems and I am fairly familiar with SQL server, so I think I am just being thick-headed here and hope someone can help me out.
I am getting an error when I run Setup.asp on a newly installed version of snitz forum. The error is 80004005 and says that it is unable to locate the data source. ("Data source name not found and no default driver specified.")
SQL Server is running on the same machine as IIS.
The website is configured for both anonymous access and Windows Integrated Authentication.
I am using mixed authentication mode on the SQL server.
I have a login and user with dbo rights on the forum SQL database and the user is configured to use the SQL login rather than Windows login.
I've tried using the SQL connection strings in the config.asp file (modified with my database name, user id and pwd); I have tried using the DSN string (after setting up a DSN on the machine (which worked when tested); and I tried the nifty little trick of configuring a *.udl file that I found out about on one of these forums (which also worked when tested).
I've tried supplying the Setup.asp script with the sa username and password, and I get the same error.
I am able to connect to my SQL server with another instance of SQL server running on another machine.
I have never had trouble installing snitz before - what am I missing?
|
|
|
tinker
Starting Member
4 Posts |
Posted - 27 June 2004 : 16:39:41
|
 New wrinkle. I tried reinstalling Snitz, deleting and reinstalling the SQL database and recreating the user logins. Now I get the following error when I run the Script.asp:
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 :
Unspecified error
Furthermore, when I ran script.asp before, I would get an initial screen that said I needed to setup the db; then I would get a "login screen" at which I would be given a chance to tell snitz the login to use and the password (and I would select an Admin name and password) then I would finally get the error previously discussed. However, now when I run script.asp I just get this screen - I am no longer given any opportunity to give snitz setup the login information!
All of the info that I gave in the earlier post about my configuration is still true. Also, I forgot to mention then that, I do have a firewall, but I am using SQL server defaults and I have opened port 1433 on the firewall.
Any help is appreciated.
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
tinker
Starting Member
4 Posts |
Posted - 27 June 2004 : 20:16:43
|
I can turn off the firewall - but, it is a bit of trouble. It is a hardware firewall which is also acting as my DHCP server. So, I'd rather not if I don't have to. What I did just do is place my machine on the "DMZ" which is almost as good as unplugging the firewall and I got the same error.
However, if you really think the problem is the firewall, then I guess I will have to pull the plug.
This is really strange. I had a snitz forum setup about 2 years ago behind this firewall and had no problems. I just can't understand why the code is unable to find the db that resides on the same machine and I REALLY do not understand why the DSN did not work. I think there must be a clue in that - but what it is, I do not know. |
|
|
|
tinker
Starting Member
4 Posts |
Posted - 27 June 2004 : 22:32:01
|
 We'll I'm not sure what the problem was but it is fixed. I managed to get a new forum working on another computer test website and another SQL Server DB and then uploaded the website and the SQL Server DB to my production machine. It all seems to be working now.
I have no clue what the problem was. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
