How can I make one computer server at Home for access of SQL Server 2012/2008


hi all,

sorry basic question 0 in networking. i grateful if guides should make 1 of home pc server. scenario follows:

i want give training few students sql server t-sql.

i have 1 laptop using sql server 2012 having windows 7 pro(laptop master-want make server). have other laptop running windows 7 pro , got sql server 2008. students have mix of laptops including windows xp, windows vista, windows 7 , windows 8. students have sql server 2008 installed , working.

q1: want make laptop master(explained in above paragraph) as server , want other laptops to access master server in home network. install sample exercise database on server , students writing queries access data.

q2: can secure sample database students can copy sample database server?

q3: can students run queries remotely sitting home?

thanks in advance.

kind regards

a k


adnan

first of all, need valid ip. can enable remote connections in sql server, students can work on sql server via internet. 

more info:

what valid ip address?

configuring ms sql server remote access

how enable remote connections in sql server 2008?


t-sql e-book technet wiki community
my blog
my articles



SQL Server  >  SQL Server Application and Multi-Server Management



Comments

Popular posts from this blog

Motherboard replacement

Cannot create Full Text Search catalog after upgrading to V12 - Database is not fully started up or it is not in an ONLINE state

Remote Desktop App - Error 0x207 or 0x607