microsoft sql server error 18456

Question

i have windows vista at my pc,but when i want to connect to SQL server 2005  the folowing error appear,

Server Name: KHALED-PC
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536

Answer 1

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

Answer 2

Welcome to MSDN Forums

Refer this link for connecting to SQL Server from Windows Vista, http://msdn2.microsoft.com/en-us/library/bb326612.aspx

- Deepak

Answer 3

 

i install microsoft SQL server 2005 at my pc,and i have windows vista installed on it, but when i open the SQL manegement studio and press connect the following error appear :

Error Number:

TITLE: Connect to Server
------------------------------

Cannot connect to KHALED-PC.

------------------------------
ADDITIONAL INFORMATION:

Login failed for user 'Khaled-PC\Khaled'. (Microsoft SQL Server, Error: 18456)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
TITLE: Connect to Server
------------------------------

Cannot connect to KHALED-PC.

------------------------------
ADDITIONAL INFORMATION:

Login failed for user 'Khaled-PC\Khaled'. (Microsoft SQL Server, Error: 18456)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

 

18456
Severity: 14
State: 1
Line Number: 65536 

 

my email: [e-mail]

Answer 4

Use "SQL Server 2005 Surface Area Configuration" to add yourself as an administrator on the SQL Server Instance.  In Vista, a Windows admin is not a SQL admin by default - they need to be added.

 

Answer 5

khaledaaa wrote:

i install microsoft SQL server 2005 at my pc,and i have windows vista installed on it, but when i open the SQL manegement studio and press connect the following error appear : Error Number: TITLE: Connect to Server ------------------------------ Cannot connect to KHALED-PC. ------------------------------ ADDITIONAL INFORMATION: Login failed for user 'Khaled-PC\Khaled'. (Microsoft SQL Server, Error: 18456) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ TITLE: Connect to Server ------------------------------ Cannot connect to KHALED-PC. ------------------------------ ADDITIONAL INFORMATION: Login failed for user 'Khaled-PC\Khaled'. (Microsoft SQL Server, Error: 18456) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------   18456 Severity: 14 State: 1 Line Number: 65536    my email: [e-mail]

Hi,

Check out the below link, I hope this will  solve your problem!!

 Login failed - Error Number: 18456 - Severity: 14 - State: 1

Answer 6

Aaron Alton wrote:

Use "SQL Server 2005 Surface Area Configuration" to add yourself as an administrator on the SQL Server Instance.  In Vista, a Windows admin is not a SQL admin by default - they need to be added.

 

This information was very accurate.  Thank you very much !

 

Answer 7

How can I get to Surface Area Configuration to add myself?

Answer 8

It is installed as part of the SQL Server Tools.

Please post your message in the "SQL Server Tools General" forum.

Answer 9

thank you guys

Answer 10

Simple, login as administrator for example. drill down to the security folder, right click on Log ins, and add the user u were trying to access with.

logoff, and login with the target user, connect to ur instance using SSMS.... done