Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Assigning an IP Address to SQL Server

Author  Topic 

schan8593
Starting Member

13 Posts

Posted - 2012-07-24 : 15:53:28
Hi everyone,

How do I assign an IP Address to my MS SQL Server so that other computers on the network can access it? I need to do this because SQL Server is virtualized on a computer. I noticed you can go to SQL Server Configuration Manager, but it lists a bunch of IP Addresses and I'm not sure what to do with them. Can someone please help me so that I acn assign an IP Address for other users to access the SQL Server?

Thanks,
Stephen

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-07-24 : 16:09:36
Why don't you just use the IP address of the virtual machine? And why do the users need to do this? Just have them connect to the virtual machine name\instance name.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

schan8593
Starting Member

13 Posts

Posted - 2012-07-24 : 16:18:06
Oh okay. How would I get them to connect to the virtual machine name then, assuming I have the IP Address? Sorry I'm a bit new to this.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-07-24 : 16:20:27
It's no different than a regular machine. You use hostname\instancename. The user does not need to know the IP address. We never use IP addresses here, always hostname.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

schan8593
Starting Member

13 Posts

Posted - 2012-07-24 : 16:26:00
How would they connect using the virtual machine using the hostname then? I'm not too familiar with this process, sorry.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-07-24 : 16:38:21
The hostname of the virtual machine is what I mean.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

schan8593
Starting Member

13 Posts

Posted - 2012-07-24 : 16:49:55
Yes, can you guide me through the process in which you connect to the hostname of the virtual machine?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-07-24 : 18:03:18
hostname\instancename if using a named instance or just hostname if using a default instance.

Type in hostname in a cmd window on the virtual machine to get the host's name.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

schan8593
Starting Member

13 Posts

Posted - 2012-07-25 : 18:38:06
Thanks, that helps!
Go to Top of Page
   

- Advertisement -