Lost connection to my SQL Repository

More
5 years 2 months ago #20892 by imchaz
I recently changed the computer name and domain where I installed AETL, so this affected my SQL server instances names.

It uses to be USER1\MSSQLSERVER and USER1\MSSQLSERVER1. I used windows authentication to connect.

My new computer name changed to CHUCKB

When I open the application I get an error message that states "Failed To Connect To Repository"
I had two MSSQL Instances that I had access with the Computer Name USER1
1. MSSQLSERVER
2. MSSQLSERVER1

I now have access to MSSQLServer1 using Windows Authentication Account VPS\cbernardes
I no longer have access to the instance MSSQLServer using Windows Authentication Account.

My Repository Name is ETL_Repository and I see the two files located in my MSSQLServer instance location.
1. ETL_Repository.mdf
2. ETL_Repository_log.ldf

Is there a way I can move the ETL Repository to be recognized by the MSSQLSERVER1 instance?
I think if I can connect to it, I can get all of my related files.

What do I need to do? I hope I can get that information. Thanks so much for any assistance.

Please Log in or Create an account to join the conversation.

More
5 years 2 months ago - 5 years 2 months ago #20894 by admin
Hello

I think the easiest option is to use SQL Server authentication to connect to the SQL server
That way you will be able to connect to MSSQLSERVER and MSSQLSERVER1
(This is what we usually recommend)



Let us know if it helps or not

Mike
ETL Architect
Attachments:
Last edit: 5 years 2 months ago by admin.

Please Log in or Create an account to join the conversation.

More
5 years 2 months ago #20898 by imchaz
At this point, when using SSMS, I cant even call up the SQL instance to get that option.
Whats another option?

Please Log in or Create an account to join the conversation.

More
5 years 2 months ago #20899 by admin
In this case, you need to ask your SQL server DBA for assistnce

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save