?
Solved

XP operation system won't connect over the network to SQL Server 2008 RS express

Posted on 2012-08-28
8
Medium Priority
?
287 Views
Last Modified: 2012-09-16
Good morning experts. My Windows 7 based PC's will connect perfectly to my SQL 2008 R2 express database. I do however have one legacy XP machine that I also need to connect to it and I am getting this error: "the database could not be opened using this username and password."
0
Comment
Question by:tfgeorge
  • 4
  • 4
8 Comments
 
LVL 12

Expert Comment

by:xmlmagician
ID: 38340827
are you using the correct ODBC drivers?
0
 
LVL 1

Author Comment

by:tfgeorge
ID: 38341000
Good question xmlmagician. How can I verify?
0
 
LVL 12

Expert Comment

by:xmlmagician
ID: 38341057
my apologies i might have jumped the gun as we have a setup in my organisation where we access an SQL back end with MS access at the front.

what program do you use to access the date on the SQL server?
0
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
LVL 12

Assisted Solution

by:xmlmagician
xmlmagician earned 400 total points
ID: 38341062
0
 
LVL 1

Author Comment

by:tfgeorge
ID: 38341526
We're connecting using a asset/work order managment software called Cartegraph.
0
 
LVL 12

Expert Comment

by:xmlmagician
ID: 38344421
i am not familiar with the program but could you try the steps on this link:

http://itknowledgeexchange.techtarget.com/sql-server/steps-to-troubleshoot-connections-to-your-sql-server/
0
 
LVL 1

Accepted Solution

by:
tfgeorge earned 0 total points
ID: 38388451
It was an IPv6 issue.
0
 
LVL 1

Author Closing Comment

by:tfgeorge
ID: 38402932
Not much information given in the other answers.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

864 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