What does this error message mean?

[Rojena]

Hi,

I am trying to run a macro, but I keep getting this login error. I have access to all directories/folders needed to run this macro and my credentials are all up to date. Can someone please help me!

 

[RoryA]

What macro are you trying to run?

 

[Rojena]

What macro are you trying to run?

Hey RoryA, thanks for the reply!

I am trying to run a macro that imports files from a range of different folders, all of which I have access to. So, that is why I am confused about the error message.

Thanks!

 

[RoryA]

We aren't psychic, so we'll need to see some code, please.

 

[Rojena]

We aren't psychic, so we'll need to see some code, please.

Sorry about that! It's just that this file is confidential, but I have attached a screenshot of the place where the code breaks and I get the "Login failed for user" message.

Thanks.

 

[RoryA]

Whatever login details it's using in the clsSQL class are clearly invalid. That's about all I can say without seeing the Class_Initialize code for that class.

 

[Rojena]

Whatever login details it's using in the clsSQL class are clearly invalid. That's about all I can say without seeing the Class_Initialize code for that class.

Here is the class initialize code. Not sure what I need to do to validate my credentials:

 

[RoryA]

It's using your windows login as credentials so it would appear those are not valid for that database.

 

[Rojena]

It's using your windows login as credentials so it would appear those are not valid for that database.

Oh I see, thanks for your help on this! Would you happen to know how I could go about validating them for that database? My credentials work with every system in the network/I am able to run other macros which reference this specific database as well. I am wondering if I could do something to this existing code as a workaround?


Thanks!!

 

[RoryA]

You'd have to check with your DBA for that. The database name looks a little odd, so I assume that's a port number added to it. You might need to check that too.