Cisco Support Community
Step-by-Step Configuration and Troubleshooting Best Practices for the NGFW, NGIPS and AMP Technologies A Visual Guide to the Cisco Firepower Threat Defense (FTD)
Community Member

Accessing Local CSA 5.2 SQL 2005 Express database

How can I go about opening/accessing/showing tables and data with a local 2005 SQL Express on a 5.2 server? Is there a default username/password to gain access to the DB?

Looking at the Database Maintenance option it shows

DB Server: (local)

DB Name: csamc52

Connection type: trusted

Here is what I tried so far.

1> use csamc52

2> go

Msg 916, Level 14, State 1, Server MD-CSA, Line 1

The server principal "MD-CSA\csa" is not able to access the database "csamc52" under the current security context.

1> select @@version

2> go

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)

Feb 9 2007 22:47:07

Copyright (c) 1988-2005 Microsoft Corporation

Express Edition on Windows

NT 5.2 (Build 3790: Service Pack 2)

(1 row affected)

1> exit

Then attempted the CSAMC credentials and got the following.

C:\Program Files\Support Tools>osql -U csaadmin


Login failed for user 'csaadmin'. The user is not associated with a trusted SQL Server connection.

Do I have to have Administrative privileges on the server to access the DB? Should there have been an SA account set during a manual installation? I believe it was installed/set-up with the automatic install of 2005 express during the CSAMC installation.

Any help will be appreciated.

Community Member

Re: Accessing Local CSA 5.2 SQL 2005 Express database

Once receiving local admin privileges on the csa server, I did a osql -E and had access to the DB. I just wanted to post the resolution in case others happen to come across the same predicament in the future.

CreatePlease to create content