by Peter Olcot » Tue, 17 Jun 2003 20:41:50
by Keith Kratochvi » Tue, 17 Jun 2003 22:23:35
If this is a server that you installed, the (sa) password might be empty (unless you set it during install). If this is a server that someone else installed, it most likely has a password and you will need to contact someone in order to receive a valid user name and password that you can use.
--
Keith, SQL Server MVP
by Peter Olcot » Wed, 18 Jun 2003 07:31:33
What version of SQL Server? Did you recently install the server, or is this one that has been
installed for a while? Do you have a Database Administrator that might be in charge of this
database that you can contact in order to receive a user and password?
If this is a server that you installed, the (sa) password might be empty (unless you set it during
install). If this is a server that someone else installed, it most likely has a password and you
will need to contact someone in order to receive a valid user name and password that you can use.
--
Keith, SQL Server MVP
Quote:> I want to export the "Authors" table to MS Access to
> test some example ADO C++ code. It is asking for a
> password, and I don't know what it is.
by Keith Kratochvi » Wed, 18 Jun 2003 22:17:08
--
Keith, SQL Server MVP
> What version of SQL Server? Did you recently install the server, or is this one that has been
> installed for a while? Do you have a Database Administrator that might be in charge of this
> database that you can contact in order to receive a user and password?
> If this is a server that you installed, the (sa) password might be empty (unless you set it during
> install). If this is a server that someone else installed, it most likely has a password and you
> will need to contact someone in order to receive a valid user name and password that you can use.
> --
> Keith, SQL Server MVP
> > I want to export the "Authors" table to MS Access to
> > test some example ADO C++ code. It is asking for a
> > password, and I don't know what it is.
by Peter Olcot » Thu, 19 Jun 2003 20:36:39
I guess you could try connecting with the sa login and '' for a password.
Or create a login and password that you can use.
--
Keith, SQL Server MVP
by Keith Kratochvi » Thu, 19 Jun 2003 22:34:50
--
Keith, SQL Server MVP
> I guess you could try connecting with the sa login and '' for a password.
> Or create a login and password that you can use.
> --
> Keith, SQL Server MVP
by Tim Morriso » Thu, 19 Jun 2003 22:37:39
Tim Morrison
message
> I guess you could try connecting with the sa login and '' for a password.
> Or create a login and password that you can use.
> --
> Keith, SQL Server MVP
by Peter Olcot » Fri, 20 Jun 2003 08:21:30
> Tim Morrison
> > What is the sa login?
> > (I am brand new to SQL Server, and don't know anything about it,
> > except that it is called SQL server).
> message
> > I guess you could try connecting with the sa login and '' for a password.
> > Or create a login and password that you can use.
> > --
> > Keith, SQL Server MVP
by Peter Olcot » Fri, 20 Jun 2003 08:26:09
sa is the system admistrator account. If you have not set the password (during the initial install
or during installation of SQL Server Service Pack 4) it will be empty. SQL Server has two methods
of authentication. Windows and SQL Server. Windows authentication is based on the Windows
accounts. SQL Server authentication is based on a separate user name and password that are not tied
to the Windows network password.
--
Keith, SQL Server MVP
> I guess you could try connecting with the sa login and '' for a password.
> Or create a login and password that you can use.
> --
> Keith, SQL Server MVP
by Kalen Delane » Fri, 20 Jun 2003 08:45:55
--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
> > Tim Morrison
> > > What is the sa login?
> > > (I am brand new to SQL Server, and don't know anything about it,
> > > except that it is called SQL server).
in
> > message
> > > I guess you could try connecting with the sa login and '' for a
password.
> > > Or create a login and password that you can use.
> > > --
> > > Keith, SQL Server MVP
by Peter Olcot » Fri, 20 Jun 2003 11:16:11
> --
> HTH
> ----------------
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
> > Okay, now what is the SQL Administrator's Username: ???
> > > 'sa' stands for "SQL Administrator". It is the MASTER login that cannot
> be
> > > changed or deleted. If you have the sa password, you can do anything.
> This
> > > is why it is VERY important that if your SQL Server (or MSDE) is exposed
> to
> > > the internet, you MUST change the default password (which is blank)
> > > Tim Morrison
> > > > What is the sa login?
> > > > (I am brand new to SQL Server, and don't know anything about it,
> > > > except that it is called SQL server).
> in
> > > message
> > > > I guess you could try connecting with the sa login and '' for a
> password.
> > > > Or create a login and password that you can use.
> > > > --
> > > > Keith, SQL Server MVP
1. default password for sql server
hello
what's the default password admin sql server?
I try to create database for project central and I can't log as admin
thanks
arek
2. Help on Syntax for Case in Where Clause
3. MSDE install with Instance Name installs as default server
4. DB Design question: Do you create a separate PK in the join table?
5. Changing passwords for Oracle-installed Default users
7. SQL server default password...
9. Install SQL Server 7.0 when SQL Server 2000 is installed
10. SQL Server 2000 Install nobody knows the password.
11. What is the default password for the postgres user in the default
12. Access97: How to set form defaults based on SQL Server defaults
13. SQL*NET - is password encryption default or does it need to be enabled