Solved

SQL Express 2005 ODBC Connection Problems

Posted on 2009-07-03
3
449 Views
Last Modified: 2012-05-07
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
0
Comment
Question by:bains1000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 9

Accepted Solution

by:
drequinox earned 500 total points
ID: 24771181
specify your connection string like this
x.x.x.x\sqlexpress
or if its local try .\sqlexpress
 do it when it asks which sql server you want to connect to , in drop down box, just type .\sqlexpress

notice the dot !!!
0
 

Author Comment

by:bains1000
ID: 24771898
thanks for this, I am not recieving a slightly different error:

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?
0
 
LVL 26

Expert Comment

by:tigin44
ID: 24779165
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.
0

Featured Post

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server 2012 express 24 44
SQL Server: SNAPSHOT replication to include a newly added table. 2 39
SQL query with cast 38 64
SQL Server for XML PATH giving wrong results. 6 59
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question