Showing posts with label Microsoft. Show all posts
Showing posts with label Microsoft. Show all posts

How to connect Nodes to Domain Controller.

You may have question how to Connect Node1 to DC ?

It is an easy task to perform, don't know why no one else created a proper blog about it.

First, you have to install 3 roles to the DC to make it Domain Controller and then it will be ready to add other nodes.

So the three roles are AD DC, DHCP, and DNS.

Add this three roles, then Promote your server as Domain controller create a Forest, give it a name and create NETBIOS.

Once it is done, go to Network adaptors settings and assign it a IP, you can assign class A, B or C, whichever you wish.

For example take class an IP address 10.1.10.1 and keep the default gateway and DNS server also the same.

Once you will assign the IP address now its time to set DHCP so that other computer will get the IPI addresses and will be able to connect to the domain.

So go to DHCP and right click on IPV4 and select New Scope option and create a scope and take range between 10.1.10.100 to 10.1.10.200.

Now we are done with the setting on DC.

Now need to connect Node one to the DC, so go back to the Node1 and in server manager select local server, in there click on manage IPV4 and now assign it any IP address which is within the scope and make the default gateway the IP address of the DC server.

Now go back to Server Manager click on Local Server and here click on "Workgroup" and change it to the domain name you had earlier assigned.

Now you will be able to connect the DC with the different nodes.

Found below video very useful to perform the above task and you can also proceed with performing clustering.

Video Courtesy : 

SrinathChowdary



SQL Query Error: Msg 242, Level 16, State 3, Line 24, The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.


So while running a SQL query in SQL Server you may find this error :


“Msg 242, Level 16, State 3, Line 24
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.”


After trying multiple formats was able to execute and  found that the reason behind this error was tryingMYSQL Datetime formate instead Microsoft SQL server:



For an Example, just take below SQL query and try to understand.


------------------------------------------------------------>
First, create a table:


Create table professionals (Pro_ID int primary key, First_Name varchar(30), Last_Name Varchar(30),  Date_Join datetime, Profession varchar(30));


So in above example when you are going to enter the date and time in Date_Join in MySQL formate which is in bold below:


MySQL FORMAT:
insert into professionals(Pro_ID, First_name, Last_name, Salary, Date_Join, Profession)
Values
(2, 'Steve', 'Jobs', 1500000, '1983-02-04 09.00.00', 'CEO')


_________________MS SQL FORMAT BELOW_________________


It will not accept it because it needs a MS SQL Server Format which is below:


MS SQL SERVER FORMAT:
(2, 'Steve', 'Jobs', 1500000, '1983-02-04 09:00:00:000', 'CEO')


Hopefully, this is going to save a lot of trouble for you.


Enter your email address:

Delivered by FeedBurner