Look in the logs and see what account the web server is trying to log in
as.
Christopher Bellizzi
SQL DBA/Programmer
240 Falls Street
Seneca Falls, NY 13148
Phone: (315) 568-7886
Email: Christopher.[Email address protected]
-----Original Message-----
From: Robert Davis
[mailto:mssqldba-ezmlmshield-x23834609.[Email address protected]
Sent: Friday, January 27, 2006 5:07 PM
To: LazyDBA Discussion
Subject: RE: newbie question
What is the exact error?
Robert Davis
-----Original Message-----
From: David A Masiello
[mailto:mssqldba-ezmlmshield-x95067015.[Email address protected]
Sent: Friday, January 27, 2006 1:44 PM
To: LazyDBA Discussion
Subject: newbie question
Hello All,
I have a Webserver running Apache/PHP which connects to a stand alone
MSSQL Server.
I set up another Box with same Apache/PHP config which i need to connect
to the same MSSQL Server but it keeps refusing the db connection. The
PHP/web config files are identical more or less.
I've installed the Client Network Utility on the webserver to verify its
using PORT 1433, and the named Pipes are enabled.
Bot Boxes are Dell 1850s
Are there any reasons why the database would refuse a connection from
one webserver vs another, besides errors on the webserver side?
(....and same username/password/database names)
I just want to rule out any configuration problems on the DB side. Im
85% sure the problem resides on the Webserver, but just in case.
Thanks in advance,
Dave
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
************************************
This e-mail and any files transmitted with it are proprietary and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender. Please note that any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of ITT Industries, Inc. The recipient should check this e-mail and any attachments for the presence of viruses. ITT Industries accepts no liability for any damage caused by any virus transmitted by this e-mail.
************************************
MS Sql Server LazyDBA home page