Page 1 of 1
I cannot connect to the server
Posted: Mon 19 Apr 2010 12:06
by cristian_cobuz
I'm trying to connect to a MSSQL EXPRESS with authetentification using server mode but it doesn't work.
Using windows authentification, it works fine.
Using authetentificationmode I get the message
"Cannot connect with user sa"
I can connect with other applications in server mode
Any ideas would be great
Posted: Mon 19 Apr 2010 14:14
by Dimon
Please, check if the Password property is correct and that the specified user has privileges to access to the database. Also specify the SDAC version you are using.
Posted: Tue 20 Apr 2010 08:12
by cristian_cobuz
The password property is correct, the user is "sa" and the
component version is 4.8 (trial) for Delphi 7
Do I have to install additional software components on my computer or make some special settings for the sql server?
Any ideas would be great
Posted: Tue 20 Apr 2010 09:39
by Dimon
Can you connect to SQL Server with SDAC using Windows authentication?
Also try to use the SQL Native Client provider.
Posted: Tue 20 Apr 2010 11:20
by cristian_cobuz
Using windows authentification, it works fine.
Posted: Tue 20 Apr 2010 12:18
by Dimon
This is a very strange situation. Please try to use ADO components (TADOConnection) to connect to SQL server. If connection will be established, please send us the connection string.
Posted: Tue 20 Apr 2010 16:49
by tinof
Perhaps it is tooo simple -
But do you have checked, if sql server authentication is enabled at this server (Management Studio -> select Server -> Settings -> Safety)?
Can you connect with any other tool (i.e. Management Studio) using server auth?
Just one idea (i have had the same problem just a couple of days before
)
tino