Connecting a .bak file of SQL server to visual studio

Question

0.00/5 (No votes)

See more:

Hi,
So my problem over here is that, i have done back up on my sql database named 'SDP' then i have restored the sql backup file in another new PC. Now i would like to execute my vb.net program from the new PC. The problem i am facing is that the server name i have written in my codes are the server name of my previous PC("servernamePC1"). Now in the new PC, it has a new server name. Hence, how to set a universal connection path in vb.net to connect to my database.

The server name i have given down there is a sample server name not the actual server name. Assume that the server name("servernamePC1") is the first PC's server name. Now i have to connect to the database in a new pc with a different server name. Is that possible? or do i have to set a universal path??

What I have tried:

Dim con As New SqlConnection("server = servernamePC1; database=SDP; integrated security=SSPI")

Posted 17-Apr-19 8:45am

Member 13864666

Updated 24-Apr-19 11:58am

Add a Solution

Comments

[no name] 17-Apr-19 15:18pm

You can
a.) Put the server name into a configuration file
b.) Use only unnamed server instances which are always reachable with "localhost"

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

phil.o · Answer 1 · 2019-04-22T13:34:00

Solution 1

You can try 'localhost' as generic server name on local machine. Make sure SQL services listen to address 127.0.0.1

Posted 22-Apr-19 13:34pm

phil.o

Richard Deeming · Answer 2 · 2019-04-24T11:58:00

Solution 2

This is why you should always store your connection strings in your config file[^], as 0x01AA suggested in the comments. :)

You might be able to get away with setting up an alias[^] for the old server. But you would need to set that up on every computer where you application needs to run.

Posted 24-Apr-19 11:58am

Richard Deeming