We have a sharpoint site hosted on our company's central shaerpoint server (not MOSS). We have a MS SQL DB running on one of our local servers.
I need to coneect to this DB, so through Sharepoint Designer, I try to connect to a data source. But it always fails to connect to this DB. However, I tried the same connection through VisualStudio, just to check, and it was able to connect to the DB.
Am wondering is it because the DB is not on the same server as the shareopint, so is this because of some trust relates issues? In any ways, is connecting to the DB from the SPD as data source the only way to connect to it?
What am I doing wrong here to get the conncetion going? Any inputs appreciated.
View Complete Post