Hi.
Realistically, you can use ADO for any type of DB connection (as far as I'm aware) and it's only the ConnectionString property that has to be changed to suit. Do a Google search for delphi ADO tutorials - it's very simple (relative to what you want, of course) - and just change the ConnectionString to suit your SQL Server.
I've coded applications that use Access, Paradox, Oracle, SQL Server, DataFlex, just to name a few, and they all work the same. That's the beauty of generic DB objects.
If you have any specific questions about this topic, just ask.
Good luck,
John.