mssql + PHP issue - URGENT.

[Soren Hansen]

On Mon, Apr 26, 2010 at 04:51:47PM +0100, Jamie McDonald wrote:
> Our database servers however have remained as Microsoft SQL 2008
> servers.

There's a bunch of hints on the php.net page for mssql_connect.
Specifically, this may apply:

    When you try to connect to SQL Server 2008 Express, you always have
    to name the instance you are trying to connect to, even if you
    installed SQL2008express as "Default" instance instead of named
    instance. If your instance is SQLExpress and server name is
	myServer, the server parameter must be: "myServer\SQLExpress". If
	you installed Default instance of Standard (not express) version of
	SQL2008 instead, you don't need to name the instance. To connect
    using TCP/IP, you need also to check server network configuration,
    enable TCP/IP (listen all: yes), then go to addresses tab and setup
    port 1433 in all addresses you want the server listen on (by
    default, port is blank and server don't listen).  Libraries involved
    in TCP/IP are ntwdblib.dll and dbnetlib.dll. Have fun!

Source: http://www.php.net/manual/en/function.mssql-connect.php#96134

Another comment on that page says:

    If your are trying to connect to a MSSQLServer 8 and got this error:
	Unabled to connect to: [SERVER_NAME] and u r using Server
	authentication, make sure 2 set up mssql.secure_connection to Off in
    da php.ini

    RCGP

    Making this world better everyday... peace out

Source: http://www.php.net/manual/en/function.mssql-connect.php#85783

Apologies for the poor spelling in that last one. I'm not the original
author.

I've never used MS SQL myself, so it's hard for me to tell if the above
make sense for your case. If not, try looking through the comments on
that page for hints.

-- 
Soren Hansen
Ubuntu Developer
http://www.ubuntu.com/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
URL: <https://lists.ubuntu.com/archives/ubuntu-server/attachments/20100426/a2aa4e2d/attachment.pgp>