sql connection fail

[Leslie Lim]

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

[Simon Hayes]

Re: sql connection fail

"Leslie Lim" <accbase@pc.jar ing.my> wrote in message news:<c11fkr$44 t$1@news4.jarin g.my>...[color=blue]
> 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[/color]

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

[Jim Morrison]

help with sql server install/uninstall

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

[Erland Sommarskog]

Re: help with sql server install/uninstall

Jim Morrison (dorz11@comcast .net) writes:[color=blue]
> 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).[/color]

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.
[color=blue]
> 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.[/color]

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

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Jim Morrison]

Re: help with sql server install/uninstall

Erland thanks, see below:

Erland Sommarskog wrote:[color=blue]
> Jim Morrison (dorz11@comcast .net) writes:
>[color=green]
>>I recently installed sql server 2000. Unfortunately >[/color]
>
> There no reason to reinstall to get SQL authentication. Just right-
> click the database in Enterprise Manager,[/color]

I can't connect on any database in enterprise manager since it will not
connect.
[color=blue][color=green]
>>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.[/color]
>
>
> So what messages do you get?[/color]
A connection could not be established to (LOCAL)
Reason: Login failed for user 'Ripple\Jim'

[color=blue]
>
> When you try to use Windows authentication, are you logged into Windows
> as an administrator?[/color]

Yes[color=blue]
>
> If Windows authentication does not work it may be some registry hickup.
> But if sa does not work, you are using the wrong password.
>[/color]
Is there anyway to reset the sa password?

Thanks,

Jim

--

Effective Test Solutions, LLC
A Test Automation Company

http://www.effectivetest.com

[Erland Sommarskog]

Re: help with sql server install/uninstall

Jim Morrison (dorz11@comcast .net) writes:[color=blue]
> Erland Sommarskog wrote:[color=green]
>> There no reason to reinstall to get SQL authentication. Just right-
>> click the database in Enterprise Manager,[/color]
>
> I can't connect on any database in enterprise manager since it will not
> connect.[/color]

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

And of course, it is the server itself that you should right-click.
[color=blue][color=green]
>> When you try to use Windows authentication, are you logged into Windows
>> as an administrator?[/color]
>
> Yes[/color]

Hm, did you at some point revoke login rights for BUILTIN/Administrators?
[color=blue]
> Is there anyway to reset the sa password?[/color]

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

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp