Database版 - fixed：PHP IIS SQL2012, connection through NT authenticatio |
|---|
|
|
|
|
|
|
n********6
发帖数: 1511 | 1 --Fixed---
It's more on IIS configuration.
set impersonate = 0 in php.ini
set network service in application pool.
set username & pwd blank in php page.
-----Problem------------
I can use the 'WebAppDBConn' user in Studio, but failed in web.
Internal Server Error CDbConnection failed to open the DB connection. An
internal error occurred while the Web server was processing your request.
Please contact the webmaster to report this problem.
Thank you.
Connection String failed:
$databasetype = 'odbc_mssql';
$databaselocation = 'localhost';
$databasename = 'MyDatabase';
$databaseuser = 'ServerName\WebAppDBConn';
$databasepass = 'MyPassword';
Connection String succeed:
$databasetype = 'odbc_mssql';
$databaselocation = 'localhost';
$databasename = 'MyDatabase';
$databaseuser = 'sa';
$databasepass = 'MyPassword';
Connection String succeed:
$databasetype = 'odbc_mssql';
$databaselocation = 'localhost';
$databasename = 'MyDatabase';
$databaseuser = 'UserInSQLAuthentication';
$databasepass = 'MyPassword'; | u*********e
发帖数: 9616 | 2 what's your connection string? | B*****g
发帖数: 34098 | 3 http://www.mitbbs.com/article/WashingtonDC/31551549_0.html
request.
【在 n********6 的大作中提到】
: --Fixed---
: It's more on IIS configuration.
: set impersonate = 0 in php.ini
: set network service in application pool.
: set username & pwd blank in php page.
: -----Problem------------
: I can use the 'WebAppDBConn' user in Studio, but failed in web.
: Internal Server Error CDbConnection failed to open the DB connection. An
: internal error occurred while the Web server was processing your request.
: Please contact the webmaster to report this problem.
|
|
|
|
|
|
|
|
