SQL server 2008 connction to a website - how is the connection made?
Posted on 2012-04-06
My company has a website that connects to SQL server 2008.
The website interface using PHP/MySQL. It is actually just a WordPress modified/customized site.
so we have:
"website" <------> SQL server.
1 - where is the connection initializes, in SQL server calling requesting the website? Or the connection code (or "string") withing the WordPress code, calling SQL server?
2- If from the website, where do you put that connection code?
If from SQL server, where do you do it in SSMS or what is the T-SQL to make the connection.
As you can see from this, I am new to the process, so please use simple English.
Thanks very much.