Welcome to MobyThreads.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in
All support for the MobyThreads Threaded phpBB MOD can now be found on welsolutions at this forum

sql database access from windows 2003 webedition

  
   Web Hosting and Web Master Forums (Home) -> IIS RSS
Next:  IIS 6.0 caching  
Author Message
cormstrup

External


Since: Jun 03, 2004
Posts: 1



(Msg. 1) Posted: Thu Jun 03, 2004 11:43 am
Post subject: sql database access from windows 2003 webedition
Archived from groups: microsoft>public>inetserver>iis (more info?)
We have a web server that is set up in the DMZ of our firewall.
It of course is on a seperate subnet from the internal SQL server.
Our network is Windows 2000 with active directory.
The web server is windows 2003 web edition.

We are having trouble getting the ASP.net web application to authenticate or
establish it's connection string to the SQL server and associated databases.
We had it working when the server was setup temporarily on a XP desk top
with IIS.(it was a little inconsistent)Now that it is installed on a 2003
web edition server, it will not establish a connection to the database.Nic
settings the same as working XP setup. Firewall settings the same. Maybe
2003 has different default setting or will not handle SQL the same.
Webserver is correct in DNS and WINS.

Does anyone know how to resolve this issue?

 >> Stay informed about: sql database access from windows 2003 webedition 
Back to top
Login to vote
anonymous131

External


Since: Oct 17, 2003
Posts: 720



