re-install MSDE

Hi,
I've been trying to install the IBUYSPY samples and have been running into server problems. I've done everything from uninstalling and reinstalling MSDE to manually erasing the data files via window explorer. I've got everything so screwed up now, that e
ven though MSDE is installed, I can't access it through Server Explorer in VS DotNet. I have 2 questions
1) How can I do a clean install of MSDE (erase everything, then reinstall everything)?
2) What significance do the aspnet_wp and SQLDebugger accounts have? Should these accounts be set as administrator accounts, and should they be password protected?
I've had both IBUYSPY samples installed and working properly before... I'm almost ready to re-format my hard drive and start from scratch!!
Thanks!!
Curt
Hi Curt,
For reinstalling MSDE, I would suggest you go through the steps listed in
the following KB article of uninstalling the MSDE and then you can do a
fresh installation.
HOW TO: Manually Remove a Microsoft SQL Server 2000 Desktop Engine (MSDE
2000) Instance
http://support.microsoft.com/default...&Product=sql2k
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
sql

Registered Servers are unavailable

So I've had some issues upgrading to SQL Server Mgmt Studio Dev from Express. I finally got everything upgraded / installed and I see the instances that I was using with Express in my Registered Servers window but I can't connect to any of them. After looking in my Microsoft SQL Server directory I noticed that there are no MSSQL.# folders. How can I recreate these or create a new instance on my local machine?

Hi,

Do you mean that you want to import the SQLExpress database intoSQL Server management Stuido Expresswhich provides a graphical management tool for SQL Server 2005 Express Edition (SQL Server Express).? If so, you can use "aspnet_regsql" tool and try again, the tool exists in DiskRoot:\WINDOWS\Microsoft.NET\Framework\versionEdtion\.

Thanks.

register database

I have installed an application made with VB6 on a computer, and have
installed MSDE 2000. I've copied the .ldf and .mdf files in the appropriate
folder. However, the login information that is contained in the application
doesn't allow me to access the database. I was able to access the database
when I was designing the application. I used a dataenvironment. When I ran
the application on the user's computer, it asked for the password for the sa
account and also for the name of the instance of SQL Server to connect to.
I was able to give that information correctly. What is the problem? Was I
supposed to do more than copy the .ldf and .mdf files onto the hard drive.
Was I supposed to somehow register those files with SQL Server? MSDE
doesn't come with the same tools as SQL Server. Can someone help?
Daniel,
Julia's TSQL is right.
Just an extra point though - if you want to do this sort of thing
graphically using SQL Server client tools - Enterprise Manager, query
analyser etc - then you could register the MSDE instance on another
Enterprise Manager on the network. If it is a stand-alone PC then you might
install Developer Edition just to get the tools ($40ish).
HTH,
Paul Ibison
|||However, last time I heard, this is violating the license agreements. We have had a discussion about this in
the MVP group, and hopefully MS will make these things much clearer on their web pages (if that haven't
already been done...). :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:%23vf8$GvSEHA.3968@.TK2MSFTNGP09.phx.gbl...
> Daniel,
> Julia's TSQL is right.
> Just an extra point though - if you want to do this sort of thing
> graphically using SQL Server client tools - Enterprise Manager, query
> analyser etc - then you could register the MSDE instance on another
> Enterprise Manager on the network. If it is a stand-alone PC then you might
> install Developer Edition just to get the tools ($40ish).
> HTH,
> Paul Ibison
>
|||Hi,
MSDE will not come up with normal tools graphical tools. Follow the below
steps to attach the database in MSDE
1. From command prompt execute
OSQL -Usa -Ppassword -S servername (Enter Key)
This will go go to a sql prompt, there execute the sp_attach_db to attach
the MDF and LDF file to sql server
1> sp_attach_db
'dbname','c:\mssql\data\dname_data.mdf','c:\mssql\ data\dname_log.ldf'
(enter Key)
2>go (enter key)
This will attach the database to sql server. After this you can access the
database. Provide the directory and MDF and LDF file names appropriately.
Microsoft is giving a free tool named "SQL Server web data Administrator" to
manager and administrator the SQl server. This will be more useful to
MSDE users.
Download the free tool from below site.
http://www.microsoft.com/downloads/d...798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
Thanks
Hari
MCDBA
"Daniel" <dwbnews@.hotmail.com> wrote in message
news:OIsozWpSEHA.3332@.tk2msftngp13.phx.gbl...
> I have installed an application made with VB6 on a computer, and have
> installed MSDE 2000. I've copied the .ldf and .mdf files in the
appropriate
> folder. However, the login information that is contained in the
application
> doesn't allow me to access the database. I was able to access the
database
> when I was designing the application. I used a dataenvironment. When I
ran
> the application on the user's computer, it asked for the password for the
sa
> account and also for the name of the instance of SQL Server to connect to.
> I was able to give that information correctly. What is the problem? Was
I
> supposed to do more than copy the .ldf and .mdf files onto the hard drive.
> Was I supposed to somehow register those files with SQL Server? MSDE
> doesn't come with the same tools as SQL Server. Can someone help?
>
|||Thanks fo rthis feedback. I'll hold off from this recommendation (here and
in class) until things are sorted.
Regards,
Paul Ibison
|||I was a bit surprised to here that you can't even use your own EM to manage your own MSDE's, but that is the
way I read one of the posts. Hopefully, MS will understand that first step is to document this as clearly as
possible...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:uKEI5YGTEHA.3660@.tk2msftngp13.phx.gbl...
> Thanks fo rthis feedback. I'll hold off from this recommendation (here and
> in class) until things are sorted.
> Regards,
> Paul Ibison
>
|||Thank you for the comments. You may be interested to learn what I've found
out. It is actually possible to use code (in my case I use Visual Basic 6)
to attach the database to MSDE. Here is a link I found that leads to other
links that give more information:
http://msdn.microsoft.com/vstudio/do...eploying.aspx.
Paul Ibison mentioned in his post about a class? I'm curious about what
class that is.
Daniel
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uKEI5YGTEHA.3660@.tk2msftngp13.phx.gbl...
> Thanks fo rthis feedback. I'll hold off from this recommendation (here and
> in class) until things are sorted.
> Regards,
> Paul Ibison
>
|||Daniel,
I work for a CTEC (like several others on the MS newsgroups, inc Tibor) - www.pygmalion.com.
Regards,
Paul Ibison