Solved

SQL Server 2008 Login Issue

Posted on 2013-05-13
2
1,039 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
2 Comments
 
LVL 21

Accepted Solution

by:
mcsween earned 500 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

770 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