R
Roger Withnell
I have a Web Server and an SQL server both running under Windows 2003.
I want to connect to the SQL Server database from the websites on the Web
Server.
There is a private LAN between the two servers. They are not on the same
work group but I can access shared folders across the LAN using the syntax
'\\<ipaddress>\<SharedFolder>' in the Explore address. (The servers are
hired from a remote Host supplier and this is the way that I have to
communicate between servers).
To test this, I have set up on both servers a shared folder with Everyone
permissions set to 'Allow full control'.
Both the servers have the Windows Firewall active.
The Web Server has a Security Policy set up using the Security Configuration
Wizard. The SQL Server does not.
From the SQL Server, I can access the shared folder on the Web Server using
\\<ipaddress>\<SharedFolder> in Explore after entering the username and
password of the latter when prompted.
From the Web Server, I CANNOT access the shared folder on the SQL Server by
the same method, getting the error 'Windows cannot find
'\\<ipAddress>\<SharedFolder>'.
Any ideas why? Is it to do with the Security Policy setup on the Web
Server? If so, how do I update it to fix the problem? I've looked through
the Security Configuration Wizard but can't see anything obvious. Turning
both firewalls off does not fix the problem.
Any help much appreciated.
Thanking you in anticipation.
Roger
I want to connect to the SQL Server database from the websites on the Web
Server.
There is a private LAN between the two servers. They are not on the same
work group but I can access shared folders across the LAN using the syntax
'\\<ipaddress>\<SharedFolder>' in the Explore address. (The servers are
hired from a remote Host supplier and this is the way that I have to
communicate between servers).
To test this, I have set up on both servers a shared folder with Everyone
permissions set to 'Allow full control'.
Both the servers have the Windows Firewall active.
The Web Server has a Security Policy set up using the Security Configuration
Wizard. The SQL Server does not.
From the SQL Server, I can access the shared folder on the Web Server using
\\<ipaddress>\<SharedFolder> in Explore after entering the username and
password of the latter when prompted.
From the Web Server, I CANNOT access the shared folder on the SQL Server by
the same method, getting the error 'Windows cannot find
'\\<ipAddress>\<SharedFolder>'.
Any ideas why? Is it to do with the Security Policy setup on the Web
Server? If so, how do I update it to fix the problem? I've looked through
the Security Configuration Wizard but can't see anything obvious. Turning
both firewalls off does not fix the problem.
Any help much appreciated.
Thanking you in anticipation.
Roger