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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
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.
ASKER
Hi Dave, which utility program are you referring to?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes Vitor, I have SSMS installed on my work laptop?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?