• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1056
  • Last Modified:

SQL Server 2008 Login Issue

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
Dovberman
Asked:
Dovberman
1 Solution
 
mcsweenSr. Network AdministratorCommented:
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
 
DovbermanAuthor Commented:
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now