IIS 7 & IIS 8
Login failed when connecting to SQLExpress 2012 DB
Last post Feb 21, 2013 03:45 PM by wfaz
Feb 21, 2013 12:16 AM|LINK
I am attempting to link IIS 8 (on 2012 DC x64) with my locally installed SQLExpress 2012 installation. I know I have entered the correct server name and database as it is just prompting for a password. When I enter the password of the windows account which
is linked to the database (domain\administrator), there is an error occurring which indicates a bad login (username/password error). I have also tried with the SA account and the same error occurs.
Is there anything obvious I am missing? Perhaps some mis-configuration in SQLExpress?
Any help would be appreciated
Feb 21, 2013 06:57 AM|LINK
Have you try to reset your password? Could you please kindly check that the SQL services is start?
Feb 21, 2013 03:45 PM|LINK
Thanks for your quick reply
The service is definitely running as it does not throw a connection error, and it prompts for credentials (password). I use the administrator account for everything, the same server is a DNS, so it is getting credentials from there (windows authentication).
I can try resetting it but I use the password all the time and it is problem free.