?
Solved

SQL Server 2008 Login Issue

Posted on 2013-05-13
2
Medium Priority
?
1,049 Views
Last Modified: 2013-05-14
I installed SQL Server 2008 on my new Windows 8 machine.

It had been installed on my Windows 7 machine and was running well for 3 years.

Here is the login error:

Cannot connect to ADMIN-PC1\MSSQLSERVER3.

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

Explanation
The SQL Server client cannot connect to the server. This error could occur because the server is not configured to accept remote connections.

How do I configure the server to accept remote connections?SQL Server :Login Error
   
User Action
Use the SQL Server Surface Area Configuration tool to allow SQL Server to accept remote connections. For more information about the SQL Server Surface Area Configuration Tool, see Surface Area Configuration for Services and Connections.

Where do I find the SQL Server Surface Area Configuration tool ?
0
Comment
Question by:Dovberman
[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
2 Comments
 
LVL 22

Accepted Solution

by:
mcsween earned 2000 total points
ID: 39161694
At the server:

1. Start, All Programs, Microsoft SQL Server 2008 R2, Configuration tools, SQL Server Configuration Manager
2. SQL Server Network Config, TCP/IP (Make sure set to enabled)
3. Control Panel, Admin Tools, Windows Firewall With Advanced Security
4. Inbound Rules, Click New Rule
5. Port, Next
6. TCP, Specific port 1433, Next
7. Allow the Connection
8. Check Domain (you can select all 3 if you like), Next
9. Name: Allow SQL 1433, Finish
0
 

Author Comment

by:Dovberman
ID: 39162119
I followed the steps and enabled TCP/IP.

>>Control Panel, Admin Tools, Windows Firewall With Advanced Security>>

The following error occurred:

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

Cannot connect to ADMIN-PC1\MSSQLSERVER3.

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

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

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

I am not sure what to enter as the Login Name.

How can I find out what my Login Name is?  I set one up but forgot what it is.

Thanks,
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Suggested Courses

777 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