dbTalk Databases Forums  

SQL Server 2005 can't attach database on Windows Vista

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools SQL Server 2005 can't attach database on Windows Vista

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss SQL Server 2005 can't attach database on Windows Vista in the microsoft.public.sqlserver.tools forum.



Reply
Page 1 of 19 1 2 3 4 5 6 7 8 9 10 11 > Last »
 
Thread Tools Display Modes
  #1  
Old   
Daniel Grassick
 
Posts: n/a

Default SQL Server 2005 can't attach database on Windows Vista - 04-01-2008 , 02:31 PM






I am running Windows Vista on a new Dell computer with both the Developer
and Expression versions of SQL Server 2005 installed and I am experiencing
the following problem:

1) Used modified downloaded "instnwnd.sql" script to create Northwind
database in directory "C:\DevNet2008\Data" for SQL Server 2005 Express

2) Detached database in Microsoft SQL Server Management Studio by right
clicking "Nothwind" and selecting "Tasks > Detach ..."

3) Immeditately tried to re-attach by right clicking databases and selecting
"Attach ..." and adding the database file in the dialog but get 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 5(error not found) while
attempting to open or create the physical file
'C:\DevNet2008\Data\Northwnd.mdf'. (Microsoft SQL Server, Error: 5123)

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

------------------------------
BUTTONS:

OK
------------------------------


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

Default Re: SQL Server 2005 can't attach database on Windows Vista - 04-01-2008 , 04:59 PM





Daniel Grassick (dmgrass (AT) community (DOT) nospam) writes:
Quote:
3) Immeditately tried to re-attach by right clicking databases and
selecting "Attach ..." and adding the database file in the dialog but
get the following error:
Did you try to attach it to the same instance or the other instance?

Quote:
CREATE FILE encountered operating system error 5(error not found) while
attempting to open or create the physical file
NET HELPMSG 5 will tell you that this is "Access is denied".

Thus, is is either a permissions problem - or you did not detach the
database from the original instance as you thought.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


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

Default Re: SQL Server 2005 can't attach database on Windows Vista - 04-01-2008 , 04:59 PM


Daniel Grassick (dmgrass (AT) community (DOT) nospam) writes:
Quote:
3) Immeditately tried to re-attach by right clicking databases and
selecting "Attach ..." and adding the database file in the dialog but
get the following error:
Did you try to attach it to the same instance or the other instance?

Quote:
CREATE FILE encountered operating system error 5(error not found) while
attempting to open or create the physical file
NET HELPMSG 5 will tell you that this is "Access is denied".

Thus, is is either a permissions problem - or you did not detach the
database from the original instance as you thought.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


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

Default Re: SQL Server 2005 can't attach database on Windows Vista - 04-01-2008 , 04:59 PM


Daniel Grassick (dmgrass (AT) community (DOT) nospam) writes:
Quote:
3) Immeditately tried to re-attach by right clicking databases and
selecting "Attach ..." and adding the database file in the dialog but
get the following error:
Did you try to attach it to the same instance or the other instance?

Quote:
CREATE FILE encountered operating system error 5(error not found) while
attempting to open or create the physical file
NET HELPMSG 5 will tell you that this is "Access is denied".

Thus, is is either a permissions problem - or you did not detach the
database from the original instance as you thought.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


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

Default Re: SQL Server 2005 can't attach database on Windows Vista - 04-01-2008 , 04:59 PM


Daniel Grassick (dmgrass (AT) community (DOT) nospam) writes:
Quote:
3) Immeditately tried to re-attach by right clicking databases and
selecting "Attach ..." and adding the database file in the dialog but
get the following error:
Did you try to attach it to the same instance or the other instance?

Quote:
CREATE FILE encountered operating system error 5(error not found) while
attempting to open or create the physical file
NET HELPMSG 5 will tell you that this is "Access is denied".

Thus, is is either a permissions problem - or you did not detach the
database from the original instance as you thought.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


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

Default Re: SQL Server 2005 can't attach database on Windows Vista - 04-01-2008 , 04:59 PM


Daniel Grassick (dmgrass (AT) community (DOT) nospam) writes:
Quote:
3) Immeditately tried to re-attach by right clicking databases and
selecting "Attach ..." and adding the database file in the dialog but
get the following error:
Did you try to attach it to the same instance or the other instance?

Quote:
CREATE FILE encountered operating system error 5(error not found) while
attempting to open or create the physical file
NET HELPMSG 5 will tell you that this is "Access is denied".

Thus, is is either a permissions problem - or you did not detach the
database from the original instance as you thought.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


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

Default Re: SQL Server 2005 can't attach database on Windows Vista - 04-01-2008 , 04:59 PM


Daniel Grassick (dmgrass (AT) community (DOT) nospam) writes:
Quote:
3) Immeditately tried to re-attach by right clicking databases and
selecting "Attach ..." and adding the database file in the dialog but
get the following error:
Did you try to attach it to the same instance or the other instance?

Quote:
CREATE FILE encountered operating system error 5(error not found) while
attempting to open or create the physical file
NET HELPMSG 5 will tell you that this is "Access is denied".

Thus, is is either a permissions problem - or you did not detach the
database from the original instance as you thought.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


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

Default Re: SQL Server 2005 can't attach database on Windows Vista - 04-01-2008 , 04:59 PM


Daniel Grassick (dmgrass (AT) community (DOT) nospam) writes:
Quote:
3) Immeditately tried to re-attach by right clicking databases and
selecting "Attach ..." and adding the database file in the dialog but
get the following error:
Did you try to attach it to the same instance or the other instance?

Quote:
CREATE FILE encountered operating system error 5(error not found) while
attempting to open or create the physical file
NET HELPMSG 5 will tell you that this is "Access is denied".

Thus, is is either a permissions problem - or you did not detach the
database from the original instance as you thought.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


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

Default Re: SQL Server 2005 can't attach database on Windows Vista - 04-01-2008 , 04:59 PM


Daniel Grassick (dmgrass (AT) community (DOT) nospam) writes:
Quote:
3) Immeditately tried to re-attach by right clicking databases and
selecting "Attach ..." and adding the database file in the dialog but
get the following error:
Did you try to attach it to the same instance or the other instance?

Quote:
CREATE FILE encountered operating system error 5(error not found) while
attempting to open or create the physical file
NET HELPMSG 5 will tell you that this is "Access is denied".

Thus, is is either a permissions problem - or you did not detach the
database from the original instance as you thought.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


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

Default Re: SQL Server 2005 can't attach database on Windows Vista - 04-01-2008 , 04:59 PM


Daniel Grassick (dmgrass (AT) community (DOT) nospam) writes:
Quote:
3) Immeditately tried to re-attach by right clicking databases and
selecting "Attach ..." and adding the database file in the dialog but
get the following error:
Did you try to attach it to the same instance or the other instance?

Quote:
CREATE FILE encountered operating system error 5(error not found) while
attempting to open or create the physical file
NET HELPMSG 5 will tell you that this is "Access is denied".

Thus, is is either a permissions problem - or you did not detach the
database from the original instance as you thought.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
Reply
Page 1 of 19 1 2 3 4 5 6 7 8 9 10 11 > Last »

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

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.


Contact Us - dbTalk Databases Forums - Archive - Top