Can't connect to my SQL server

philjayj · 6 Dec 2008 at 20:48

I'm a bit desperate for some help, and would appreciate any you can give.

I have SQL Server 2005 set up on a spare machine I have on my network. I'm trying to upsize an Access Database and/or create an ODBC data connection, but I keep getting the following message:

Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''. The user is not associated with a trusted SQL Server connection.

I have changed the server authentication to mixed, but still no joy.

Oh, and although the SQL Server is installed on a spare machine, its running on a virtual OS.

Thanks for reading.

philjayj · 6 Dec 2008 at 21:35

Hi. Thanks for your reply. Yes, its been restarted numerous times but still no change unfortunately.

philjayj · 6 Dec 2008 at 22:05

Hi Gord

Thanks for getting back to me.

I am trying to connect with my laptop on the same home LAN.
I don't have a domain, but they are both in the same workgroup.
I am trying to connect with Windows Authentication.
I am using SQL 2005 Standard.

The error message posted in my previous post is what I'm still getting.

Although when trying to create an ODBC connection, I am unsure whether I should have a tick in "connect to SQL Server to obtain default settings for the additional configuration options." Also, should there be anything in the Login ID / Password fields (even if grayed out)?

philjayj · 6 Dec 2008 at 23:03

I have enabled remote connections via the servers properties, but I don't know about named pipes - how would I check this?

Thanks

philjayj · 7 Dec 2008 at 00:07

OK, so should I leave the SQL server authentication in mixed mode?

philjayj · 7 Dec 2008 at 13:40

Gord, using SQL auth works fine. Although I did try the first method mentioned in your link, but that still doesnt work.

Thanks for your help.