I have a Windows 2000. When I tried to INSTALL the MSDE in order my Visual C# programs could deal with SQL databases, I got this message:
" Microsoft SQL Server Desktop Engine
A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit."
Well since I a novice both in C# programming and SQL database, I have no idea:
1) what a "strong SA password" is.
2) what a SAPWD switch is and how to set it.
I did not find any readme file specific for the MSDE installation. The one that comes with it, it is about the installation of the SQL server.
I intend to access the SQL Server as a LOCAL USER and using WINDOWS INTEGRATED SECURITY.
This is the Connection String that I use in my web.config:
<add key="ConnectionString" value="server=(local); database=MyDatabase; trusted_connection=true" />
3) So what I should do ?
I would be grateful if you could answer these three questions. Thank you.