• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 616
  • Last Modified:

sql server error 18452

i get  error 18452
when i connect to sql server that install on windows 7 host pc

i open port 1433 and get this error
0
ajaymaster1558
Asked:
ajaymaster1558
1 Solution
 
bbaoIT ConsultantCommented:
here are some steps to troubleshoot the issue.

1. make sure the SQL service has been started up. you may check this with either SQL management console or NET START at command prompt.

2. make sure TCP port 1433 is being listen for the SQL service. you may use "netstat -an" to check this. if not, go to SQL management console to verify the services and port settings.

3. verify SQL Server Surface Area Configuration, make sure it has enabled both local and REMOTE connection. by default, only local connection is allowed.

i guess your issue is just caused by this configuration.

FYI

http://technet.microsoft.com/en-us/library/ms173748(v=sql.90).aspx
0
 
Carl TawnSystems and Integration DeveloperCommented:
What authentication mode did you select when you installed? Are you connecting locally (i.e. on the server where SQL is installed) or are you connecting remotely?
0
 
Narender GakkaAWS / DevOps / Cloud ConsultantCommented:
suspect this would resolve your issue with authentication or login.

http://support.microsoft.com/kb/555332
0
 
ajaymaster1558Author Commented:
thanks that great
i just create new user to database and error gon
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now