SQL Server

I'm a bit of a noob on the whole enterprise manager thing.

I got my ASP connection string:

strCon = "Provider=SQLOLEDB;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"

Works fine on another machine.  Now I installed SQL Server on another machine.

Server users windows authentication.
Database I want to use has a new user 'Gullanian'.  I set the password and all, but when I put the username and pw in the connection string it gives me an unspecified error, I'm guessing some permissions or invalid login whatever.  I right clicked my Gullanian user and checked every box I could find, but it still doesn't work!

Can someone step me through how to create a new user and what to put in my connection string?  Can't figure it out.

First of all don't check all the roles boxes, as some are like db_denyread which will prevent your script from reading data. Uncheck the boxes like that and try again

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'STUDY\IUSR_STUDY'.
/wdfinal/includes/common.asp, line 28

Did I mess the permissions up at all?

You just need to add STUDY\IUSR_STUDY as a new user on that server/database