Database permie1: jmo21 can you come here and have a look at this
jmo21: sure
DBP1: this website can get it's data fine, it uses a sql account in it's connection string, but when we login to SQL Server using that account, the login fails
jmo21: that's weird. Are you sure you are trying the correct server, and have you confirmed the sql username and password are correct.
DBP1, DatabasePermie2, SharepointPermie : YES!
jmo21: are you sure this is the correct web.config file for the website?
SPP: yes.
jmo21: change something in it to see if it fails.
SPP: {changes the username in the config, website duly throws an error}
jmo21: so the username and password is fine, are you SURE you are typing the correct username and password into the correct SQL Server login screen?
DBP1 : YES!
DBP2: hey wait it works for me
DBP1: oh, I've spelt the username wrong.
jmo21: *sigh*
jmo21: sure
DBP1: this website can get it's data fine, it uses a sql account in it's connection string, but when we login to SQL Server using that account, the login fails
jmo21: that's weird. Are you sure you are trying the correct server, and have you confirmed the sql username and password are correct.
DBP1, DatabasePermie2, SharepointPermie : YES!
jmo21: are you sure this is the correct web.config file for the website?
SPP: yes.
jmo21: change something in it to see if it fails.
SPP: {changes the username in the config, website duly throws an error}
jmo21: so the username and password is fine, are you SURE you are typing the correct username and password into the correct SQL Server login screen?
DBP1 : YES!
DBP2: hey wait it works for me
DBP1: oh, I've spelt the username wrong.
jmo21: *sigh*
Comment