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)
No comments:
Post a Comment