Migrating Data from MsAccess

Hello
I'm trying to migrate the data from Access to MSDE database.
What is the easiest and most efficent method of doing it.
Also the AutoNumber field from Access, how does that move over to MSDE ?
Any help would be appreciated.
Thanks
Hemang
"Hemang Shah" <hemang@.hemang.net> wrote in message
news:YNSdneSqD-fQkGzcRVn-2A@.rogers.com...
> Hello
> I'm trying to migrate the data from Access to MSDE database.
> What is the easiest and most efficent method of doing it.
> Also the AutoNumber field from Access, how does that move over to MSDE ?
> Any help would be appreciated.
> Thanks
> Hemang
>
|||Buy Microsoft SQL Server Developers Version (if you don't already have it)
and use Enterprise Manager and the data import wizard to import your Access
data. Dealing with an AutoNumber column is easy, define your destination
columns as an IDENTITY column and allow identity insert when importing the
data.
Jim
"Hemang Shah" <hemang@.hemang.net> wrote in message
news:YNSdneSqD-fQkGzcRVn-2A@.rogers.com...
> Hello
> I'm trying to migrate the data from Access to MSDE database.
> What is the easiest and most efficent method of doing it.
> Also the AutoNumber field from Access, how does that move over to MSDE ?
> Any help would be appreciated.
> Thanks
> Hemang
>
|||Thanks Jim
Can you import to a MSDE database from Enterprise Manager ? Will that
database still be portable to MSDE ?
Thanks
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:e$s2eN9$EHA.2552@.TK2MSFTNGP09.phx.gbl...
> Buy Microsoft SQL Server Developers Version (if you don't already have it)
> and use Enterprise Manager and the data import wizard to import your
> Access data. Dealing with an AutoNumber column is easy, define your
> destination columns as an IDENTITY column and allow identity insert when
> importing the data.
> Jim
> "Hemang Shah" <hemang@.hemang.net> wrote in message
> news:YNSdneSqD-fQkGzcRVn-2A@.rogers.com...
>
|||hi Hemang
Hemang Shah wrote:
> Thanks Jim
> Can you import to a MSDE database from Enterprise Manager ? Will that
> database still be portable to MSDE ?
>
SQL Server 2000 and MSDE 2000 share the same engine, as they are only
different edition of the same product, so MSDE database can be used by SQL
Server, but SQL Server dbs can be used by MSDE depending on it's limitation
on size...
regards
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea
I used the upsized wizard of ms Access and it created a new database for me
in SQL and also retained the relationships and data, it was a breeze!
Thank You
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:35f9qhF4ispi8U1@.individual.net...
> hi Hemang
> Hemang Shah wrote:
> SQL Server 2000 and MSDE 2000 share the same engine, as they are only
> different edition of the same product, so MSDE database can be used by SQL
> Server, but SQL Server dbs can be used by MSDE depending on it's
> limitation
> on size...
> regards
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
sql

Migrating an Access Database to MSDE

I'm very new to MSDE, so this may be a basic question but I've been unable
to find a solution.
Is it possible to migrate a database from Access to a Sqldatabase in MSDE?
If so, how? The Access Upsize Wizard doesn't seem to do it?
Thanks in advance.
The Access upsize wizard should move the data but not much more. You can
also use DTS to import Access/JET database. Unfortunately, an "Access" JET
database also contains, forms, reports, macros and other "stuff" that is
lost when you move to MSDE. The Access application itself also uses
techniques that don't migrate well and don't take advantage of SQL Server's
power.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Tom Wing" <biciwing@.optonline.net> wrote in message
news:c6m7d.22354$kq6.12187878@.news4.srv.hcvlny.cv. net...
> I'm very new to MSDE, so this may be a basic question but I've been unable
> to find a solution.
> Is it possible to migrate a database from Access to a Sqldatabase in MSDE?
> If so, how? The Access Upsize Wizard doesn't seem to do it?
> Thanks in advance.
>
sql

Migrate mySQL to MSDE

Hi,
I'd like to migrate a mySQL database to MSDE (developpement
purpose only). Is there any way/tools/scripts I could use
to do that ?
TIA
JAM
Get the Developers Edition of SQL Server. It's only $49 US or less.
With it you will have all the tools and documentation you need for importing
from just about any datasource.
Jim
"Jam" <anonymous@.discussions.microsoft.com> wrote in message
news:1286801c411a3$e17a8120$a501280a@.phx.gbl...
> Hi,
> I'd like to migrate a mySQL database to MSDE (developpement
> purpose only). Is there any way/tools/scripts I could use
> to do that ?
> TIA
> JAM
|||Hi Jam,

