Setting-up MSDE with VS.NET and C#

[Guest]

I am brand new to .NET. For that matter, so is my whole corporation, hence this dumb question. How can I set-up MSDE or SQL Server Desktop to work with VS.NET and the various development languages. Only one person here has any access to the MS SQL packages and getting him to due anything is like trying to give a wolverine a root canal! They have made me the project lead for all future development in .NET (the guy they had on it quit last week and I was chosen because I can read C++ and VB code).

Specifically, I followed the installation procedures that came with .NET Architect; however, there appears to be no active server (desktop version) running when MSDE loads up. I probably screwed it up during installation; however, I can't find any of the sample database or any tools to create my own. Any ideas?

Please give a newbie a hand!

Thanks

 

[Cindy Winegarden]

In news: (e-mail address removed),

....How can I set-up MSDE or SQL
Server Desktop to work with VS.NET .....

Specifically, I followed the installation procedures that came
with .NET Architect; however, there appears to be no active server
(desktop version) running when MSDE loads up. I probably screwed it
up during installation; however, I can't find any of the sample
database or any tools to create my own. Any ideas?

Please give a newbie a hand!

Hi Jinksk,

Others will have more details but MSDE does not come with a "front end" GUI
tool to administer it. There are third-party tools or you can use the
command line interface. If you get the Developer edition of SQL Server
(About $50, see http://www.microsoft.com/sql/howtobuy/development.asp) you
can get an idea of how useful the Enterprise Manager and Query Analyzer are.
As far as I know for a production environment you would need a full version
of SQL Server in order to use the GUI tools, but I'm not a licensing expert.

You can post questions to any of the SQL Server newsgroups, especially
microsoft.public.sqlserver.msde, when you have questions like this. MSDE is
all the same no matter whether you installed it with VS.NET or Visual FoxPro
or Office or whatever.

 

[Cindy Winegarden]

I haven't installed MSDE by itself for quite a while and I'm not sure
whether the sample DBs come with it. In any case, the sample DBs are just
SQL script text files and if you email me offline I can send them to you.

I don't work with MSDE all that much so you will probably get better help in
the MSDE newsgroup, but I went to http://groups.google.com and put in the
exact text of the error message in quotes (SQL Server does not exist or
access denied") and came up with quite a few leads, including the following
KB article, "Potential causes of the "SQL Server Does Not Exist or Access
Denied" error message" (support.microsoft.com/default.aspx?kbid=328306)

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
(e-mail address removed) www.cindywinegarden.com

Cindy;
The "front-ends" I can live without. It's when I try to load the

Sample Database apps (like Dunwamish). I get a "Microsoft SQL Server Login"
dialog with the error message: "[DBNETLIB][ConnectionOpen (Connect()).] SQL
Server does not exist or access denied."

Also, where can I find the other sample databases (PUBS in particular)

since all of the examples and tutorials are based on them?