that sucks but it looks like I could setup multiple instances using sql standard edition, which would give me 2 active passive clusters

microsoft

same error

here it is I think this is a straightforward issue

no just on the screen where you need to put in the IP address for the network resource during the inital cluster setup, you put in the ip and it...

right but if the ip is invalid (can't ping it) the resource will never be created,

thanks you are validating what I thought, my network guy thinks the install will create the IP, I always thought the IP had to be setup and valid first. ...

we actually have a 3rd party app that simulates the mirroring so I am looking at the active passive solution

forget the port issue, start simple

"Check if instance name is correct and if SQL Server is configured to allow remote connections"

Did you check this on the remot instances you...

Proof of concept would be about 100, but if it flies could be 1000, THinking of doing the proof version on BI and see if software vendor if there...

Problem is they don't offer proc license for BI, so if you build a corporate warehouse you almost have to go for enterprise edition (29K a proc). Should have...

I kind of agree bu the horse is out of the barn, one way or the other I either change the one linked server to new name and developers change...

I have this same issue, set sql 2012 on a server on windows 2012 as a test bed. Developer comes to me today, no sql server, databases are there...

THanks I do have a concern that I may be introducing extra overhead that may actually cost me, the data I am looking at making the indexed view on is...

I will create the indexed view on server a. The query comes from server B, can I still use the "NoExpand hint to any query that you want...