about sql server

viral
viral Member Posts: 23
edited 2008-09-20 in SQL General
hello

i have problem like this. i have database on my local machine. i want to attach that data base to sql server 2005 on different machine. i dont want to shift my database there. i just want to attach database

is it possible? how?
Viral Rami

Comments

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    That is not possible. SQL only uses direct attached drives.

    You can play around witht he SQL Cluster manager and try to make SQL think it is a storage but that would be time consuming. (I've never tried it myself)
    Marije Brummel | Freelance Business Central Specialist
  • viral
    viral Member Posts: 23
    thank you for reply
    Viral Rami
  • viral
    viral Member Posts: 23
    hello

    i m trying to install sql server 2005 on my machine. My OS is xp.
    is there any problem with that?
    while installing it gives errors
    1. MSXML6 is failed.
    2. Data base service failed.

    how to solve this problem??
    i m using first time sql server.
    Viral Rami
  • bbrown
    bbrown Member Posts: 3,268
    What SQL Edition are you installing? Only Express and Developer will run on XP.
    There are no bugs - only undocumented features.
  • viral
    viral Member Posts: 23
    i m trying to install standard edition. i also tried for enterprise edition.
    Viral Rami
  • bbrown
    bbrown Member Posts: 3,268
    They don't run on XP.
    There are no bugs - only undocumented features.
  • kriki
    kriki Member, Moderator Posts: 9,121
    bbrown wrote:
    They don't run on XP.
    Actually I have standard edition SQL2005 on my XP SP3 (installed SQL2005 when my XP was still on SP2) portable and it works fine.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • bbrown
    bbrown Member Posts: 3,268
    Interesting. I've never actually tried it. I just use the developer's edition on my laptop. Not surprised that it would run. But I don't think MS would support it on XP.
    There are no bugs - only undocumented features.
  • viral
    viral Member Posts: 23
    hi
    kriki

    i have xp sp2. may be because of its giving error
    when i m starting installing sql server its give 2 warning.
    after that setup is failed n give message like MS SQL SERVER cant install on ur computer.

    well actually i want to use my local database n want to attact with sql server(other machine). i dont think so its possible.
    Viral Rami
  • kriki
    kriki Member, Moderator Posts: 9,121
    It is possible to install standard SQL2005 on your portable.

    But it is not possible to have some SQL-DB-files on YOUR computer and they being attached on a SQL-server running on another machine. The files MUST be local to the machine otherwise SQL-server refuses it.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • viral
    viral Member Posts: 23
    hi
    kriki

    i tried to install sql server 2005(std) on my machine. but it gives error of MSXML6 setup failed, and other errors also.

    n thanks for reply
    Viral Rami
  • kriki
    kriki Member, Moderator Posts: 9,121
    Strange, I didn't have any problems installing it.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    At our company we all have either standard or enterprise running on windows XP, vista, 2003 and 2008. No problem.

    We also have the sql tools on our 2008 terminal server as distributed programs. Works exelent.
    Marije Brummel | Freelance Business Central Specialist
  • SilverX
    SilverX Member Posts: 134
    As an answer to your initial question: It is possible to attach databases on network shares. But it is not supported by microsoft. I've never used or tested this myself, but I came across this article recently.

    http://support.microsoft.com/kb/304261/en-us
    Cheers
    Carsten


    ==> How To Ask Questions The Smart Way
    This post is my own opinion and does not necessarily reflect the opinion or view of my employer.
  • David_Singleton
    David_Singleton Member Posts: 5,479
    viral wrote:
    hello

    i have problem like this. i have database on my local machine. i want to attach that data base to sql server 2005 on different machine. i dont want to shift my database there. i just want to attach database

    is it possible? how?

    Why :-k
    David Singleton
  • viral
    viral Member Posts: 23
    hello

    finally i managed to install Standard Edition 2005 on my PC XP Sp2. Its working fine.

    Thank you to all
    Viral Rami

Categories