MSDE and installing MS SQL server 2000

Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE. I
read the installation manual but couldn't find the answer:-;
Question:
I've a server running MSDE latest patches etc.
I just purchaced MS SQL server 2000 standaard edition.
Does the installation of MS sql 2000 server takes care of copying and using
the old MSDE database(s)?
There is one application using MSDE with MSSQLSERVER as named instance, I
Think :-?
Or do i need to desintall MSDE?
Thanks for the time
Hi,
SQL Server standard edition Installation will not copy the existing
databases. Databases
you need to copy manually.
Easy approach is:-
1. Install SQL 2000 with same service pack in new machine as old
2. Stop MSSQL Server and SQL Agent service is Old server as well as in new
server
3. Copy MDF and LDF files to the new server (Incluing system databases -
Master, msdb, tempdb, model),
It is a must that you should copy the folders to same folders
as in old server
4. Start MSSQl Server service in new server
5. Login to Query Analyzer in new machine and change the SQL server name
select @.@.servername
-- The name should be old server name
Execute below script to change the server name, this step is no required
if you do not want to change server name.
sp_dropserver <servername>
go
sp_addserver <newserver_name>,local
6. Stop and start MSSQL Server and SQl agent service. Login to Enterprise
manager and see whether all your databases are up.
Note:
Ensure that you install the new SQL server with the same directory structure
as old and copy the MDF and LDF to the same folders. otherwise the database
will not come online.
You can also look into the below links to move the databases.
move the data via backup and restore
http://support.microsoft.com/default...;en-us;Q304692
sp_detach_db and sp_attach_db
http://support.microsoft.com/support.../q224/0/71.asp
one more option -- the copy database wizard
http://support.microsoft.com/default...;en-us;Q274463
PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
http://support.microsoft.com/default...;en-us;Q168001
Thanks
Hari
SQL Server MVP
"lau" <lau@.discussions.microsoft.com> wrote in message
news:66F50CDB-4DED-4E50-B7FE-45E0CE5AFCA4@.microsoft.com...
> Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE.
> I
> read the installation manual but couldn't find the answer:-;
> Question:
> I've a server running MSDE latest patches etc.
> I just purchaced MS SQL server 2000 standaard edition.
> Does the installation of MS sql 2000 server takes care of copying and
> using
> the old MSDE database(s)?
> There is one application using MSDE with MSSQLSERVER as named instance, I
> Think :-?
>
> Or do i need to desintall MSDE?
> Thanks for the time
>

MSDE and installing MS SQL server 2000

Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE. I
read the installation manual but couldn't find the answer:-;
Question:
I've a server running MSDE latest patches etc.
I just purchaced MS SQL server 2000 standaard edition.
Does the installation of MS sql 2000 server takes care of copying and using
the old MSDE database(s)?
There is one application using MSDE with MSSQLSERVER as named instance, I
Think :-?
Or do i need to desintall MSDE?
Thanks for the timeHi,
SQL Server standard edition Installation will not copy the existing
databases. Databases
you need to copy manually.
Easy approach is:-
1. Install SQL 2000 with same service pack in new machine as old
2. Stop MSSQL Server and SQL Agent service is Old server as well as in new
server
3. Copy MDF and LDF files to the new server (Incluing system databases -
Master, msdb, tempdb, model),
It is a must that you should copy the folders to same folders
as in old server
4. Start MSSQl Server service in new server
5. Login to Query Analyzer in new machine and change the SQL server name
select @.@.servername
-- The name should be old server name
Execute below script to change the server name, this step is no required
if you do not want to change server name.
sp_dropserver <servername>
go
sp_addserver <newserver_name>,local
6. Stop and start MSSQL Server and SQl agent service. Login to Enterprise
manager and see whether all your databases are up.
Note:
Ensure that you install the new SQL server with the same directory structure
as old and copy the MDF and LDF to the same folders. otherwise the database
will not come online.
----
--
You can also look into the below links to move the databases.
move the data via backup and restore
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q304692
sp_detach_db and sp_attach_db
http://support.microsoft.com/support/kb/articles/q224/0/71.asp
one more option -- the copy database wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463
PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q168001
Thanks
Hari
SQL Server MVP
"lau" <lau@.discussions.microsoft.com> wrote in message
news:66F50CDB-4DED-4E50-B7FE-45E0CE5AFCA4@.microsoft.com...
> Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE.
> I
> read the installation manual but couldn't find the answer:-;
> Question:
> I've a server running MSDE latest patches etc.
> I just purchaced MS SQL server 2000 standaard edition.
> Does the installation of MS sql 2000 server takes care of copying and
> using
> the old MSDE database(s)?
> There is one application using MSDE with MSSQLSERVER as named instance, I
> Think :-?
>
> Or do i need to desintall MSDE?
> Thanks for the time
>