> I'd like to migrate a mySQL database to MSDE (developpement
> purpose only). Is there any way/tools/scripts I could use
> to do that ?
Download yourself a copy of "Database Workbench" from
www.upscene.com
It includes a Schema Migrator tool - that should get you started.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

Migrate MSDE data to SQL 2000

I have local copy of MSDE 2000 on an XP workstation.
My program has already been reconfigured to point to a remote (from the XP
viewpoint) SQL 2000 server. As such, it has created the 2 databases that it
uses and is already populating those databases with data.
The question is, how do I get the "old" data from MSDE on the XP box into
the "new" databases on the remote SQL server?
When I try to use DTS and choosing the default of OLE Provider for SQL for
the source, I can't connect to the XP MSDE, which is using SQL Auth. I know
I am using the correct "sa" password for the MSDE database.
Robert
You have a few options: DTS, Detatch/Reattach, or Backup/Restore.
I prefer to backup on the old server, copy the backup file to the new
server, and restore it on the new server. This is fairly easy to do. Just
make sure you create the users from the old server on the new server first,
and then run sp_change_users_login to eliminate orphaned users after you do
the restore.
"Robert Gandrud" wrote:

> I have local copy of MSDE 2000 on an XP workstation.
> My program has already been reconfigured to point to a remote (from the XP
> viewpoint) SQL 2000 server. As such, it has created the 2 databases that it
> uses and is already populating those databases with data.
> The question is, how do I get the "old" data from MSDE on the XP box into
> the "new" databases on the remote SQL server?
> When I try to use DTS and choosing the default of OLE Provider for SQL for
> the source, I can't connect to the XP MSDE, which is using SQL Auth. I know
> I am using the correct "sa" password for the MSDE database.
> Robert
|||As far as I know, the only user is the "sa" user in the old MSDE database.
What then?
"Dan" wrote:
[vbcol=seagreen]
> You have a few options: DTS, Detatch/Reattach, or Backup/Restore.
> I prefer to backup on the old server, copy the backup file to the new
> server, and restore it on the new server. This is fairly easy to do. Just
> make sure you create the users from the old server on the new server first,
> and then run sp_change_users_login to eliminate orphaned users after you do
> the restore.
> "Robert Gandrud" wrote:
|||hi Robert,
Robert Gandrud wrote:
> I have local copy of MSDE 2000 on an XP workstation.
> My program has already been reconfigured to point to a remote (from
> the XP viewpoint) SQL 2000 server. As such, it has created the 2
> databases that it uses and is already populating those databases with
> data.
> The question is, how do I get the "old" data from MSDE on the XP box
> into the "new" databases on the remote SQL server?
> When I try to use DTS and choosing the default of OLE Provider for
> SQL for the source, I can't connect to the XP MSDE, which is using
> SQL Auth. I know I am using the correct "sa" password for the MSDE
> database.
>
MSDE installs by default disabling network protocols...in order to them
after installation you have to run the
Server Network Utility (svrnetcn.exe) and enabling the desired
protocol(s)...
Win XP Windows Firewall could be an issue too and please have a look at
http://support.microsoft.com/kb/841251/en-us in order to enable remote
connectivity...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

Migrate MSDE 2000 to SQL 2000

I would like to know how I can move current MSDE 2000
database to SQL 2000 database. I want to put all
databases on my 1 SQL server.
Thanks.
The simplist way to do this is to backup and restore the databases to your
new server. You will then need to add any SQL Server logins to your new
server that are users in your databases. Then run sp_change_users_login (see
BOL) to synch the database users with the logins.
Jim
"SQL_Newbie" <anonymous@.discussions.microsoft.com> wrote in message
news:12dc01c50419$1e354bf0$a601280a@.phx.gbl...
>I would like to know how I can move current MSDE 2000
> database to SQL 2000 database. I want to put all
> databases on my 1 SQL server.
> Thanks.

