Accessing Local CSA 5.2 SQL 2005 Express database

Solutionary — Sun, 10 Mar 2019 11:17:41 GMT

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

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

Password:

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.

Re: Accessing Local CSA 5.2 SQL 2005 Express database

Solutionary — Fri, 12 Sep 2008 18:28:42 GMT

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.

topic Accessing Local CSA 5.2 SQL 2005 Express database in Network Security

Accessing Local CSA 5.2 SQL 2005 Express database

Re: Accessing Local CSA 5.2 SQL 2005 Express database