Login failed for user 'sa'

[GroovyGrimm]

I'm in the process of converting an old sql server at work. We need to keep the data for 7+ years by law. I'm doing this by using vmware esxi and it worked perfectly other than for the limited disk space ( ~36GBs of space left). The problem however is we found out we can't access the databases anymore from our shortcuts.https/imgur.com/a/Zq2Rj

 

[ss202sl]

Do your shortcuts have the old SQL server SA account tied to them? maybe deleting the old shortcuts, and recreating them with the new server will help.

 

[GroovyGrimm]

Do your shortcuts have the old SQL server SA account tied to them? maybe deleting the old shortcuts, and recreating them with the new server will help.

Sorry, the way we open the server is through a batch file and we use a shortcut of that.

 

[ss202sl]

Have you updated the batch file to use the login for the new server

 

[GroovyGrimm]

Have you updated the batch file to use the login for the new server

What do you mean by updating it.I just converted the server over to a smaller server using vmware converter. It's using server 2003.

 

[Alabalcho]

Unless you put some efforts into troubleshooting, you will go nowhere.
- do that batch file (and the application it invokes) connect to the correct SQL server?
- Do credentials for that server match?

 

[rgd1101]

If you did the converted, can you login to the new server with the sa account and sa password?

the batch calling an app? someone have to do more research

 

[GroovyGrimm]

Unless you put some efforts into troubleshooting, you will go nowhere.
- do that batch file (and the application it invokes) connect to the correct SQL server?
- Do credentials for that server match?

I've been troubleshooting for about 2 weeks, one and off, don't be rude and tell me i haven't put effort into it.
-It points to itself, and uses a file to get the info. That file is correct.
-Credentials have been verified and are correct.

If you did the converted, can you login to the new server with the sa account and sa password?

the batch calling an app? someone have to do more research

I can login to the server with windows credentials and sql server credentials.
The batch calls access to open the database for easy viewing of the items.
You guys keep on being rude and i expected more of this community.

 

[The Paladin]

can you open the database with msql and see if username and password manually entered works?
what application was interacting with the sql database a lot of programs will generate an app with Sa and a default "program based" password.
I have seen that a few times with badging software I support.