• 0

I want to make a local SQL Server 2005...


Question

Hey

In SQL 2000, I could simply connect to a local host server (which I made in installation) and connect to a server on a local host. In SQL 2005, things are obviously different. Does someone know how to make a local server in SQL 2005 and make a database (or transfer a 2000 database) and simple work offline? This is for school so thats why it is offline.

8 answers to this question

Recommended Posts

  • 0
  On 12/05/2010 at 15:33, alfaaqua said:

In SQL 2000, I could simply connect to a local host server (which I made in installation) and connect to a server on a local host. In SQL 2005, things are obviously different.

How are things different? And WTF is the difference between connecting "to a local host server" and connecting "to a server on a local host"?? :wacko:
  • 0

http://www.connectio...sql-server-2005

Just use 'localhost' as the server name.

Use sp_detatch_db and sp_attach_db to install a copy of your db on the localhost, or restore a backup.

Restored or attached will be upgraded to SQL05 automatically.

  • 0
  On 13/05/2010 at 21:01, boogerjones said:

How are things different? And WTF is the difference between connecting "to a local host server" and connecting "to a server on a local host"?? :wacko:

Im not really sure how to start a SQL server service on my computer so it can itself become a SQL Server.

It is simply worded differently. I hope your period ends soon......... :unsure:

  Quote

http://www.connectio...sql-server-2005

Just use 'localhost' as the server name.

Use sp_detatch_db and sp_attach_db to install a copy of your db on the localhost, or restore a backup.

Restored or attached will be upgraded to SQL05 automatically.

Thanks :)

The lines on those pages though look like when I want to connect thru VB.

I simple want to be able to modify/create/delete databases with tables, columns etc then use commands on them such as select * from table and just have them display the result.

Hmm that bold part is not true as I rather just work with the database in SQL2000 mode.

  • 0
  On 17/05/2010 at 15:24, alfaaqua said:

The lines on those pages though look like when I want to connect thru VB.

I simple want to be able to modify/create/delete databases with tables, columns etc then use commands on them such as select * from table and just have them display the result.

Download the free SQL 2008 db and management tools. The SQL Management Studio will let you connect to a local or remote server and open a query window.

  • 0

A SQL server installed as the default instance allows you to connect using the host name or IP address, e.g. MyServer. When you install a fully fledged Sql Server (not express), it by default will instance as the default instance.

A named instance requires an additional identifier, e.g. MyServer\MySqlInstance. Sql Server Express by default installs as a named instance I believe.

  • 0
  On 18/05/2010 at 10:07, Antaris said:

A SQL server installed as the default instance allows you to connect using the host name or IP address, e.g. MyServer. When you install a fully fledged Sql Server (not express), it by default will instance as the default instance.

A named instance requires an additional identifier, e.g. MyServer\MySqlInstance. Sql Server Express by default installs as a named instance I believe.

Im using the Enterprise Edition.

Could someone please talk me thru to at least make a new "instance"? :)

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • I see, yeah that makes sense. I have been in situations where I barely did not crush badly on the road due to other driver starting to change lanes into another car - freaked out last second and avoided it by crashing into the side of the bridge instead. i got away because I quickly changed lanes 2 times in a couple of second and unlike that idiot I did not lose control big part of this was my car was good 😊 (audi a7) vs the old van the crashed driver was driving would AI be able to react and quickly change lanes twice both time barely avoiding collision … I don’t know my car systems pumped the breaks and tried to warn me with a beep and vibration but if I slammed the breaks the car behind me would hit me then again I have BMW driver training and a good car - so I have no idea how robot taxi would react i am not sure extreme fast lane changes would be programmed in - it is dangerous as hell unless you are FULLY aware, and have done it before but it is a general risk to do it especially in the conditions with bad weather and when you are not driving a sports car with 4 wheel drive and very good control
    • PDF Arranger 1.12.1 by Razvan Serea PDF Arranger merges or splits PDF documents and rotates, crops and rearranges their pages using an interactive and intuitive graphical interface. It is a front end for pikepdf. It's available for Linux and Windows. PDF Arranger features: Merge double-sided scanned document Delete pages from a PDF file Rotate pages in a PDF file Merge multiple PDF documents Zoom in / out Export selected pages from a PDF Undo/redo support Duplicate PDF pages Crop white borders Supports importing encrypted PDF files Create a booklet from multiple pages Allow to edit Keywords, Subjects and dates in document info ...and more PDF Arranger 1.12.1 changelog: Fix incompatibility with Python 3.13.4 on Linux #1238 Update Dutch and Italian translation Download: PDF Arranger 1.12.1 | 42.6 MB (Open Source) Download: PDF Arranger Portable | PortableApps.com View: PDF Arranger Website | Other operating systems | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • If you can't sleep, work, or make out with your lady in the back of the car, then it isn't actually "full self driving"...and shouldn't be marketed lied about that way. It's actually just "driver assisted".
    • I’m happy to admit that I truly hate musk from the bottom of my heart. He provided me with PLENTY reasons.
    • AIMP 5.40 Build 2683 is out.
  • Recent Achievements

    • Collaborator
      CHUNWEI earned a badge
      Collaborator
    • Apprentice
      Cole Multipass went up a rank
      Apprentice
    • Posting Machine
      David Uzondu earned a badge
      Posting Machine
    • One Month Later
      Stokenking earned a badge
      One Month Later
    • One Month Later
      Kevin Jones earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      538
    2. 2
      ATLien_0
      262
    3. 3
      +Edouard
      193
    4. 4
      +FloatingFatMan
      177
    5. 5
      snowy owl
      135
  • Tell a friend

    Love Neowin? Tell a friend!