[Cialug] php/mssql connection issues

[Dave J. Hala Jr.]

Here's something I googled that might be useful:


There seems to be a repeating thread online that relates to this
problem, and it could be found here:
http://www.developersdex.com/sql/message.asp?p=1925&ID=%3CE21CE687-93FB-4908-95F0-E67D5D9075C7%40microsoft.com%3E

Possible issues are:
1. Remote connections not enabled on the SQL server (probably does not
apply to you).
2. Most likely- the machine is not a member of the domain, or is not
being recognized as a domain member. As a result, the user name
forwarded to the server arrives to the server itself as null. 

Note: The fact that you are able to register the server on your machine
does not imply that you will be able to connect to it. Depending on how
you registered the server, the user does not necessarily log into the
server upon server registration.

See if you can communicate with the PDC of the domain, or if other
computers on the domain can see your workstation. This will allow you to
identify whether the issue is indeed #2 mentioned above.

This may also apply:

http://support.microsoft.com/kb/164167

On Tue, 2006-10-31 at 08:25, Laith Preston wrote:
> Login failed for user '-------------'. The user is not associated with a 
> trusted SQL Server connection. (severity 14) in
> 
> Dave J. Hala Jr. wrote:
> > Try doing:
> >
> >  $db = mssql_connect($host,$user,$pass) or die (mysql_error());
> >
> > This should return the error message. That will give you a good place to
> > starting looking.
> >
> >
> >
> >
> > On Mon, 2006-10-30 at 16:51, Laith Preston wrote:
> >   
> >> I am having a problem connecting to an MSSQL server from php on a IIS 
> >> installation. I know... I know... project requirements.
> >>
> >> anyway
> >> If I connect to an named DSN using the odbc connection functions it 
> >> works, but if I try to connect to it using the mssql functions it fails, 
> >> I am uncertain if the client will allow for use of the odbc
> >>
> >> $db  =  mssql_connect($db_host,$db_user,$db_pass);
> >>
> >> $db2    = odbc_connect($db_dsn,$db_user,$db_pass);
> >>
> >>
> >> any thoughts?
> >>
> >> Thanks
> >> Lathrop
> >>
> >> _______________________________________________
> >> Cialug mailing list
> >> Cialug at cialug.org
> >> http://cialug.org/mailman/listinfo/cialug
> >>     
> 
> 
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
-- 

Open Source Information Systems, Inc. (OSIS)
Dave J. Hala Jr., President <dave at osis.us>
641.485.1606