VMWare : How to configure static IP address for ESXi Hosts

Posted by Sqltimes
On February 28, 2015
0 Comments

Quick one today: For one of our lab servers, we needed reconfigure an ESXi host from dynamic (default) to static IP address. Following are the steps, that worked for us. Not sure how, screenshots could be take from a ESXi console, so only text instructions for this post. Go to the physical ESXi machine and […]

Posted by Sqltimes
On February 21, 2015
0 Comments

Sometimes, in our environment, we have multiple instances of Sql Server running on the same machine. In default configuration, when named instances come up, they listen on some port number. This port number changes every time they restart.Check out the listening port in two ways: Sql Server Error Logs SCM >> TCP/IP properties window See […]

Posted by Sqltimes
On February 14, 2015
0 Comments

Quick one today: When I restore databases from one instance to a different instance, i.e. from QA environment to Integration environment or to UAT, this issue of orphan users occurs. Login are instance level principals and Users are database level principals. Each user account at the database level is mapped to a login at instance […]

VMWare : How to configure static IP address for ESXi Hosts

Sql Server : How to configure Sql Server instance to listen in static port

Sql Server: How to fix orphan users (and map them to logins)