Windows Vista - login failed for user 'sa'

[JLR1234]

I've installed my VB6 compiled application on Windows Vista (it actually installed without errors) but am receiving a runtime error "login failed for user 'sa'" when trying to access any recordsets using the Microsoft ADODC recordset component. I am accessing an SQL Server database. The program has worked fine for years on Windows 98, 2000 and XP.

Any ideas?

Also, does anyone know of a support group for VB6 and Windows Vista issues? I can't seem to find one.

 

[dilettante]

SQL Server 2000 (including MSDE) on Windows Vista FAQ suggests no changes should be required in your programs.

However Vista does try to "harden" Named Pipes so if you're connecting that way (or possibly other ways) you may run into connection woes. If you're using a TCP-based connection I'd think you'd be ok. Not being a SQL Server guy I'm probably all wet of course. Have you tried the SQL Server forums here?

I've had little luck in finding VB vs. Vista support forums myself, and little interest most places in starting one. As far as Tek-Tips goes it was suggested that we post in the Vista Desktop forum1583 here. This is far from ideal, not the least of which being that VB programmers seldom visit the Desktop forums. Right now it's the only game in town that I'm aware of though.

Some good basic generic info can be found at

http://devreadiness.org/

and you might also try Software Development for Windows Vista for questions.

 

[JLR1234]

Thanks for the links! That's a good start.

I don't think it's an SQL issue because I can log in to the database and the program. The error occurs when I try to open the ADODC (ADO Data Control) component. It's an MS component so I was hoping it would work.