Scorz (9/4/2014)

---

We have an active\passive cluster that needs to be dismantled but we want to keep the SQL instance. Can I just remove each node from the sql cluster...

changing the computer name will essentially change the sql instance name, this is likely the issue you are having. Supply the new servername or the IP address and retry the...

sounds like the log is not large enough to cope with the longest active transaction 😉

do you want the AlwaysOn solution to reatin a failover cluster instance as a replica? There are restrictions by doing this 😉

an upgrade is perfectly viable as long as it's between supported editions. What is the state of each node for cluster membership? Is the current instance a Failover Cluster Iinstance...

do you plan to use separate NICs or one NIC?

bpowers (9/3/2014)

---

We created a new SQL Server instance, on a new virtual machine, to replace one of our servers that has a production instance of SQL Server. On the new...

if running under local system you shouldnt need to do anything

Whats your environment like?

For example, If it takes 2 days just to rack the servers and connect the storage this would need to be factored in.

Yes you can add extra IP addresses for SQL server to listen on, you either stack them on the same NIC or have separate NICs

You'll need to create a new SPN if you change the computername and the svc account does not have permission to do it automatically.

To be honest i can't remember, you could...

what is your question??

This violates all Windows and SQL server security Best Practice.

cstrati (9/2/2014)

---

so I can't give those logins access to the...

that's not surprising