View Single Post
  #2 (permalink)  
Old September 12th, 2013, 06:43 AM
bill071 bill071 is offline
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2013
Location: Chicago area
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default I made some progress

I decided not to use SQL Server 2000. Instead I used SQL Server 2005 Express. SQL Server 2005 Express was much easier to install since it had a GUI interface. When using the “ODBC Database Source Administrator”, I got to the “Microsoft SQL Server DSN Configuration” window. When I clicked next I got the follow message:

Connection failed:
SQLState: '08001'
SQL Server Error: 2
[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].
Connection failed:
SQLState: 'HYT00'
SQL Server Error: 0
[Microsoft][SQL Native Client]Login timeout expired
Connection failed:
SQLState: '08001'
SQL Server Error: 2
[Microsoft][SQL Native Client]An error has occured 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.

I looked at the documentation on the internet for this type of problem. All of it talks about how to allow remote connections. I do not have any remote connections. I just have one stand alone PC. I did all that stuff to allow remote connections any ways to see if that helped. It did not. Does anyone have any ideas?