Dot is fine....I'm in the UK 🙂
At the moment it is just connecting, I reckon I could do the restore once I am beyond that.
I'm a bit confused as to what to enter for each of the below, I have tried server name is JamesPC\James and just JamesPC (which is the name of my machine, but no luck);
Currently it is just my Azure subscription details showing to connect, which obviously won't work.
If anyone is happy to Skype and I will share my screen then that would be good.
Server type: Database Engine
Server name: JamesPC\James
Authentication: Windows Authentication
User name: N/A
If your instance of SQL Server is not listening on port 1433 then you'll need either to make sure the SQL Server Browser service is running, or specify the port number with the server name, for example "JamesPC,12345" (without the inverted commas). And, as Beatrix suggested, check that you do indeed have a SQL Server instance called James and that it's actually running. If it still doesn't work, please post the exact error message. You can also look in the errorlog file, which will tell you why authentication failed (assuming that you get past connection and on to authentication - the error message returned to user contains little information, in order not to help attackers).