Migrate from Access to MSDE

Hi,
We have been using VB and Access to collect our date for several years.
Now our Access database is reaching 2 gb and we will soon have to switch to
sql server.
As intermediate step I downloaded MSDE2000 relA and istalled it.
I tried to use "Upsizing Wizard" but at the end, even if let me go trough to
process, it does not create the project file.
What do I do wrong?
Thank you
You have the same size limitations in MSDE as you do in Access. Your
MSDE database will actually be larger than it would be in Access due
to the increased overhead involved in SQL Server, but it's not clear
if that is a problem or not since you have not posted any error
messages. You can get more information about the upsizing wizard and
its many points of failure from the upsizing whitepaper, available at
http://support.microsoft.com/default...en-us;q294407.
--Mary
On Thu, 26 Aug 2004 11:39:06 -0700, "WilliamD"
<WilliamD@.discussions.microsoft.com> wrote:

>Hi,
>We have been using VB and Access to collect our date for several years.
>Now our Access database is reaching 2 gb and we will soon have to switch to
>sql server.
>As intermediate step I downloaded MSDE2000 relA and istalled it.
>I tried to use "Upsizing Wizard" but at the end, even if let me go trough to
>process, it does not create the project file.
>What do I do wrong?
>Thank you
|||I know about size limitations, but I would like to get more familiar with
SQLServer (before we have to migrate in few months), using MSDE. Then I
believe it would take no effort to migrate to SQL Server, is that right?
I tried Upsizing Wizard with a small database with only 2 tables. I did get
no error message, but Access did not created the project file. Into the
upsizing report, that is created at the end, for each table it says "skipped".
"Mary Chipman" wrote:

> You have the same size limitations in MSDE as you do in Access. Your
> MSDE database will actually be larger than it would be in Access due
> to the increased overhead involved in SQL Server, but it's not clear
> if that is a problem or not since you have not posted any error
> messages. You can get more information about the upsizing wizard and
> its many points of failure from the upsizing whitepaper, available at
> http://support.microsoft.com/default...en-us;q294407.
> --Mary
> On Thu, 26 Aug 2004 11:39:06 -0700, "WilliamD"
> <WilliamD@.discussions.microsoft.com> wrote:
>
>
|||Hi William,
I'd strongly suggest you get a copy of the developer edition of sql server.
It's about $49 USD and provides a whole raft of tools that will be useful to
you. You might have more luck using SQL Enterprise Manager to import your
tables, etc. from your Access databases. You get a lot more control and can
see a lot more of what's going on.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"WilliamD" <WilliamD@.discussions.microsoft.com> wrote in message
news:AFE56A8D-9A3C-4E00-AB07-52D07D986C0A@.microsoft.com...
> I know about size limitations, but I would like to get more familiar with
> SQLServer (before we have to migrate in few months), using MSDE. Then I
> believe it would take no effort to migrate to SQL Server, is that right?
> I tried Upsizing Wizard with a small database with only 2 tables. I did
get
> no error message, but Access did not created the project file. Into the
> upsizing report, that is created at the end, for each table it says
"skipped".[vbcol=seagreen]
> "Mary Chipman" wrote:
switch to[vbcol=seagreen]
trough to[vbcol=seagreen]
|||Did you read the upsizing whitepaper? It tells you why the wizard
skips tables, which it does for a myriad of reasons. I'd definitely
follow Greg's recommendation to purchase the Developer edition to
familiarize yourself with SQL Server. You can use it to develop a
solution which you then deploy using MSDE (the license agreement
prohibits using the Dev edition on a production server). Access/MSDE
alone do not have the capability to develop applications and neither
are much use in learning SQL Server.
--Mary
On Mon, 30 Aug 2004 16:51:03 -0700, "WilliamD"
<WilliamD@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I know about size limitations, but I would like to get more familiar with
>SQLServer (before we have to migrate in few months), using MSDE. Then I
>believe it would take no effort to migrate to SQL Server, is that right?
>I tried Upsizing Wizard with a small database with only 2 tables. I did get
>no error message, but Access did not created the project file. Into the
>upsizing report, that is created at the end, for each table it says "skipped".
>"Mary Chipman" wrote:

