Accessing Local CSA 5.2 SQL 2005 Express database

Unanswered Question
Sep 12th, 2008
User Badges:

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

Password:

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.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Solutionary Fri, 09/12/2008 - 11:28
User Badges:

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.

Actions

This Discussion