If there is someone administrating the SQL Server/network, you should ask
him/her for the information needed to connect to an SQL Server database.
Basically, if the SQL server uses Windows security, you need to know the SQL
Server instance name (if it is default instance, that will be the computer
name where the SQL Server installed), and the database name. If the SQL
Server is configured to allow remote access and your windows user account
has the permission to access the SQL Server/database, then you should not
have difficutyies to follow the Migration assistnace. If the SQL Server uses
mixed secuirty mode, you can, instead, ask a username/password pair from the
administrator.
OTH, since you are to migrate your Access database to SQL Server database,
it is strongly recommended to do your due study on SQL Server before
migrating, after all, SQL Server is a very complicated server software
package.