Last post Nov 16, 2016 12:06 PM by paindaasp
Nov 15, 2016 05:52 PM|acmedeepak|LINK
I am about to host my application in server. My problem is that till date I have worked on a test database and now I need to work on live one. So, the connection string needs to be changed. The connection string I have now is:
<add name="ApplicationServices" connectionString="Password=success;User id=sa;database=BSJ_APPLN;server=SANDBOX-02\GP;" />
Now, my live database will be in another machine with details:
SQL 2014 , Instance SANDBOX-02\GP
I have tried:
<add name="ApplicationServices" connectionString="Password=success;User id=sa;database=BSJ_APPLN;server=192.168.108.26\SANDBOX-02\GP;" />
This did not work
I will host my application in IP: 192.168.108.25. Now, How can I make a connection string before hosting so that I will get the appropriate results if the context of database is same as the previous one.
Please help me
Nov 15, 2016 06:24 PM|Khanna Gaurav|LINK
Try without instance name i.e. as below
<add name="ApplicationServices" connectionString="Password=success;User id=sa;database=BSJ_APPLN;server=192.168.108.26;" />
Nov 15, 2016 07:05 PM|PatriceSc|LINK
If it doesn't help have a look at the web server event log where you should find an error message that should help to narrow down the root cause.
Nov 16, 2016 03:12 AM|Eric Du|LINK
As far as I know, the server string inside of connectionString should like this(if exist port number): server=IP address, import number. You can try to do like this.
Nov 16, 2016 10:48 AM|devangoza1986|LINK
Try this below connection string.
connectionString="Data Source=ServerName\InstanceName;Initial Catalog=DatabaseName;Integrated Security=True;MultipleActiveResultSets=True" />
Make necessary changes as per required.
Nov 16, 2016 12:06 PM|paindaasp|LINK
Have you tried:
- OR -