Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

interview

home / developersection / interviews / please help me i want to create a connection string that can be use with multiple sql server means it will accept the server name of the machine
Ask Question

please help me i want to create a connection string that can be use with multiple sql server means it will accept the server name of the machine

Anil Yadav 3044 15 Feb 2012
asp.net asp.net
Updated 21 Sep 2020
Anil Yadav
Anil Yadav

Other

I have just started my career as a developer asp.net developer

Message

1 Answers

Anonymous User
Anonymous User 16 Feb 2012
Report Abuse
Hi Anil,
You can run multiple instances of SQL Server on the same host using the named instance feature. If your target database instance is a named instance, SqlClient will also need to know the instance name or instance port number. The instance name can be specified by appending a backslash and instance name to the Data Source value:
Data Source=SQLSERVERNAME.MYDOMAIN.COM\MYINSTANCE;Integrated Security=SSPI;Initial Catalog=MyDatabase
For more details check this link...
http://weblogs.sqlteam.com/dang/archive/2011/07/10/sql-server-connection-strings.aspx
advertising