Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.

konektovanje na MSSQL2000 via PHP

[es] :: PHP :: konektovanje na MSSQL2000 via PHP

[ Pregleda: 2370 | Odgovora: 2 ] > FB > Twit

Postavi temu Odgovori

Autor

Pretraga teme: Traži
Markiranje Štampanje RSS

kimistan
Mihailo Stanisic
Novi Sad

Član broj: 5921
Poruke: 36
194.106.174.*



Profil

icon konektovanje na MSSQL2000 via PHP15.02.2006. u 15:22 - pre 221 meseci
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?


 
Odgovor na temu

SmilieBG
Aleksandar Skodric
NL

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



+3 Profil

icon Re: konektovanje na MSSQL2000 via PHP15.02.2006. u 16:14 - pre 221 meseci
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
=========
 
Odgovor na temu

kimistan
Mihailo Stanisic
Novi Sad

Član broj: 5921
Poruke: 36
195.252.94.*



Profil

icon Re: konektovanje na MSSQL2000 via PHP16.02.2006. u 15:18 - pre 221 meseci
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!
 
Odgovor na temu

[es] :: PHP :: konektovanje na MSSQL2000 via PHP

[ Pregleda: 2370 | Odgovora: 2 ] > FB > Twit

Postavi temu Odgovori

Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.