Cheat application to connect to different SQL Server database

Question

At work I wrote an application that processes data from a SQL Server database and outputs it in file format.

Now I need to use it at home and since app has hard-coded connection string I've got a problem. I got a copy of database at my company, the original database is inaccesable from the outside of the company.

Connection string format looks like this

Data Source=serverName-01;Initial Catalog=dbName_01;Integrated Security=True;Pooling=False

I've tried to cheat app by editing windows hosts file:

serverName-01 127.0.0.1

But it did not work. Is there a way to make it work without going to work and editing source code ?

Lesson learned hard way - never hard-code connection srings :<

Your company is so generous to take the source code at home? — TalentTuner
– TalentTuner, Commented Mar 22, 2013 at 12:49
I got source code, but project uses some liblaries that I cannot legaly install at home. — EOG
– EOG, Commented Mar 22, 2013 at 12:52
All you can do is install a local database with the exact same servername and db schema. — Mike C.
– Mike C., Commented Mar 22, 2013 at 12:52
Tried it SQL-server does not allow to use '-' character in name. '-' in company domain computer name — EOG
– EOG, Commented Mar 22, 2013 at 12:54

steoleary · Accepted Answer · 2013-03-22 13:55:59Z

1

To do this you can use an alias defined in SQL Server Configuration manager. Create an alias for your local instance that has the exact same name as the one in the connection string.

Have a look at the following article for how to do this (it's pretty simple):

Create or Delete a Server Alias for Use by a Client (SQL Server Configuration Manager)

answered Mar 22, 2013 at 13:55

steoleary

9,3682 gold badges38 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cheat application to connect to different SQL Server database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related