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

[Dirk Bulinckx]

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