Any third-party freebies to administer MSDE?

Are there any third party freebies available to administer MSDE? I'm looking
to replace Interbase with MSDE, but I'll need some sort of Query Analyzer /
Admin interface to replace IBConsole which is free with Interbase. Is
anything like this available?
Thanks for your help,
Joe Geretz
This link may help.
http://www.microsoft.com/sql/msde/partners/default.asp
Jim
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:u91ZuEDGEHA.3856@.TK2MSFTNGP12.phx.gbl...
> Are there any third party freebies available to administer MSDE? I'm
looking
> to replace Interbase with MSDE, but I'll need some sort of Query Analyzer
/
> Admin interface to replace IBConsole which is free with Interbase. Is
> anything like this available?
> Thanks for your help,
> Joe Geretz
>
|||http://www.aspfaq.com/2442
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:u91ZuEDGEHA.3856@.TK2MSFTNGP12.phx.gbl...
> Are there any third party freebies available to administer MSDE? I'm
> looking
> to replace Interbase with MSDE, but I'll need some sort of Query Analyzer
> /
> Admin interface to replace IBConsole which is free with Interbase. Is
> anything like this available?
> Thanks for your help,
> Joe Geretz
>
|||Joseph,

> Are there any third party freebies available to administer MSDE?
There aren't only 3rd party tools, have a look at MS Web Administrator:
http://www.microsoft.com/downloads/d...displaylang=en
The only disadvantage I can see is the poor performance.
I have also tested DbaMgr (http://www.asql.biz/DbaMgr.shtm) and the free
version of myLittleAdmin (http://www.mylittletools.net/scripts/en/mla_sql/).
For having a quick look at your databases, myLittleAdmin is very good.
Bye,
mm

Any issues with using Noton Ghost with SQL Server?

I seem to recall from reading an article that there are issues with backing
up hard drives with Norton Ghost with SQL Server or MSDE installed.
However, I can't seem to find the KB article. Can someone confirm this with
resource articles?
Thanks in advance.The issue is most likely if your trying to do this while SQL Server is
running. If it's not running I don't see why you couldn't ghost it but that
is not a very efficient way to backup sql server.
--
Andrew J. Kelly
SQL Server MVP
"wym" <wym@.sympatico.ca> wrote in message
news:Doxub.9670$iT4.1045873@.news20.bellglobal.com...
> I seem to recall from reading an article that there are issues with
backing
> up hard drives with Norton Ghost with SQL Server or MSDE installed.
> However, I can't seem to find the KB article. Can someone confirm this
with
> resource articles?
> Thanks in advance.
>|||Thank you for the reply. Actually, the question came up because our
application uses MSDE 2000 and it is set to autostart when OS starts. When
customers backup with with Ghost, I doubt they will turn off MSDE (they will
have to search for it since SQL Server Service Manager is not in the tray).
If they reinstall the image, will there be any issues with MSDE or the
databases?
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OvHVoHjrDHA.2408@.tk2msftngp13.phx.gbl...
> The issue is most likely if your trying to do this while SQL Server is
> running. If it's not running I don't see why you couldn't ghost it but
that
> is not a very efficient way to backup sql server.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "wym" <wym@.sympatico.ca> wrote in message
> news:Doxub.9670$iT4.1045873@.news20.bellglobal.com...
> > I seem to recall from reading an article that there are issues with
> backing
> > up hard drives with Norton Ghost with SQL Server or MSDE installed.
> > However, I can't seem to find the KB article. Can someone confirm this
> with
> > resource articles?
> >
> > Thanks in advance.
> >
> >
>|||You can't guarantee a consistent database by backing up at the file level
when sql server is running. I would look into writing some simple BACKUP
and RESTORE scripts. They work the same on MSDE as they do on any edition
and are the correct way to backup the databases.
--
Andrew J. Kelly
SQL Server MVP
"wym" <wym@.sympatico.ca> wrote in message
news:HKzub.10072$iT4.1118306@.news20.bellglobal.com...
> Thank you for the reply. Actually, the question came up because our
> application uses MSDE 2000 and it is set to autostart when OS starts.
When
> customers backup with with Ghost, I doubt they will turn off MSDE (they
will
> have to search for it since SQL Server Service Manager is not in the
tray).
> If they reinstall the image, will there be any issues with MSDE or the
> databases?
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OvHVoHjrDHA.2408@.tk2msftngp13.phx.gbl...
> > The issue is most likely if your trying to do this while SQL Server is
> > running. If it's not running I don't see why you couldn't ghost it but
> that
> > is not a very efficient way to backup sql server.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "wym" <wym@.sympatico.ca> wrote in message
> > news:Doxub.9670$iT4.1045873@.news20.bellglobal.com...
> > > I seem to recall from reading an article that there are issues with
> > backing
> > > up hard drives with Norton Ghost with SQL Server or MSDE installed.
> > > However, I can't seem to find the KB article. Can someone confirm
this
> > with
> > > resource articles?
> > >
> > > Thanks in advance.
> > >
> > >
> >
> >
>

any installation no-no's?

We are installing MS Win Server 2003 and my old version (7?) of MSDE is not
supported. So I will download MSDE 2000 and install it. I do not have a lot
of experience installing MSDE. I installed it a few times years ago and, with
a few exceptions, it has run just fine since then.
I vaguely remember that I used all the installation defaults with MSDE. That
led to a problem whenever the administrator, or whoever the user was when it
was installed, changed thier password, the connection to the database no
longer worked.
Can anyone suggest a source of information that might be useful to me to
read before I install MSDE 2000?
Thanks for your help, John Brown
John Brown
hi John,
John Brown wrote:
> We are installing MS Win Server 2003 and my old version (7?) of MSDE
> is not supported. So I will download MSDE 2000 and install it. I do
> not have a lot of experience installing MSDE. I installed it a few
> times years ago and, with a few exceptions, it has run just fine
> since then.
> I vaguely remember that I used all the installation defaults with
> MSDE. That led to a problem whenever the administrator, or whoever
> the user was when it was installed, changed thier password, the
> connection to the database no longer worked.
> Can anyone suggest a source of information that might be useful to me
> to read before I install MSDE 2000?
> Thanks for your help, John Brown
modifying the "sa" password was a problem for MSDE 1.0 relating to Windows
account running the SQL Server Agent, but this does not apply to MSDE
2000... and there are not other problems I'm aware of.. but, of course, you
should have a look at the readme file bundled with the installation
package...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Any ideas, please...

I have create a database, login, role, user at a named instance of MSDE by
running the following scropt:
CREATE DATABASE [testdb_vg]
USE Master
EXEC SP_ADDLOGIN @.loginame = 'test_login', @.passwd = 'psw'
USE [testdb_vg]
EXEC SP_ADDROLE [test_role]
GRANT CREATE TABLE TO [test_role]
EXEC SP_ADDUSER [test_login], [test_user], [test_role]
Then I run SQL Analyser and try to connect to the database using SQL
Authentication:
user: test_user
password: psw
and I am getting message:
Unable to connect to server SSSSSS\NNNN
Message: 18452, level 16, state 1,
[Microsoft][ODBC SQL Server Driver][SQL Server] Login for user "test_user".
Reason: not associated with a trusted SQL Server connection
with other SQL server instance it works OK?!Are you sure MSDE is set up to use both SQL Server and Windows
authentication? Sounds like it is set to Windows authentication only...
"Vlad Gonchar" <VladG@.Frogware.com> wrote in message
news:#QRC#M5eDHA.560@.tk2msftngp13.phx.gbl...
> I have create a database, login, role, user at a named instance of MSDE by
> running the following scropt:
> CREATE DATABASE [testdb_vg]
> USE Master
> EXEC SP_ADDLOGIN @.loginame = 'test_login', @.passwd = 'psw'
> USE [testdb_vg]
> EXEC SP_ADDROLE [test_role]
> GRANT CREATE TABLE TO [test_role]
> EXEC SP_ADDUSER [test_login], [test_user], [test_role]
> Then I run SQL Analyser and try to connect to the database using SQL
> Authentication:
> user: test_user
> password: psw
> and I am getting message:
> Unable to connect to server SSSSSS\NNNN
> Message: 18452, level 16, state 1,
> [Microsoft][ODBC SQL Server Driver][SQL Server] Login for user
"test_user".
> Reason: not associated with a trusted SQL Server connection
> with other SQL server instance it works OK?!
>|||See the section that starts with "Another way to change the security mode
after installation..." in
http://support.microsoft.com/?kbid=285097
"Vlad Gonchar" <VladG@.Frogware.com> wrote in message
news:#QRC#M5eDHA.560@.tk2msftngp13.phx.gbl...
> I have create a database, login, role, user at a named instance of MSDE by
> running the following scropt:
> CREATE DATABASE [testdb_vg]
> USE Master
> EXEC SP_ADDLOGIN @.loginame = 'test_login', @.passwd = 'psw'
> USE [testdb_vg]
> EXEC SP_ADDROLE [test_role]
> GRANT CREATE TABLE TO [test_role]
> EXEC SP_ADDUSER [test_login], [test_user], [test_role]
> Then I run SQL Analyser and try to connect to the database using SQL
> Authentication:
> user: test_user
> password: psw
> and I am getting message:
> Unable to connect to server SSSSSS\NNNN
> Message: 18452, level 16, state 1,
> [Microsoft][ODBC SQL Server Driver][SQL Server] Login for user
"test_user".
> Reason: not associated with a trusted SQL Server connection
> with other SQL server instance it works OK?!
>|||In my case MSDE was set up to use Windows authentication only...|||is there any SQL query way to recognize what the mode is for an instance of
SQL Server?

Any difference between SQL Server 2000 and MSDE 2000?

I am creating an install program and I'm wondering if there is a

difference between SQL Server 2000 and MSDE 2000? Do they have

different entries in the Registry?

From the documentation that I've read it seems as if they are one and the same.

However, if someone knows how to differentiate between them in the Registry it would be greatly appreciated.
ThanksMSDE 2000 is the desktop engine of the SQL Server 2000.|||So as far as Registry entries go, there would be no noticeable difference between the two....is that correct?

Any difference between MSDE and SQL Server 2000 :-?

Hi,

I am developing an web-database application using ASP.net,c# and MSDE. and after the completion of the project i want to deploy the database over the server whichs got sql server professional edition.

Are there any changes to be made while deploying it over the server and also will the connection string for MSDE and SQL client the same ?

Please do clear me the confusions i have got ..

thanks inadvance

No difference. Just move it over, change the credentials you use to connect, and all will be well.|||

Hey Hi,

Thanks for ur reply man.. Now i dont have any kinda confusions with these 2, i will continue my work.

Thanks again

Answer: Access creates DB in MSDE in SQL Server Authentication mod

I've confirmed that MS Access will create an ADP project in MSDE only if the server is set to Mixed (SQL Server and Windows) authentication mode. Trials in Windows Authentication mode failed. This is still hard to believe, I know, but its a reality.
To all those who tried to help, my sincere thanks.
Lou Arnold
Ottawa, Canada
Lou,
Did you have to create users in the SQL database itself so that Domain
Users could access the MSDE, and if so, with what tool did you use?
"Lou Arnold" <Lou_Arnold@.nospam.com> wrote in message
news:EB2211E6-F5BD-4DD8-AC32-65B7B0DC0ECA@.microsoft.com...
> I've confirmed that MS Access will create an ADP project in MSDE only if
> the server is set to Mixed (SQL Server and Windows) authentication mode.
> Trials in Windows Authentication mode failed. This is still hard to
> believe, I know, but its a reality.
> To all those who tried to help, my sincere thanks.
> --
> Lou Arnold
> Ottawa, Canada