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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RIASAuthor Commented:
Thanks Mark!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.