HELP! unable to create DB -- visual studio .net setup

cindy
7/12/2003 11:03:01 AM

I have installed Visual Studio.NET Professional.. and
want to work with SQL databases. I am using the server
Explorer and can connect and to a LOCAL SQL server on my
XP machine and also to the SQL server on a Windows 2000
server... I authenticated okay - I can open them and it
looks like I can edit data ... BUT... on both of these,
when I try to create a new DB I get a message
saying "Cannot create databases on this server" the Help
screen says that ---- VS.NET Pro edition can only create
a database on the SQL SErver Desktop Engine. If you want
to create a database on other SQL Server Instances, you
must purchase the Enterprise edition of VS.NET.----
First - what do they mean by SQL Server Desktop Engine?
Are they referring to the SQL Enterprise manager? or is
there somewhere else that I can do this. Can I only edit
data and not the design??? It also does not allow me to
add tables or columns to current DB's.
ANY help or suggestions would be appreciated... Hope I
didn't purchase software that isn't capable of doing what
I need... :-(

mohan_nalinaranjan NO[at]SPAM online.microsoft.com
7/14/2003 7:37:21 PM

HI,

you can go to the following location to learn more about MSDE (
http://www.microsoft.com/sql/msde/productinfo/overview.asp

(The Desktop Engine is the successor to Microsoft Data Engine (MSDE) 1.0
and is often referred to as MSDE 2000. The Desktop engine is a
redistributable version of the SQL Server relational database engine.
Third-party software developers can include it in their applications that
use SQL Server to store data. It is made available as a set of Windows
Installer merge modules that can be included in an application setup.

The Desktop Engine is an ideal embedded or offline data store, because it
is easy to install and has the smallest footprint of any edition of SQL
Server 2000. The Desktop Engine does not include any graphical management
tools. The Desktop engine does not include any analysis capabilities (such
as OLAP, data mining, and data warehousing features) or SQL Server Books
Online.
The Desktop Engine uses the same concurrent workload throttle as Personal
Edition. )

Yes with pro you can create tables and views only with MSDE and not with
SQL server instances.
--------------------
[quoted text, click to view]

--

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.

visual studio .net setup : HELP! unable to create DB