I got request saying that
So I would like to know whether DB_NAME can be accessed outside of VDI/VM-Ware or can we access DB_NAME database through queries outside VM-Ware?
We want to access DB_NAME with read only access outside VM Ware .
I don;t have much knowledge about it.Does this mean I have to create login with window authentication or sql server authentication . The person who requests for the read only access doen;t looks like domain user.
can you please tell me what are the steps i need to follow?
asked Jun 07, 2012 at 09:22 PM in Default
VMware creates a server. If that server is on your network, it acts like any other server on your network, except it's virtual. So any security settings, such as setting up an Active Directory group, assigning that to a Role in a database, and then having that Role have read access to the tables, these are all standard SQL Server settings. These are just exposed through a SQL Server instance that is running on a an OS that is a virtual server as opposed to a physical machine. I've got multiple virtuals running on my laptop. Some of them are part of my local domain and can be accessed from any other machine, including virtuals, on the domain. Others are isolated and running inside their own domain with their own IP addresses. These can't be accessed by the rest of the network. It all depends on how you set things up for the server. There are not real tricks needed for VMware for this.
answered Jun 07, 2012 at 10:00 PM
Grant Fritchey ♦♦