Solved

Is there access restriction to attached database?

Posted on 2014-11-09
4
47 Views
Last Modified: 2015-01-06
I attached to a database that was sent to me in form of mdf and log files.  I put these 2 files in the sql 2012 express' data folder.  I then was able to attach to the file.  It's just odd that the database would show up with name as c:\.....\its-database-name in Sql Management Studio.  It doesn't just show the database name.

I am able to open the database tables in Management Studio.

In the Security, my login, User Mapping, I can't give my self any permission except fore "Connect Sql".  

where can I enable remote connection?  I am not able to use C# code to open this database.
0
Comment
Question by:lapucca
  • 2
  • 2
4 Comments
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 40432236
What's the size of the .mdf?
You can always try to detach and attach it again. Maybe something went wrong at the first time.
0
 

Author Comment

by:lapucca
ID: 40433964
Very small database with 2 tables and less than 100 rows each.
In the Security, my login, User Mapping, I can't give my self any permission except fore "Connect Sql".  
Why this so?  Is it because this database wasn't originally created on my PC?
0
 
LVL 46

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40434454
There's no "Connect Sql" permission.
Can you post a screenshot of that, please?
0
 

Author Comment

by:lapucca
ID: 40435322
Yes, I will post the screenshot this evening.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

920 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now