I got some problem .. The User want to Key-In the MSDE sa Password Manually when Install the MSDE. Have any Idea ?
This is a ready-only archive of the InstallSite Forum. You cannot post any new content here. / Dies ist ein Archiv des InstallSite Forums. Hier können keine neuen Beiträge veröffentlicht werden.
How to let user KeyIn the MSDE sa Passwords?
Started by
Lee Koh Ching
, Jul 13 2007 09:19
2 replies to this topic
Lee Koh Ching
-
- Full Members
- 17 posts
Posted 13 July 2007 - 09:19
I got some problem .. The User want to Key-In the MSDE sa Password Manually when Install the MSDE. Have any Idea ?
Bobtcny
-
- Full Members
- 9 posts
Posted 17 July 2007 - 14:57
How are you installling MSDE? If you are using the Installshield MSDE 2000 object, it has a sa password property that you can set. You could use AskText to get the user's input on the sa password and then set the sa password property on the object.
Quest7
-
- Full Members
- 8 posts
Posted 18 July 2007 - 21:10
What I did, and I regret, was built a custom dialog to get the password in the event the user already had MSDE 2000 installed and had a password.
I took the value and stored it, and then passed that into a batch file using %1, which installed MSDE 2000.
The problem is, when you try to repair the program, it fails and you have to manually enter the password in the batch file and run it separately.
I don't have a better solution as we've moved on to SQL Server 2005, but I thought I'd throw that out there as to how not to do it ;P
I took the value and stored it, and then passed that into a batch file using %1, which installed MSDE 2000.
The problem is, when you try to repair the program, it fails and you have to manually enter the password in the batch file and run it separately.
I don't have a better solution as we've moved on to SQL Server 2005, but I thought I'd throw that out there as to how not to do it ;P