SQL Server 2005 can't attach database on Windows Vista

#41

Daniel Grassick (dmgrass (AT) community (DOT) nospam) writes:

Quote:

Thanks for the suggestions but no luck. Both the installed Developer and
Express editions have version numbers 9.00.3054.00 and I installed SP1
for my Windows Vista Ultimate OS.

It seems it must be a permissions problem. My login "Daniel" is set as an
administrator but when I try to manually copy either the ".mdf" or ".ldf"
files I must acknowledge the prompt "You'll need to provide administrator
permission to copy to this file" for the destination folder and I then get
the User Account Control dialog with the prompt "Windows needs your
permission to continue".

When I run the T-SQL statement you suggested I get the error message:

Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "C:\DevNet2008\Data\northwnd.mdf".
Operating system error 5: "5(error not found)".

It's not good news that you can't reproduce the problem but I'm still
hoping for some inspired idea as to what could be going on!

What is the service account for SQL Server? What rights does this
service account have in the directory you use?

--
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

#42

Daniel Grassick (dmgrass (AT) community (DOT) nospam) writes:

Quote:

Thanks for the suggestions but no luck. Both the installed Developer and
Express editions have version numbers 9.00.3054.00 and I installed SP1
for my Windows Vista Ultimate OS.

It seems it must be a permissions problem. My login "Daniel" is set as an
administrator but when I try to manually copy either the ".mdf" or ".ldf"
files I must acknowledge the prompt "You'll need to provide administrator
permission to copy to this file" for the destination folder and I then get
the User Account Control dialog with the prompt "Windows needs your
permission to continue".

When I run the T-SQL statement you suggested I get the error message:

Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "C:\DevNet2008\Data\northwnd.mdf".
Operating system error 5: "5(error not found)".

It's not good news that you can't reproduce the problem but I'm still
hoping for some inspired idea as to what could be going on!

What is the service account for SQL Server? What rights does this
service account have in the directory you use?

--
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

#43

Daniel Grassick (dmgrass (AT) community (DOT) nospam) writes:

Quote:

Thanks for the suggestions but no luck. Both the installed Developer and
Express editions have version numbers 9.00.3054.00 and I installed SP1
for my Windows Vista Ultimate OS.

It seems it must be a permissions problem. My login "Daniel" is set as an
administrator but when I try to manually copy either the ".mdf" or ".ldf"
files I must acknowledge the prompt "You'll need to provide administrator
permission to copy to this file" for the destination folder and I then get
the User Account Control dialog with the prompt "Windows needs your
permission to continue".

When I run the T-SQL statement you suggested I get the error message:

Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "C:\DevNet2008\Data\northwnd.mdf".
Operating system error 5: "5(error not found)".

It's not good news that you can't reproduce the problem but I'm still
hoping for some inspired idea as to what could be going on!

What is the service account for SQL Server? What rights does this
service account have in the directory you use?

--
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

#44

Daniel Grassick (dmgrass (AT) community (DOT) nospam) writes:

Quote:

Thanks for the suggestions but no luck. Both the installed Developer and
Express editions have version numbers 9.00.3054.00 and I installed SP1
for my Windows Vista Ultimate OS.

It seems it must be a permissions problem. My login "Daniel" is set as an
administrator but when I try to manually copy either the ".mdf" or ".ldf"
files I must acknowledge the prompt "You'll need to provide administrator
permission to copy to this file" for the destination folder and I then get
the User Account Control dialog with the prompt "Windows needs your
permission to continue".

When I run the T-SQL statement you suggested I get the error message:

Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "C:\DevNet2008\Data\northwnd.mdf".
Operating system error 5: "5(error not found)".

It's not good news that you can't reproduce the problem but I'm still
hoping for some inspired idea as to what could be going on!

What is the service account for SQL Server? What rights does this
service account have in the directory you use?

--
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

#45

Daniel Grassick (dmgrass (AT) community (DOT) nospam) writes:

Quote:

Thanks for the suggestions but no luck. Both the installed Developer and
Express editions have version numbers 9.00.3054.00 and I installed SP1
for my Windows Vista Ultimate OS.

