John (Yiannis) Toutountzoglou
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(MyS ettings) and the route was :Data Source=SPARTAN2-PC\VAIO_VE DB;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
This sql database used a connection string named: FM_beConnectionstring1(MyS
(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
ASKER
SPARTAN2-PC\VAIO_VEDB:old laptop
FM_be is available on the new laptop
FM_be is available on the new laptop
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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..
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.