Re: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 11/23/04

Next message: Marina S.: "Can't concatenate string"
Previous message: Dean: "RE: SQL Script against ADO Connection"
In reply to: Scott Ivey: "Re: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."
Next in thread: Scott Ivey: "Re: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."
Reply: Scott Ivey: "Re: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."
Messages sorted by: [ date ] [ thread ]

Date: Tue, 23 Nov 2004 15:53:52 -0500

> I am the network administrator as well as the DBA - and everything looks
> good on the cluster setup. However - I'll be the first to admit that I'm
no
> Cluster expert.

Uh, I'm confused. Are you using load balancing? clustering? both?

Next message: Marina S.: "Can't concatenate string"
Previous message: Dean: "RE: SQL Script against ADO Connection"
In reply to: Scott Ivey: "Re: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."
Next in thread: Scott Ivey: "Re: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."
Reply: Scott Ivey: "Re: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Clustered vs NonClustered
... >> This is where you tell the DBA to analyze the data. ... If you cluster on ... >>> range queries on are not friendly to inserts as SQL has to page split ... >>> with having a clustered index on a column where range queries will be ...
(microsoft.public.sqlserver.programming)
Re: Clustered vs NonClustered
... > the number of databases times the number of tables times the amount of ... >> This is where you tell the DBA to analyze the data. ... If you cluster on ... and it is up to the DBA to find the most efficient fillfactor. ...
(microsoft.public.sqlserver.programming)
Re: Clustered vs NonClustered
... > This is where you tell the DBA to analyze the data. ... If you cluster on ... >> range queries on are not friendly to inserts as SQL has to page split to ... >> performed, if your table is insert heavy, having the clustered index on ...
(microsoft.public.sqlserver.programming)
Re: active/passive with multiple instances
... has a limited impact on strict DBA functions. ... Microsoft SQL Server MVP ... > An Active/Passive cluster is always called that and never Passive/Active. ... the cluster becomes their hardware ...
(microsoft.public.sqlserver.clustering)
Re: Clustered vs NonClustered
... Most people here work as DBA. ... If you cluster on ... >> performance and page splitting. ... >> performed, if your table is insert heavy, having the clustered index on ...
(microsoft.public.sqlserver.programming)