the server principal is not able to access the dat

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

the server principal is not able to access the dat

Author

Topic

arvind_ramugade
Starting Member

30 Posts

Posted - 2012-05-08 : 08:21:22

Hi,
I'm getting below error while trying to connect to d/b

the server principal is not able to access the database under the current security context 916

I'm trying to connect the d/b through Linux as below

TDSVER=8.0 /ms/dist/fsf/PROJ/freetds/0.82/bin/tsql -H dzwas1036 -p 7001 -U dmaskq -P xxxxxxx
locale is "C"
locale charset is "ANSI_X3.4-1968"
1> use QC_ETL_QA__alz
2> go
Msg 916, Level 14, State 1, Server DZWAS1036\NYQINW6T6, Line 1
The server principal "dmaskq" is not able to access the database "QC_ETL_QA__alz" under the current security context.

Pls advise.

Thanks & Regards
Arvind

ramugade

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2012-05-08 : 19:34:09

Is the LOGIN "dmaskq" mapped as a USER in your target database? Can that LOGIN successfully access the database when using Management Studio?

=================================================
There is a foolish corner in the brain of the wisest man. -Aristotle, philosopher (384-322 BCE)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources