sql remote access

• muhamadehsan

  SSC Veteran

  Points: 227

  More actions

  February 27, 2011 at 10:13 am

  #232749

  Hi,

  First i would like to introduce myself i am Ehsan and just new to sql server i have few questions

  1. i have two computers one is desktop and one is laptop bot running windows 7

  2. i want to make my desktop a server with all the database files on it

  3.i want to work on laptop and get access from the desktop

  Please do not mind to answer these questions or if i can get help step by step it would be more better.

  thanks

  Ehsan

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738632

  More actions

  February 27, 2011 at 10:32 am

  #1292047

  You haven't asked a question. You made three statements.

  You can install SQL Server on one, and the client tools on the other machine and have them work. You will have to be sure the firewalls are open and remote access is enabled inside SQL Server through the sp_configure setting.

  sp_configure 'show advanced options', 1;

  GO

  RECONFIGURE;

  GO

  sp_configure 'remote access', 1;

  GO

  RECONFIGURE;

  GO

• Jeff Moden

  SSC Guru

  Points: 1004638

  More actions

  February 27, 2011 at 1:25 pm

  #1292060

  I'll also remind folks that SQL Server Standard Edition and Enterprise Editions require Windows Server, as well. SQL Server Express and Developer's Editions will install on the desktop edition of Windows. Just keep in mind that the Developer's Edition has a very strict licensing agreement.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)