Viewing 15 posts - 1 through 15 (of 17 total)
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...
August 29, 2013 at 6:43 pm
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...
August 29, 2013 at 3:53 am
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...
August 28, 2013 at 3:06 am
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...
August 27, 2013 at 5:20 pm
HanShi (8/27/2013)
August 27, 2013 at 3:55 pm
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...
August 27, 2013 at 3:48 pm
Andreas Wolter-332291 (8/25/2013)
dokledon (8/25/2013)
I don't think you can have more than 1 default instance.
That's true for Standalone SQL, but I was wondering for Cluster SQL, since the VIP...
August 25, 2013 at 5:42 pm
I don't think you can have more than 1 default instance.
That's true for Standalone SQL, but I was wondering for Cluster SQL, since the VIP Name (SQL Server...
August 25, 2013 at 9:16 am
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.
August 6, 2013 at 6:01 pm
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...
June 15, 2013 at 9:48 pm
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.
May 30, 2013 at 2:52 pm
Thanks for your answer foxxo.
I was confused about Linked Server on Local Server, but it seems to be a good solution.
Dok.
May 29, 2013 at 5:17 am
In other words, can we have Linked Servers between Instances inside same server, or is there a better solution ?
May 28, 2013 at 4:47 pm
Thank you Lowell, but I stil get the same errors.
May 6, 2013 at 8:42 am
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...
May 3, 2013 at 12:53 pm
Viewing 15 posts - 1 through 15 (of 17 total)