Error -2147217900: failed to create SQL database

Geoff,
On a different note, we rebuilt the SQL cluster network today. However when
I run the MSI, I am seeing the below given error this time:
Event Type:Error
Event Source:MsiInstaller
Event Category:None
Event ID:10005
Date:10/16/2006
Time:4:06:34 PM
User:myDomain\SQLServerAccount
Computer:SQLServer
Description:
Product: Database -- Error 26201. Error -2147217900: failed to create SQL
database: ApplicationDb, error detail: CREATE DATABASE failed. Some file
names listed could not be created. Check previous errors..
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Any thoughts on what this error is, and what could be causing this?
--Mehul
"Geoff N. Hiten" wrote:

> Use the cluster.exe command-line utility to stop and restart instances from
> within a script.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Mehul" <Mehul@.discussions.microsoft.com> wrote in message
> news:39DD3469-5CEE-49DC-9755-681B5701D0EF@.microsoft.com...
>
>
When you rebuilt the cluster, did you add disk resources as dependencies for
SQL Server? If not, then SOL Server cannot see the disks.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"Mehul" <Mehul@.discussions.microsoft.com> wrote in message
news:CCA03ACA-2B83-488C-B479-11406C9E2D1C@.microsoft.com...
Geoff,
On a different note, we rebuilt the SQL cluster network today. However when
I run the MSI, I am seeing the below given error this time:
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 10005
Date: 10/16/2006
Time: 4:06:34 PM
User: myDomain\SQLServerAccount
Computer: SQLServer
Description:
Product: Database -- Error 26201. Error -2147217900: failed to create SQL
database: ApplicationDb, error detail: CREATE DATABASE failed. Some file
names listed could not be created. Check previous errors..
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Any thoughts on what this error is, and what could be causing this?
--Mehul
"Geoff N. Hiten" wrote:

> Use the cluster.exe command-line utility to stop and restart instances
> from
> within a script.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Mehul" <Mehul@.discussions.microsoft.com> wrote in message
> news:39DD3469-5CEE-49DC-9755-681B5701D0EF@.microsoft.com...
>
>
|||Try creating the databases maually so you get the SQL error message, not the
installer error message. That should tell you exactly why it failed.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:u4pJE2X8GHA.4708@.TK2MSFTNGP05.phx.gbl...
> When you rebuilt the cluster, did you add disk resources as dependencies
> for
> SQL Server? If not, then SOL Server cannot see the disks.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> .
> "Mehul" <Mehul@.discussions.microsoft.com> wrote in message
> news:CCA03ACA-2B83-488C-B479-11406C9E2D1C@.microsoft.com...
> Geoff,
> On a different note, we rebuilt the SQL cluster network today. However
> when
> I run the MSI, I am seeing the below given error this time:
> Event Type: Error
> Event Source: MsiInstaller
> Event Category: None
> Event ID: 10005
> Date: 10/16/2006
> Time: 4:06:34 PM
> User: myDomain\SQLServerAccount
> Computer: SQLServer
> Description:
> Product: Database -- Error 26201. Error -2147217900: failed to create SQL
> database: ApplicationDb, error detail: CREATE DATABASE failed. Some file
> names listed could not be created. Check previous errors..
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Any thoughts on what this error is, and what could be causing this?
> --Mehul
> "Geoff N. Hiten" wrote:
>
|||You are right on. This is exactly the cause for the below given error log.
We ran profiler to see what commands is the MSI passing to create the DB.
Then we manually tried to run that command in Query analyzer, that throwed
reference to the disk dependency.
Thanks Tom/Geoff for your quick response.
--Mehul
"Tom Moreau" wrote:

> When you rebuilt the cluster, did you add disk resources as dependencies for
> SQL Server? If not, then SOL Server cannot see the disks.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Mehul" <Mehul@.discussions.microsoft.com> wrote in message
> news:CCA03ACA-2B83-488C-B479-11406C9E2D1C@.microsoft.com...
> Geoff,
> On a different note, we rebuilt the SQL cluster network today. However when
> I run the MSI, I am seeing the below given error this time:
> Event Type: Error
> Event Source: MsiInstaller
> Event Category: None
> Event ID: 10005
> Date: 10/16/2006
> Time: 4:06:34 PM
> User: myDomain\SQLServerAccount
> Computer: SQLServer
> Description:
> Product: Database -- Error 26201. Error -2147217900: failed to create SQL
> database: ApplicationDb, error detail: CREATE DATABASE failed. Some file
> names listed could not be created. Check previous errors..
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Any thoughts on what this error is, and what could be causing this?
> --Mehul
> "Geoff N. Hiten" wrote:
>
>