Solved

How to Attach sample db

Posted on 2012-03-22
1
255 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
[X]
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
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.

688 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