There are two ways to publish a datasource to the Server. The first one is to click on "Server" on the Topmenu and then you go to Publish Datasource and there are both. From there you have to choose the first one and after the upload is finished you can choose the other one and upload it, too.
the second way: you simply do a right click on the Datasource you want to upload, press publish to server and follow the steps.
2. When you connect to the SQL Database and do a refresh of your Data or you use the live connection I think you are asked to enter a Password to connect. When you upload the Datasource have you embedded the Password?