Unanswered: MSDE Installation Problem - very urgent
I'm facing a strange problem with MSDE. I installed MSDE 2000 in a newly formatted Window 2000 professional Machine with SP2 and IE5.5. I restarted the machine after MSDE installation. Installed my application, which creates a database. Database creation failed, I got this error "Login failed for user 'spsadmin'. Reason: Not associated with a trusted SQL
Server connection.". I tried again, this time I restarted the machine thrice after installing MSDE, then ran my setup. Database installation was through. We can't ask the end user to restart the machine these many times. Any help will be appreciated.
Thanks in advance,
I solved the problem. It was because of the authentication. In the setup the login mode was changed to 2 and it was not getting reflected as the service was running. So from the setup I stopped the service, changed the mode and started the service again, this time database had been created successfully.