Groups | Blog | Home
all groups > sql server clustering > march 2004 >

sql server clustering : Connecting to Virtual Server SQL 2000 Enterprise


Tomas Nelson Reyes
3/9/2004 9:49:05 AM
I have a Cluster Server with SQL Srv. Enterprise 2000 +
last HF's installed. And i tray to connnect from an IIS
(ASP) to my Virtual Server and i get an error (Access
Denied), i read a lot of Articles from MS, but i don't
have a clear answer to my problem. The question is:
What is the diference to stablishing a connection with a
SQL Cluster Server, from a normal SQL Server?
Because my aplications still working good in the other
servers, but when i traing to migrate to SQL Cluster
Server i get that error.
Some could helpme please, i need a concret response to my
anonymous NO[at]SPAM discussions.microsoft.com
3/9/2004 10:57:59 AM
I have instaled in the 2 nodes of my Cluster MDAC 2.7 SP1,
and MDAC 2.5 SP3 in my Web's servers, it could be the
problem????

[quoted text, click to view]
Geoff N. Hiten
3/9/2004 1:12:49 PM
The only difference is clusters typically look like named instances, which
require a semi-recent version of MDAC (I think 2.6 or higher, but I might be
off). Other than that, clustered instances look just like any other SQL
instance to the outside world.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

[quoted text, click to view]

Geoff N. Hiten
3/9/2004 2:05:00 PM
Upgrade MDAC on the web servers if possible.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

[quoted text, click to view]

rboyd NO[at]SPAM onlinemicrosoft.com
3/10/2004 5:32:31 PM
The problem may stem from the account that ASP is using to connect to SQL
Server.

Check out the following article to see if it helps:

http://support.microsoft.com/?id=176377

Rand
This posting is provided "as is" with no warranties and confers no rights.
AddThis Social Bookmark Button