473,225 Members | 1,379 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,225 software developers and data experts.

sql connection fail

I had link my 4 of workstations to server with MySql.
1 pc of my pc can run a software which can update MsSql perfectly but not
others(3 failed).
I tried to add System Dsn data source for Control Panel - Odbc data source
32.
The pc which working fine with the software function but 3 of the rest not.
My pcs running xp and win98 !

Regards.
Thanks.

Leslie Lim

Jul 20 '05 #1
5 4222
"Leslie Lim" <ac*****@pc.jaring.my> wrote in message news:<c1**********@news4.jaring.my>...
I had link my 4 of workstations to server with MySql.
1 pc of my pc can run a software which can update MsSql perfectly but not
others(3 failed).
I tried to add System Dsn data source for Control Panel - Odbc data source
32.
The pc which working fine with the software function but 3 of the rest not.
My pcs running xp and win98 !

Regards.
Thanks.

Leslie Lim


You mention both MySQL and MSSQL - this newsgroup is for MSSQL only,
so if you have a problem with MySQL, you should post this in a MySQL
forum.

If your connection problem is with MSSQL, then you will need to give
some more information - what version of MSSQL do you have, how exactly
are you trying to connect, what errors do you get, can you connect
with osql.exe etc.

You may want to install the latest MDAC package to ensure that you
have the latest MSSQL client, and then try your connection again:

http://msdn.microsoft.com/data/

Simon
Jul 20 '05 #2
Hello,

I recently installed sql server 2000. Unfortunately I selected windows
access only. So i uninstalled sql server using the xp pro control panel
program uninstall (not the disc :-( ). Then I tried to install sql
server from the disc which hung things up since the uninstall didn't
actuall uninstall the server! So I reran the disc and selected upgrade
or remove existing, removed it (which still doesn't really do that but
never mind).

Finally I got it all back and working, everything is installed and
working EXCEPT.... I can't connect. All the former accounts I had that
worked don't work anymore. Windows authentication for my account used
to grant access, it no longer does. My sa entry does not work. So this
means when I try to start entrerprise manager it wont connect, meaning I
can't do anything account wise!!!

Tried uninstall, then reinstall again with disc but it does no good. An
uninstall really does not uninstall the server.

So what do I do?
1) is there a way to uninstall completely and start over?
2) is there a way to get admin or access setup with enterprise manager?

Any help would be kind,

Thanks,

Jim

Jul 20 '05 #3
Jim Morrison (do****@comcast.net) writes:
I recently installed sql server 2000. Unfortunately I selected windows
access only. So i uninstalled sql server using the xp pro control panel
program uninstall (not the disc :-( ). Then I tried to install sql
server from the disc which hung things up since the uninstall didn't
actuall uninstall the server! So I reran the disc and selected upgrade
or remove existing, removed it (which still doesn't really do that but
never mind).
There no reason to reinstall to get SQL authentication. Just right-
click the database in Enterprise Manager, choose Properties, and then
find the Security tab, where you can configure which authentication to
use.
Finally I got it all back and working, everything is installed and
working EXCEPT.... I can't connect. All the former accounts I had that
worked don't work anymore.


So what messages do you get?

When you try to use Windows authentication, are you logged into Windows
as an administrator?

If Windows authentication does not work it may be some registry hickup.
But if sa does not work, you are using the wrong password.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #4
Erland thanks, see below:

Erland Sommarskog wrote:
Jim Morrison (do****@comcast.net) writes:
I recently installed sql server 2000. Unfortunately >
There no reason to reinstall to get SQL authentication. Just right-
click the database in Enterprise Manager,


I can't connect on any database in enterprise manager since it will not
connect.
Finally I got it all back and working, everything is installed and
working EXCEPT.... I can't connect. All the former accounts I had that
worked don't work anymore.

So what messages do you get?

A connection could not be established to (LOCAL)
Reason: Login failed for user 'Ripple\Jim'


When you try to use Windows authentication, are you logged into Windows
as an administrator?
Yes
If Windows authentication does not work it may be some registry hickup.
But if sa does not work, you are using the wrong password.

Is there anyway to reset the sa password?

Thanks,

Jim

--

Effective Test Solutions, LLC
A Test Automation Company
http://www.effectivetest.com

Jul 20 '05 #5
Jim Morrison (do****@comcast.net) writes:
Erland Sommarskog wrote:
There no reason to reinstall to get SQL authentication. Just right-
click the database in Enterprise Manager,
I can't connect on any database in enterprise manager since it will not
connect.


Yeah, but you should have done this, instead of reinstalling.

And of course, it is the server itself that you should right-click.
When you try to use Windows authentication, are you logged into Windows
as an administrator?


Yes


Hm, did you at some point revoke login rights for BUILTIN/Administrators?
Is there anyway to reset the sa password?


Not without loggin in.

Difficult to say from a distance, but uninstall again, and this time make
sure that there is nothing left on disk, and also check the registry for
HKLM\Software\Microsoft\MSSQLServer and make sure it is not there anymore.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: pleake | last post by:
Following is a logon.asp script. This script works when IIS is reset each day. The epapi object is a vendor api program I do not have the code for! The logon process involves three servers: ...
4
by: James | last post by:
We've had a recurring problem where all of a sudden we get a DBMSSOCN General Network Error on any page that connects to SQL Server. Then we have to reboot the server and everything works fine...
1
by: Abby | last post by:
I'm writing a code to send/receive udp packet. I'll receive ip address from user (this is the starting ip), then I'll ask user how many ip he wants to connect to. For examples: Please enter 1st...
0
by: DT | last post by:
We have service oriented architecture that comprises of a number of Win2k/IIS boxes. Some of these web service applications access an AS400 system for data acess (We are using HitSoftware's Ritmo...
4
by: yop | last post by:
All I need to store a connection in the application object due to the need to use MYSQL and its very poor connection pooling. Would someone have an example as the code below is not working...
9
by: Scott Ribe | last post by:
OK, I'm using a pool of worker threads that each have a connection (from my own software, no PHP or anything like that involved), and a connection is in a state where all queries fail. Looking back...
1
by: Cylix | last post by:
I would like to get the error context about the fail connection, I am using ADODB.connection to connect the Database. Now, I just using Try conn.open(connectionString) Catch ex as exception...
16
by: crbd98 | last post by:
Hello All, Some time ago, I implemented a data access layer that included a simple connectin pool. At the time, I did it all by myself: I created N connections, each connection associated with...
1
by: Pradeep83 | last post by:
Hi All Problem : I am unable to retrieve the data from the table in postgres database using C application which i have written in solaris os. Query: How to check whether connection is there...
3
by: Alexnb | last post by:
Okay, I already made this post, but it kinda got lost. So anyway I need to figure out how to test if the user is able to connect to a specific website. Last time I got pointed to the urllib2 page,...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.