Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > "SQL Server does not exist or access denied" on a App Center node

Reply
Thread Tools

"SQL Server does not exist or access denied" on a App Center node

 
 
Christophe Niel
Guest
Posts: n/a
 
      01-13-2004
Hi

As stated in Q315159, I have a problem to access a SQL server, but, I don't
have the same cause :
I use Application Center so I had to I use a domain account as the Asp.net
worker process in order to have the right NTFS permission on the replicated
files of the application (otherwise I have unknown account as ASPNET does
not have the same SID on the 2 server)
I already had the "Network Library =dbmssocn" option in the connect string
I use impersonation.

Well, I don't have the causes described in Q315159, but I have the symptoms.
And I have it on only one of the cluster node. It works fine on one of the
node everytime I'm connected to it and doesn't on the other node.

I trie do code a small in-line aspx page wich connect to the database using
the same connect string and it worked on both server. But when I use any
aspx pages that try to connect to the server using the code-behind I have
the SQL exception.

Where can it come from?
(What I don't understand is that the 2 nodes have exactly the same
application files and it doesn't work.)

Thanks in advance.


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
xsl variable $node/text() but $node can non-node-set help! Tjerk Wolterink XML 2 08-24-2006 03:28 AM
How to set the node indent property between the parent node and the leaf node viveknatani@gmail.com ASP .Net 0 02-13-2006 07:11 PM
Does my object exist? So why its HWND doesn't exist? That's a question... (CMonthCalCtrl control) LT C++ 7 07-25-2004 07:08 PM
Server cannot access application directory... The directory does not exist or is not accessible because of security settings. ASP .Net Security 1 05-21-2004 03:47 PM
xpath - how to find a node where a specific attribute does NOT exist? KathyB ASP .Net 0 07-20-2003 02:51 AM



Advertisments