Re: DEFAULT INSTANCE INSTALLATION PROBLEM ON SQL2005
  Home FAQ Contact Sign in
microsoft.public.sqlserver.setup only
 
Advanced search
POPULAR GROUPS

more...

 Up
Re: DEFAULT INSTANCE INSTALLATION PROBLEM ON SQL2005         

Group: microsoft.public.sqlserver.setup · Group Profile
Author: Ekrem Önsoy
Date: Feb 4, 2008 10:20

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" 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
>
>
no comments
diggit! del.icio.us! reddit!