bains1000
asked on
SQL Express 2005 ODBC Connection Problems
Hi
I am in the process of setting up a sql express 2005 on windows xp pc. I am experiencing problems when trying to connect to the database via odbc (screen shot attached)
I have tried the SA account and the domain administrator account.
I have enabled TCP connections for remote and local. At this stage i am only trying to connect locally on the same machine. I have also tried using the name localhost when selecting the database server, rather than the netbios name.
Any help would be greatly appreciated.
thanks..
odbc-error.jpg
I am in the process of setting up a sql express 2005 on windows xp pc. I am experiencing problems when trying to connect to the database via odbc (screen shot attached)
I have tried the SA account and the domain administrator account.
I have enabled TCP connections for remote and local. At this stage i am only trying to connect locally on the same machine. I have also tried using the name localhost when selecting the database server, rather than the netbios name.
Any help would be greatly appreciated.
thanks..
odbc-error.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1. Do your sql installation default or a named instance? if its a named instance then you should give the instance name in your server definition.
2. Did you define any aliases for your sql server? misconfigured alliases may prevent your connection. check it under SQL server configuration manager -> SQL Native Client Configuration -> Aliases.. if exists you should delete them and then try connecting.
2. Did you define any aliases for your sql server? misconfigured alliases may prevent your connection. check it under SQL server configuration manager -> SQL Native Client Configuration -> Aliases.. if exists you should delete them and then try connecting.
ASKER
Connection failed:
SQLstate: '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.
I seem to be one step closer, any ideas?