April 25, 2010 at 3:49 am
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?
April 26, 2010 at 4:40 am
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