I have produced an asp.net application, and it's time for me to look to installing it at my clients site.
The application uses MS SQL. I have a redistribution license for MSDE 2000. So I have spent all morning ( :-( ) trying to work out how I can distribute it.
I have worked out how to install MSDE, however I can't find any information on:
1. How to connect to the MSDE instance (both for admin and through the asp.net pages).
2. What tools I can use to add/import a database to the MSDE instance.
3. If there is a way to create a distribution package other than using Visual Studio (which I don't have)
I have named the instance WENS, I set the password to XXXXX (not that)
I have worked out how to start the service by opening the service manager. However there are no admin tools provided, and when I use the MS SQL admin tools I can't connect, it doesn't accept the user account
So, basically, any help you can give me would be fantastic, I'm at a loose end, lol.
Thanks a lot for your help.
(Tools I have at my disposal, web matrix, MS SQL Enterprise Edition, MSDE, and I'll download anything that will help (and is legal to use) )