adodb connection string for SQL Server

Does anybody have the connection string for ADODB to connect to SQL Server.

What I have so far is
strConnect = "Provider=SQLOLEDB;
Data source= I am not sure if this is the server name;
Initial Catalog = Name of the database;
User Id = Is this supposed to be sa or sysadm;
Password= mypassword;

thanks for your help
Joel