Sql db string

Hello,
Is there anychange in the db connection string when connecting from vb. net to sql server dayabase instance  when clustering is done on the database.

Regards
RIASAsked:
Who is Participating?
 
Mark WillsTopic AdvisorCommented:
yes I believe so. But if you are changing to a cluster then you do have options depending on how you set it up. For example, Availability Groups with multi-IP's you will need to add the MultiSubnetFailover=TRUE connection parameter

Need to read : https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/listeners-client-connectivity-application-failover

So, bit of a catch-22 - in the first instance you wont need to change, but then, because you are going to a cluster, then you may as well take advantage so you wont have to worry.

But it does depend on your Cluster plans / goals.

Clear as mud ?  Might be better off ask a more specific question in VB.Net  ADO topic areas once you have your clustering directions/architecture plans in place.
1
 
ste5anSenior DeveloperCommented:
Maybe.

When the SQL cluster name or IP is different than you single instance before, then yes, in this case you need to change it.
0
 
RIASAuthor Commented:
Thanks Stefan,
This the connection string I am currently using

Data Source=SV90;Initial Catalog=SAMPLEDBINSTANCE;Integrated Security=True

Can you guide what will change?
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
ste5anSenior DeveloperCommented:
hmm... "Data Source"??

This means that you're using a user or system DSN. Thus you need to check it in odbcad32.
0
 
Mark WillsTopic AdvisorCommented:
You need to connect using the SQL Server instance name. You can not connect using the cluster (node) name.

Do you get an error message ? If so, please post.
0
 
RIASAuthor Commented:
Hi Mark,

Thanks.Right now we are on not on cluster so this connection string is fine. But planning for a cluster so need to know what changes in my vb.net connection string.
0
 
Mark WillsTopic AdvisorCommented:
Well, there is one thing if planning on Mirroring. Failover Partner.  

But not what BOL says, read https://blogs.msdn.microsoft.com/spike/2010/12/08/clarification-on-the-failover-partner-in-the-connectionstring-in-database-mirror-setup/
1
 
RIASAuthor Commented:
Thanks Marks, but you suggest there is no potential change in the conn string?
0
 
RIASAuthor Commented:
Still this will work?
Data Source=SV90;Initial Catalog=SAMPLEDBINSTANCE;Integrated Security=True
0
 
RIASAuthor Commented:
Thanks Mark!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.