SQl Server Connection Settings

Hi all,





I am a newbie to .NET and MS SQL server. I am trying to connect to sql server d/b from my application files.





How should i open a connection from my system pc5 (where application/proj being developed) to SQL serevr which is installed on my server(server1). Both are in network.





I have installed sql client on my system(pc5) and created my d/b (MyDB) thru EM, now how can i create username & password for MyDB datbase.





I had installed ASP.NET Commerce server(from ASP.NEt site) on my system pc5 its working fine with accessing Commerce d/b from server1. I observed the string in web.config file of commerce application it is as follows.





<add key="ConnectionString" value="server=server1;database=Commerce;uid=CommerceUser;pwd=CommerceUser;" />








In the same way can i create Username and passsword for MyDB database, if so how should i do that. that should look like some thing like this..





<add key="ConnectionString" value="server=server1;database=MyDB;uid=MyDBUser;pwd=MyDBpass;" />


to do in this way i need to create username and pw for MyDB . How should i create username ansd pw for MYDB datase.





Pls help me out.





Thanks in adv


Kumar