x

sql server account outside VDI

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?

more ▼

asked Jun 07, 2012 at 09:22 PM in Default

avatar image

kalpu234
72 4 8 9

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Jun 07, 2012 at 10:00 PM

avatar image

Grant Fritchey ♦♦
137k 20 43 81

Thanks Grant for your quck responce. SO, if Create sql server login with read only access will provide an acess to the user right. or do i need to do any other things.

Thanks

Jun 07, 2012 at 10:42 PM kalpu234

As long as that server is part of your domain, it's just like any physical server on your domain. So yes.

Jun 07, 2012 at 10:45 PM Grant Fritchey ♦♦

yes that server who hosts sql server is part of the domain but my question is I am creating sql server account for the user who is not a domain user. on that case can he access database outside VDI/VMWare if I created account with read permission on that database.(here I am still confused outside VDI/vmware)

Thanks

Jun 07, 2012 at 11:00 PM kalpu234

OK. So its a SQL login instead of an Active Directory login. It's still standard SQL Server rules that apply as long as that virtual server is treated like other servers on your system, it has an IP address, it's ports are exposed for connection to SQL Server, etc. There's actually shockingly little special about setting up VM servers. Main trick is monitoring the base machine so that you can tell when you have memory or cpu issues because monitoring the virtual won't tell you that.

Jun 07, 2012 at 11:21 PM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x107

asked: Jun 07, 2012 at 09:22 PM

Seen: 1084 times

Last Updated: Jun 07, 2012 at 11:21 PM

Copyright 2017 Redgate Software. Privacy Policy