duplicate database connections (up to 20 of them for one database connection)

Steven Chen

April 28, 2020 15:14

Hi All, 

 

Hope all of you are safe and healthy in this special season!

 

 

I created a site with sevearl database connections created to feed my data links. Quite standard format: 

 

Display Name: TEST

 

Data Source Type: SQL Client

 

Data Source=(fully qualifed server name)\SQLDB1;Initial Catalog=XXX;Integrated Security=False;User ID=XXX;Password=XXX. 

 

Error action: Log at Debug level. 

 

 

When the site is running for quite a while, I checked back, I found that there are about 20 duplicate database connections under Sites/Database Connections: 

 

TEST

 

TEST

 

TEST

 

...

 

TEST

 

 

For testing purpose, I deleted some TEST database connections, but the site is broken, showing up the global image 

 

 

Wonder if anyone experiences similar issue before? 

 

Thanks 

 

 

Steven 

 

 

0

• 

  Steven Chen

  April 28, 2020 16:30

  The issue was resovled. I ended up with reconnect to the "correct" database connections in Manager, and then deleted the unnecessary database connections from site. xml file.  Have a great day!

  0

Please sign in to leave a comment.