How to set up a localhost for sql server on my PC

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.
LVL 2
brgdotnetcontractorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
'localhost' Only works on the 'local host', the computer you are on.  It can not be used to access anything on another computer.

Installing SQL Server Express shouldn't be a problem on your own computer...  if they allow you to install software.  It is unlikely and probably undesirable to install it on another computer that has SQL Server 2008 that is used by everyone else.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
I don't know if I really understood your first question.
What you mean? At home you have a local installation in your PC but at work the SQL Server is installed in a remote server so when you use SSMS you need to give the target server name instead of localhost? Is that?

For your second question, the answer is yes. By default the instance name will be SERVERNAME\SQLEXPRESS.
0
brgdotnetcontractorAuthor Commented:
At home I have my own laptop, and it is a Toshiba. I have sql server 2008 installed on it. It accesses my local hard drive.

I have a HP laptop at work and it has sql server installed, but the databases are located on other servers, and when I start query analyzer, the database I chose is located on a remote server.

So for my work HP laptop, I access databases located on remote servers using Query Analyzer.
So my question is: How do I set up my Sql server on my HP laptop, so that I can have a local
database on my local C: drive that I can access using query analyzer?
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Dave BaldwinFixer of ProblemsCommented:
it has sql server installed, but the databases are located on other servers
I don't think it works that way.  I'm pretty sure the server has to be where the database files are.  You can connect to a remote server without an SQL Server being installed on your local machine.

As fro actually having it installed on your local machine, just download SQL Server Express and install it.  I recomment you get the version that includes SSMS (SQL Server Management Studio).  You can connect to any database you have a login for with SMSS, local or remote.
0
brgdotnetcontractorAuthor Commented:
Well I would have to disagree with your conclusion Dave. A few years ago, I worked for a company and I was able to have a local database on my C:\ drive, and also be able to access remote sql servers on the companies servers using SQL server 2008 management studio. Typically for your own machine the username is "sa" account. Anyway it can be done.
One other person who replied to my post noted that having the full version of sql server 2008 and the Express version on my machine at the same time might not be such a great idea.
0
Dave BaldwinFixer of ProblemsCommented:
True for SQL Server Management Studio which I have on a couple machines here... but it is not the SQL Server itself, it is a utility program.
0
brgdotnetcontractorAuthor Commented:
Hi Dave, which utility program are you referring to?
0
Dave BaldwinFixer of ProblemsCommented:
SSMS, SQL Server Management Studio.  It is a utility program.  It is not the SQL Server program.

The SQL Server program does not appear on the desktop.  It only runs as a service as do all the other SQL server type programs like MySQL, Oracle and PostGreSQL.  They all require external programs to access them.  On my computer there are two services that are the actual interfaces to MS SQL Server, 'sqlwriter.exe' and 'sqlbrowser.exe'.  'sqlbrowser.exe' is used to connect to 'named instances' on port 1434.
0
brgdotnetcontractorAuthor Commented:
Ok, thanks Dave. I am still confused as to why I am not able to have sql server point to a local database on my c drive. Typically this involves use of an sa account.
0
Dave BaldwinFixer of ProblemsCommented:
From what you have said so far, I do not think you actually have SQL Server installed on your own work machine.  The 'sa' account is not necessary for that.  In SSMS, you can select any server on your network by clicking on the down arrow on the server selection.  You can even ask it to browse the network to find installed instances that are not listed.  Here's a pic of the SSMS login window on this machine.
SSMS login window
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
So for my work HP laptop, I access databases located on remote servers using Query Analyzer.
Query Analyzer it's a tool for SQL Server 7 and 2000. You can't access recent versions of SQL Server with Query Analyzer. You'll need SSMS.
Do you have SSMS in you work laptop?
0
brgdotnetcontractorAuthor Commented:
Yes Vitor, I have SSMS installed on my work laptop?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Can you post a screen shot on how are you trying to connect to SQL Server? Something similar as Dave posted.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.