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 :
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...
Do you need a fix IP for remote connection? ShowDo you need a fix IP for remote connection? Myth Truth How does it work? An Internet Service Provider will usually provide a user with a fix IP address that cannot be changed by the user himself. This number is used by another...
Connecting to a Ftp server under Ms-Dos ShowConnecting to a Ftp server under Ms-Dos The ftp command allows you to get connected using command lines. Some of these options provide an automatic connection; this is done through a list of commands store on a text file. ftp -i ...
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...
DB9 connector ShowDB9 connector The DB9 (originally DE-9) connector is an analog 9-pin plug of the D-Subminiature connector family (D-Sub or Sub-D). The DB9 connector is mainly used for serial connections, allowing for the asynchronous transmission of data as...
Types of connectors Show5-pin DIN plugs A DIN (or DIN5) connector is a plug with 5 pins, formerly used to connect keyboards to computers: The DIN5 connector has been made obsolete by PS/2 and USB connectors. Pins Pin number Function 1 Reset...
Ask your question Reply

1

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

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
  • +1

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