[WORKED] MSDE sp4 installation+osql connect

ok yesterday i crunched my head against the wall, after trying MSDE
installation (MSDE rel.A and MSDE SP4) on a brand new WXPPSP2 laptop.
Today it worked, in this way:
#Prerequisites
1.removed any MSDE installation (control panel > Remove Applications)
2.removed any MSDE directory (eg. "C:\programmi\Microsoft SQL Server") and
subdirs
3.removed any MSSQL regKey (Regedit.exe > HKLM\Software\Microsoft, keys
named "Microsoft SQL Server" or "MSDE", i browsed by intuition)
#Installation
i used following installation parameters:
BLANKSAPWD=1 (testing purposes only, next i'll check SAPWD="strongpwd")
INSTANCENAME ="theinstance"
DATADIR = "c:\Program Files\Microsoft SQL Server\MSSQL$theinstance\data\"
(notice the final backslash)
/L*v "C:\msde.log"
#Connection
$ osql -S (local)\theinstance -E
using -U sa with no input as password i get the error "Access denied for
"sa" user. Reason: not associated with a trusted SQL Server connection"
since i installed with blank sa pwd. (In theory sa should gain access with
no password specified)
actually, if you install MSDE without specificating the authentication mode,
the installation sets the login authentication to Windows authentication
mode, not the integrated one, hence you cannot access with builtin users
login.
See http://support.microsoft.com/default...;EN-US;Q285097
for further infos.

> #Connection
> $ osql -S (local)\theinstance -E
> using -U sa with no input as password i get the error "Access denied for
> "sa" user. Reason: not associated with a trusted SQL Server connection"
> since i installed with blank sa pwd. (In theory sa should gain access with
> no password specified)

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for us

We changed from sql 7 to 2000, crissis mode.
One use with a laptop keeps getting the error when connecting to the sql
server.
SQL 2000 latest, mixed mode.
Laptop xp pro latest, mdac is latest.
I looked up sql server 26000 and 18452. I was not able to resolve the
problem. Still an untrusted connection.
I do know it is in the user profile but what?
Hi Brian,
Just to be sure, you have some machines working and one particular machine
(the laptop) is not working, right? Are you using Named Pipes or TCP-IP? Is
the laptop using a trusted connection or SQL Server security mode? What was
the exact text of the error message? What things have you tried that did not
resolve the problem?
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
"BrianMultiLanguage" <BrianMultiLanguage@.discussions.microsoft.com> wrote in
message news:3D81F886-58B5-4C09-AA8A-1529B54CE72B@.microsoft.com...
> We changed from sql 7 to 2000, crissis mode.
> One use with a laptop keeps getting the error when connecting to the sql
> server.
> SQL 2000 latest, mixed mode.
> Laptop xp pro latest, mdac is latest.
> I looked up sql server 26000 and 18452. I was not able to resolve the
> problem. Still an untrusted connection.
> I do know it is in the user profile but what?