DataBase not connecting

Help Studio
, ,
1

image
image500×654 19 KB

Hi I have data base connection which was working earlier. Now it’s throwing key not found error. Any idea why?

2

Are you using or referring any dictionary type variable here @Rahul_Srinivas

3

@Rahul_Srinivas

Are ou using variables here?

while configuring and testing connection you should use direct values.variables are to be used only during runtime and not while configuring or testing connection

cheers

4

@Rahul_Srinivas ,

Please make sure the you put actual values instead of the variable while configuring connection.

5

Hello All, This was working before but suddenly it was not working and I tried testing in a test enivironment using direct values only, no variables still it was not working.

6

@Rahul_Srinivas

when you hardcode values then what error are you getting?

did you happen to check with adding a new activity?

cheers

7

Connect to database: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) , It is throwing this issue

8

@Rahul_Srinivas

as per error…sql server is not reachable…

please check this

cheers

9

thanks, I’ve actually put one extra alphabet in connection string

1 Like