It seems it must be a permissions problem. My login "Daniel" is set as an
administrator but when I try to manually copy either the ".mdf" or ".ldf"
files I must acknowledge the prompt "You'll need to provide administrator
permission to copy to this file" for the destination folder and I then get
the User Account Control dialog with the prompt "Windows needs your
permission to continue".

When I run the T-SQL statement you suggested I get the error message:

Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "C:\DevNet2008\Data\northwnd.mdf".
Operating system error 5: "5(error not found)".

It's not good news that you can't reproduce the problem but I'm still
hoping for some inspired idea as to what could be going on!

What is the service account for SQL Server? What rights does this
service account have in the directory you use?

--
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

#46

Daniel Grassick (dmgrass (AT) community (DOT) nospam) writes:

Quote:

Thanks for the suggestions but no luck. Both the installed Developer and
Express editions have version numbers 9.00.3054.00 and I installed SP1
for my Windows Vista Ultimate OS.

It seems it must be a permissions problem. My login "Daniel" is set as an
administrator but when I try to manually copy either the ".mdf" or ".ldf"
files I must acknowledge the prompt "You'll need to provide administrator
permission to copy to this file" for the destination folder and I then get
the User Account Control dialog with the prompt "Windows needs your
permission to continue".

When I run the T-SQL statement you suggested I get the error message:

Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "C:\DevNet2008\Data\northwnd.mdf".
Operating system error 5: "5(error not found)".

It's not good news that you can't reproduce the problem but I'm still
hoping for some inspired idea as to what could be going on!

What is the service account for SQL Server? What rights does this
service account have in the directory you use?

--
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

#47

Hi,
In addition to Erland's suggestion, I also would like to ask you some other
questions:
1. What is the result if you turn off User Account Control?
2. Are there any anti-virus software installed on your OS? If so, what is
the result if you turn if off?
3. What is the result if you perform a test with a different database with
different data file locations?

Look forward to your response.

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

#48

Hi,
In addition to Erland's suggestion, I also would like to ask you some other
questions:
1. What is the result if you turn off User Account Control?
2. Are there any anti-virus software installed on your OS? If so, what is
the result if you turn if off?
3. What is the result if you perform a test with a different database with
different data file locations?

Look forward to your response.

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

#49

Hi,
In addition to Erland's suggestion, I also would like to ask you some other
questions:
1. What is the result if you turn off User Account Control?
2. Are there any anti-virus software installed on your OS? If so, what is
the result if you turn if off?
3. What is the result if you perform a test with a different database with
different data file locations?

Look forward to your response.

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

#50

Hi,
In addition to Erland's suggestion, I also would like to ask you some other
questions:
1. What is the result if you turn off User Account Control?
2. Are there any anti-virus software installed on your OS? If so, what is
the result if you turn if off?
3. What is the result if you perform a test with a different database with
different data file locations?

Look forward to your response.

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Server 2005 can't attach database on Windows Vista

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

Re: SQL Server 2005 can't attach database on Windows Vista - 04-02-2008 , 05:03 PM

Re: SQL Server 2005 can't attach database on Windows Vista - 04-02-2008 , 05:03 PM

Re: SQL Server 2005 can't attach database on Windows Vista - 04-02-2008 , 05:03 PM

Re: SQL Server 2005 can't attach database on Windows Vista - 04-02-2008 , 05:03 PM

Re: SQL Server 2005 can't attach database on Windows Vista - 04-02-2008 , 05:03 PM

Re: SQL Server 2005 can't attach database on Windows Vista - 04-02-2008 , 05:03 PM

Re: SQL Server 2005 can't attach database on Windows Vista - 04-03-2008 , 05:13 AM

Re: SQL Server 2005 can't attach database on Windows Vista - 04-03-2008 , 05:13 AM

Re: SQL Server 2005 can't attach database on Windows Vista - 04-03-2008 , 05:13 AM

Re: SQL Server 2005 can't attach database on Windows Vista - 04-03-2008 , 05:13 AM