Posts

Showing posts from January, 2007

Alias con SQL 2005

Si configurar un Alias con SQL 2005 debes utilizar el nombre del servidor y no la IP. De lo contrario dara timeouts.

Como configurar un alias para conectarse a una instancia en puerto no default

Configure a SQL client alias
If you block UDP port 1434 or TCP port 1433 on the SQL Server computer, you must create a SQL client alias on all other computers in the server farm. You can use SQL Server client components to create a SQL client alias for computers that connect to SQL Server 2000 or SQL Server 2005.

1.
Run Setup for SQL Server 2005 on the target computer and select the following client components to install:

1.
Connectivity Components

2.
Management Tools


2.
Open SQL Server Configuration Manager.

3.
In the left pane, click SQL Native Client Configuration.

4.
In the right pane, right-click Aliases, and select New Alias.

5.
In the Alias dialog box, enter a name for the alias and then enter the port number for the database instance. For example, enter SharePoint_alias.

6.
In the Port No field, enter the port number for the database instance. For example, enter 40000. Ensure that the protocol is set to TCP/IP.

7.
In the Server field, enter the name of the SQL Server computer.

8…

Como cambiar el puerto por default en una instancia de SQL Server 2005

Configure a SQL Server 2005 instance to listen on a nondefault port
Use SQL Server Configuration Manager to change the TCP port that is used by an instance of SQL Server 2005.

1.
Use SQL Server Configuration Manager to change the TCP port that is used by an instance of SQL Server 2005.

2.
On the SQL Server computer, open SQL Server Configuration Manager.

3.
In the left pane, expand SQL Server 2005 Network Configuration.

4.
Under SQL Server 2005 Network Configuration, click the corresponding entry for the instance that you are configuring. The default instance is listed as Protocols for MSSQLSERVER. Named instances will appear as Protocols for named_instance.

5.
In the right pane, right-click TCP/IP and click Properties.

6.
Click the IP Addresses tab. For every IP address assigned to the SQL Server computer, there is a corresponding entry on this tab. By default, SQL Server is listening on all IP addresses assigned to the computer.

7.
To globally change the port that the default instanc…

Transferir los roles del un Domain Controller a otro

http://support.microsoft.com/kb/324801/en-us

FSMO Roles
In a forest, there are at least five FSMO roles that are assigned to one or more domain controllers. The five FSMO roles are: • Schema Master: The schema master domain controller controls all updates and modifications to the schema. To update the schema of a forest, you must have access to the schema master. There can be only one schema master in the whole forest.
• Domain naming master: The domain naming master domain controller controls the addition or removal of domains in the forest. There can be only one domain naming master in the whole forest.
• Infrastructure Master: The infrastructure is responsible for updating references from objects in its domain to objects in other domains. At any one time, there can be only one domain controller acting as the infrastructure master in each domain.
• Relative ID (RID) Master: The RID master is responsible for processing RID pool requests from all domain controllers in a particular domai…