Hello.
i can't connect to SQL Server using CakePHP.
i get the following errors:
Warning (2): mssql_connect() [function.mssql-connect]: Unable to
connect: SQL Server is unavailable or does not exist. Specified SQL
server not found. (severity 9)
Warning (2): mssql_connect() [function.mssql-connect]: Unable to
connect to server: SERVER\IST1,2020 [CORE\cake\libs\model\datasources
\dbo\dbo_mssql.php, line 144]
I googled many sites offering guides to troubleshoot connectivity
issues... but none worked.
Here's my situation
- I have a pc named "SERVER" running Win 2K3 server + SQL Server 2005.
- This pc is the Domain Controller of my small LAN.
- SQL Server has a running istance named "IST1", listening on the non-
standard port 2020.
- "IST1" has both TCP/IP and Named Pipes connections enabled.
- The SQL Server istance uses SQL authentication
Cake is installed on a non-domain, WindowsXPSP3-powered PC.
This machine can:
- ping the DB server, using both name (DNS works correctly) or IP
address
- TelNet the DB server + port (i get the "black screen" response)
Every other domain-pc in LAN can access and manage data on SQL Server.
My app has the following DB setup:
class DATABASE_CONFIG {
var $default = array(
'driver' => 'mssql',
'host' => 'SERVER\IST1',
'port' => '2020',
'persistent' => false,
'login' => 'ernesto',
'password' => 'omitted',
'database' => 'ernesto_test_db',
'prefix' => 'dbo.',
);
}
Can som1 help me please?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