(Msg. 2) Posted: Thu Jun 03, 2004 11:43 am
Post subject: sql database access from windows 2003 webedition [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Lemme look into my crystal ball and see what the error
message that you are seeing is. Nope. I can't see it. You
are going to have to post the error message.

doug
 >-----Original Message-----
 >We have a web server that is set up in the DMZ of our
firewall.
 >It of course is on a seperate subnet from the internal
SQL server.
 >Our network is Windows 2000 with active directory.
 >The web server is windows 2003 web edition.
 >
 >We are having trouble getting the ASP.net web
application to authenticate or
 >establish it's connection string to the SQL server and
associated databases.
 >We had it working when the server was setup temporarily
on a XP desk top
 >with IIS.(it was a little inconsistent)Now that it is
installed on a 2003
 >web edition server, it will not establish a connection
to the database.Nic
 >settings the same as working XP setup. Firewall settings
the same. Maybe
 >2003 has different default setting or will not handle
SQL the same.
 >Webserver is correct in DNS and WINS.
 >
 >Does anyone know how to resolve this issue?
 >
 >
 >.
 ><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: sql database access from windows 2003 webedition 
Back to top
Login to vote
user641

External


Since: Aug 22, 2003
Posts: 1637



(Msg. 3) Posted: Thu Jun 03, 2004 2:40 pm
Post subject: Re: sql database access from windows 2003 webedition [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Christian Ormstrup" <cormstrup RemoveThis @tmi-canada.com> wrote in message
news:uEftekXSEHA.3872@TK2MSFTNGP10.phx.gbl...
 > We have a web server that is set up in the DMZ of our firewall.
 > It of course is on a seperate subnet from the internal SQL server.
 > Our network is Windows 2000 with active directory.
 > The web server is windows 2003 web edition.
 >
 > We are having trouble getting the ASP.net web application to authenticate
or
 > establish it's connection string to the SQL server and associated
databases.
 > We had it working when the server was setup temporarily on a XP desk top
 > with IIS.(it was a little inconsistent)Now that it is installed on a 2003
 > web edition server, it will not establish a connection to the database.Nic
 > settings the same as working XP setup. Firewall settings the same. Maybe
 > 2003 has different default setting or will not handle SQL the same.
 > Webserver is correct in DNS and WINS.
 >
 > Does anyone know how to resolve this issue?

It would help to know more specifically what "having trouble" means ... any
error messages? What happens?

--
Tom Kaminski IIS MVP
<a style='text-decoration: underline;' href="http://www.iistoolshed.com/" target="_blank">http://www.iistoolshed.com/</a> - tools, scripts, and utilities for running IIS
<a style='text-decoration: underline;' href="http://mvp.support.microsoft.com/" target="_blank">http://mvp.support.microsoft.com/</a>
<a style='text-decoration: underline;' href="http://www.microsoft.com/windowsserver2003/community/centers/iis/" target="_blank">http://www.microsoft.com/windowsserver2003/community/centers/iis/</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: sql database access from windows 2003 webedition 
Back to top
Login to vote
user675

External


Since: Aug 28, 2003
Posts: 617



(Msg. 4) Posted: Thu Jun 03, 2004 7:47 pm
Post subject: Re: sql database access from windows 2003 webedition [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Thu, 3 Jun 2004 08:43:21 -0600, "Christian Ormstrup"
<cormstrup.TakeThisOut@tmi-canada.com> wrote:

 >We have a web server that is set up in the DMZ of our firewall.
 >It of course is on a seperate subnet from the internal SQL server.
 >Our network is Windows 2000 with active directory.
 >The web server is windows 2003 web edition.
 >
 >We are having trouble getting the ASP.net web application to authenticate or
 >establish it's connection string to the SQL server and associated databases.
 >We had it working when the server was setup temporarily on a XP desk top
 >with IIS.(it was a little inconsistent)Now that it is installed on a 2003
 >web edition server, it will not establish a connection to the database.Nic
 >settings the same as working XP setup. Firewall settings the same. Maybe
 >2003 has different default setting or will not handle SQL the same.
 >Webserver is correct in DNS and WINS.
 >
 >Does anyone know how to resolve this issue?

What happens when it won't connect ? Any error messages, etc ?

Try this KB article to start with :

How to troubleshoot connectivity issues in SQL Server 2000
<a style='text-decoration: underline;' href="http://support.microsoft.com/?id=827422" target="_blank">http://support.microsoft.com/?id=827422</a>


Regards,

Paul Lynch
MCSE<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: sql database access from windows 2003 webedition 
Back to top
Login to vote
cormstrup1

External


Since: Jun 03, 2004
Posts: 1



(Msg. 5) Posted: Thu Jun 03, 2004 7:47 pm
Post subject: Re: sql database access from windows 2003 webedition [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
We get no error messages from Windows or sql.
We do get a debug message from the .net app that my colleague created
for our web site. That it fails to authenticate on line 57 when it
attempts to authenticate to the sql server database.

This does not happen when we load this app on a XP desk top running IIS.
as mentioned in the previous message.

The 2003 web edition server will not authenticate.


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
 >> Stay informed about: sql database access from windows 2003 webedition 
Back to top
Login to vote
user658

External


Since: Aug 26, 2003
Posts: 1525



(Msg. 6) Posted: Thu Jun 03, 2004 8:19 pm
Post subject: Re: sql database access from windows 2003 webedition [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Thu, 03 Jun 2004 16:47:56 +0100, Paul Lynch <paul.lynch.TakeThisOut@nospam.com>
wrote:

 >On Thu, 3 Jun 2004 08:43:21 -0600, "Christian Ormstrup"
 ><cormstrup.TakeThisOut@tmi-canada.com> wrote:
 >
  >>We have a web server that is set up in the DMZ of our firewall.
  >>It of course is on a seperate subnet from the internal SQL server.
  >>Our network is Windows 2000 with active directory.
  >>The web server is windows 2003 web edition.
  >>
  >>We are having trouble getting the ASP.net web application to authenticate or
  >>establish it's connection string to the SQL server and associated databases.
  >>We had it working when the server was setup temporarily on a XP desk top
  >>with IIS.(it was a little inconsistent)Now that it is installed on a 2003
  >>web edition server, it will not establish a connection to the database.Nic
  >>settings the same as working XP setup. Firewall settings the same. Maybe
  >>2003 has different default setting or will not handle SQL the same.
  >>Webserver is correct in DNS and WINS.
  >>
  >>Does anyone know how to resolve this issue?
 >
 >What happens when it won't connect ? Any error messages, etc ?
 >
 >Try this KB article to start with :
 >
 >How to troubleshoot connectivity issues in SQL Server 2000
 >http://support.microsoft.com/?id=827422

Also this one:

HOWTO: IIS and SQL Server on Separate Machines with Trusted
Connection:
<a style='text-decoration: underline;' href="http://support.microsoft.com/default.aspx?scid=kb;en-us;q176379" target="_blank">http://support.microsoft.com/default.aspx?scid=kb;en-us;q176379</a>

Jeff<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: sql database access from windows 2003 webedition 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Accessing an Access database on a Novell server from a Win.. - Hi, I've a problem and I guess it has something to do with IIS security. I've created an ASP which connects (from a win2k server) to an Access database on a NOVELL server. Every time the script results in an 80004005 Disk or Network error on the line..

I can't write data to an access database in a webfolder of.. - Hi there, The Problem: I can't write data to an access database in a webfolder of a windows Prof 2000 machine, whereas the same web application runs fine under Windows XP. I looked into the windows security setting for the database and found that is set...

Database Access - We are using IIS 5.0 on the dmz port of our firewall. Our data via odbc (visual foxpro) is on the trusted side of the firewall. We are unable to access our data . We get an error "ODBC Visual FoxPro Driver]Cannot open file" Thanks, Gary...

cannot access database - i am having truoble with the asp page when i try to access the database which i have accessed many times before. the database is access 97 and i am using the jet 4 engine to access it, but for some reason it is now giving me an error message when i....

IIS Frontpage extensions over UNC shares with Win2003 WebE.. - Hi, Does anyone know why it's not possible to install frontpage extensions on an IIS virtual server (using 2003 Web Edition) if the backend storage is a UNC share? I've got it working ok using two std. edition servers but web edition just wont play ball...
   Web Hosting and Web Master Forums (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]