FreeTDS Development Group

["O'Neil, Donald A." <DONALD.A.O'NEIL AT saic.com>]

Our DB admin detached the DB from the MSSQL server, ran a backup and the
re-attached the DB, and ever since he did that we're getting errors on
our FreeTDS scripts:

 

DBI connect('server=CCSD-WIN-DB01','NOCReader',...) failed: Server
message number=4064 severity=11 state=1 line=0 server=CCSD-WIN-DB01
text=Cannot open user default database. Login failed.Server message
number=18456 severity=14 state=1 line=0 text=Login failed for user
'NOCReader'.OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78)
NUMBER = (34)

Server CCSD-WIN-DB01, database

Message String: Adaptive Server connection failed

 at /scripts/engineering/list_routers.pl line 19

unable to connect to server Server message number=4064 severity=11
state=1 line=0 server=CCSD-WIN-DB01 text=Cannot open user default
database. Login failed.Server message number=18456 severity=14 state=1
line=0 text=Login failed for user 'NOCReader'.OpenClient message: LAYER
= (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (34)

Server CCSD-WIN-DB01, database

Message String: Adaptive Server connection failed

 

Anyone have any ideas as to what could have happened on the SQL side of
things to break this?

 

________________________________

Don O'Neil
Senior Network Engineer
SAIC - CCSD Network Operations
(702) 351-7261 cell

(702) 799-6174 fax

0099-5941 wan

oneilda AT saic.com