Configuring a security policy to connect two servers via a LAN

[Guest 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