MSDE to SQL Server Express

Hi - I have an MSDE database running on my server - I'd like to port my asp.net 1.1 app to asp.net2, and make use of SQL 2005 Express.

How do I transfer my data from an MSDE database to SQL Server Express, keeping intact all of my unique ID fields, indexes, and SPs (I don't have any functions or views)

Thanks for any help,

Mark

Your best bet is either to "detach" it on the MSDE side, and "attach" it or "restore from backup" on the SQL 2005 side, or use DTS (data transformation services).

|||Hi - it's just SQL Server 2005 Express I have available, so no management tools are there to allow me to 'restore from backup' - I'm not sure it supports DTS either.

Has anyone else been able to do this?

Thanks, Mark|||

Even with SQL Express you should have the ability to detach the database. You need the Management studio installed to work with the Express server engine though. You can download it here.

http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en

|||You don't have to detach from SQL Express if you are using a file based database (You are if you use the AttachDB attribute in your connect string). Just stop whatever application that uses it, and copy the mdb/ldb files to SQL Sever 2005 and attach.

MSDE Setup -- Wheres the Server?

I am using VB.net to build ASP.net pages. I finally decided it was time to start using SQL server based code. So, I installed MSDE...or so I thought.

I have the server Icon in the bottom systray and it's green and seems to be running.

I have been able to use Microsoft Access' Database Upgrade Wizard to create BB.adp file.

An in VB.net I see a master.dbo connection in Server Explorer.

But I can't figure out how to access the database via the SQL server. When I right click on Server Explorer...the Create a New SQL database menu item is greyed out.

My concern is that my installation is not complete and/or I don't know how to locate and verify the server.

Any help would be appreciated. ThanksMSDN link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msderoadmap.asp to run thru the details.

MSDE ReleaseA

Can i redistribute only osql.exe with my asp.net application
we are using licensed Install Shield for packaging..
we use this osql.exe for creating and setup database...
regards
sahridhayan
hi,
sahridhayan wrote:
> Can i redistribute only osql.exe with my asp.net application
> we are using licensed Install Shield for packaging..
> we use this osql.exe for creating and setup database...
I do not think you can separate oSql.exe from the full MSDE package from a
legal point of view..
but perhaps you've better ask Microsoft representatives...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I'm not sure about MSDE, but if you have a SQL Server license you can
distribute OSQL. Refer to REDIST.TXT for a listing of all the
redistributable components of SQL Server.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3h5uarFf6jcoU1@.individual.net...
> hi,
> sahridhayan wrote:
> I do not think you can separate oSql.exe from the full MSDE package from a
> legal point of view..
> but perhaps you've better ask Microsoft representatives...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi,
Desperado wrote:
> I'm not sure about MSDE, but if you have a SQL Server license you can
> distribute OSQL. Refer to REDIST.TXT for a listing of all the
> redistributable components of SQL Server.
>
again, I'm not sure you can "cannibalize" osql.exe that way... of course,
having a full SQL Server licence, you can install the Client Tools, that
include quiet all tools... but this way I'm little skeptic... but I'm not a
lawyer
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

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

MSDE Not Connected

Hi,

I installed MSDE 2000 SP3 to use the ASP.NET QuickStart samples on
my Windows 2000 machine. I ran
setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD<my password>

I then ran the QuickStart installer.

These steps were documented by MS.

But when I rebooted, the SQL Service Manager was 'Not Connected'
and the circle in front of the server icon was blank/white. Also the QuickStart samples that connect to MSDE won't and give errors like 'System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.' or '...Login failed for user '<my server name>\ASPNET'

When I run 'osql -E -S <my server name>\VSDOTNET' command I get '1>'. So there is a connection that's possible. Also the MSSQL$VSDOTNET is Started.

Any suggestions?Try running the SVRNETCN.exe tool to find out what protocols MSDE is using. I had a similar problem (not with .NET) and found that NO protocols were selected. Ergo, no connection possible.

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe

-- Steve

Originally posted by ericscat
Hi,

I installed MSDE 2000 SP3 to use the ASP.NET QuickStart samples on
my Windows 2000 machine. I ran
setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD<my password>

I then ran the QuickStart installer.

These steps were documented by MS.

But when I rebooted, the SQL Service Manager was 'Not Connected'
and the circle in front of the server icon was blank/white. Also the QuickStart samples that connect to MSDE won't and give errors like 'System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.' or '...Login failed for user '<my server name>\ASPNET'

When I run 'osql -E -S <my server name>\VSDOTNET' command I get '1>'. So there is a connection that's possible. Also the MSSQL$VSDOTNET is Started.

Any suggestions?|||Hi,

Thanks I ran it and restarted the MSSQL$VSDOTNET service, but I
don't see any change. Sorry I don't know much of this. Your right
there were no protocols selected so I enabled TCP/IP. What is the
SQLAgent$VSDOTNET service? It's setup as a Manual startup.

Any more tips? I would assume that when I installed MSDE and
setup the instance that I would see the small green right pointing
arrow in the Service Manager icon. The Manager still says Not Connected.
??|||Sorry,

I rebooted and got an automatic connection/Sql Server Service
started.
Thanks for your help.

msde memory leak?

Any problem with MSDE?
Client: ASP.Net C#
Server: MSDE
2 CPU/2GB RAM machine
at beginning, RAM for MSDE is 80MB
after 40 hours, RAM for MSDE is 1.3GB
Connections to msde is flat: 28 connections
1. It is said msde will keep grabbing ram, but is it too much?
2. try to set the limitation for max mem, but got error, says can not find
'max server mem'
sp_configure 'max server mem' 3000000
thanks,
Shelby
hi Shelby,
"shelby" <shelby@.discussions.microsoft.com> ha scritto nel messaggio
news:2537A25E-666F-4E46-9878-DB00B854AF66@.microsoft.com
> Any problem with MSDE?
> Client: ASP.Net C#
> Server: MSDE
> 2 CPU/2GB RAM machine
> at beginning, RAM for MSDE is 80MB
> after 40 hours, RAM for MSDE is 1.3GB
> Connections to msde is flat: 28 connections
> 1. It is said msde will keep grabbing ram, but is it too much?
> 2. try to set the limitation for max mem, but got error, says can not
> find 'max server mem'
> sp_configure 'max server mem' 3000000
try perhaps with
EXEC sp_configure 'max server memory' , xx
regarding your memory usage, it could be actually normal, as SQL Server
manage it's memory footprints very well, but it usually is very hungry about
it...
you can have a look at http://tinyurl.com/63bl3 , but a better disgression
about memory management is provided by Ken Henderson, and you can have a
loot at a sample chapter at
http://msdn.microsoft.com/library/de...v_03252004.asp
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

MSDE Licensing In Web App?

I have an ASP.NET web application that will be accessed from the Internet.
Does the MSDE redistributable license cover this situation?
Thanks,
<WARNING: I'm not a lawyer>
Yes. It's commonly used that way. The biggest limitation is usually the
database size limit if you make good use of connection pooling.
</WARNING: I'm not a lawyer>
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Hani Atassi" <hani@.community.nospam> wrote in message
news:89E6E948-F597-41DF-9F8A-61F0DBC2177D@.microsoft.com...
>I have an ASP.NET web application that will be accessed from the Internet.
> Does the MSDE redistributable license cover this situation?
> Thanks,
|||you may also need a Windows Server External Connector License.
If you are running on Windows Server and the external connections are not
from employees, then you need the EC. If they are employees, then you need
CALs for those employees.
-Dino
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:eSlqRs9xEHA.3840@.tk2msftngp13.phx.gbl...
> <WARNING: I'm not a lawyer>
> Yes. It's commonly used that way. The biggest limitation is usually the
> database size limit if you make good use of connection pooling.
> </WARNING: I'm not a lawyer>
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Hani Atassi" <hani@.community.nospam> wrote in message
> news:89E6E948-F597-41DF-9F8A-61F0DBC2177D@.microsoft.com...
>

MSDE Licensing

The MSDE licence says that it can be used for up to 5 concurrent users. My app is an ASP.NET app, so won't I just be using one user - the ASP.NET account? I'm wondering whether we can get away with just buying a new server and sticking MSDE on it rather than shelling out for another £5000 SQL server licence...I do not believe what you say (5 concurrent users) is correct.

http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp.

From this page:

Q. Can I use MSDE as a database for Web applications?

A. Yes, MSDE is an ideal solution for basic Web applications with up to 25 concurrent users.

There is throttling of performance with 8 concurrent OPERATIONS (but three are normally used internally).

Fromthis page:

The Microsoft® SQL Server? 2000 workload governor is designed to limit the performance of an instance of the database engine any time more than eight operations are active at the same time. An instance of the SQL Server 2000 database engine is one copy of the database software that operates as an operating system service.

The operations counted by the workload governor are:

Processing a request to open an inbound connection and login.

Processing a batch of one or more Transact-SQL statements received over an inbound connection.

Processing a distributed transaction operation, such as a prepare-to-commit or rollback operation.

Processing a request to log off and close an inbound connection.

Periodic system-generated operations such as shrinking a database if the database has the AUTO_SHRINK option turned on, completing the deletion of rows from the base level of indexes, or populating the SQL Server performance counters in the System Monitor.

Instances of SQL Server 2000 Personal Edition will also periodically generate system operations to process any full-text indexes referenced by the databases managed by the instance. SQL Server 2000 Desktop Engine (MSDE 2000) does not support full-text indexes.|||Sorry - missed a "2" out there.... Thats answered the question great - thanks a lot!

MSDE License

I have a question
We have recently developed a application in ASP that is being shipped to a
client server in Ireland. The ASP application has a database backend in
SQL2000. The clients server is likely to have between 25 and 40 users
accessing the application.
There will be no SQL development or amendments needed on the client server.
We will however need to replicate the data back to our HQ.
Will MSDE cover the Licensing requirements
Many Thanks in advance of your help
Carl Lightfoot
Hi Carl,
Unless the clients are all likely to be hitting the web app constantly and
you can live with the 2G database limit, I think it should be fine.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Carl Lightfoot" <CarlLightfoot@.discussions.microsoft.com> wrote in message
news:F4985F31-77EA-4570-A354-C337704B913B@.microsoft.com...
> I have a question
> We have recently developed a application in ASP that is being shipped to a
> client server in Ireland. The ASP application has a database backend in
> SQL2000. The clients server is likely to have between 25 and 40 users
> accessing the application.
> There will be no SQL development or amendments needed on the client
server.
> We will however need to replicate the data back to our HQ.
> Will MSDE cover the Licensing requirements
> Many Thanks in advance of your help
> --
> Carl Lightfoot
|||Carl,
Remeber that the limit for simultaneous connections is 25.
The database starts to lag at 8.
[]'s
Bruno
>--Original Message--
>Hi Carl,
>Unless the clients are all likely to be hitting the web
app constantly and
>you can live with the 2G database limit, I think it
should be fine.
>HTH,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
>"Carl Lightfoot"
<CarlLightfoot@.discussions.microsoft.com> wrote in message[vbcol=seagreen]
>news:F4985F31-77EA-4570-A354-C337704B913B@.microsoft.com...
being shipped to a[vbcol=seagreen]
database backend in[vbcol=seagreen]
25 and 40 users[vbcol=seagreen]
on the client[vbcol=seagreen]
>server.
HQ.
>
>.
>
|||Hi Bruno,
There is no 25 simultaneous connection limit. The only limit in this regard
relates to concurrent workloads.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Bruno Avanco" <brunojfk@.hotmail.com> wrote in message
news:83a401c495c1$c2fc2df0$a501280a@.phx.gbl...[vbcol=seagreen]
> Carl,
> Remeber that the limit for simultaneous connections is 25.
> The database starts to lag at 8.
> []'s
> Bruno
> app constantly and
> should be fine.
> <CarlLightfoot@.discussions.microsoft.com> wrote in message
> being shipped to a
> database backend in
> 25 and 40 users
> on the client
> HQ.

msde INSTALLATION

Hi

I am trying to install the MSDE.
I followed the steps on this page http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1
on running the setup I get a message showing that the following instance is not valid and it doesn't install the MSDE.

Could somebody help me.

AkshatOK. what's your computer's name?
what command line are you specifying, exactly?|||Thanx for the message.
Computer Name=Akshat

Setup SAPWD=hello SecurityMode=SQL

These are mentioned on the webpage for installation so I just followed them.

http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1

Akshat

MSDE included as part of ASP.NET deployment package?

I need to design an asp.net application w/ and MSDE backend database that will be deployed at 50 different location (unrelated to each other). The application's deployment package needs to be downloaded from a web site on the internet. The end user locations do not have SQL2000 or MSDE...some have access.

I want to know if my deployment package can include the MSDE software? Or, can anyone offer ideas on the EASIEST way for these small offices to get MSDE installed on each of their servers so that my ASP.NET applications will connect to via ado.net.

Thanks for any ideas.I believe you can include it in your deployment package so long as its use at each location is consistent with the MSDE licensing agreement.

Appropriate uses of MSDE

MSDE Help

Hey,

I have produced an asp.net application, and it's time for me to look to installing it at my clients site.

The application uses MS SQL. I have a redistribution license for MSDE 2000. So I have spent all morning ( :-( ) trying to work out how I can distribute it.

I have worked out how to install MSDE, however I can't find any information on:

1. How to connect to the MSDE instance (both for admin and through the asp.net pages).
2. What tools I can use to add/import a database to the MSDE instance.
3. If there is a way to create a distribution package other than using Visual Studio (which I don't have)

I have named the instance WENS, I set the password to XXXXX (not that)

I have worked out how to start the service by opening the service manager. However there are no admin tools provided, and when I use the MS SQL admin tools I can't connect, it doesn't accept the user account
sa, XXXXX

So, basically, any help you can give me would be fantastic, I'm at a loose end, lol.

Thanks a lot for your help.

(Tools I have at my disposal, web matrix, MS SQL Enterprise Edition, MSDE, and I'll download anything that will help (and is legal to use) )http://support.microsoft.com/default.aspx?scid=kb;EN-US;321698 - KBA to start with and refer to corresponding KBA links too.|||Hey,

That seemed to fix a lot of my problems, thanks ;-).

I still have one issue I can't seem to find an answer to in there.

When I connect to the database from another computer, I get an error message saying

Please verify SQL Server is running and check your SQL Server registration properties ...

The instance is called WENS and is located on a computer named ASHG

so I am attempting to connect to

ASHG\WENS

is that correct? what could be causeing this error? all the services in the services manager for the WENS instance as running.

Thanks
-Ashleigh

MSDE Help

I have never done anything with databases, so I am a newbie. My goal is to install an ASP.NET forum, but I need MSDE installed. I downloaded MSDE from the Microsoft website. When I run the setup.exe file, I get an error. It says:

A strong SA password is required for security reasons. Please use SAPWD switch to supply
same. Refer to readme for more details. Setup will now exit.

I looked at the documentation but could not find anything usefull, what do I have to do to install it. Thanks in advance for responses.Did you try the instructions here?Installing MSDE For ASP.NET Web Matrix Also, if you follow links from there you are led toInstalling a New Instance of MSDE 2000 SP3a which may also help.

Terri|||ok, I followed the instructions, but got yet another error.

The Windows Installer Service could not be accessed. This can occur if you are running Windows in safe mode, or if the Windows Installer is not correctly installed. Contact your support personnel for assistance.

well, I am not in safe mode, I guess my Windows Installer is not correctly installed, I don't know why that would be. Does anyone know how I can fix this problem.

MSDE for free?

Im searching for a SQL server that is free.

I have programed a ASP system that Im now intend to sell.

But the problem is that it needs to run on SQL and therefor im searching for a SQL server that is free to use.

And I found out that MSDE is free.

Now Im wondering if I can use this for the ASP system I intend to sell?

I wont make any money on MSDE, becaus the costumers will pay for the ASP and not the SQL. Is this possible?Check the following links:

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=7840&pg=2

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/usingmsde.asp

http://msdn.microsoft.com/vstudio/downloads/addins/msde/deploying.aspx|||Thank you... that was a greate help for me...