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
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
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)
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.
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.
Login to the FXOS chassis manager.
Direct your browser to https://hostname/, and log-in using the user-name and password.
Go to Help > About and check the current version:
Check the current version availa...
We have configured the outside and inside Interface with official ipv6 adresses, set a default route on outside Interface to our router, we also have definied a rule , which also gets hits, to permit tcp from inside Interface to any6.
In Syslog I also se...