Shankar, Thanks for your response. I did some testing an determined that TCP/IP was enabled, I guess I just assumed that the instance name was required, and never tested that.
This is working now. It seems that the port number is assigned to each individual instance name, and in my setup 1433 port pointed to the SQLExpress instance. I'll close the other JIRA Ticket for WSAS. -----Original Message----- From: Selvaratnam Uthaiyashankar [mailto:[email protected]] Sent: Monday, April 20, 2009 11:50 PM To: [email protected] Subject: Re: SQL Express db config for PHP hi, <server>127.0.0.1,1433</server> this should work for express version as well. can you check whether mssql express is listening on that port? regards, shankar On Tue, Apr 21, 2009 at 1:48 AM, Ben Dewey <[email protected]> wrote: > I was able to get the PHP version of ST up and running using the WAMP > Server. > > I had some trouble getting the server connection working with my version of > MS SQL Express 2008 which uses a named instance of \SQLExpress. > > <server>127.0.0.1,1433</server> # default > > <server>127.0.0.1\SQLExpress,1433</server> # timeout > <server>127.0.0.1:1433\SQLExpress</server> # timeout > <server>localhost\SQLExpress,1433</server> # timeout > <server>localhost:1433\SQLExpress</server> # timeout > > <server>localhost\SQLExpress</server> # success > > It might be helpful to add a note to the PHP Install Document, under the > Installing PHP -> Options Headings (1-5, 2-4, 3-2) for setting the database > server if you have an instance of SQL Express installed. > > Ben Dewey > > > -- S.Uthaiyashankar Software Architect WSO2 Inc. http://wso2.com/ - "The Open Source SOA Company"
