Login Failed

Toad for SQL Server
1

I have Toad for SQL Server 5.0.2.612 and I try to connect to a local .mdb file with Windows Authentication. I get login failed. I use the database programatically, and my connection string has Integrated Security=True ,and the program uses it just fine without password requirements. I would expect Toad to be able to connect with Windows Authentication.

I also tried connecting with SQL Server Authentication and sa for login and I get The user is not associated with a trusted SQL Server connection.

What can I do to use Toad for my SQL Server Express ?

Thanks,
Jon

2

Hi Jon,

Toad can connect to SQL Server Express. Let’s try to figure out what’s your problem:
Can you please give me more details on what is the difference between your app and Toad? have you ran app and Toad on the same workstation? is SQL Server Express installed locally or it is remote server? What protocols allowed on your SQL Server?

Regards,
VB

3

The difference is machines. When I connected in SW, it was on a different computer. On the current computer, the main problem appears to be that the version of SQL Server was older than the version that created the database. However, when I upgraded the SQL Server version in this computer, I was able to go farther on the login with TOAD.

I still was unable to login with Windows Authentication, but when I used SQL Server authenticaion, and supplied sa as the user, and blank as the password (the file has no password), it returned this error:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

Thank you for responding,
Jon

4

Hi Jon,

It’s quite interesting.
Can you please let me know what is your configuration of SQL Server in:

  • SQL Server Configuration Manager (what protocols are enabled?)
  • SQL Server Surface Area Configuration -> Services and Connections (what do you have in remote connections?)

Also can you send to me a backup of your database so I can try to play with that on my local express edition.

5

Shared Memory enabled
Named Pipes disabled
TCP/IP enabled
VIA disabled

  • SQL Server Surface Area Configuration -> Services and Connections (what do you have in remote connections?)

I don't know what that is. I didn't find a tool for it. As for remote connections, there shouldn't be any. This is just an instance of Express installed on my local computer.

Thanks,

6

Also can you send to me a backup of your database

I'll be glad to send you a copy of my mdf file (it's just Express 2008). It is attached.
MailClient.mdf (2.5 MB)

7

Hello Jon,
Do you still have problem with connection to server?
Is so, we recommend you to download SQL Server Management Studio
http://www.microsoft.com/express/Database/InstallOptions.aspx
and then connect to server using this tool.
If connection will success there and still connection will failed in TOAD for SQL Server, please let us know.

Thanks,
Anastasia