about sql server

viral

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?

Marije_Brummel

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)

viral

thank you for reply

viral

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.

bbrown

What SQL Edition are you installing? Only Express and Developer will run on XP.

viral

i m trying to install standard edition. i also tried for enterprise edition.

bbrown

They don't run on XP.

kriki

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.

bbrown

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.

viral

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.

kriki

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.

viral

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

kriki

Strange, I didn't have any problems installing it.

Marije_Brummel

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.

SilverX

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

David_Singleton

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

viral

hello

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

Thank you to all