| Author |
 Topic  |
|
shannon
Starting Member
11 Posts |
 Posted - 01 June 2004 : 13:23:52
|
I have been sucessfully running the Snitz forum off of an Access database for several years. The version I was using was 3.3.03. I am trying to configure the Snitz forum to run off of a remote database ... SQL Server 2000 installed on a Windows 2003 machine. I have downloaded the newest version from the web site (3.4.04). I have modified the config.asp file properly (to the best of my knowledge). I am able to connect to the remote database using the Enterprise Manager and the Query Analyzer. When I try to run setup.asp, hoever, I get the following error ...
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 :
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Can anyone help resolve this installation issue?
Thanks,
Shannon |
Edited by - shannon on 01 June 2004 13:25:46 |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 01 June 2004 : 13:40:04
|
Try using your server's IP address in your config.asp connection string.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
 |
|
|
shannon
Starting Member
11 Posts |
Posted - 01 June 2004 : 15:33:12
|
quote:
Originally posted by Doug G
Try using your server's IP address in your config.asp connection string.
I tried both the name and the IP address of the server. The exact same error results from both. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
shannon
Starting Member
11 Posts |
Posted - 01 June 2004 : 21:47:24
|
quote:
Originally posted by ruirib
Make sure the user you're specifying has permissions to access that server and database.
How do I do this? I think the default user is IUSR_HERCULES (Hercules is the name of the web server on which the Snitz forum is installed). What exactly do I need to give this user permission to access? To my knowledge the user doesn't directly access the SQL Server database tables (like with Access).
Shannon
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 01 June 2004 : 21:51:18
|
Do you have any firewall that may be blocking access to your sql server?
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 02 June 2004 : 08:50:09
|
quote:
Originally posted by shannon
I tried both the name and the IP address of the server. The exact same error results from both.
In Enterprise Manager, does it show just as your IP Address or does it have a backslash and a name after it
eg.
111.222.333.444
or
111.222.333.444\Name
Also, check what port SQL Server is using (open Sql Server Client Network Utility, view the properties of TCP/IP) |
The UK MkIVs Forum |
|
|
|
shannon
Starting Member
11 Posts |
Posted - 02 June 2004 : 16:39:24
|
1) I have no firewalls between the two servers. They are on the same LAN.
2) I have tried the following connection strings:
strConnString = "Provider=SQLOLEDB;Data Source=DB;database=Northwind;uid=sa;pwd=admin"
strConnString = "Provider=SQLOLEDB;Data Source=12.34.132.242;database=Northwind;uid=sa;pwd=admin"
This IP address is a local address only available on the LAN. But the web server can access this machine by either name or IP address. I also tried the following connection string ...
strConnString = Provider=SQLOLEDB.1;Password=admin;Persist Security Info=True;User ID=sa;Initial Catalog=Northwind;Data Source=DB"
... which is a string I can successfully connect with using ADO components from within a Delphi application.
All result in the same error.
3) I am not sure what you are referring to with Enterprise Manager. I see Console Root > Microsoft SQL Servers > SQL Server Group > DB (Windows NT) > Databases > Northwind, master, tempdb, model, etc. Where do I look for the IP address or the IP address\Name?
The Client Network Utility says TCP/IP uses default port 1433.
Shannon
|
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 02 June 2004 : 16:46:38
|
All those connection strings should work, although you should create a db for Snitz really instead of Northwind.
Have you tried creating a System DSN to the 2003 server from the 2000 server to test the connection?
Don't worry about what I said about Enterprise Manager, I was just checking if you were using the default instance on port 1433 which you are. |
The UK MkIVs Forum |
|
|
|
shannon
Starting Member
11 Posts |
Posted - 02 June 2004 : 18:26:16
|
quote:
All those connection strings should work, although you should create a db for Snitz really instead of Northwind.
I have. I just switched to using Northwind as a test when connecting to my other database failed.
quote:
Have you tried creating a System DSN to the 2003 server from the 2000 server to test the connection?
How do I do this? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
proeder
Junior Member
Australia
230 Posts |
Posted - 02 June 2004 : 19:55:34
|
quote:
Make sure the user you're specifying has permissions to access that server and database.
Have you checked that your sql server supports mixed mode authentification? |
Looking for german Snitz forum? Suchst Du ein deutsches Snitz Forum?
Hier findest Du eins...
Hosting with ASP Support available: http://www.sharepointing.com |
|
|
|
shannon
Starting Member
11 Posts |
Posted - 03 June 2004 : 10:42:03
|
Here's an update.
On the web server, I went into Internet Services Manager and viewed the properties of the Default Web Site. On the Directory Security tab I selected the Edit button for Anonymous access, and edited the account used to my own user name/password rather than the IUSR_HERCULES. Everything worked and the forum was set up properly with the connection string ...
Provider=SQLOLEDB.1;Password=XXX;Persist Security Info=True;User ID=sa;Initial Catalog=Northwind;Data Source=DB
The bad thing about this, however, is that I can not keep this account for anonymous access. I am an administrator. When I switch back to IUSR_HERCULES I am in the same boat as I was to begin with ... SQL Server does not exist or access denied.
I have read that Windows 2003 is much more restrictive about user access to resources. Is it possible that the user IUSR_HERCULES may not have privileges to connect to the SQL service on the database server and this has nothing to do with connecting to the databases themselves (i.e. it does not seem to matter whether I am trying to connect to the database I created or the sample database)?
Shannon |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
shannon
Starting Member
11 Posts |
Posted - 03 June 2004 : 11:57:25
|
This issue is resolved.
I created a user named IUSR_HERCULES on both the web server and the database server with the same password ... anonymous.
I then went into Internet Services Manager and viewed the properties of the Default Web Site. On the Directory Security tab I selected the Edit button for Anonymous access, and edited the account to be IUSR_HERCULES with the password anonymous. I unchecked the option that said "Allow IIS to control password."
Then everything worked with the connection string ...
Provider=SQLOLEDB.1;Password=XXX;Persist Security Info=True;User ID=sa;Initial Catalog=Northwind;Data Source=DB
I am not really sure what the issues are here. IUSR_HERCULES does not have privileges to access the database itself ... entering this username and password into the connection string will fail. But it does seem that the Windows user must be created on the database server. Again, this server is running Windows 2003.
Thanks to everyone that helped me resolve this problem.
Shannon
|
|
|
|
Topic |
|
Topic Locked
