Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 ERROR 53

Author  Topic 

Trteresa
Starting Member

2 Posts

Posted - 2010-05-06 : 17:30:43
I am completely new at this so i might need a lot of help. My problem is the following:

Im trying to Specify a username and password for WhatsUp Gold to use when connecting to SQL Server 2005 Express for this I have to follow several steps:
a- From the Windows Start menu, select Control Panel > Administrative Tools > Data Sources and select the System DSN tab.
b- Select the WhatsUp DSN and click Configure. The Configuration wizard opens.
- Verify that the fields in the first dialog are correct for your SQL Server authentication preferences, then click Next.

c- On the second dialog, verify that the With SQL Server authentication using login ID and password entered by the user option is selected. In the Login field, enter the SQL username. In the Password field, enter the SQL user's password.

And here comes my problem, doing this step i get the following error:

[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [53].
[Microsoft][SQL Native Client]Login timeout expired
[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.

The default user name and password of the WHATSUP GOLD services:
user name: sa
Password: WhatsUp_Gold

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-06 : 17:40:13
http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Trteresa
Starting Member

2 Posts

Posted - 2010-05-06 : 18:26:05
Thank U for answering the post, but honestly I still have no idea of what to do. I read the info of the link U posted but there are several thing i have already done and some others i have no idea of how to do them.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-06 : 18:40:59
Let's start with some of the easier stuff:

1. Try HostName\SQLExpress for the server name
2. Try HostName,PortNumber (you'll need to look this up in SQL Server Config. Mgr. or in the Error Log)
3. Telnet HostName PortNumber (access telnet from Start..Run..cmd)

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -