Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
samjesse
Starting Member
8 Posts |
 Posted - 2009-05-14 : 01:36:46
|
| Hiunder sql2005 with windows xp pro. Databases > Attach > Add gives meTITLE: Microsoft SQL Server Management Studio Express------------------------------Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)The server principal "*****" is not able to access the database "model" under the current security context. (Microsoft SQL Server, Error: 916)how can I fix this?thanks |
|
|
PinkFloyd
Starting Member
1 Post |
Posted - 2010-02-09 : 13:43:32
|
| Hello samjesse, I'm having a similar problem trying to attach an .mdf to SQL Server on my host provider (Network Solutions).Did you ever get a response on this?Another Brick in the Wall |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-09 : 13:59:31
|
| I don't have an answer for you PinkFloyd, but I wonder if this is a scenario where making a Backup and using RESTORE would work more easily than ATTACH? |
|
|
|
vmenon
Starting Member
17 Posts |
Posted - 2010-02-11 : 06:49:45
|
| Seems to me the issue is due to lack of permissions. 1. Please can you determine what are the permissions the login account has, i.e. the account that you are using for attaching the database?2. The account that you are using might be an administrator at OS level, but that not necessarily translate to administrative privileges on the SQL instance.3. You might want to attempt connecting with administrator privileges enabled [or at least with an account that has "CREATE DATABASE" permission], to see if the attach succeeds. |
|
|
|
|
|
|
not able to attach