hey guys, is there is anything i need to be mindful of when installing sql server Personal edition on a pc that will be hosting asp.net applications?

any special attention to WindowsNT Authentication vs SA Login? choose both?

i had a very bad and insurmountable experience once before on this with a failed login.

while developing the application on my local machine, it ran perfectly fine, but when i put the program in a virtual directory on that very same box that i had sql server, i got the "Not Associated with a Trusted Sql Server Connection" error.

i tried every suggestion offered, but the only one i didnt try (since sql server was already installed) was the one that said to choose "both" {WindowsNT Authentication and SA authentication) when installing.
i flat out couldnt remember and there were already windows apps running on that machine so, i didnt bother uninstalling and re-installing.

Also, should i choose "Default" installation ??/
thanks again for any help or any references you can point me to
rik

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

"rik butcher" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> any special attention to WindowsNT Authentication vs SA Login? choose
> both?
>
Not really. Choose both in case you cannot implement Windows Integrated
authentication. With Windows mode, it is more secure because the
authentication is performed by the operating system with 1-way hash PW.

> while developing the application on my local machine, it ran perfectly
> fine, but when i put the program in a virtual directory on that very same
> box that i had sql > server, i got the "Not Associated with a Trusted Sql
> Server Connection" error.
>
You have to create an account inside SQL using Windows Account, example, if
your box is Windows XP, then "MachineName\ASPNET" account must be assigned
to a specific catalog in your SQL instance in order for Integrated Windows
authentication to work. (You may want to use the SQL/Enterprise Mgr. for
this).

> Also, should i choose "Default" installation ??/

Yes

*****************

John