Re: MS SQL server problem

[Joshua Benner]

I ran into problems similar to this when I had PHP executing as an unprivileged user. Otherwise, I'd write a little test script for connecting to the db, and google for others having problems connecting PHP to MSSQL. Langdon Stevenson wrote: Hi I have a Cake app that has been running happily on MS SQL Server for over a year. Today I made some minor changes to some views and some time after building the changes to the test machine I started getting the following errors: Warning: mssql_pconnect(): Unable to connect to server: 192.168.8.53\ in c:\inetpub\wwwroot\cake\libs\model\dbo\dbo_mssql.php on line 138 Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in c:\inetpub\wwwroot\cake\libs\model\dbo\dbo_mssql.php on line 140 Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in c:\inetpub\wwwroot\cake\libs\model\dbo\dbo_mssql.php on line 162 I believe that this started before I updated the cake directory to version 1.1.16. Watching the SQL Server I can see that PHP isn't even getting a connection to it. The web server (IIS) and the application are on the same physical machine as the database. I have tested the login and database credentials via SQL Manager and they work fine, so I don't believe that configuration is the issue. I am stumped. Not sure how to trouble shoot this one, so I would welcome any suggestions that anyone may have. Regards, Langdon --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---