Hi,
If I connect to
SQLServer Express via Windows Authentication it works
fine. But if I use SQL Server Authentication it doesn't work with a new
created user and
sa (with a new password) too. I turned mixed mode on, registry key
HKLM\Software\Microsoft\Microsoft Sql Server\MSSQL.1\\MSSQLServer\login
has the value 2 and all ports are set to 1433 but there is still
error 18452. Any suggestions
Error 18452
Hot Topic
- Changes not replicated to subscriber
- Microsoft SQL Server Management Studio problem
- Connection failed!
- Can't connect with Visual Web Developer Express
- NEWSEQUENTIALID()
- SSIS in .NET 2005
- setting variable value
- Watching an incoming directory for files to process
- Can't Connect to SQL 2005 Express Edition via Server Manangment Studio
- SSIS 64bit to MSAS 64 bit
SQL Server
- Newbie - What is the CLR Keyword/Method for @@IDENTITY - thanks!
- How to change the value of a variable within data flow
- Logon Failu unknown user name or bad password - using xp_cmdshell or bulk insert
- Encryption not supported on SQL Server - Error Message
- SP1 Installation Failure for Reporting Services Instances
- Data Flow Source for dbf (DBASE IV) files
- SQL 2000 and 2005 on same server
- Easiest way to start and read a trace from within a SSIS package
- SQL Server 2000 and SQL Server 2005 on the same computer
- Data-Driven Subscription not shown
Error 18452
custom gljaber
Thank you.
Moshik
Kean
What is the exact error message that you are getting back Take a look at the errorlog as well to see what message is logged there.
How are you trying to connect If you're connecting through an application, make sure that you don't specify integrated authentication in the connection string.
Thanks
Laurentiu
David Collie
Did you restart the server service
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
vinod123
Marcus2828