dbTalk Databases Forums  

Attach database to SQL server express

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss Attach database to SQL server express in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Qin Yang
 
Posts: n/a

Default Attach database to SQL server express - 07-29-2010 , 01:19 AM






Hi,

I try attach database to SQL Server express. I got the following error.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click:
http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

------------------------------

CREATE FILE encountered operating system error 1346(Either a required
impersonation level was not provided, or the provided impersonation level is
invalid.) while attempting to open or create the physical file
'D:\WebAppts.mdf'. (Microsoft SQL Server, Error: 5123)

For help, click:
http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476

Thanks in advance.
Qin.

Reply With Quote
  #2  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Attach database to SQL server express - 07-29-2010 , 03:42 AM






Qin Yang (QinYang (AT) clinicalcomputers (DOT) com.au) writes:
Quote:
CREATE FILE encountered operating system error 1346(Either a required
impersonation level was not provided, or the provided impersonation
level is invalid.) while attempting to open or create the physical file
'D:\WebAppts.mdf'. (Microsoft SQL Server, Error: 5123)
That's one I've never seen before.

I found this in Books Online:

When you are detaching or attaching a database, the Database Engine tries
to impersonate the Windows account of the connection performing the
operation to guarantee that the account has permission to access the
database and log files. For mixed security accounts that use SQL Server
logins, the impersonation might fail.

I don't really know what is going on, but there might be some issue with
your Windows account.

How are you logged into SQL Server: Windows authentication or SQL
authentication?

Are you in a workgroup or a domain?

What is the service account for SQL Server? Does the service account have
Windows permission to impersonate you?

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Reply With Quote
  #3  
Old   
Kuldeep
 
Posts: n/a

Default RE: Attach database to SQL server express - 08-03-2010 , 02:17 AM



Start your SQL Server services from services.msc
Go to start menu.
run.
type services.msc
search for SQL SERVER (.......) just right click it and start.


"Qin Yang" wrote:

Quote:
Hi,

I try attach database to SQL Server express. I got the following error.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click:
http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

------------------------------

CREATE FILE encountered operating system error 1346(Either a required
impersonation level was not provided, or the provided impersonation level is
invalid.) while attempting to open or create the physical file
'D:\WebAppts.mdf'. (Microsoft SQL Server, Error: 5123)

For help, click:
http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476

Thanks in advance.
Qin.


.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.