Step 4Ĭhoose a data source for the data you want to import from the drop down. The SQL Server Import and Export Wizard will open. Right-click on your database and select Tasks then Import Data from the menu. Open SQL Server Management Studio and connect to your database. A copy of SQL Server Management Studio Express.A Database user How Do I Change the Owner Password for My Database?.How do I add a MSSQL database to my account? A Fasthosts account that contains an MSSQL database.