DEFAULT INSTANCE INSTALLATION PROBLEM ON SQL2005

I have win2003 machine which is named fenermarket.

I have an installed instance which is FENERMARKET\ALISVERISSAATI.

I installed sp1 and sp2 too.

When i try to install default instance as another instance the setup process
give the error.Im sure that my Sa password is true. I choose windows
authentication as aut type.


SQL service MSSQLSERVER started successfully waiting for SQL service to
accept client connections
Service MSSQLSERVER started at Mon Feb 04 19:18:21 2008
Loaded DLL:
C:\WINDOWS\system32\Odbc32.dll
Version:
3.526.3959.0


SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=28000, level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL
Native Client][SQL Server]Login failed for user 'sa'.

Error Code: 0x80074818 (18456)
Windows Error Text: Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Fri Jul 29 01:13:53 2005
Function Name: OdbcConnection::connect@connect
Source Line Number: 148



---- Context -----------------------------------------------


Connecting to SQL Server
ExecuteSqlCommands
Originial error was 80074818 (18456)
ipt
SqlScriptHlpr



Error Code: 18456

Where do you need the "sa" Login and it's password if you use Windows
Authentication in SQL Server Setup?

In this error, the key thing is to see the "State number" in Login Failed
error message. Here is a nice blog about this error:
http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

--
Ekrem Önsoy


"in da club" <s> wrote in message
news:umNJdQ1ZIHA.1164@TK2MSFTNGP02.phx.gbl...
>I have win2003 machine which is named fenermarket.
>
> I have an installed instance which is FENERMARKET\ALISVERISSAATI.
>
> I installed sp1 and sp2 too.
>
> When i try to install default instance as another instance the setup
> process give the error.Im sure that my Sa password is true. I choose
> windows authentication as aut type.
>
>
> SQL service MSSQLSERVER started successfully waiting for SQL service to
> accept client connections
> Service MSSQLSERVER started at Mon Feb 04 19:18:21 2008
> Loaded DLL:
> C:\WINDOWS\system32\Odbc32.dll
> Version:
> 3.526.3959.0
>
>
> SQL_ERROR (-1) in OdbcConnection::connect
> sqlstate=28000, level=-1, state=-1, native_error=18456,
> msg=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.
>
> Error Code: 0x80074818 (18456)
> Windows Error Text: Source File Name: lib\odbc_connection.cpp
> Compiler Timestamp: Fri Jul 29 01:13:53 2005
> Function Name: OdbcConnection::connect@connect
> Source Line Number: 148
>
>
>
> ---- Context -----------------------------------------------
>
>
> Connecting to SQL Server
> ExecuteSqlCommands
> Originial error was 80074818 (18456)
> ipt
> SqlScriptHlpr
>
>
>
> Error Code: 18456
>
>