2. PHPRunner General questions
  3. Problem connecting with SQL2005
This topic is locked

Problem connecting with SQL2005

 		4/15/2009 4:01:24 AM
PHPRunner General questions
R
 Ravengaard author

Hi, I am experiencing some difficulties connecting PHPRunner with SQL Server 2005.

I am using hostname HOSTNAME/SQLEXPRESS as host, also tried numeric IP.

I am getting bounced from the login with the error code: SQL Error State:28000 Native Error Code: 4814. It also states that the user is not trusted.

I have set the SQL Server to login with the "Local System" setting, which should mean that the local system administrator should be allowed to connect, right?
I have dug around a bit, does PHPRunner support trusted connections?

Also, I have tried putting the SQL Server in "mixed mode" (Both Windows Auth and SQL Login) without any results.
Thanks in advance.
Sergey Kornilov admin 4/15/2009

You need to use SQL Server authorization on connection screen.
Generated PHP application won't work if you trusted connection.
R
 		Ravengaard author 4/16/2009

Yes, just realized that this morning after reinstalling the SQL Server. Thank you for you swift reply.