Migrate DB from MSDE to Sql Server 2005 Express

Hi - is it possible to migrate to SQL Server 2005 Express from MSDE - and still use ASP.Net 1.1? Or will Express only work with ASP.Net 2.0?
My MSDE database has simple SPs (no functions), and straight forward tables - can I just use DTS from Enterprise Manager to transfer this from MSDE to SQL Express, or create a backup, and import that into SQL Express 2005?
Also, there was a sort of Enterprise Manager available for SQL Server 2005 Express at one point - does anyone know where to find that?
Thanks for any pointers/help.
MarkSQL Server Express comes with Express manager a separate install but I don't think the new DTS Integration Services is part of it but the product is still in beta so download the developer edition and use the integration services to do the migration. The management studio the replacement of Enterprise manager is a separate install under management tools. Try the thread below to download the developer edition. Hope this helps.
http://forums.asp.net/1069636/ShowPost.aspx|||

Hi - thank you Caddre.

Can I still use the old ASP.Net 1.1 framwework with the SQL Server 2005 Express though? Or will it only work with .Net2?

Thanks, Mark

|||SQL Server 2005 Express was released July 29, 2004 with Asp.net 2.0 for public beta 1 so I am sure you can use it with Asp.net 1.1. All you need is permissions and connection string, try the link below for Microsoft provided tutorial. Hope this helps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/paght000010.asp|||Hi.
When I tried the SQL Express beta earlier this year, I had some troubleconnecting to the database from a ASP.NET 1.1 application.
I found out that (at least in my environment) I had to connect to thedatabase using tcp/ip. In may case (the database was on the samemachine as the ASP.NET application) I used Server=127.0.0.1,1433instead of Server=(local) in the connection string.
It should also be possible to use Server=servername,portnumber instead of hard coding theip number.

Migrate database from SQL2005 to SQL 2000 (or MSDE)

Hi,
Is it possible to do? (how to do it)
I've tied to do backup and thet to restore it but it hasn't work.
Regards
KrisHi
No, the backup and data files are not compatible when going from 2005 to 200
0.
You have to script the schema and data out and run it against 2000.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kris" wrote:

> Hi,
> Is it possible to do? (how to do it)
> I've tied to do backup and thet to restore it but it hasn't work.
> Regards
> Kris

Migrate database from SQL2005 to SQL 2000 (or MSDE)

Hi,
Is it possible to do? (how to do it)
I've tied to do backup and thet to restore it but it hasn't work.
Regards
KrisHi
No, the backup and data files are not compatible when going from 2005 to 2000.
You have to script the schema and data out and run it against 2000.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kris" wrote:
> Hi,
> Is it possible to do? (how to do it)
> I've tied to do backup and thet to restore it but it hasn't work.
> Regards
> Kris

Migrate database from SQL2005 to SQL 2000 (or MSDE)

Hi,
Is it possible to do? (how to do it)
I've tied to do backup and thet to restore it but it hasn't work.
Regards
Kris
Hi
No, the backup and data files are not compatible when going from 2005 to 2000.
You have to script the schema and data out and run it against 2000.
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kris" wrote:

> Hi,
> Is it possible to do? (how to do it)
> I've tied to do backup and thet to restore it but it hasn't work.
> Regards
> Kris

Migrate Backup DAT file from MS SQL to MSDE 2000

Hi,
Anyone know how to migrate migrate backup file DAT from MS
SQL 7.0 to MSDE 2000?
Thanks
Michael
If this is a backup file created with SQL Servers BACKUP command then you
can simply restore the database to the MSDE 2000 instance. The RESTORE
command will convert the database for you.
Jim
"Michael" <anonymous@.discussions.microsoft.com> wrote in message
news:0a9401c503f4$51839a90$a401280a@.phx.gbl...
> Hi,
> Anyone know how to migrate migrate backup file DAT from MS
> SQL 7.0 to MSDE 2000?
> Thanks
> Michael

