Solved

SQL Server 2008 Login Issue

Posted on 2013-05-13
2
1,042 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Input parameteres to DragOver 2 20
SQL USE DATABASE VARIABLE 5 30
RAISERROR WITH NOWAIT 2 18
Migration from SQL server to oracle (XML input) 4 28
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

820 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