Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

How to Attach sample db

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
Ravee123
Asked:
Ravee123
1 Solution
 
TempDBACommented:
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now