RE: [SA-list] SQL Server 2000 DB check

[Dirk Bulinckx]

They need to be installed.

And in the start of the mail he said that the Enterprise manager worked and that the sqldmo libs are installed, so that should be ok.

 

dirk.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Ross, Tim (MAN-RS)
Sent: Wed Mar 26 5:52 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [SA-list] SQL Server 2000 DB check

Just an observation, but you used to have to have the SQL Enterprise Manager loaded to have the network libraries for the SA SQL check to work correctly... I never saw this mentioned in any of the emails.

-----Original Message-----
From: Terry Dart [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 10:26 AM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] SQL Server 2000 DB check

The appropriate SQL libraries are selected. The username sa and password have been re-entered several times and are definatly correct.

 

SQL Server 200 is using SQL authorisation.

 

I have tried running the check whilst SA is running as a service and as an application.

 

How should I enter the database name, I have tried entering the name on its own and I have tried preceding the database with the name of the server but none of them work.

 

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Dirk Bulinckx
Sent: 26 March 2003 14:09
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] SQL Server 2000 DB check

Did you specify a username/password for the check?

What authentication is SQL using?

 

dirk.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Terry Dart
Sent: Wed Mar 26 3:03 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] SQL Server 2000 DB check

I have tried running as both and neither work.

 

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Dirk Bulinckx
Sent: 26 March 2003 13:44
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] SQL Server 2000 DB check

Try it as application to see if that works.

 

dirk.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Terry Dart
Sent: Wed Mar 26 2:40 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] SQL Server 2000 DB check

It is running as a service.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Dirk Bulinckx
Sent: 26 March 2003 13:23
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] SQL Server 2000 DB check

How is SA running?

As application or as service?

 

 

dirk.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Terry Dart
Sent: Wed Mar 26 1:02 PM
To: [EMAIL PROTECTED]
Subject: [SA-list] SQL Server 2000 DB check

Hello

 

I am having trouble getting the SQL Server DB check to work on Servers Alive. I have read some previous comments about users having this same problem but everything that needs to be installed on the machine should be, Enterprise Manger and an SQL client works on the machine and the file sqldmo.dll is present on the machine and is in the registry so I assume that the DLL must have been successfully registered

 

Every time I run the check I get the following error message

 

'Unsuccessful connection MS-DMO (ODBC SQL State: 0800) Error 0:{Microsoft} ODBC SQL Server Driver}{DBNETLIB SQL Server does not exist or access denied.| [MS][ODBC SQL Server Driver][DB NetLib]Connection Open (connect())'

 

I would appreciate any help I could get from anyone who has a fix for this problem or can tell me what else on the machine in question I need to look for

 

 

Thanks

********************************************************************************
This e-mail is confidential and may be privileged. It may be read, copied and used only by the intended recipient.
If you have received this in error, please contact the sender immediately by return e-mail or by telephoning +44 (0)29 2027 0000. Please then delete the e-mail and do not disclose its contents to any other person.
We believe, but do not warrant that this e-mail and any attachments are virus free. You should take full responsibility for virus checking.
The Peacock Group plc reserve the right to monitor all e-mail communications through their internal and external networks.
********************************************************************************

********************************************************************************
This e-mail is confidential and may be privileged. It may be read, copied and used only by the intended recipient.
If you have received this in error, please contact the sender immediately by return e-mail or by telephoning +44 (0)29 2027 0000. Please then delete the e-mail and do not disclose its contents to any other person.
We believe, but do not warrant that this e-mail and any attachments are virus free. You should take full responsibility for virus checking.
The Peacock Group plc reserve the right to monitor all e-mail communications through their internal and external networks.
********************************************************************************

********************************************************************************
This e-mail is confidential and may be privileged. It may be read, copied and used only by the intended recipient.
If you have received this in error, please contact the sender immediately by return e-mail or by telephoning +44 (0)29 2027 0000. Please then delete the e-mail and do not disclose its contents to any other person.
We believe, but do not warrant that this e-mail and any attachments are virus free. You should take full responsibility for virus checking.
The Peacock Group plc reserve the right to monitor all e-mail communications through their internal and external networks.
********************************************************************************

********************************************************************************
This e-mail is confidential and may be privileged. It may be read, copied and used only by the intended recipient.
If you have received this in error, please contact the sender immediately by return e-mail or by telephoning +44 (0)29 2027 0000. Please then delete the e-mail and do not disclose its contents to any other person.
We believe, but do not warrant that this e-mail and any attachments are virus free. You should take full responsibility for virus checking.
The Peacock Group plc reserve the right to monitor all e-mail communications through their internal and external networks.
********************************************************************************

This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.