MSDE 2000: Authentication failed despite BLANKSAPWD
From: Stefan M. Huber (looseleaf_at_gmx.net)
Date: 10/28/04
- Next message: Andrea Montanari: "Re: Is using linked server with MSDE the way to go for this problem?"
- Previous message: Rick Pinson: "Is using linked server with MSDE the way to go for this problem?"
- Next in thread: Stefan M. Huber: "Re: MSDE 2000: Authentication failed despite BLANKSAPWD"
- Reply: Stefan M. Huber: "Re: MSDE 2000: Authentication failed despite BLANKSAPWD"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 28 Oct 2004 10:31:15 +0200
Hi!
We're having troubles on a Windows 2003 Server. MSDE 1.0 does not
install (even though we already have this setup at other customers).
So I downloaded MSDE 2000. Unfortunately, somebody else just executed the
installation procedure without setup-parameters. I wanted to have an empty
password (I know, I know. But it is a closed system) and I need SQL
security mode and network protocols.
Thus I uninstalled MSDE 2000 again and launched setup.exe this way:
setup DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL BLANKSAPWD=1
The installation went fine and I did *no* receive the error about the
trusted connections. However, I received "Authentication for user sa
failed" when simply doing this
osql -Usa -P -dmaster
Any clues?
Stefan
- Next message: Andrea Montanari: "Re: Is using linked server with MSDE the way to go for this problem?"
- Previous message: Rick Pinson: "Is using linked server with MSDE the way to go for this problem?"
- Next in thread: Stefan M. Huber: "Re: MSDE 2000: Authentication failed despite BLANKSAPWD"
- Reply: Stefan M. Huber: "Re: MSDE 2000: Authentication failed despite BLANKSAPWD"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
