SQL server error - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 03-04-2008, 11:32 AM   #1 (permalink)
I know things...
 
wicked23's Avatar
 
Join Date: Jun 2006
Location: Pennsylvania
Posts: 398
Default SQL server error

I'm running windows XP pro and I'm getting an error everytime I try to connect a new ststem data source, in the odbc data source administrator box. I've googled the error and none of the recommended fixes worked.
here is the error:

Microsoft SQL server login
connection failed:
sql state:'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.

Now i know this issue is only on one machine. It has nothing to do with permissions etc. It worked then after i tried to connect 2 the tables using access 07 it screwed something up.

I tried deleting the connection and reestablising another in hopes it would get corrected, this also gives me an error.
I noticed when I add the new sql server driver, when I go to connect to the server, my server is in the drop down box twice. I think the problem lies here.
In every other pc it is in only once. I can connect to other servers but not the one I need . This has stumped alot of people.

Is there any way to resetthat list of servers to get rid of the glitch?
__________________

wicked23 is offline  
Old 03-04-2008, 11:59 AM   #2 (permalink)
I know things...
 
wicked23's Avatar
 
Join Date: Jun 2006
Location: Pennsylvania
Posts: 398
Default Re: SQL server error

I quess what I'm after is the name of the .dll i can replace that is associated with the list of network servers.
__________________

wicked23 is offline  
Old 03-05-2008, 09:28 AM   #3 (permalink)
I know things...
 
wicked23's Avatar
 
Join Date: Jun 2006
Location: Pennsylvania
Posts: 398
Default Re: SQL server error

what no suggestions????
wicked23 is offline  
Old 03-05-2008, 09:58 AM   #4 (permalink)
Repeat Offender
 
superdave1984's Avatar
 
Join Date: Aug 2006
Location: South Fulton, TN
Posts: 1,980
Default Re: SQL server error

Have you tried reinstalling the ODBC driver?
__________________
Change the world. Of one person. Today.

If your equation requires either a complex combination of variables to get the desired result OR you can't seem to get the result regardless of the variables....it ain't your variables, it's your constant.
superdave1984 is offline  
Old 03-05-2008, 10:23 AM   #5 (permalink)
I know things...
 
wicked23's Avatar
 
Join Date: Jun 2006
Location: Pennsylvania
Posts: 398
Default Re: SQL server error

Do you mean the sql server driver in the odbc data source administrator box? Then YES that is when i get the error. When the original connection got corrupted I deleted the driver then tried to reinstall.
wicked23 is offline  
Old 03-05-2008, 11:42 AM   #6 (permalink)
I know things...
 
wicked23's Avatar
 
Join Date: Jun 2006
Location: Pennsylvania
Posts: 398
Default Re: SQL server error

fixed it. if anyone cares here is the solution.

in the registry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\connectto
apparently when i tried to connect to sql databases with access 07 i prematurely closed out the process and there was an entry here and in DB-lib that had to be deleted.
It was like it was permately stuck into trying to connect, hence why I had to of the same exact server names in my drop box. In connectto OBDC temporary shows the connection in connecto then deletes it when finish
wicked23 is offline  
Old 03-05-2008, 05:28 PM   #7 (permalink)
Call me Mak or K
Mod Emeritus
 
KSoD's Avatar
 
Join Date: Sep 2004
Location: C:\
Posts: 35,647
Default Re: SQL server error

Glad you got it fixed. I just found some info on this finally. But sadly none of the solutions were as easy as what you had found. They involved some intense testing to find the issue. Glad it is working now for you though.
__________________

__________________
I do not accept support questions via EMail, PM, IM or my G+ page!

Phone: LG Optimus G Pro
Running: Stock JB from LG with Nova Launcher

KSoD is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Free Copies of Windows Server, SQL Server and Visual Studio 2008 Osiris Microsoft Windows and Software 0 01-22-2008 10:31 AM
Try Microsoft Windows Home Server for 120 Days Osiris Microsoft Windows and Software 0 11-04-2007 07:13 PM
Convince me to build a server.....please jfenwick System Upgrades 5 10-30-2007 01:27 PM
Domain Controller and SQL server Build abadjay New Systems | Building and Buying 2 10-05-2007 08:39 AM
vBulleting Forum installed last night; SQL Error #1226 Today Slam'n Systems Internet Software and Browsers 0 07-11-2007 06:13 PM



Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 08:42 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.