asp.net & sql server

[rbutch]

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...

 

[WJ]

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