If you need any further information i will do my best to provide, although i am somewhat amateurish in this field right now i am willing to learn. I would really like to be able to access our SQL database from my PC! Hopefully this is possible. (Microsoft SQL Server, Error: 18456) Could anyone shed some light on this for me or let me know how i might get round this. The error message it throws up is Cannot connect to SERVER\Database. Using my 'domain\username' or simply 'username' and login details i am unable to connect. Using windows authentication clearly doesn't work, as my laptop is not part of the work domain (so my administrator at work tells me), but he cannot understand why the 'SQL Server Authentication' wont work. Basically i can work off my own laptop like it's a work laptop with no less fuctionality, but much keener and more up-to-date software and system etc :) Anyhow my issue: Using my laptop i have discovered i am unable to access the SQL server we have setup remotely. This allows me to access shared drives, outlook email, network resources (printers etc.) and some in house systems as well. Running Windows 7 i am currently able to log onto my work network with my laptop when in the office, and also remotely via a VPN connection when at home. To help do this i want to be able to access our work database from my own pc.
Hi all, Hopefully i am in the right place here and thanks in advance for anyone who can offer me any help! I am new to SQL server as it is something we are integrating into my work environment as we speak, Therefore I will be getting up to speed on how to use it over the coming weeks.