Solved

sql server error 18452

Posted on 2014-04-20
4
533 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
4 Comments
 
LVL 37

Expert Comment

by:Bing CISM / CISSP
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

Integrate social media with email signatures

Is your company active on social media? Do you also use email signatures? Including social media icons in your email signature is a great way to get fans for free. Let all your email users know you’re on social media quickly and easily, in a single click.

Join & Write a Comment

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
A procedure for exporting installed hotfix details of remote computers using powershell
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

747 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now