[es] - konektovanje na MSSQL2000 via PHP

kimistan
Mihailo Stanisic
Novi Sad

Član broj: 5921
Poruke: 35
194.106.174.*

Profil

konektovanje na MSSQL2000 via PHP

^{15.02.2006. u 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?

^{15.02.2006. u 15:22}

SmilieBG
Aleksandar Skodric
NL

Član broj: 13094
Poruke: 1822
*.wxs.nl.

Profil

Re: konektovanje na MSSQL2000 via PHP

^{15.02.2006. u 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?! :)

=========
Uporedi cene i karakteristike za vise od 10.000 proizvoda, izmedju ostalog:
Digitalni foto-aparati
Mobilni telefoni
Skolski pribor
=========

^{15.02.2006. u 16:14}

kimistan
Mihailo Stanisic
Novi Sad

Član broj: 5921
Poruke: 35
195.252.94.*

Profil

Re: konektovanje na MSSQL2000 via PHP

^{16.02.2006. u 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!

^{16.02.2006. u 15:18}