Yes, there is, but it will require sending user credentials (login name and password) to the server. That's why using integrated (Windows NT) security is the preferred option.
Either way, you'd have to create a login (to access the server, i.e. CREATE LOGIN) and bind that to a database user (to access the database; i.e. CREATE USER...FOR LOGIN).
SQL Server security is a very broad subject - consult Books Online for an overview and all the details. You can also come back here with a more specific question later.
ML
---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com