Re: Firewall settings choices

From: Fox Bortniker (fox@connexions.net)
Date: 02/05/03 

From:     Fox Bortniker <fox@connexions.net>
Date: Wed, 05 Feb 2003 14:43:48 -0800

Thanks so much for your willingness to help. This is what I was having a
problem with. I can set up a connection string as you have here, but I
do not know how to configure SQL with a required Login and PW. Is this
done in Enterprise ?

<%SQLConn = "DRIVER={SQL
Server};SERVER={ServerName};DATABASE={DataBaseName};UID={UserName};PWD={
Logi
naccountpassword};"%>

With ACCESS I just us the SA without a PW which as I understand it, this
is pretty standard. Blink Blink, a light just came on. Now that I am
writing this to you and have been reading so much lately, I now know why
I should change that and I will. However, I do not know how to configure
SQL for public access. Where do I configure the needed Login and PW for
access via the web pages. I will be using a system DSN. Do I first
configure USERS and ROLES in Enterprise and then use a public user ? Or
is that way off the mark ? Once I have that done I can pop that into the
script above and go for a test ride.

I just found out that when I blocked Internet Access in the firewall and
left it only "Trusted Access" to server, I could not use my other SQL
connection until turning it back to allow. I thought that it would
consider its access as a system access via the trusted ips since its
accessed by the web server on the same machine. Guess I was wrong.

Thanks,
Fox

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Pass Through Query Question
    ... "Joe Williams" wrote in message ... > when you mentioned setting the connection string in the properties of the ... It runs with no problem using SQL query anlayzer. ...
    (microsoft.public.access.queries)
  • Re: connectionstring & web farm
    ... the scenario used in this question was a web farm configuration (3 ... I know all the machines in the web farm need to have the connection string. ... Placing the connection string in Machine.config on every web server can from ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cant get SQL INSERT code to work
    ... I'm not sure you can use SQL to add data to an Excel file from another ... From Access Help file (covers JET SQL): ... ' Create the connection string. ... > 'Excel file and modify the SQL statement to fit your data. ...
    (microsoft.public.access.queries)
  • Re: Dataset - Error
    ... Server connection ... So looking at this we see that it is an error coming from SQL. ... Next we would look at the connection string, which is used to "login" to SQL ... What is does specify in regards to the userid is the ...
    (microsoft.public.cert.exam.mcsd)
  • Re: EXEC master..xp_cmdshell Prevention
    ... > I found that my web application did use a connection string in a file ... > stored procedures for every SQL statement would be impractical. ... I have created a new login account ...
    (microsoft.public.sqlserver.security)