Thanks for the reply Lynn.

The option "prevent saving changes that require table re-creation" is currently checked. But I dont want any data loss if I am making changes to...

I was able to create the unique constraints.

Thanks.

Thanks for the reply. This a requirement from one of my developers. So in this case I need to have a third column that is a combination of column1 and...

In the sql server report config manager I connected to the database engine on second server and also was creating a connection to the second database instead of connecting to...

I figured out the issue. I am able to see the second server in the sacelout deployment tab.

I followed the instructions from this url:

http://msdn.microsoft.com/en-us/library/ms159114.aspx

I have 2 of these on Server 1:

Broadcom netxtreme gigabit ethernet

Server 2:

Realtek RTL8168B/8111B Family PCI-E Gigabit Ethernet NIC (NDIS 6.20)

Realtek RTL8168D/8111D Family PCI-E Gigabit Ethernet NIC (NDIS 6.20)...

Perry and Elliot,

Thanks for your replies. I was trying to team up the nics for public network failover but i could not find this option in the nic properties window....

You CAN make it work with one NIC but it is not recommended and there are risks associated with that course. I'm asking what your intentions are for the second...

The clustering worked well without any issues when I was using only 1 nic in all the three servers. I did not configure a seperate private network for the heartbeat...

In my scenario both the nics are in the same subnet..I think it should still work...but it wont

Server Manager-->Diagnostics-->Device Manager-->Network Adapters-->2 for each server

Ok...I was able to install SQL successfully with just one IP (I unchecked the Network Cluster2) instead of giving it 2 IP's...I dont understand why it errors out when I...

No

No It doesnt work for some reason...I still got this error:

SQL Server Setup has encountered the following error:

The IP Address '' is already in use. To continue, specify a different...