From: Tom DE B. <Tom...@dh...> - 2003-04-29 12:26:31
|
Dear Roy, I think you will not like my reply, but it does look like a password issue. Here is what I get when using a correct login (how would you love to see this :-): [root@netsaint libexec]# sqsh -D product -P xxxxxxxx -U sa -S server sqsh-2.1 Copyright (C) 1995-2001 Scott C. Gray This is free software with ABSOLUTELY NO WARRANTY For more information type '\warranty' [13] server.Product.1> quit And here is what I get when using a wrong password: [root@netsaint libexec]# sqsh -D product -P yyyyyyyy -U sa -S server sqsh-2.1 Copyright (C) 1995-2001 Scott C. Gray This is free software with ABSOLUTELY NO WARRANTY For more information type '\warranty' Msg 18456, Level 14, State 1 Login failed for user 'sa'. So that looks exactly like what you are seeing. A few additional questions: 1) Is it a SQL account you are using to log in, or a domain account? 2) Can you log in with that account using the Win32 Query Analyzer? 3) Did you specify the server in your freetds.conf file? 4) What SQL server version are you using? 5) Have you already tried with another account (maybe the nagios user doesn't have rights on the database you are trying to connect to)? Tried "sa" already? Kind regards, Tom Roy Sigurd Karlsbakk wrote: > hm. > > this doesn't look good. > > I can't get in to any server at all! > And the username/password pair is double checked > > Any ideas? > > roy@utility:~$ sqsh -D metabase -P xxxxxx -U nagios -S display00 > sqsh-2.1 Copyright (C) 1995-2001 Scott C. Gray > This is free software with ABSOLUTELY NO WARRANTY > For more information type '\warranty' > Msg 18456, Level 14, State 1 > > Login failed for user 'nagios'. > roy@utility:~$ sqsh -D prontobase -P xxxxxx -U nagios -S display01 > sqsh-2.1 Copyright (C) 1995-2001 Scott C. Gray > This is free software with ABSOLUTELY NO WARRANTY > For more information type '\warranty' > Msg 18452, Level 14, State 1 > > Login failed for user 'nagios'. Reason: Not associated with a trusted SQL > Server connection. > roy@utility:~$ > > > On Tuesday 29 April 2003 11:13, Tom DE BLENDE wrote: > >>Here is a small example script I wrote. It verifies whether all >>Maintenance Plans on a server have finished without problems during >>the last x minutes. You have to schedule it to run every x minutes and >>then provide the x minutes as an argument to the plugin. >> >>I have some more to check for: >>blocked processes >>running dbcc's during office hours >>running backups during office hours >>replication being up and running >> >>Roy Sigurd Karlsbakk wrote: >> >>>I am ;-) >>> >>>On Monday 28 April 2003 16:16, Tom DE BLENDE wrote: >>> >>>>I've got a few scripts to check ms sql using sqsh if someone is >>>>interested... >>>> >>>>Roy Sigurd Karlsbakk wrote: >>>> >>>>>What's the status of check_mssql now? >>>>> >>>>>On Friday 04 April 2003 02:07, Sam Tilders wrote: >>>>> >>>>>>According to the mailing list archives, >>>>>> >>>>>>From: Jonathan Rozes <jrozes@vi...> >>>>>>RE: MSSQL plugin ? >>>>>>2002-11-27 11:13 >>>>>> >>>>>>posted a check_mssql plugin that used "sqsh" to check a MS SQL Server. >>>>>> >>>>>>I was starting to write one myself when I checked the archives. >>>>>>Unfortunately the archives don't seem to include the attachment of the >>>>>>actual plugin script. >>>>>> >>>>>>If "Jonathan Rozes" is still on the list of anyone knows how else to >>>>>>get the script perhaps they could pipe up and say so... >>>>>> >>>>>>It'd be great to try out a script someone else has already written. >>>>>>Doesn't seem to have made it into the contrib or anything though. > > |