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

SQL 2005 from Windows 7.0 32 Bit OS

SQL 2005 / Windows 7.0

I have installed SQL 2005 on Windows 7.0. SQL 2005 is working fine on local machine .., But when i try to connect the database which are on the server ... it throws an exception !!

Please read the error message.

I am not able to figure it out .. whether it is LAN or Configuration Manager or ???
TITLE: Connect to Server
------------------------------

Cannot connect to FORMER.

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

The client was unable to establish a connection because of an error during connection initialization process before login. Possible causes include the following:  the client tried to connect to an unsupported version of SQL Server; the server was too busy to accept new connections; or there was a resource limitation (insufficient memory or maximum allowed connections) on the server. (provider: Named Pipes 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

------------------------------
BUTTONS:

OK
------------------------------

Open in new window

0
chokka
Asked:
chokka
  • 5
  • 3
1 Solution
 
robertg34Commented:
*Click start, all programs, microsoft sql server 2005, configuration tools, sql server configuration manager
*Then choose, the 'surface area configuration for services and connections'
*Choose 'remote connections'
*Finally select 'local and remote connections' using both tcpip and named pipes

0
 
chokkaStudentAuthor Commented:
I did as per your comment. But still i am facing this issue !!
TITLE: Connect to Server
------------------------------

Cannot connect to former.

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

The client was unable to establish a connection because of an error during connection initialization process before login. Possible causes include the following:  the client tried to connect to an unsupported version of SQL Server; the server was too busy to accept new connections; or there was a resource limitation (insufficient memory or maximum allowed connections) on the server. (provider: Named Pipes 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

------------------------------
BUTTONS:

OK
------------------------------

Open in new window

0
 
chokkaStudentAuthor Commented:
robertg34:  Thank you.

I think there is a problem on Connecting Server Computer ( i.e Former ).
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
chokkaStudentAuthor Commented:
This issue is in SQL 2008 installed Computer.


When i tried to connect Former ( Thats the name of the Comp which has SQL 2008), i am facing this problem !!
0
 
robertg34Commented:
Do you have admin rights on the server?  
0
 
chokkaStudentAuthor Commented:
Former is my local Machine. I have Admin Rights.

I am actually trying to connect my local server from another computer ..!
0
 
chokkaStudentAuthor Commented:
Do we need to do some steps on SQL Server Surface Area Configuration ???
0
 
robertg34Commented:
What is the name of the server with the sql 2008 database you are trying to connect to?  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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