What about Upgrade Advisor? He should find potential problems.

Hello,

I have similar problem. Two application server exactly the same configuration one works fionr one reports this error. I use TCP/IP only, telnet works fine but in ODBC or OLE...

Don't you see guys that approach: I wait for problems and then apply a patch is very bad. On systems which have very strict SLAs 99,999 for example you must...

To be honest it doesn't matter what was default for which system. The question is in 64 bit is there still recommended for MS to go with optimization for net...

I have no time to verify this and server is quite strong so we have alwayes a lot of available resources. It's more general question what's your idea about such...

Yes we usually do this but now we are before SQL 2005 validation. I ask to validate SP2 build and now I'm thinking maybe its not a bad ide to...

Michael Valentine Jones (1/7/2008)

It has nothing to...

In SQL 2k it is automatically set up to correct one. On SQL 2k5 32 Bit as far as I remember as well.

Good point Greg. I would add it tries to convert. When there's mapping between DTS and SSIS component it replaces old with new one (there are some exceptions) if not...

After upgrade SQL 2000 DTS components are deleted. Yoi should do following:

1. Add or Remove Programs in CP

Repair SQL Server 2005 Backward Compatibility feature

2. Download and install following package:

SQLServer2005_DTS.msi.

Afterwards you...

Thanks a lot for this findings.

The problem is that in standard clusterconfiguration you have two physical NICs: Public nad heartbeat and several virtual NICs for Virtual OS and each virtual SQL instance.

Now the question is...

I can test this but still without official statement from Ms we can't implement this on prod. But if you don;'t have idea maybe it's good to open case and...

Each instance ahs its own IP. My question is another:

Can I assigned the same port 1433 to those three instances?

I don't know if cluster is so clever that it will...

I have similar issue. I moved server from one domain to another one and on one node (this is cluster) after SQL Service starts I have following error in SQL...