Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

How to Attach sample db

Posted on 2012-03-22
1
250 Views
Last Modified: 2012-04-05
In my desktop, client already installed SQL Server 2008 R2 and working with Database Engine and Analysis Server.

When I try to attach sample db (sample files from Microsoft Press's SQL Server 2008 MDX Step By Step, ) for my self practice, it says i have no access / permission.

I want to practice and do some testing for my own learning purpose. For this, it should not connect with client's database/server.

Let me know how to manifest this.

Is there any alternate ways ?

Regards
Rave
0
Comment
Question by:Ravee123
1 Comment
 
LVL 25

Accepted Solution

by:
TempDBA earned 500 total points
ID: 37753569
You should be having dbcreator role assigned to your login. Or you can also ask for sysadmin if you want to do some other task.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

856 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