MSDE database.

[rpal]

I am installing Full stand-alone installation for CE 9.

Setup program can install its own Microsoft Data Engine
(MSDE) database by default. I should go with default? I should first install SQL Server and make SQL server as default.

Should I choose Windows NT or SQL Server
Authentication when connecting to local database installation.

I have no experience, I hope some have experience in installation of CE 9 , could help me.

Thanks,
Raj.

 

[Guyute97]

I used the standard database. It installs MSSQL 7. If you have another DB that you prefer that will work. For ease of intergration I stuck with the default.

--Guyute

 

[rpal]

So Guyute do I need to worry about NT/SQL server authentication at any point. And in the documentation they are saying I have to create some account for ASP (Automated Process Scheduler)? Can you please explain what they mean.
Thanks,
Raj.

 

[EcofAcer]

No need to wory about NT authentication on MSDE. The install installs MSDE with the sa ID and not password. The APS will use that to log on to MSDE and keep it's info in it.