[ kimistan @ 15.02.2006. 15:22 ] @
Pozdrav,

Imam na lokalu XP i apache1.3.33 i php4.3.11.Na remote imam w2003server i mssql2000.Imam script:
<?
$conn=mssql_connect("remote\instanca","sa","");
if ($conn) {
echo "Konektovan si!";
}
else {
echo "Woops ! ".mssql_get_last_message();
}

?>
Koristim PHPEditor,kada kroz njegov debuger pustim script,radi.
Ali kada probam kroz browser javlja gresku:
Warning: mssql_connect(): message: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. (severity 14) in C:\Program Files\YellowTip\Htdocs\test\~phpdesigner_output_tmp.php on line 2

Promenio sam u php.ini:
mssql.secure_connection = Off

i sve dobro konfigurisao kako pise na php.net-u.

Ne znam gde gresim,da li na w2003 treba da imam opet sve ovo sto imam na lokalu?


[ SmilieBG @ 15.02.2006. 16:14 ] @
M$ says:

There is a space after server name in the connection string:

osql -E -S "<serverName> ,1433"

Login failed for user ''. The user is not associated with a trusted SQL Server connection.

The server ERRORLOG/EventLog shows something similar to:

2005-08-11 12:46:04.29 Logon Error: 17806, Severity: 20, State: 2.
2005-08-11 12:46:04.29 Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: <IP address>]
2005-08-11 12:46:04.29 Logon Error: 18452, Severity: 14, State: 1.
2005-08-11 12:46:04.29 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: <IP address>]

Pa proveri i to :)

Poz,
Sale

PS. jesi li restartovao apache nakon promene php.ini fajla?! :)
[ kimistan @ 16.02.2006. 15:18 ] @
Pozdrav Sale,

kada otkucam poruku u cmd,ako si na to mislio dobijem:
[DBNETLIB]SQL server does not exist or access denied.
[DBNETLIB]ConnectionOpen<Connect<>>.

Restartovao sam i Apache posle promene php.ini file-a.


Hvala!