Setting up website Connectivity

  • During development of my Website I used an SA username and password to access my Development server SQL2000 Database. Now I am moving it to production and I know that I need to create a separate account for my webserver connection to use. I have read about machine connections, etc. is there any information out there about the most/best secure way to accomplish this?

  • You might want to visit a web development centric site, get their input on this. In general we use a sql login with the minimum access needed for all our external web apps.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply