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

[Terry Dart]

Thanks I will try that.

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

First tab of the entry

 

dirk.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Terry Dart
Sent: Thu Mar 27 9:58 AM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] SQL Server 2000 DB check

I cannot see a prompt for hostname where I can put the name of the SQL server.

 

Under the DB check information I say that it is an SQL Server check, the database name (which is admn), the username and password and the SQL library to use.

 

 

Terry

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

hostname should be the name of the sql server

database name the name of the database.

 

dirk.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Terry Dart
Sent: Wed Mar 26 5:26 PM
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: sal

********************************************************************************
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.
********************************************************************************