Question How to connect to SQL server 2008 from other PC via internet? Can i use VPN? (1 Viewer)

[xaysana]

Hi Guys,
Disappear from this forum for sometimes. Hoping all of you are doing fine and weathy.

I am interested to learn SQL server, now i own 2008 standard edition version. Just got it downloaded from website.

I do not know anything about this.

Firstly, what I would like to do is:
I am planning to install SQL server on primary domain controller (PDC) so that PDC server can centrallizing user account. I also plan to have an internal intranet. Once user is prompted for changing password occassionally. user only change his password once and affects to intranet and his account in AD services. at the same time having SQL server holds a sales database.

Secondly, User can access to sales database on lan and remote access from other places. How can i make this happen?

Thirdly, ...coming soon
Fouthly, ...coming soon
Fithly, ...coming soon

I may stop at this point before getting to any further comfusion.
Can somebody give me some instruction in detail please?

Thank you

 

[rodmc]

You should not run SQL server on a DC, its a very bad idea.

A DC has high traffic so this will impact on not only Directory Services but will impact SQL server performance as well, plus for fault tolerance, it isnt a good idea either, if the DC goes down so does you database.

 

[Simon_MT]

Better to use a Terminal Server.

Simon