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

SQL Server error 10061

Hello guys !!

I have a "server" that has a reporting tool called Artus and connect to a SQL Server 2000.
It has been working perfectly for more than 10 months until Monday.
Since then I'm receiving the following error:

Connection failed:
SQLState: '01000'
SQL Server Error:10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]connectionOpen(Connect()).
Connection failed:
SQLSTate: '08001'
SQL Server Error:17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

What can I do?
0
Mighty_Ed
Asked:
Mighty_Ed
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
1) check if the sql server is indeed started on the server
2) check which service pack you have on the windows server installed (which version of windows?), and which service pack your sql server has (should be at least SP3)
0
 
Mighty_EdAuthor Commented:
yes it's started the rest of my users, myself and other servers are connected to it.

The workstation I'm willing to reconnect to the server is XP PRO SP2

The server I'm willing to reconnnect is NT 4.0


AGAIN; everything was working perfectly. I think ity has something to do with daylight savings because in Mexico we changed on Sunday
0
 
Mighty_EdAuthor Commented:
Well I finally solved this out.
For some reason the server was blocking the port and the session, I stopped the service, started it again and exactly when the service starts I started the session and everything worked out.

Thanks anyway
0
 
GranModCommented:
PAQed with points refunded (500)

GranMod
Community Support Moderator
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

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