Search : in
By :

Connecting to SQL

Last answer on Oct 24, 2009 1:55:27 pm BST fahime, on May 15, 2009 12:19:40 pm BST 
 Report this message to moderators

Hello,
I have installed SQL Server 2005 and I can not connect to it , I dont know my server name and SQL Server show this error to me:
TITLE: Connect to Server
------------------------------

Cannot connect to home sql express.

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

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1231)

For help, click: http://go.microsoft.com/...

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

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

Configuration: Windows XP Internet Explorer 6.0

Best answers for « connecting to SQL » in :
Visual FoxPro and SQL Server ShowVisual FoxPro and SQL Server Visual Foxpro 9 and SQL Server 2005 Is there a better alternative than using Visual FoxPro to manage efficiently a SQL Server? Here's an interesting issue. For more information see the article:...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Error code 81000314 - Unable to connect ShowError code 81000314 - Unable to connect When connecting to MSN messenger, the following error message appears on your screen: The opening session. NET Messenger Service failed because the service is temporarily unavailable. Try...
Download Outlook Connector ShowConnector Microsoft Outlook allows to use Outlook 2003 or Outlook 2007 to access and manage freely your Windows Live Hotmail or Live Mail accounts, especially the contacts. Depending on the services, the calendar task synchronization and the notes...
Download Avanquest Connection Manager Free ShowWith the increasing development of wireless connection or Wifi, you can connect to internet almost anywhere. The only problem with this technology is that you must time configure your computer so that it can use the available network. Avanquest...
Download Connection Keeper ShowSometimes by downloading large files on a connection modem 56k, the computer thinks that you are not any more in active service and cut connection. Connection Keeper is a tool which will simulate an Internet browser in given spaces and regular....
Sharing an Internet connection ShowAdvantages If you have a local area network (two or more computers connected in a network) with one computer connected to the Internet (via a modem, using a cable, etc.), it may be useful to make the connection accessible to the other computers on...
Connecting the computer to a HIFI sound system ShowWhy connect a computer to a sound system? These days, computers provide sound quality that is as good as hifi sound systems. It is possible to use them to listen to music, in particular thanks to mp3 files that provide sound quality that is...
Sharing an Internet connection in Windows XP ShowAdvantages If you have a local area network (two or more computers connected in a network) with one computer connected to the Internet (via a modem, using a cable, etc.), it may be useful to make the Internet accessible to the other computers on...
Ask your question Reply

1

Bin2000, on May 15, 2009 12:26:02 pm BST
  • +2

How-to-make-database-connectivity-in-asp-net
this the problems

   
Reply to Bin2000

2

shijo Baby, on Jul 16, 2009 4:10:24 pm BST

Hi

I was also facing the issue some time before

i just got the solution

http://sqlservererror-info.blogspot.com/...


I helpfull pls leave acomment

   
Reply to shijo Baby

3

Skaria, on Jul 17, 2009 12:29:03 pm BST
  • +2

I got the reasons for the following error. This error is comming because you have to enable remote connection for sql server



Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact that under
the default settings SQL Server does not allow remote connections.

In the following url theire is ways to enable remote connections in sql server

http://sqlservererror-info.blogspot.com/...

   
Reply to Skaria

4

Tomas, on Jul 17, 2009 12:37:17 pm BST
   
Reply to Tomas

5

Sunil, on Jul 19, 2009 8:46:42 am BST

Hi

If you wants to know how to enable remote connections

in sql server 2005 pls visit this

http://aspnetmembershipprovider.blogspot.com/...


Regards

   
Reply to Sunil

6

Appu, on Jul 19, 2009 8:47:33 am BST

Hi

i was facing the error when opening connection using sqlconnection

nw got solved




http://aspnetmembershipprovider.blogspot.com/...


See This

   
Reply to Appu

7

saeed, on Jul 24, 2009 6:31:00 am BST
  • +3

Here is the solution :
those who use combination of Windows XP and SQLExpress and have not installed sql-server engine on system should add the /sqlexpress to end of server name string

   
Reply to saeed

8

Kathiravan Jayachandran, on Aug 11, 2009 4:01:04 am BST
  • +1

Yes, It will work when u add the mssmibiz at the end of your server name it workzzzzzz...

But if i add sqlexpress at the end of my servername it throwing error:26

Still there is some issues in Vista + SQL 2005 server.

Go to services.msc and start all the sql services..

Cool... It will work...

But how to connect with sqlexpress.. im able to connect with mssmibiz only ...

   
Reply to Kathiravan Jayachandran

9

 ABrightWorker, on Oct 24, 2009 1:55:27 pm BST
  • +1

Hi All,

There following possibilities.

1. Your SQl Browser is off
2. Protocols under SQLServer Configuration Manager > SQL Server 2005 Network Configuration > Protocols for SQL Express like TCP/IP, Named Pipes are disabled.

Resolution.

Just Start SQL Browser.
Enable the Protocols.
Restart SQL Express service.

This might resolve the problem

Thanks,
A Bright Worker

   
Reply to ABrightWorker
Ask your question Reply
They need your help