• 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

    • Lets just hope they don't jump to an American corporation like RedHat.
    • Does today Linux still ask you to compile something for something to work? if Yes, lets wait for another 10 years.
    • No point really. I rarely get any responses to it. Btw, Bing is also an embarrassment for MS for the same reasons. The MS fans around here never engage as they have have no defence to it.
    • "Microsoft Trump" suite maybe something Trump regime will make it happen by blackmailing them.
    • MusicPod 2.13.0 by Razvan Serea MusicPod is a super simple app that lets you play your music, listen to podcasts, and stream internet radio—all in one place. Just open it, add your music files, or search for something cool to listen to. No complicated menus, no confusing settings—just play, pause, skip, and enjoy. It supports all the usual music formats like MP3, FLAC, and M4A, and it even remembers your favorite stuff. You can also find and follow podcasts, download episodes to listen offline, and browse radio stations by name, tag, or country. It looks clean, runs fast, and is totally free. MusicPod does the job without getting in your way. MusicPod key features: Supports major audio formats like MP3, FLAC, M4A, and MP4 Organizes your local music library by title, album, or artist Built-in podcast search, subscriptions, and offline downloads Stream internet radio by name, tag, or country Pin your favorite albums, podcasts, and stations Create and manage custom playlists Smart, minimalist interface that's easy to use Stream or download media Notifications for new podcast episodes Built with Flutter for smooth, cross-platform performance MusicPod 2.13.0 changelog: bring back blur as an option, add generated l10n, fix connectivity handler (#1324) (d04834d) Translated using Weblate (Chinese (Simplified Han script)) (#1310) (20003ff) Translated using Weblate (Swedish) (#1327) (5247d62) Translations update from Hosted Weblate (#1320) (84b5c00) Translations update from Hosted Weblate (#1322) (8e1a881) Translations update from Hosted Weblate (#1325) (8027f61) Translations update from Hosted Weblate (#1328) (358ff0f) Bug Fixes missing system color icon (#1333) (7346176), closes #1302 unify ways of presenting chips in the app (#1330) (da2a8f6) Download: MusicPod 2.13.0 | 28.6 MB (Open Source) Links: MusicPod Website | MacOs | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
  • Recent Achievements

    • First Post
      LsDmT earned a badge
      First Post
    • One Month Later
      evershinefacilityservice earned a badge
      One Month Later
    • Week One Done
      evershinefacilityservice earned a badge
      Week One Done
    • One Month Later
      POR2GAL4EVER earned a badge
      One Month Later
    • Week One Done
      Orpheus13 earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      569
    2. 2
      ATLien_0
      256
    3. 3
      +Edouard
      163
    4. 4
      +FloatingFatMan
      157
    5. 5
      Michael Scrip
      110
  • Tell a friend

    Love Neowin? Tell a friend!