Solved

sql server error 18452

Posted on 2014-04-20
4
554 Views
Last Modified: 2014-04-21
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
Comment
Question by:ajaymaster1558
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 37

Expert Comment

by:bbao
ID: 40012134
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
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 40012307
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
 
LVL 8

Accepted Solution

by:
Narender Gakka earned 500 total points
ID: 40012330
suspect this would resolve your issue with authentication or login.

http://support.microsoft.com/kb/555332
0
 

Author Closing Comment

by:ajaymaster1558
ID: 40012468
thanks that great
i just create new user to database and error gon
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Group Policy 5 18
Search Text in Views 2 27
SQL Simple Query Taking a Very Long Time 11 36
Total count in section based report in SSRS 10 11
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question