[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Trying to install isolated instance of Microsoft SQL

Posted on 2004-09-16
3
Medium Priority
?
253 Views
Last Modified: 2006-11-17
Hi,

I'm a brand new user of Microsoft SQL.  

I installed MS SQL on my computer which is attached peer to peer to my boss' computer and we have some valuable data on his computer.  

Basically, I want to get an isolated version of SQL running on my computer so I can muck around with tables and not worry about deleting things.

Following is what I see on my version of SQL

>Console Root
   >Microsoft SQL Servers
      >SQL Server Group
         >Ori (Windows NT)
            >Databases
            >Data Transformation services
            >etc.

Can I just use add remove programs to remove SQL from my computer without messing up his version or data on his computer?

I tried to install a new server group and a new registration.  They seemed to appear, but they didn't have anything in them (ie. the basics like pubs, etc.)

What would you recommend I do?

Thanks,

Evan
0
Comment
Question by:EvanBrenner
  • 2
3 Comments
 

Accepted Solution

by:
onwin earned 500 total points
ID: 12079280
Probably, you are connecting to your boss's SQL server setup on his computer using the SQL Client Tools on your computer. You can use the Add/Remove programs to remove the SQL Server software on your computer without deleting any data present on the SQL Server database setup on your boss's computer.

To have a separate isolated version for yourself, you can install the SQL Server Personal Edition on your computer as a separate SQL Server and work on it and copy the database from your boss's computer onto your server and then use it.

Hope this information helps.
0
 

Author Comment

by:EvanBrenner
ID: 12079315
Yes, that seems like the best route.

Thanks!
0
 

Author Comment

by:EvanBrenner
ID: 12079327
Forgot the accept, so here it is.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question