Yes it's possible.
Assuming that you have a module, in the module declare a connection object. You can either use the SQL Native Provider or use the OLE DB database Provider.
An example. The server name is Tana and I have a database named WaterPro. we will be connecting to the database using a user named Manager whose password is LetItGoN0w.