MSDE and installing MS SQL server 2000

Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE. I
read the installation manual but couldn't find the answer:-;
Question:
I've a server running MSDE latest patches etc.
I just purchaced MS SQL server 2000 standaard edition.
Does the installation of MS sql 2000 server takes care of copying and using
the old MSDE database(s)?
There is one application using MSDE with MSSQLSERVER as named instance, I
Think :-?
Or do i need to desintall MSDE?
Thanks for the timeHi,
SQL Server standard edition Installation will not copy the existing
databases. Databases
you need to copy manually.
Easy approach is:-
1. Install SQL 2000 with same service pack in new machine as old
2. Stop MSSQL Server and SQL Agent service is Old server as well as in new
server
3. Copy MDF and LDF files to the new server (Incluing system databases -
Master, msdb, tempdb, model),
It is a must that you should copy the folders to same folders
as in old server
4. Start MSSQl Server service in new server
5. Login to Query Analyzer in new machine and change the SQL server name
select @.@.servername
-- The name should be old server name
Execute below script to change the server name, this step is no required
if you do not want to change server name.
sp_dropserver <servername>
go
sp_addserver <newserver_name>,local
6. Stop and start MSSQL Server and SQl agent service. Login to Enterprise
manager and see whether all your databases are up.
Note:
Ensure that you install the new SQL server with the same directory structure
as old and copy the MDF and LDF to the same folders. otherwise the database
will not come online.
----
--
You can also look into the below links to move the databases.
move the data via backup and restore
http://support.microsoft.com/defaul...b;en-us;Q304692
sp_detach_db and sp_attach_db
http://support.microsoft.com/suppor...s/q224/0/71.asp
one more option -- the copy database wizard
http://support.microsoft.com/defaul...b;en-us;Q274463
PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
http://support.microsoft.com/defaul...b;en-us;Q168001
Thanks
Hari
SQL Server MVP
"lau" <lau@.discussions.microsoft.com> wrote in message
news:66F50CDB-4DED-4E50-B7FE-45E0CE5AFCA4@.microsoft.com...
> Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE.
> I
> read the installation manual but couldn't find the answer:-;
> Question:
> I've a server running MSDE latest patches etc.
> I just purchaced MS SQL server 2000 standaard edition.
> Does the installation of MS sql 2000 server takes care of copying and
> using
> the old MSDE database(s)?
> There is one application using MSDE with MSSQLSERVER as named instance, I
> Think :-?
>
> Or do i need to desintall MSDE?
> Thanks for the time
>

MSDE and Enterprise Manager?

I am a complete sql newbie! For the life of me I can't figure out how to get Enterprise Manager to connect with MSDE. Something about mixed mode or tcp/ip settings? But no one's ever really clear on how to do these things. I've uninstalled MSDE until I can get more info.

I just need a quick walk-through on how to install msde to work with EM. This is what I used when MSDE requested a strong password:

setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"

Is this correct? Any help would be appreciated.

Thanks.

You access it by address or servername + \ + Instance name:

Server\MSDEInstanceName

|||

What part are you having a problem with?

Tell EM to connect to the server\instancename using sql authentication login sa, password AStrongPWD.

