Virtual IP adress and SQL Server

I have 3 questions on Above subject

1. How can we configure VIP's (Virtual IP address) for SQL Server??
2. If we have to install 3 instances of SQL Server on single server (Not a virtual server) then how can we configure each instance for different VIP address.
3. Also what test can we do to confirm that this Change has been configured properly??

Check the below links
http://msdn.microsoft.com/en-us/library/ms143738(SQL.90).aspx
http://support.microsoft.com/kb/244980
/**Hope this helps.**/

Hi Arun,
My server is not a virtual or cluster server so above links provided do not apply. Can you please update on how to update or add virtual IP Address to the SQL Server instance.

for standalone sql server installations, you can not provide virtual IP's. virtual ip;s are only for cluster environments.
The question fo you--> why you want to use three virtual ip;s for three instances on the server?

In that case, just want to clarify what TCP/IP properties does in SQL Server Configuration Manager TCP/IP Properties on the IP Addresses section.
Don't we specify here IP address on which SQL server should listen to, provided global property 'Listen All' is set to No.

If it is a standalone server, you can't specify virtual address since it is only for servers in cluster. Now for standalone server you might use Configuration manager to specify the IP Address and port number the server should listen to with Listen All to "NO".

I am not too good in networking, can you explain whats the difference between Normal IP address and Virtual IP address and how SQL server see them differently??

http://en.wikipedia.org/wiki/Virtual_IP_address
http://en.wikipedia.org/wiki/IP_address
Google a bit on it...

Thanks satya,
I came across this article attached below
http://www.microsoft.com/communitie...bb3-9c6a-42c825ddb1dc&lang=en&cr=US&sloc=&p=1
Can we have Multiple Instances with Different IP Addresses and Same Port Number in SQL SERVER (on same server ofcourse). This article says that this is possible by SQL alias, I have tried but its not working.
My understanding is SQL alias is used only for refereing to different SQL name and not for routing to different Port number??
If above is possible, can you please tell me how we can implement this??? is there a separate method to implement this as well??

Thanks satya,
I came across this article attached below
http://www.microsoft.com/communitie...bb3-9c6a-42c825ddb1dc&lang=en&cr=US&sloc=&p=1
Can we have Multiple Instances with Different IP Addresses and Same Port Number in SQL SERVER (on same server ofcourse). This article says that this is possible by SQL alias, I have tried but its not working.
My understanding is SQL alias is used only for refereing to different SQL name and not for routing to different Port number??
If above is possible, can you please tell me how we can implement this??? is there a separate method to implement this as well??

HI Forum,
i AM still waiting for reply for above question??

To find out the IP address on which your server is running.

1. EXEC master.dbo.xp_cmdshell 'ipconfig'
2. OR, Check sql server error log
3. OR, HKEY_LOCAL_MACHINESoftwareMicrosoftMSSQLServer MSSQLServerSuperSocketNetlibTcp
4. OR, look at sql server network utility on that server.

/**Hope this Helps.**/

I don't know i am correct or not.. but you edit the host file and add different name to the same IP
eg: 192.168.1.1 sqlserver1, 192.168.1.1 sqlserver2, 192.168.1.1 sqlserver3
then give the users with sqlserver1instance1, sqlserver2instance2, sqlserver3instance3
also desable ping, and check with network people they can mask ip address. so that users will not know they will think that all are differernt servers. is this u are trying to achive?
Thanks
John