Home > IT Answers > SQL Server > SQL server 2000 sp3 database remote access
Itdonsavi
30 pts.
 SQL server 2000 sp3 database remote access
Remote SQL Server, SQL Server 2000 SP3, SQL Server database
hi i want to access a sql server 2000 sp3 database in remote system where no sql server 2000 is installed. can anyone help me for this?

Software/Hardware used:
ASKED: April 9, 2010  6:27 PM
UPDATED: May 6, 2010  6:23 PM
RELATED QUESTIONS
Answer Wiki:
You have to have SQL Server installed on the server which has the data files installed on it. If SQL isn't installed on that server, you'll need to either install it, or more the database files to another server which already has SQL Server installed. You can then attach the database to that instance by using the sp_attach_db system stored procedure.
Last Wiki Answer Submitted:  April 11, 2010  5:51 am  by  Aguacer0   8,120 pts.
All Answer Wiki Contributors:  Aguacer0   8,120 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

How do you want to access it ? by means of an application ? If so, what type of application ?

carlosdl
 63,580 pts.
 

As to the prior answer, you can’t attach a SQL database over a mapped network drive. This would be an unsupported configuration, and SQL won’t let you do it.

Denny Cherry
 64,550 pts.
 

thanks to all who tried my problem…. i finished that project with my guides help…. thanks a lot to all

Itdonsavi
 30 pts.