On my home Laptop, my SQL server is setup on my local hard drive, and I can created databases locally and access Query analyzer management studio. However at work, my Sql server does not have a local host account, and it only accesses databases on a target server.
I can't figure out how to use my localhost account at work. First question is "Does anyone know how I can set up a localhost account on my work pc".
Second question, can I install SQL server express next to my Sql server 2008 (On my work computer)? Because I am thinking that maybe I can just have my Sql server express access my local hard drive.