Create database on WIN2K cluster

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi,

I wanted to create a SQL Server 2000 database on a WIN2K cluster server, using a script. The system prompted me the following error messages:

"Server: Msg 5184, Level 16, State 2, Line 9 Cannot use file 'd:\ilienyc\data\pridatafile\ilienycroot.mdf' for clustered server. Only formatted files on which the cluster resouce of the server has a dependency can be used."

The same file system exist on both nodes of the cluster. Would some one tell me why this happens and how to resolve the problem?

Your inputs are greatly appreciated!

Yichang Chen

-- Anonymous, June 07, 2001

Answers

Yichang,

There is some advice on how to deal with this error in the usenet newsgroup microsoft.public.sqlserver.clustering if you search for the phrase "Error 5184". Here is a link to that usenet search:

http://groups.google.com/groups?as_epq=Error% 205184&as_ugroup=microsoft.public.sqlserver.clustering&num=100

(The URL should, of course, be typed all on one line with no spaces.)

Hope this helps,

Eric Kohnen

-- Anonymous, June 08, 2001


Moderation questions? read the FAQ