SQL Server 2000 login failed
after installing SQL Server Desktop Engine it isn't possible to connect to the server.
The server is started.
»SQL Server does not exist or access denied.«
I have tried both merge modules and Setup.exe with a related .ini file. I set the SECURITYMODE="SQL" in the .ini file and checked the registry entry after installation which was set to 0.
Any idea what I do wrong ??
Thanks for all help.
If you're using SQL authentication, then you have to connect with a recognized login, 'sa' initially, then with any logins you may have created.
I tried login with 'sa' and no password. I tried with setting a password in the .ini file, I tried without. I tried with Windows NT authentification.
The login mode is SQL, but no idea why the login with 'sa' and NULL password doesn't work.
Can you create on ODBC alias to the server through the ODBC Manager in the control panel? If you can't do this then likely something is wrong with the MSDE installation itself. If you can, then something is wrong with the way your installer is tlking to the server. I'm new to IS Dev 7, so I can't offer mush more than that. Sorry.