• 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

    • Intel's 20-core Ultra 7 processor is now available with a massive discount by Taras Buria The Intel Core Ultra 7 265K, Intel's latest 20-core desktop processor, is getting more affordable. Now, the chip is available on Amazon with a 36% discount, saving you $144, which you can spend on a higher-spec graphics card, better cooling, a bigger SSD, or some new games. If you want to build a computer with the discounted Intel Core Ultra 7 265K, you will need a motherboard with the LGA 1851 socket and 800 series chipset. The Core Ultra 7 265K has 20 cores, 8 of which are performance cores, and 12 are efficiency cores operating at lower clocks for less demanding tasks. Performance cores have the maximum clock speed of 5.4GHz, while efficiency cores peak at 4.6GHz. However, the processor is unlocked, which means you can push those clocks higher if you have enough cooling and a motherboard that supports overclocking. Speaking of cooling, the processor has a TDP of 125W. A cooler is not included in the box, so do not forget to add one to your shopping cart. The Intel Core Ultra 7 265K has 30MB of level 3 cache (L3). It works with DDR5 memory (rated for 6,400 MT/s) and has a built-in graphics at 2GHz, which is enough for image output, media consumption, and all sorts of tasks that do not require a lot of GPU power. There is also a neural processing unit with 13 TOPS, which can handle on-device AI processing. Intel Core Ultra 7 Desktop Processor 265K 5.5 GHz - $259.99 | $144 off on Amazon US This Amazon deal is US-specific and not available in other regions unless specified. If you don't like it or want to look at more options, check out the Amazon US deals page here. Get Prime (SNAP), Prime Video, Audible Plus or Kindle / Music Unlimited. Free for 30 days. As an Amazon Associate, we earn from qualifying purchases.
    • It's stuff like this countries like Denmark are giving up by switching to Linux. Good luck to them.
    • I think a big part of it is developers have grown themselves too big and ballooned their budgets. It's the only way to show endless growth to investors between releases. Then they make massive investments in games designed for the bottom line hoping players follow instead of designing them for the players and hoping the bottom line follow in the way smaller, indie developers do. This often causes the games to fail to hook players. Instead they need to streamline development, lower budgets and sales forecasts, actually listen to gamer feedback, realize that social media doesn't dictate real world gaming tastes and habits, and overall learn to adapt instead of regurgitating the same formulas over and over.
    • Yea, I don't buy new, I always wait for games to be on clearance. I thank those with money and time to waste for funding the fun I'll have for a fraction of the price.
  • Recent Achievements

    • Week One Done
      bukro earned a badge
      Week One Done
    • One Year In
      Wulle earned a badge
      One Year In
    • One Month Later
      Wulle earned a badge
      One Month Later
    • One Month Later
      Simmo3D earned a badge
      One Month Later
    • Week One Done
      Simmo3D earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      552
    2. 2
      ATLien_0
      243
    3. 3
      +FloatingFatMan
      166
    4. 4
      Michael Scrip
      121
    5. 5
      Steven P.
      95
  • Tell a friend

    Love Neowin? Tell a friend!