• 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

    • Microsoft updates Media Creation Tool with a newer Windows 11 release by Taras Buria If you want to download a Windows 11 image or create an install media, the Media Creation Tool app is one of the best options—simple, fast, and, more importantly, official. While there are other useful alternatives, such as Rufus, Media Creation Tool remains the default choice for those who simply want a clean Windows 11 installation on a supported computer. Thanks to the latest MCT update, you will have to deal with fewer updates after installing Windows 11. Microsoft has quietly updated the Media Creation Tool app so that it downloads the latest Windows 11 release, version 24H2, with build number 26100.4349. This is the most recent public Windows 11 update (June 2025 Patch Tuesday), which eliminates the need to download large updates for your PC after installing the operating system. You can download Media Creation Tool from the official Windows 11 website. If you are familiar with it, this simple app can generate a Windows 11 image with the language you need or create a bootable USB media. Note that it only works on Windows, so Linux or macOS users have to download Windows images directly from the official website and then use apps that are available on their platforms. Another thing worth noting is Media Creation Tool is not the right choice if you want to install Windows 11 on an unsupported PC. In such a case, you can use MCT to download an ISO and then create a modified install media with apps like Rufus or Ventoy as described in our dedicated guide. If you want a more exotic Windows 11 Edition, try the Oofhours Media Tool, which allows you to select Windows 10 or 11, architecture (x64, x86, or ARM64), language, and edition. In addition to standard Home and Pro, the application can download non-mainstream SKUs, such as Enterprise, Education, or Professional for Workstations. Via: Deskmodder
    • Putting premium on your higher end laptops really makes it feel like your lower end laptops are worse.
    • Funny enough just removed insta account and whatsapp is next. Less power needed now
    • If you only show the stop code and what failed for less than 2 seconds, what use is it?
    • How about using all that hot air Zuck spews? That surely can power something...
  • Recent Achievements

    • Conversation Starter
      Kavin25 earned a badge
      Conversation Starter
    • One Month Later
      Leonard grant earned a badge
      One Month Later
    • Week One Done
      pcdoctorsnet earned a badge
      Week One Done
    • Rising Star
      Phillip0web went up a rank
      Rising Star
    • One Month Later
      Epaminombas earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      538
    2. 2
      ATLien_0
      207
    3. 3
      +FloatingFatMan
      174
    4. 4
      Michael Scrip
      148
    5. 5
      snowy owl
      119
  • Tell a friend

    Love Neowin? Tell a friend!