Re: MSDE password change for "sa"

From: Dan Kennedy (dankennedy24_at_hotmail.com)
Date: 06/16/04 

Date: 16 Jun 2004 11:26:10 -0700

But the current "sa" password isn't blank... will that statement still
work? I login to the machine as a local admin and connect via the
osql statement as the same ID as I logon to the machine with.

Sue Hoegemeier <Sue_H@nomail.please> wrote in message news:<np8vc0p2v2lfj8ke5mm0vf6f8vmrfg9plg@4ax.com>...
> If you can login as an admin on the box and the
> builtin\administrators group login was not removed or
> modified, you will be logged in as a member of the sysadmins
> server role. As a sysadmin, you can execute the following to
> change the sa password:
> sp_password NULL, 'NewSaPassword', 'sa'
> Upgrading to SQL Server isn't too bad. Run the SQL Server
> installation CD. You will be asked if you want to upgrade
> your existing instance or install a new one. Choose to
> upgrade.
> For more detailed steps on upgrading, you can refer to the
> SQL Server Books Online topic:
> How to perform an edition upgrade within SQL Server 2000
> (Setup)
> http://msdn.microsoft.com/library/en-us/howtosql/ht_install_1d7y.asp
>
> -Sue
>
> On 15 Jun 2004 17:41:11 -0700, dankennedy24@hotmail.com (Dan
> Kennedy) wrote:
>
> >Hello,
> > If I can get into the default instance of MSDE using a Windows
> >account (trusted connection) using 'osql -E' is it possible for me to
> >change the 'sa' SQL account if I don't know the current password? The
> >Windows account is a domain admin and local box admin if that matters.
> > Also, can anyone point me to a Q article that will give me a step
> >by step on how to upgrade from MSDE to SQL so I can get past this 2GB
> >limitation?
> >
> >If anyone can answer these I am definitely buying beers!!
> >
> >Thanks,
> >Dan

Relevant Pages

  • Re: MSDE password change for "sa"
    ... Upgrading to SQL Server isn't too bad. ... You will be asked if you want to upgrade ... >Windows account is a domain admin and local box admin if that matters. ...
    (microsoft.public.sqlserver.server)
  • Re: Connextion Error After Installing SQL Server 2005 on Vista
    ... Your suggestion of right clicking and running as an admin worked perfectly. ... I right clicked the first login above and selected Properties. ... The solution is to explicitly grant Bob access to SQL Server. ... During the installation, I was prompted a couple of times to install a service pack for Visual Studio 2005, which is not currently installed. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2005 login with Windows Authentication
    ... I obviously installed SQL Server using my Francois (admin) local user ... So having stated that I chose windows authentication as ... And the reason for this is that a Windows login also can have access ...
    (microsoft.public.sqlserver.security)
  • RE: Linked server issue
    ... SQL Server logins to the Admin account of the Access database. ... Add a new linked server using SQL Server Enterprise Manager. ... Remote login: Admin ...
    (microsoft.public.sqlserver.tools)
  • Re: Capture IP Address
    ... I have some MS Access front end databases linked to SQL Server 2000 ... logins for every user that requests access to the database and capture every ... The interesting part is that the Login Failed attempt ... any of our databases named 'Admin' especially to our Master. ...
    (microsoft.public.sqlserver.security)