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.
Any help will be appreciated.