TDS just 'died'
"O'Neil, Donald A." <DONALD.A.O'[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <60A966341E6EB342B08B956223D8A9C503B47B61@0461-its-exmb02.us.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
[email protected]