DTS and connection to sql server

[mooniron]

I am a novice for SQL server. I am studying with sql server on two computers. One of them is server and other is client. I creat a table named as table1. Then create a new login like login1. I tried both windows authentication and sql server authentication. But I couldn't achieve the connection from client side to server database. I think it failed because of sql server authentication failure. When I try to use sql server authentication ".. Login failed for user 'login1'. not associated with trusted sql server connection" error occures. So, MY FIRST PROBLEM IS TO ACHIVE THE CONNECTION FROM CLIENT TO SERVER ON SQL SERVER (You may offer me about making new login). Then, MY SECOND PROBLEM IS HOW TO USE DTS WIZARD. After all can you write me a sample connection string to sql server database. Thank you very much. (Also I will thank you if you know that is it possible to use DTS in Access database.)