MSDE to SQL2000

I would like to know if it's possible to transfer a database from MSDE to SQ
L 2000 with the use of sp_detach_db from MSDE and sp_attach_db tp SQL2000Yep. Just handle orphaned users afterwards. sp_change_users_logins or
http://dbmaint.com/SyncSqlLogins.asp.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:C3EE7F95-750A-4559-AC34-3D1514DA5919@.microsoft.com...
> I would like to know if it's possible to transfer a database from MSDE to
SQL 2000 with the use of sp_detach_db from MSDE and sp_attach_db tp SQL2000

MSDE to SQL2000

I would like to know if it's possible to transfer a database from MSDE to SQL 2000 with the use of sp_detach_db from MSDE and sp_attach_db tp SQL2000Yep. Just handle orphaned users afterwards. sp_change_users_logins or
http://dbmaint.com/SyncSqlLogins.asp.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:C3EE7F95-750A-4559-AC34-3D1514DA5919@.microsoft.com...
> I would like to know if it's possible to transfer a database from MSDE to
SQL 2000 with the use of sp_detach_db from MSDE and sp_attach_db tp SQL2000

MSDE SP4 install problem

I attempted to install MSDE SP4 (file SQL2000.MSDE-KB884525-SP4-x86-ENU) on a WinXP Pro SP2 machine.

Command used:

setup SAPWD="ourpw" SECURITYMODE=SQL /L*v c:\MSDELog.log

Install log shows successful install.

MSDE appears to function properly, service starts automatically after reboot, etc.

I can open and work with DB's with a freebie 3rd party GUI called DbaMGR2K, through which I have added the necessary DB user for our locally running ASP application to use the db.

However, when I try to use the DB with our locally running ASP application - connecting with ADO from a dll we wrote, I get the following:

"[DNETLIB]{ConnectionOpen (Connect()).]SQL Server does not exist or access denied"

Any help appreciated.

day10

Hi,

make sure that you connect to the same database and you are using a valid login for connecting. Perhaps you have chosen another authentication mode within the ADO code ? That could explain either the one or the other error message you are getting.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I think we have solved the issue. We used the SQL Server Network Utility to enable TCP/IP (apparently not enabled by default) and now all appears well.

I wonder if there is a way to enable TCP/IP during the install process. Is there an install flag/option?

|||

>> Is there an install flag/option?

Most likely. The flag for this when installing SP3 was "DISABLENETWORKPROTOCOLS=0". I wouldn't think that they would have removed it for SP4.

sql

MSDE prototyping

I haven't used MSDE yet. Does it run with an Enterprise Manager & Sql analyser interface?
I'm working on an asp.net vb project using sql2000. Users request me to create a protype for their review and training use. Can I deploy my project with only dlls forthe front end and an MSDE backend created from a script of the original Sql2000 database? Is there any potential discrepacy or problem with my prototyping plan? How can I copy my original database from sql2000 to msde?

Thanks for any help.Yes, Enterprise Manager and Query Analyzer can be interfaces to MSDE.

Yes, you can use MSDE as the back end for development but deploy to a SQL Server 2000 database.

When I mean "can" I mean "technically possible". I am not 100% sure of "legally possible". The licensing information for MSDE is fairly confusion, IMO.

The SQL Server 2000 Developer's edition is made specifically for situations like yours. It is $49.95 US and would give you the EM and QA tools plus the database. SeeDevelopment Edition Licensing.

I think the best way to transfer the data and schema would be to restore a backup.

Terri