[nastava:2003] - Re: Baze by "Damjan S. Vujnovic" <damjan@galeb.etf.bg.ac.yu>

Zarko Acimovic wrote:
> Hvala Vojo, sad radi !!!
>  
> Uglavnom izvodio sam neke egzibicije na racunaru pa sam uninstalirao SQL 
> Sevre 7.0 i sad kad ponovo zelim da ga instaliram, pri samom kraju 
> instalacije dobijam sledece poruke:
>  
> Starting Service...
> Connecting to Server...
> Connection Failed - Retrying
>  
> Setup failed to configure server. Refer to sever error logs and 
> cnfgsvr.out for more info.
>  
> Kada otvorim  cnfgsvr.out pise sledece:
> Starting Service ...
>  
> Connecting to Server ...
>  
> driver={sql server};server=USER;UID=sa;PWD=;database=master
>  
> [Microsoft][ODBC SQL Server Driver]Client unable to establish connection
>  
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen 
> (CreateFile()).
>  
> driver={sql server};server=USER;UID=sa;PWD=;database=master
>  
> [Microsoft][ODBC SQL Server Driver]Client unable to establish connection
>  
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen 
> (CreateFile()).
>  
> driver={sql server};server=.;UID=sa;PWD=;database=master
>  
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not 
> found.
>  
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen 
> (CreateFile()).
>  
> SQL Server configuration failed.
>  
>  
> Da li neko ima ideju sta treba ispraviti?
> Hvala,
> Zare

Zasto koristis named pipies a ne TCP/IP kao protokol za povezivanje?

Podesi da se na bazu povezuje preko TCP/IP-a, a ne preko named pipes. Ja 
sam malo zardjao kada je SQL Server 7 u pitanju, kod SQL Servera 2000 
ima Server Network Utility i tu podesis da ti jedini enabled protocol 
bude TCP/IP. Tamo odakle administriras taj SQL Server (odakle pokreces 
Enterprise Manager), tj na klijentskoj strani, pokrenes Client Network 
Utility i opet podesis da ti TCP/IP bude jedini enabled protocol.

Ako imaš firewall, vodis racuna da dozvolis saobracaj preko porta 1433 
(ili koji si vec podesio)...

Pozdrav,
Damjan S. Vujnovic