|||If you have the full SQL Server installed then you install the MSDE as a named instance and right click at the top of the Enterprise manager of the full version to register the MSDE and you can manage it directly. If you have the MSDE installed then you install the full version as a named instance and repeat the above. I have registered 68 SQL Server 7/2000 in one XP box so if you have more questions post again. Hope this helps.|||

Thanks to everyone for their help.

I had the eval version of 2000 installed but it's expired. I would now like to use EM with MSDE to connect to the database on my website. I re-installed MSDE but it's only showing the local database.

When I try to register my online domain (ip address) it fails. Says sql may not be running. But it is running. I know it's something basic and silly I'm not doing, but I'm still very new to sql. Is there any other very basic step I may be missing?

Again, thanks for everyone's help...sorry for all the newbie questions.

|||

Which is probably correct because your SQL Server service maybe off, the developer edition is $40 in the link below but you could get it for less because when you are using hosting company you need Enterprise manager. Hope this helps.

http://www.provantage.com/buy-22053391-microsoft-backoffice-sql-server-2000-developer-edition-shopping.htm

MSDE 2000 Administration tool

Hi all,

I have installed MSDE on my computer but it's missing, as all you already
know, a serious (well, osql IS TOO serious but not very newbie friendly)
admin tool.

I have downloaded http://www.asql.biz/DbaMgr.shtm and i'm quite happy with
it but was wondering if there's something better or that may complete what
DbaMgr2k is missing... and preferably is as free as DbaMgr2k.

Thank You,
LorenzoHi

There is a list at:
http://www.aspfaq.com/show.asp?id=2442

John

"Lorenzo Bolognini" <lorenzo@.mysurname.net> wrote in message
news:pkd_a.43324$an6.1479482@.news1.tin.it...
> Hi all,
> I have installed MSDE on my computer but it's missing, as all you already
> know, a serious (well, osql IS TOO serious but not very newbie friendly)
> admin tool.
> I have downloaded http://www.asql.biz/DbaMgr.shtm and i'm quite happy with
> it but was wondering if there's something better or that may complete what
> DbaMgr2k is missing... and preferably is as free as DbaMgr2k.
> Thank You,
> Lorenzo|||Thank you very much John.

Lorenzo

Msde

Hi Yar,

This might seem like a silly question but please bare with a newbie. I've discovered a few MSDE installations around the place, & most are on a RTM version. I know no -one else cares about them as they came with small apps. But I would like someone to confirm or deny that they are just as vunerable as any other SQL installation i.e. std edition & should apply the Service Packs ?

Cheers
SuzeA) yes

B) yes|||i'll be keeping my clothes on, 'cause i hardly know you

:)|||Although I've never tried it, I don't think that MSDE will even allow the service to start on Windoze XP without SQL sp3. Yes, without any shadow of doubt, you should apply SQL service packs to MSDE!

-PatP|||Unlike SQL Server, MSDE has been updated to include SP3. So if its a somewhat new installation it should be patched.|||@.ebola: Suze noted on her original post that "most are on a RTM version". So I assumed these are no freshly installed (wiht SP3 included), but rather some older installations (what Suze had found out with osql - "select @.@.server_version") or something like that.

I only was regarding/answering exactly this scenario

@.Rudy: Sorry, I'm not a native english speaker - I didn't quite get your comment ? Could you please elaborate a bit ? Did I offend someone in any way ?
Didn't mean to .. If it was the case, I apologize|||Thank you for the replies chaps, I'll get to work on those updates & the laugh for the morning !!! :-)|||bare = uncover, unsheathe, reveal, strip (i.e. remove clothing)

bear = carry, sustain; bear with = treat forbearingly (i.e. be patient)

:)|||Ohhhh now I see - thank you Rudy for your translation help - I hadn't seen THAT typo ...;)

MSDE

hey everybody.

I am trying to become a newbie at DNN, but in order to do that i need to setup MSDE. Can someone tell me how to set that up correctly. Any information on how to install MSDE, how to setup MSDE, and how to configure the permissions so that i have them set correctly.

Thanks

--AdamCheckthis for download location and steps to set up MSDE.

Hope that helps
Kashif