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 5 4257
"Leslie Lim" <ac*****@pc.jar ing.my> wrote in message news:<c1******* ***@news4.jarin g.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
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
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
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
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\M icrosoft\MSSQLS erver 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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: the IIS server, a Novell Server
with executable programs on it including the API program,
and an Oracle server. The logon sequence is to use the
IIS anonymous user account to access the Novell Server
which in turn instructs the API programs as to...
|
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 again, for a few more hours
and then we have the same problem. Someone suggested adding ";Network
Library=DBMSSOCN" to our connection strings. I've tried to figure out
exactly what this does and why not having it would be a problem. Any ideas?...
|
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 ip: 192.168.0.1
How many ip do you want to connect to: 10
Then, my program will create an array to store 10 ip addresses,
starting from
192.168.0.1
|
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 .net
native driver). For fail over we route these requests
through a hardware based load balancer (BigIP).
The BigIP allows us to fail over to a secondary AS400 system
in case the primary one fails.
|
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 correctly.
Thanks
| |
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 through the log I find the
first entry where this connection has an error (there are successful queries
on it prior, so it's not the first query):
2004-06-21 14:51:19 LOG: query: begin; set constraints all
deferred;
insert into...
|
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
msgbox(ex.message)
End try
|
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 a worker thread that would
execute the db commands. The pool was fixed and all the connections
were created when the db access class was instantiated. The
connections remained opened during the whole execution. If a connection
was not available...
|
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 between postgres database and C application(which we have written for accessing the database) ?
My code is comiling successfully if i run it then its giving o/p as following :
output
|
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, but if I do urlopen() and and
am not connected, the program stops. So I don't know if that was what you
guys wanted me to do, but I don't think so, you guys are smarter than that.
So, how can I test for connection to a website.
--
View this...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |