How can I connect to a remote instance of SQL Server (on my VPS) from my local machine using Windows Authentication?
By default, if I try to connect using this method, the username is my computer name but this user isn't associated with the remote instance of SQL Server.
Do I have to set up my computer as a user on my VPS somehow? If this is possible, please could someone provide very simple instructions as to how I could do this as I am very much a beginner!
All help is very much appreciated.