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:
configuring ms sql server remote access
how enable remote connections in sql server 2008?
SQL Server > SQL Server Application and Multi-Server Management
Comments
Post a Comment