Setup.exe /qb+ INSTANCENAME=newsdb_engine DISABLENETWORKPROTOCOLS=1 SAPWD=dotNet
I then installed WebDataAdmin using all of the defaults.
I opened WebDataAdmin and at the login entered these credentials:
Username: sa
Password: dotNet
Server: newsdb_engine
Each time the error is returned that the username or password is invalid and/or the server does not exist.
So I tried a different server name, adding the computer name:
Server: AZT12YXM/newsdb_engine
Same error message occurred.
Then I read that SQL Authentication mode has to have the correct registry setting.
I went to HKLM/Microsoft/MSSqlServer/MSSqlServer/ and changed the login from "1" to "0"
and rebooted.
Same error message occurred.
I do have a developer edition of SqlServer 2000, but I want to be able to install msde and configure it without enterprise tools so that msde is the sole database engine (for deployment reasons).
Could someone suggest a list of steps from start to finish for installing msde on a machine where the instance you create is the sole database on the target machine and how to configure it to be Web Data Administrator "friendly"?
Maybe this could be the "one-stop" Web Data Admin keyword search thread.
Thank you.The servername should be: MachineName\InstanceName
Cheers
Ken
No comments:
Post a Comment