• 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

    • Consumer Reports is flat out wrong. Wouldn't be the first time it's a fact that when you have more moving parts, you have more room for failure. Less points of failure when all you replace on an EV is the tires and the wipers.
    • WYSIWYG Web Builder 20.2.2 by Razvan Serea Web Buialder is a WYSIWYG (What-You-See-Is-What-You-Get) program used to create complete web sites. WYSIWYG means that the finished page will display exactly the way it was designed. The program generates HTML (HyperText Markup Language) tags while you point and click on desired functions; you can create a web page without learning HTML. Just drag and drop objects to the page position them "anywhere" you want and when youre finished publish it to your web server (using the build in Publish tool). Web Builder gives you full control over the content and layout of your web pages. One Web Builder project file can hold multiple web pages. Desktop publishing for the web, build web sites as easy as Drag & Drop "One Click Publishing" No FTP program needed. No special hosting required, use with any Hosting Service! Easily create forms using the built-in Form Wizard plus Form validation tools and built-in CAPTCHA. Advanced graphics tools like shapes, textart, rotation, shadows and many other image effects. Fully integrated jQuery UI (Accordion, Tabs etc), animations, effects and built-in ThemeRoller theme editor. Google compatible sitemap generator / PayPal eCommerce Tools Many navigation tools available: Navigation bars, tab menus, dropdown menus, sitetree, slidemenus. Built-in Slide Shows, Photo Galleries, Rollover images, Banners etc. Support for YouTube, Flash Video, Windows Media Player and many other video formats. Unique extension (add-on) system with already more than 250 extensions available! Create HTML5 / CSS3 websites today HTML5 document type (optimized HTML5 output). HTML5 audio/video and YouTube HTML5 support. HTML5 forms: native form validation, new input types and options, web storage. HTML5 canvas and svg support in shapes and other drawing tools. CSS3 @font-face. Use non web safe fonts in all modern browsers. CSS3 opacity, border radius, box shadow. CSS3 gradients. Add cool gradient effects using native CSS3 (no images). CSS3 navigation menu. Create awesome menus without using JavaScript or images. CSS3 animations and transitions. Including support for 2D and 3D transforms! Features for advanced users: Login Tools/Page Password Protection. Built-in Content Management System with many plug-ins (guestbook, faq, downloads, photo album etc). Add custom HTML code with the HTML tools. JavaScript Events: Show/hide objects (with animation), timers, move objects, change styles etc. Layers: Sticky layer, Docking layer, Floating layer, Modal layer, Anchored layer, Strechable layer and more! jQuery Theme Manager, create your own themes for the built-in jQuery UI widgets. Style Manager (global styling, H1, H2, H3 etc). Master Frames and Master Objects: reuse common element in your website. and much more! WYSIWYG Web Builder 20.2.2 changelog: Improved: Minor change in HTML formatting of the Overlay Menu. Fixed: Issue with aspect ratio of HTML Video. Download: WYSIWYG Web Builder 64-bit | 30.1 MB (Shareware) Download: WYSIWYG Web Builder 32-bit | 28.0 MB Screenshot: >> Click here << Link: Home Page | Templates | Free extras/addons | Changelog Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • You are like that narcissistic moron and his name is Paul Thurrott.
  • Recent Achievements

    • Collaborator
      Mighty Pen went up a rank
      Collaborator
    • Week One Done
      emptyother earned a badge
      Week One Done
    • Week One Done
      DarkWun earned a badge
      Week One Done
    • Very Popular
      valkyr09 earned a badge
      Very Popular
    • Week One Done
      suprememobiles earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      568
    2. 2
      +FloatingFatMan
      188
    3. 3
      ATLien_0
      177
    4. 4
      Skyfrog
      111
    5. 5
      Xenon
      110
  • Tell a friend

    Love Neowin? Tell a friend!