Showing posts with label settings. Show all posts
Showing posts with label settings. Show all posts

Wednesday, March 7, 2012

Error 3716 - security settings

My first time encountering this error, and I can't find any documentation on
it...
adErrUnsafeOperation 3716 - "Safety settings on this computer prohibit
accessing a data source on another domain."
I'm calling a stored procedure in an enterprise environment, returning a
single recordset, with ADO (not ADO.NET).
I've done a trace, the stored procedure does run, but it only errors in the
customers environment. I can't replicate.
If anyone can tell me what this error is, I can probably find the problem
much sooner.Random (cipherlad@.hotmail.com) writes:
> My first time encountering this error, and I can't find any
> documentation on it...
> adErrUnsafeOperation 3716 - "Safety settings on this computer prohibit
> accessing a data source on another domain."
> I'm calling a stored procedure in an enterprise environment, returning a
> single recordset, with ADO (not ADO.NET).
> I've done a trace, the stored procedure does run, but it only errors in
> the customers environment. I can't replicate.
> If anyone can tell me what this error is, I can probably find the problem
> much sooner.
You are probably better off asking about this in a forum devoted to ADO
ASP, or maybe Windows networking, as this does not really seem to tbe an SQL
Server issue. I searched for the error message on Google, and I got some
hits. I only pursued the first one, and did seem to give some information.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Friday, February 24, 2012

ERROR 26 AFTER UPGRADE OF SQL 2005 SERVER EXPRESS

I cannot make connection to database that I was using prior to the upgrade of SP1. Keep getting error 26-default settings prohibit remote access - but it's not remote.? Can anyone help - tell me how to change defaults or change properties to connect to my data after the update?

I am using Visual Web Developer Express. It can see the instance but cannot connect.

Using TCP/IP rather than named pipes is always "remote". YOu can enable the remote connections on the Computer by using the SQL Server Configuration surface. See more details and a screencast at my site in the section Screencasts >Enabling remote connections

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||Thank you - this did it.