problem with win2000 cluster and sql 2000 ent

Hi,
we have a win2000 adv cluster with sql server 2000 ent.
last time i had to move resources from active node to passive node, i
had big troubles.
Moving groups caused many sql db files damaged, having db marked
'suspect'
Why ? Do you know any possible reason ?
This cluster does not have a different drive for quorum disk and i
think that files needed by cluster service (log, checkpoint, ...) are
on the only shared disk, where are stored all db files.
Could be this the reason ?
Thanks in advance...
I'm not even going to ask how you got this to work in this configuration.
But, yes, it would be a problem.
Although, I suspect, that a bigger problem is that you have some form of
Disk Write Back Caching enabled.
I'd look through you server's System Event logs for various disk related
errors.
Normally, SQL Server REQUIRES a dedicated resource group, with an
independent Disk, IP Address, and Network Name resource, although the SQL
Server setup program will add the IP and Name resources for you (it will
actually bomb if those resources already exist in the group).
Sincerely,
Anthony Thomas

"The Bedroom" <thebedroom71@.gmail.com> wrote in message
news:1163973423.582387.314090@.m7g2000cwm.googlegro ups.com...
> Hi,
> we have a win2000 adv cluster with sql server 2000 ent.
> last time i had to move resources from active node to passive node, i
> had big troubles.
> Moving groups caused many sql db files damaged, having db marked
> 'suspect'
> Why ? Do you know any possible reason ?
> This cluster does not have a different drive for quorum disk and i
> think that files needed by cluster service (log, checkpoint, ...) are
> on the only shared disk, where are stored all db files.
> Could be this the reason ?
> Thanks in advance...
>

problem with WIN2000 client

One Winn 2000 workstatiom has problem with ACCESS 2003 ODBC conection to SQL
server on WIN 2003 server. Other clients are all WINXP. This cient is on the
different domain too. Some reports works, and some have error, ask for
password again but not accept it even if it is supplied again. Application
on other clients works well.Hi Zeljko,
I noticed that the issue was posted in this newsgroup as a duplicated one.
You have another post titled "problem with WIN2000 client" and I will add a
reply to that post. If you have follow up questions, please post there and
I will work with you. Thanks you very much.
Sincerely yours,
Michael Cheng
Microsoft Online Support
****************************************
*******************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.

problem with WIN2000 client

One Winn 2000 workstatiom has problem with ACCESS 2003 ODBC conection to SQL
server on WIN 2003 server. Other clients are all WINXP. This cient is on the
different domain too. Some reports works, and some have error, ask for
password again but not accept it even if it is supplied again. Application
on other clients works well.
Hi Zeljko,
I noticed that the issue was posted in this newsgroup as a duplicated one.
You have another post titled "problem with WIN2000 client" and I will add a
reply to that post. If you have follow up questions, please post there and
I will work with you. Thanks you very much.
Sincerely yours,
Michael Cheng
Microsoft Online Support
************************************************** *********
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.

Problem with win2000 and xp seeing the server

I have sql server 8.0 installed on my win2000 machine and a xp machine trying to access that server. I have my network connected through a linksys router. I can connect to the internet but can not access the server.
Mike,
Not clear. Did you mean the WinXP client cannot access the SQLServer in
Win2000? If so, what is the error?
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:16317F90-3264-4C74-B73C-38383992615B@.microsoft.com...
> I have sql server 8.0 installed on my win2000 machine and a xp machine
trying to access that server. I have my network connected through a linksys
router. I can connect to the internet but can not access the server.

Problem with win2000 and xp seeing the server

I have sql server 8.0 installed on my win2000 machine and a xp machine trying to access that server. I have my network connected through a linksys router. I can connect to the internet but can not access the server.Mike,
Not clear. Did you mean the WinXP client cannot access the SQLServer in
Win2000? If so, what is the error?
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:16317F90-3264-4C74-B73C-38383992615B@.microsoft.com...
> I have sql server 8.0 installed on my win2000 machine and a xp machine
trying to access that server. I have my network connected through a linksys
router. I can connect to the internet but can not access the server.

Problem with win2000 and xp seeing the server

I have sql server 8.0 installed on my win2000 machine and a xp machine tryin
g to access that server. I have my network connected through a linksys rout
er. I can connect to the internet but can not access the server.Mike,
Not clear. Did you mean the WinXP client cannot access the SQLServer in
Win2000? If so, what is the error?
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:16317F90-3264-4C74-B73C-38383992615B@.microsoft.com...
> I have sql server 8.0 installed on my win2000 machine and a xp machine
trying to access that server. I have my network connected through a linksys
router. I can connect to the internet but can not access the server.