MISTAKE OF CONNECTION WITH SERVER

To Connect Use:
Set Conn = New ADODB.Connection
Conn.Open "Provider=SQLOLEDB.1;Persist Security
Info=False;UID=sa;PWD=;Initial Catalog=DBSGC;Data Source=" & NomeServidor
But it Happened A Mistake AND I Had to Reinstall Sql Server 2000. would like
Orientations Of How to Install Sql, mainly when he/she Asks for Himself Para
to Choose THE Type Of Autentication. I opted For the Which Exhibited THE
Administrator AND I Left Without Password! Should I Opt For the Of System?Both of those settings you can change any time.
1. For authentication: Right click the servername in your enterprise manager
(EM), click the "Security" tab, choose the correct authentication level.
2. "sa" password. Expand the servername in EM. Click the "security"
folder, click "logins", then find "sa" in the list of logins, double-click
"sa" and enter new passowrd and confirm.
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:e2QuKlNYDHA.1736@.TK2MSFTNGP10.phx.gbl...
> To Connect Use:
> Set Conn = New ADODB.Connection
> Conn.Open "Provider=SQLOLEDB.1;Persist Security
> Info=False;UID=sa;PWD=;Initial Catalog=DBSGC;Data Source=" & NomeServidor
>
> But it Happened A Mistake AND I Had to Reinstall Sql Server 2000. would
like
> Orientations Of How to Install Sql, mainly when he/she Asks for Himself
Para
> to Choose THE Type Of Autentication. I opted For the Which Exhibited THE
> Administrator AND I Left Without Password! Should I Opt For the Of System?
>
>
>