How do I make the connection from SQL server to my webserver where my database is sitting on one computer and my IIS server is sitting on another? I figure I have to create a system DSN entry on the webserver that points to the SQL server but I can't seem to make the connection? Do I have to use tcp/ip or will named pipes work? Should I be creating the DSN on the computer with the database rather than the computer running the webserver?
Thanks,
Aaron
Thanks,
Aaron