If you want to connect without using the instancename, you need to connect using the IP-address (or servername) and portnumber. The ip-address/servername is NOT from the hostserver/cluster, but from the...

I think there is no more doubt about Default instances in a Cluster.

1) What about Static port number ? Can we use default 1433 for all instances ?

2) How connect...

I say again

Erm, no.whether stand alone or clustered you can only have one default instance, it has nothing to do with separate groups but the registry keys which are replicated...

Andreas Wolter-332291 (8/27/2013)

---

Andreas,

1) About having unique or multiple default instances inside a cluster, my doubt persist (see HanShi answer. It's a good debate)

2) About Alias, I thought about it. It...

HanShi (8/27/2013)

---

When you install a SQL instance on a cluster and as a clustered instance, you first need to create a cluster group for each instance. Because this cluster group...

no prob

UPDATED: in my original answer I mixed something Up completely, so I Change that to not confuse more People.

ok, if I understand you right: nope, you can only have...

Andreas Wolter-332291 (8/25/2013)

---

dokledon (8/25/2013)

---

That's true for Standalone SQL, but I was wondering for Cluster SQL, since the VIP...

That's true for Standalone SQL, but I was wondering for Cluster SQL, since the VIP Name (SQL Server...

Thanks to Jeff and Patrick for their answers.

It was indeed a collation problem, as one of the variable was using Upper case and was called with Lower case.

Dok.

By binaries, I mean all executables of SQL / Instances / Features.

I've just end the demo.

When installing 1st Instance, even if I select another drive for the shared features...

Despite of Foxxo clarifying answer, and I'm grateful to him, other opinions would be welcomed.

I guess it could be useful for other people that might come to similar situations.

Thanks,

Dok.

Thanks for your answer foxxo.

I was confused about Linked Server on Local Server, but it seems to be a good solution.

Dok.

In other words, can we have Linked Servers between Instances inside same server, or is there a better solution ?

Thank you Lowell, but I stil get the same errors.

Hi caepinto,

Your script is very useful as it becomes complicated to find some to document SQL 2000 instances.

However, I have this error on part 5:

5. Datafiles list

***********************

DBCC execution...