Can you try connecting with tsql ?
I have been able to connect ot mssql 2008 std edition just fine, no really
sure, but i think express has some protocols either missing or disabled by
default.
Also, you should add an entry in /etc/freetds/freetds.conf ( or the appropriate
config ) and use that entry as a connection string.
I can check the details on how i made it work tomorrow, since i am too lazy to
log to work pc right now :F
Hello all,
I've just managed to convince the management to let us run Linux boxes as our
new frontend webservers - they are ubuntu-server 9.10 boxes configured for fail
over using heartbeat and DRBD.
Our database servers however have remained as Microsoft SQL 2008 servers.
The issue I am having is that with the testing of our webserver's I cannot seem
to connect to an MS SQL 2008 Express db server, every time I get the error
"Warning : mssql_connect() [ function.mssql-connect ]: Unable to connect to
server: 192.168.1.15,1433 in /shared/var/www/oursite/inc/oursite_dbcon.php on
line 2
Could not connect to database: "
The PHP code used to connect is a standard connection string i.e.
"mssql_connect("192.168.1.15,1433","username","passw0rd") or die ("Could not
connect to database: ".mssql_get_last_message());"
The web server has has 'apt-get install php5-sybase' run on it and apache
restarted so the mssql.so object has been loaded - this is also confirmed by
its presence on the output from phpinfo();.
I have disabled the firewall on the SQL2008 server - and can see the port 1433
listening on the test sql server (my workstation) from the webserver. I am also
able to telnet to port 1433 on the SQL server from the webserver. The username
and password are also correct - I have quadruple checked this.
I've been googling all afternoon and seem to be finding conflicting information
regarding the ability of PHP to connect directly to an MSSQL database. Some
sites seem to suggest you must use a DSN via an odbc connection but other sites
suggest the old school connection string method should work fine just as you
would if using mysql. I really don't want to start modfying the developers
code, as far as I'm concerned this codebase worked fine under windows/iis so it
should run in our new Linux environment.
If anyone can give me any clarification on this issue I would be very thankful
as these servers are going to be racked this week and I do not want to have the
powers that be decide we should revert to Windows Server / IIS.
Kind Regards,
Jamie.
--
Nikolai K. Bochev
System Administrator
--
ubuntu-server mailing list
ubuntu-server@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server
More info: https://wiki.ubuntu.com/ServerTeam
