This details how to change the IP address, incidentally why aren't clients connecting via the virtual network name?

are you trying to change the IP address?

jayoub (3/24/2014)

---

I am working on migrating an SQL Cluster from Windows Server 2003 SQL 2005 to Windows Server 2008 SQL 2005 and I am considering doing the following:

Install Windows...

jasona.work (3/22/2014)

---

So, I may need to enable TDE on some DBs in the near future, and I want to get everything clear in my head. I understand the basics...

keyun21 (3/21/2014)

---

Hi Raymond,

Thanks for your reply, our main concern is running ETL as we crunch lot of data. There is already a performance issue where we are fixing it. Plus,...

Yes really, memory and cpu can be over committed usually without too much problem. If you follow the best practice and avoid over committing then cpu and memory will never...

the biggest problem with VMs is storage performance which for your DW you'll probably need. Virtual disks are generally good for standard sequential I\O but suck for random I\O. There...

shahgols (3/21/2014)

---

Hi everyone, I'm reading up on Always on and I am confused what is the difference between AlwaysOn Availability Groups and AlwaysOn Failover Cluster Instances. Can you shed...

As a dual skilled DBA, i say forget what you know about Oracle. Get the SQL server internals book and give it a good going over multiple times.

I hear...

Under the servername parameter put the full instance...

pheonix623 (3/20/2014)

---

I originally wound it by checking to see why I could not drop the login. I checked for any other using sys.server_permissions.

Select pm.class_desc,

...

Which version sql are you...

What are you using to ascertain that the login has a grant on the endpoint?

you know now 😉

do you have a firewall enabled?