Migrate

I have developed a web application using MSDE. I do not have sql 2000. I now have to transfer this database to an asp host.
Is there a DTS package or osql commands that I can export the entire database sp and all to a sql script file.

Regards
S(:You can create scripts for all of the database objects (tables, view, sprocs, etc.) but I don't believe you can create scripts for the data too. You can use DTS to copy the data, however, after you create the objects.

I haven't tried this with MSDE but with Sql Server databases you can detach them from your local database and physically copy the database files to the remote destination and then re-attach them there. The database has to be compatible with where you are attaching it and whether it considers MSDE files compatible is the question.

Microsofts Sql web admin and sqldmo

Hello all,

has anyone had the opportunity to try the sql web admin tool? if so, i have one question.

How can i use this to connect to a remote sql/msde server?

in the server textbox on the login screen i try 'machine name'\'instance name', along with the sa username and password. This does not work however.

am i just entering the wrong value , or do i need to change the code of the .connect method to allow for remote connections?

TIA.

-C-By "does not work", do you mean you are getting an error?

I have been successful using Web Data Administrator to connect to a remote database. The remote database must have mixed authentication (SQL Server and Windows). and you must be using a valid login and password. I accessed the server using the IP address.

As an additional point, I was VPN authenticated on the remote network before connecting.

Terri

Microsoft##EESS and MSDE SQL 2000 on Windows 2003 Small Business Server

Currently a server running 2003 small business operating system has MSDE 2000 and Microsoft##SSEE.

A memory problem exists with SQL consuming over 50% of RAM. Total RAM is 4GB.

There is a SQL 2000 patch for this type of problem. However, it calls for SQL to be upgraded to SP4.

Problem:
Can this MSDE 2000 be upgraded with SP4 and have memory patch applied with Microsoft##SSEE also on this box?

Please let me know. Thank you.

Yes.

You might also investigate setting the MAX memory setting for both SQL instances.

|||

Hi,

Yes you can update with SQL Server SP4.

Refering to SQL Server memory architecture it goes upto maximum limit specify by you, and if not specified it can eat up all the memory it can access and freed up as N when require by another resources. I think below articles are good enough to clear it

http://sqljunkies.com/Tutorial/0D4FF40A-695C-4327-A41B-F9F2FE2D58F6.scuk

http://msdn2.microsoft.com/en-us/library/ms187499.aspx

HTH

Hemantgiri S. Goswami

Microsoft Web Data Administrator

I have download this Front End because MSDE doesnt ship with an Visual
Interface,
i have installed MSDE2000 i believe is MSDE200a
when i installed i pass the SAPWD parameters to the setup and all was
fine...
but i cant loggin with the user SA with no password.
Even if i made an UDL File, i cant connect with that user, i have to check
login USING WINDOWS NT Integrated Security...
:S
how can i connect with the SA user with no password
________________________________
Juan Carlos Garcia
Santo Domingo, Republica Dominicana
hi Juan,
"Juan Carlos Garcia" <AskMePlease@.AskMePlease.Com> ha scritto nel messaggio
news:O%23buOQdmEHA.704@.TK2MSFTNGP09.phx.gbl...
> I have download this Front End because MSDE doesnt ship with an Visual
> Interface,
> i have installed MSDE2000 i believe is MSDE200a
> when i installed i pass the SAPWD parameters to the setup and all was
> fine...
> but i cant loggin with the user SA with no password.
> Even if i made an UDL File, i cant connect with that user, i have to check
> login USING WINDOWS NT Integrated Security...
> :S
> how can i connect with the SA user with no password
if you can not connect using SQL Server authentication at all, this usually
means that only Windows Authentication is enabled for that instance, and you
have to manually enable it, modifying a Windows registry key, as explained
in http://support.microsoft.com/default...b;en-us;285097
if you can connect with SQL Server authentication, but want to clear the sa
password to a blank password, you can execute
EXEC sp_password @.new = 'am301065' , @.loginame = 'sa'
but I strongly warn you not to do it... a strong password always is your
best friend
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Jaun
Doesn't MSDE2000a include SP3a and doesn't SP3a not work with blank passwords?
Rich
"Andrea Montanari" wrote:

> hi Juan,
> "Juan Carlos Garcia" <AskMePlease@.AskMePlease.Com> ha scritto nel messaggio
> news:O%23buOQdmEHA.704@.TK2MSFTNGP09.phx.gbl...
> if you can not connect using SQL Server authentication at all, this usually
> means that only Windows Authentication is enabled for that instance, and you
> have to manually enable it, modifying a Windows registry key, as explained
> in http://support.microsoft.com/default...b;en-us;285097
> if you can connect with SQL Server authentication, but want to clear the sa
> password to a blank password, you can execute
> EXEC sp_password @.new = 'am301065' , @.loginame = 'sa'
> but I strongly warn you not to do it... a strong password always is your
> best friend
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Thks.. for the help for both of you... but finally i have to Uninstall and
Install again passing this parameters : setup SAPWD = "****"
SECURITYMODE=SQL
and know its working... :D
thks.. again... see you..
________________________________
Juan Carlos Garcia
Santo Domingo, Republica Dominicana
"Richard Yeo" <RichardYeo@.discussions.microsoft.com> escribi en el mensaje
news:D66748B5-F213-4251-9B5F-E050B681AD08@.microsoft.com...
> Jaun
> Doesn't MSDE2000a include SP3a and doesn't SP3a not work with blank
passwords?[vbcol=seagreen]
> Rich
>
> "Andrea Montanari" wrote:
messaggio[vbcol=seagreen]
check[vbcol=seagreen]
usually[vbcol=seagreen]
you[vbcol=seagreen]
explained[vbcol=seagreen]
sa[vbcol=seagreen]
|||hi Richard,
"Richard Yeo" <RichardYeo@.discussions.microsoft.com> ha scritto nel
messaggio news:D66748B5-F213-4251-9B5F-E050B681AD08@.microsoft.com...
> Jaun
> Doesn't MSDE2000a include SP3a and doesn't SP3a not work with blank
passwords?
yes it does, but, at install time, you have to force the BLANKSAPWD=1
parameter in order to accept it... an again, I strongly recommend not to
allow blank pwd policies
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Microsoft Support to MSDE

Hi ,

Does microsoft supports MSDE still or it will support only Sql 2005 Express edition.

Hi,

see: http://blogs.msdn.com/sqlexpress/archive/2006/08/09/693650.aspx

· MSDE 2000 s almost at the end of it's support life cycle - MSDE 2000 will exit mainstream support on 4/8/2008 and no new deployment agreements will be allowed after June 30, 2007.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Microsoft SQL Web Data Administrator

I have installed this and I cannot access my MSDE Instance. Any ideas?
The instance of my DB is running.
My Server Manager Says that it is running, Services says that it is running,
but I cannot get to the SQLServer (On my own pc) with the Web Data
Administrator or TOAD for SQL Server.
|||It is quite possible that it is running on a non-standard port not 1433.
Open up a console window and type following
PROMPT> telnet localhost 1433
if you see a blank screen that means the server is listening. If you get
an error that means that it is listening on a different port
Joe Tobey wrote:
> I have installed this and I cannot access my MSDE Instance. Any ideas?
> The instance of my DB is running.
|||It is listen in on a different PORT...how do I change that?
"Dennis Black" wrote:

> It is quite possible that it is running on a non-standard port not 1433.
> Open up a console window and type following
> PROMPT> telnet localhost 1433
> if you see a blank screen that means the server is listening. If you get
> an error that means that it is listening on a different port
>
> Joe Tobey wrote:
>
>
|||To determine the port MSDE is using, run the SQL Server Network Utility
on the machine hosting the MSDE instance. The SQL Server Network
Utility can be found at \Program Files\Microsoft SQL
Server\80\Tools\Binn\svrnetcn.exe.
On the general tab, select the your MSDE instance. Select TCP/IP and
press the Properties button and look at the port
Dennis
Joe Tobey wrote:[vbcol=seagreen]
> It is listen in on a different PORT...how do I change that?
> "Dennis Black" wrote:
>