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
 Other SQL Server 2008 Topics
 Access Denied in SQL 2008

Author  Topic 

Lefteris
Starting Member

3 Posts

Posted - 2010-01-08 : 14:38:19
I have create my code in order to write images in a remote sql server
All the details of accessing and writing are fine until now, including the system account
right now i'm in the following command
SqlFileStream = New SqlFileStream(filePathName, fileToken, FileAccess.Write)
and when i'm trying to execute gives me the 'Access denied' error
i have made all the posible ( those which i know) combinations to overcome this error but nothing
Please give me the best assistance you may have
the tables for the image writing have the picture of ([username].[tPDetails] and [username].[tPImages]), i've done that in order to have the full access in the tables
Which i have it also with the picture of ([do].[tpDetails] and [dbo].[tPImages])

Now the error message has change from 'Access Denied' to
'The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you'

Lefteris Gkinis
pginis@principalit.gr
0030 22960 32843

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2010-01-08 : 16:16:06
Have you tried connecting to sql server through SQL Server management studio?
Just to doublecheck if it's not an application issue.



Jack Vamvas
--------------------
http://www.ITjobfeed.com
Go to Top of Page

Lefteris
Starting Member

3 Posts

Posted - 2010-01-10 : 13:00:32
Yes of cource always i'm looking on remote SQL server throu Management studio


Lefteris Gkinis
pginis@principalit.gr
0030 22960 32843
Go to Top of Page
   

- Advertisement -