Link to home
Start Free TrialLog in
Avatar of John (Yiannis) Toutountzoglou
John (Yiannis) ToutountzoglouFlag for Greece

asked on

How to change a connection string to an SQL database

Hello ...I had an SQL database stored in my laptop.Unfortenatelly my laptop was broken for a reason...I saved the hard drive ...and bought a new laptop.
This sql database used a connection string named: FM_beConnectionstring1(MySettings) and the route was :Data Source=SPARTAN2-PC\VAIO_VEDB;Initial Catalog=FM_be;Integrated Security=True
(FM_be is name of the database)
this does not work in my new laptop ...and all my datasets use this route...
how can i change this without creating the datasets from the begining...
thank you in advance
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Kindly check whether
1. Your new laptop name is SPARTAN2-PC\VAIO_VEDB.
2. Remote configurations are enabled for SQL Server.
3. FM_be database is available in your new laptop.
Avatar of John (Yiannis) Toutountzoglou

ASKER

SPARTAN2-PC\VAIO_VEDB:old laptop
FM_be is available on the new laptop
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I am very sory for the delay ...It is Summer in Greece so I left for Vacation...
I checked you answer so i did the following:
MyProject -Setting-
and there i just change the server....
thank you very much
Welcome and glad to help you out..