Get an error when trying to import the file.
Problem: Get an error when trying to import the file. It says the wrong name or password is being used.
Possible Solution: MSSQLServer service was running on a non-domain account which did not have access to the network. The SQL server account must have access to the location of the file. This is usually done with a share. If the Everyone group has access to the share and the error still occurs then verify the account that is running the MSSQLServer service. Open the services window and view the properties of this service. Select the Log On tab and if the service is not using the Local System account then you have to ensure that the account has rights to the domain that the file is located or move the file to the SQL server itself.