Running SQL 2005 Enterprise on my Laptop - How ?

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  July 14, 2008 at 10:34 am

  #188086

  I installed SQL 2005 on my laptop, but it's standalone and I want to run SQL on it's own. How do I configure it to work without being on a server network ?

  "An error has occured while establishing a connection to the server. When connection to SQL 2005, this may be caused by the default setting does not allow remote connection. (provider: Named Pipes Provider, error 40 - could not open a connection) Error:2

  Edit: Seems I have no SQL Services running ... hmmmmm ?

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  July 14, 2008 at 11:13 am

  #842561

  As a beginning read: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/309b9dac-0b3a-4617-85ef-c4519ce9d014.htm

  Carefully note the start up options for the various SQL services.

  Then: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/9d9b1cb9-f64b-405e-bdbb-a91b4abed871.htm

  or you may wish to view this first:

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/c82d19e5-5557-4235-9a70-37983607a1fd.htm

  These hopefully will explain how to start the database engine and each of the services.

  A lot of reading I know but it should give you the detail you require.

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]