I have a c# application which has been under development for a while and for this purposed is connected to a MS SQL Express 2010 database on the development PC. This has worked well but now I need to move to the next stage and connect to a remote SQL Standard 2005 server database. The connection string that I have used until now has been:
Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\
Security=True;Connect Timeout=30;User Instance=True"
I have created the same database on the remote SQL 2005 server and now I need to modify the connection string to point to this database. I have gone to www.connectionstring.com
but whilst there is a lot of information there, I am still unsure as to the connection string I should be using.
The database that I am trying to connect to has 2 instances:
MYSERVERNAME \ LIVESQLSERVER
MYSERVERNAME \ TESTSQLSERVER
My database RULESDB2 exists on C;\Program Files\ Microsoft SQL Server\MSSQL\DATA. I have a userId and password available. Can someone please tell me what the format of the connections string should be ?