[quoted text, click to view]

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/

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

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 (dorz11@comcast.net) writes:
[quoted text, click to view]

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.

[quoted text, click to view]

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, sommar@algonet.se

Books Online for SQL Server SP3 at

Erland thanks, see below:

[quoted text, click to view]

I can't connect on any database in enterprise manager since it will not
connect.

[quoted text, click to view]
A connection could not be established to (LOCAL)
Reason: Login failed for user 'Ripple\Jim'


[quoted text, click to view]

Yes
[quoted text, click to view]
Is there anyway to reset the sa password?

Thanks,

Jim

--

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

Jim Morrison (dorz11@comcast.net) writes:
[quoted text, click to view]

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

And of course, it is the server itself that you should right-click.

[quoted text, click to view]

Hm, did you at some point revoke login rights for BUILTIN/Administrators?

[quoted text, click to view]

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, sommar@algonet.se

Books Online for SQL Server SP3 at