Error: 18456, Severity: 14, State: 11.

  • I get this error whenever I try to connect from my php web page

    State 11 I believe is Valid login but server access failure

    I setup a test ODBC connection on the server using the same user logon details I used in my php script and the ODBC did connect.

    I've recently moved my server from a data centre to my home, it used to work at the data centre, but now it doesn't at home.

    The php script is

    $sql = mssql_connect('Servername','user','password');

    if (!$sql) die("Could not connect");

    mssql_select_db ("database", $sql) or die("Could not open database");

    It returns from line 2 "Could not connect"

    I'm using SQL Server Express 2005

    Can anyone help on this issue?

  • By default, SQL Server Express installs as a named instance called SQLEXPRESS, so you'd have to connect to it using "Servername\SQLEXPRESS". Is that a possible explanation?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply