Followed the install notes and everything seems to be working as it should but I can't connect to the DB.

I do see pdo_sqlsrv in my php extensions.

During the web installer I do see the:

Microsoft SQL Server radio button during install.

I've create a database named drupal. I specify database name as:
"drupal"
Is this the correct ?

username as:
"username"

and password appropriately.

But I am unable to connect to the DB. Any notes?

Comments

Norberto Ostallo’s picture

Norberto Ostallo commented

I had the same problem. Is your server authentication set in mixed mode ("SQL Server and WIndows authentication")?
Follow this tutorial:
http://support.webecs.com/KB/a374/how-do-i-configure-sql-server-express-to-enable-mixed.aspx

pinoyweb’s picture

pinoyweb commented

If you are connecting using Windows authentication, please ensure that your web server's service account has a corresponding SQL Server login account. Make sure that the SQL Server login account has a corresponding user account in your Drupal database. Please also ensure that you are using Mixed Mode Authentication.

david_garcia’s picture

david_garcia commented
Issue summary: View changes
Status: Active » Closed (fixed)

Always make sure that you can connect from your WebServer with SQL Server Management studio using the same configuration that you set up in Drupal.