connecting to SQL Server on local machine

ddumas

I cannot get Aware IM to connect to sql server. I have enabled mixed mode authentication, enabled TCP to port 1433, and enabled port 1433 on my windows firewall. I created a sql server login for ddumas, granted sysadmin permissions, and also granted create database.

I can connect with SQL Server Management Studio (SSMS), and can login using SQL Server Authentication, and do anything with user ddumas. Priorto this, I could not get Aware IM to connect using windows authentication (which is the best and most secure way to configure SQL Server security), so I thought I would try using SQL Server Authentication.

In the database settings, I have the following (db is on my local machine with Aware IM)

I keep getting this error:

Any ideas?

ddumas

I got this to work. Could not get it to work with Windows Authentication. Oh Well.

Using SQL Server authentication...

I had to enable UDP port 1434 on the windows firewall, and had to start the SQL Server Browser service.

works now.