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?To be honest I do not know MSDE 2000 as well as I should
but with Server 2000 you need to perform a sp_attach_db.
J
>--Original Message--
>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/details.aspx?FamilyId=C039A798-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/downloads/addins/msde/deploying.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
>
