Change default MSSQL datasource for connection string

Question

When executing integration tests, I'm using a connection string to connect to the database. I know there is a default notation for connecting to the default server instance in a connection string:

data source=.;initial catalog=[database name];integrated security=SSPI;

Unfortunately the database is currently not installed on the default server and due to compatibility issues I am unable to change to the default server. Now for all my tests, I will have to assign the sever name like so:

data source=[My Server name] ;initial catalog=[database name];integrated security=SSPI;

Since the solution is shared, I can't check this configuration in, and I'll have to do a lot of manual maintenance for this.

Is there any way I can change the default SQL Server for my PC, so that I can use the connection string as shown in the first example?

EDIT:

I was able to successfully use the following connection string:

data source=.\SQLEXPRESS;initial catalog=[database name];integrated security=SSPI;

EDIT 2:

I was able to resolve my issue by this awnser

martijn · Accepted Answer · 2017-12-08 13:41:51Z

1

I managed to resolve the issue by following the steps in this post: https://stackoverflow.com/a/11921896/1829773

answered Dec 8, 2017 at 13:41

martijn

1,4692 gold badges18 silver badges34 bronze badges

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

Comments

Samar Rizvi · Accepted Answer · 2017-12-08 11:27:10Z

0

To change the default server, do:

sp_dropserver <old_name>;  
GO  
sp_addserver <new_name>, local;  
GO

answered Dec 8, 2017 at 11:27

Samar Rizvi

4335 silver badges18 bronze badges

Comments

Coskun Ozogul · Accepted Answer · 2017-12-08 12:38:53Z

0

you can try this :

  sp_dropserver 'your server name'>;  
  GO  
  sp_addserver '.', local;  
  GO

You can change your connection string to :

data source=.;initial catalog=[database name];integrated security=True;

This will not disturb other developpers.

edited Dec 8, 2017 at 12:38

answered Dec 8, 2017 at 11:29

Coskun Ozogul

2,5172 gold badges25 silver badges37 bronze badges

7 Comments

martijn Over a year ago

This did change the name,but i still can't connect to it using the default connection string

Coskun Ozogul Over a year ago

What is the error ? may be SSPI ? Can you share the error message ?

martijn Over a year ago

There is no error message. I Can update the name, but the connection string still fails. When i run sp_helpserver i see the name and network name have been changed

martijn Over a year ago

Changing the integrated security from SSPI to TRUE didn't change how it worked. I still can't connect when I use the . as datasource, and I can connect when I use the server name.

Coskun Ozogul Over a year ago

I want to say, what is the error when you try to connect. Server not found ?

|

Collectives™ on Stack Overflow

Change default MSSQL datasource for connection string

3 Answers 3

Comments

Comments

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related