I have deploy my code in visual studio .NET 2010 in order to select images and save them into a SQL server (remote) 2008 express
When i deploy my tables as: [dbo].[tablename] then at the last command of my code which is:
sqlFile = New SqlFileStream(filePathName, fileToken, FileAccess.Write)
I receive the error of 'Access denied'
When i deploy my tables as : [UserSchema].[tablename] then i receive the error of:
'The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you'
I have made all the changes that i know around of SQL S开发者_运维技巧erver but nothing.
Please noticed that i can write data in all the privious tables without any problem, My issue starts only when i'm trying to pass the image into the shell of the table
Is there anyone which have faced this problem before?
There are about 20+ reasons why an access is denied for a request to SQL SERVER Have look at this article from Miscrosoft.
- Potential causes of the "SQL Server
does not exist or access denied"
error message
Most common errors are as follow
- Not specifying proper connection string
- The local security policy user rights assignment for your Application are not enough
Hope it helps
精彩评论