Newbie To The Server Side - Connection String Question

Hi -

I am an SQL user from the development side, this is the first time I have been tasked to set up SQL Server. So far so good, although I'm having some issues finding the information I am normally familiar with to build a connection string to our database server.

1) We are on a dedicated server with a hosting company. They did not provide us with a licence for SQL Server 2005, so we had to install SQL Server 2005 Express. So far everything is going well, I have:

- gone through the proceedure to enable remote access to the database

- installed the Northwind test database

- installed msSQL Server Management Studio express, and I can see the db components.

I usually use Enterprise Manager to connect to and construct/manage my databases - however I am usually provided the connection string information.

- I have the database set to Windows Authentication Mode.

So my questions -

1. What is the connection string format to use (with .asp)? i usually use the following:

"Provider=SQLOLEDB;Data Source=DATABASEADDRESS;Database=DATABASENAME;User Id=USER;Password=PASSWORD;"

2. How do I find my server name? currently, in the database manager it shows as "WDC202SQLEXPRESS (SQL SERVER 9.0.2047 - WDC202USERNAME)" - where USERNAME is our current username. The system Databases and Northwind are listed below.

When i try to register using the above format connection string with Enterprise Manager, I get the connection not found or login. so my last question -

3. When i am setting up my connection string, should i be using the same user/pass set that logs me into the server - i am assuming this is the Windows Authentication credentials Ive set in the Server install.

Any help would be very much appreciated.

Thanks!
eric@thatsprettyhip.com