Novo

Forum kao aplikacija na telefonu

Dodajte forum na početni ekran i koristite ga kao aplikaciju, sa menijem na dnu ekrana.

  • 2 odgovora
  • 3.029 pregleda

Najnovija ↓

konektovanje na MSSQL2000 via PHP 15.02.2006. u 16:22 · pre 252 meseca #1
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?


Re: konektovanje na MSSQL2000 via PHP 15.02.2006. u 17:14 · pre 252 meseca #2
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?! :)
Potpis
=========
Uporedi cene i karakteristike za vise od 10.000 proizvoda, izmedju ostalog:
Digitalni foto-aparati
Mobilni telefoni
Skolski pribor
=========
Re: konektovanje na MSSQL2000 via PHP 16.02.2006. u 16:18 · pre 252 meseca #3
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!
Prijavite se da biste odgovorili u ovoj temi.PrijavaRegistracija

Premeštanje teme