• 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

    • That trigger travel before actuation is a major turn off for me.
    • This ChatGPT & Automation E-Degree has been price dropped even further by Steven Parker Today's highlighted deal comes via our Online Courses section of the Neowin Deals store, where for only a limited time you can save 97% on this ChatGPT & Automation E-Degree. Immerse yourself in a transformative learning experience with these 12 captivating courses, featuring over 25 hours of engaging content that will redefine the way you perceive the digital landscape. Embrace the future with ChatGPT and unlock the potential of more than 20 indispensable AI tools tailored for today's dynamic challenges in marketing, business, and coding. Embark on a journey of skill enhancement and future-proof your career with our e-degree. Get ready to shape the future with knowledge, innovation, and the best AI tools available today! Access 12 lectures & 25 hours of content 24/7 Explore practical applications & real-world scenarios tailored to your professional domain Gain valuable experience that can be directly applied to your professional endeavors Learn the art of customization as you tailor ChatGPT to meet the unique demands of various industries Unleash your full potential in diverse professional settings Master the art of streamlining business processes through automation, enhancing efficiency, and ensuring optimal resource utilization Gain insights into powerful techniques that transform raw data into compelling visual narratives Discover how AI can amplify your creativity & contribute to groundbreaking projects Elevate your communication skills by mastering conversations with ChatGPT Explore the intersection of AI & data visualization Gray Scale Photo of Gears via PexelsGood to know Length of time users can access this course: lifetime Access options: desktop & mobile Redemption deadline: redeem your code within 30 days of purchase Experience level required: beginner Updates included Certificate of Completion ONLY Lifetime access to the ChatGPT & Automation E-Degree normally costs $790, but you can pick it up for just $19.97 for a limited time, that's a saving of $770 (97%) off the normal price! For full details, terms, and instructor info for the above courses, click the link below. Get this ChatGPT & Automation E-Degree course for just $19.97, or learn more Although priced in U.S. dollars, this deal is available for digital purchase worldwide. We post these because we earn commission on each sale so as not to rely solely on advertising, which many of our readers block. It all helps toward paying staff reporters, servers and hosting costs. Other ways to support Neowin Whitelist Neowin by not blocking our ads Create a free member account to see fewer ads Make a donation to support our day to day running costs Subscribe to Neowin - for $14 a year, or $28 a year for an ad-free experience Disclosure: Neowin benefits from revenue of each sale made through our branded deals site powered by StackCommerce.
    • Before I reached the comment section, when I first saw the image, I thought, "That's perfect." Finding a suitable image for an article you write, that's roalty free, sucks and was the part I hated the most.
    • Why? I wrote for neowin for a while and I can tell you, the hardest part is finding a thumbnail. If I could have had an AI create one that fit my topic perfectly ,I would have. I think the image they chose is perfect.
  • Recent Achievements

    • Community Regular
      Primey_ went up a rank
      Community Regular
    • Reacting Well
      Gromvar earned a badge
      Reacting Well
    • Dedicated
      BreakingBenjamin earned a badge
      Dedicated
    • Week One Done
      Hartej earned a badge
      Week One Done
    • One Year In
      TsunadeMama earned a badge
      One Year In
  • Popular Contributors

    1. 1
      +primortal
      520
    2. 2
      +FloatingFatMan
      180
    3. 3
      ATLien_0
      166
    4. 4
      Skyfrog
      105
    5. 5
      Som
      98
  • Tell a friend

    Love Neowin? Tell a friend!