Solved

nt4.4 IIS 4.0 and Sql Server

Posted on 2000-02-15
7
208 Views
Last Modified: 2013-12-28
I have a Web Server with NT 4.4 and IIS 4.0 running a website in its own Domain outside our PIX Firewall. I have an ASP application that works with SQL Server 7.0.  I don't want to data outside the firewall, but I cannot get access through ODBC to the Server in another domain that has SQL Server loaded on it.  I have read somewhere that your SQL Server database and the IIS server needed to be on the same machine. Is this true? I don't have the enterprise version of NT either I had heard that you could cluster to make this work, but I can't do that without enterprise. I this true also? Can I install SQL Server on the outside Web Server and set up a SQL Server Group to control the inside database and get access that way. Help.. Thanks in advance for your responses.
0
Comment
Question by:drg22
  • 4
  • 2
7 Comments
 
LVL 8

Expert Comment

by:MaDdUCK
Comment Utility
yes, you should be able to do this - if you can access the server inside the firewall from the outside... do you have a proxy? you need to be able to ping the sql server separately. no need to have iis and sql running on the same server, it's better if sql is a dedicated server anyway and iis is outside. as soon as you can ping from iis to sql, you can set up an application role within sql server and write the asp application appropriately to use it. for the server name in the ADO connection string, you could use the dns name or use the lmhosts file to map the ip of the sql server to its name, or use wins.

please ask if you have any questions!
0
 

Author Comment

by:drg22
Comment Utility
Ok I am able to ping between servers I am using an ODBC data source on the IIS that points to the server with SQL Server.  Do you mean I need to open the connection with a connection string without using ODBC data source? The ASP page is trying to open a connection as follows:
Set DatabaseConnection = Server.CreateObject("ADODB.Connection")
Set rsNextRec = server.CreateObject("adodb.recordset")

DatabaseConnection.open "dsn=Permits", "", ""

SQLDataInsertionString = "Select * from NextRec"
rsNextRec.Open SQLDataInsertionString,DatabaseConnection, adOpenKeyset,adLockPessimistic

now when you say set up an Application in SQL Server I currently have it as standard role.  How do I set it up to be an Application.  I know I need to add a new role, but I am not sure what name  I need it to give it there is already a public role that is standard.
0
 
LVL 8

Accepted Solution

by:
MaDdUCK earned 400 total points
Comment Utility
okay, try this as a connection string:

Provider=SQLOLEDB.1;Data Source=path to server

so if your server was named SQLSRV, try this:

Provider=SQLOLEDB.1;Data Source=\\SQLSRV

or

Provider=SQLOLEDB.1;Data Source=<IP address>

on application roles (preferable for application access rather than user access):

http://www.sfi-software.com/manuals/helpsql7/helpsqlspsetapprole_TSQL.html

0
Why do Marketing keep bothering you?

Is your marketing department constantly asking for new email signature updates? Are they requesting a different design for every department? Do they need yet another banner added? Don’t let it get you down! There is an easy way to manage all of these requests...

 

Author Comment

by:drg22
Comment Utility
Thanks MaDduck, I am going to leave this open for now. It appears to work inside on my Intranet.  I have to poke a hole in my firewall now, and do some more configuration before I can test completely. Please check back on this issue in a few hours as I may have some more questions. Thanks.
0
 

Author Comment

by:drg22
Comment Utility
Thanks MaDduck, I am going to leave this open for now. It appears to work inside on my Intranet.  I have to poke a hole in my firewall now, and do some more configuration before I can test completely. Please check back on this issue in a few hours as I may have some more questions. Thanks.
0
 
LVL 1

Expert Comment

by:vasu_i
Comment Utility
before i give suggession i want you to remember that you are using a firewall. that is in between the web and sql servers.

now the problem is sql will use one or the other port in tcp/ip to communicate with its clients. if you have configured sql server to use tcp/ip based connections you might have already observed the port number you are using. please release the port number from the firewall's block list. the reason why you are not able to connect is your firewall does not allow connection on ports other than regular ones. your firewall may be configured to allow only ports like web (tcp 80), ftp (tcp 21), dns (udp 53) and some other. please remember that you are trying to connect two systems beyond a firewall on unsupported port.

find now what is wrong. check the firewall !!!!
0
 

Author Comment

by:drg22
Comment Utility
Thanks for the comments Vasu_i I am going to award the points to MaDduck at this time as the comments solved the problem.  Thanks again for the help.
drg22
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now