Hi all,
I've tried googling this.
I'm attempting to connect to a DB on SQL Server on a MS 2003 server box. The DB is for a different application that the office uses, and I'm not the owner of it. I'm attempting to connect without making any changes to the server side of things.
The sql server I'm attempting to connect to is set up with: "with Windows NT Authentication using the Network Login ID"
On my Linux box in PHP, I've tried using a valid Network Login ID and it's not working. I can connect to other data sources that use other login types on the same box.
I can from other boxes use MS Access and connect to the data.
Is there something special I need to do in PHP to connect to the DB?
here's some of my php code:
$con = mssql_connect('192.168.111.2', 'xxxxxxx', 'yyyyyyy');
$result = mssql_query ('select * from policyregister');
while ($row=mssql_fetch_array($result))
{ print $row[1]; }
mssql_close($numero);I think you are going to need to use SQL Server authentication for web apps. When I code ASP that is how I always do it. Which means the SQL Server might have to changed to mixed mode. Windows Authentication may not work off of the LAN. I am not 100% on this.
Hi all,
I've tried googling this.
I'm attempting to connect to a DB on SQL Server on a MS 2003 server box. The DB is for a different application that the office uses, and I'm not the owner of it. I'm attempting to connect without making any changes to the server side of things.
The sql server I'm attempting to connect to is set up with: "with Windows NT Authentication using the Network Login ID"
On my Linux box in PHP, I've tried using a valid Network Login ID and it's not working. I can connect to other data sources that use other login types on the same box.
I can from other boxes use MS Access and connect to the data.
Is there something special I need to do in PHP to connect to the DB?
here's some of my php code:
$con = mssql_connect('192.168.111.2', 'xxxxxxx', 'yyyyyyy');
$result = mssql_query ('select * from policyregister');
while ($row=mssql_fetch_array($result))
{ print $row[1]; }
mssql_close($numero);|||ahhh OK. thanks. I have a windows program that works that does a "backup" of the sql server data to mysql. Maybe I just cron job that to run once a minute since my data isnt that critical. :)
I didnt see any stuff on for PHP on SQL Server authentication for web apps.
thanks. you confirmed what I was dreading. heheh
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment