No

that fails. I tried adding a DSN on the client. It finds the Server but still fails to connect no matter what settings I try.

I've even tried installing SQL Server on the client to see if it would allow me to register the other Server. It fails from both sides even though it sees the other's server as a network server. So the Host won't register the server on the client and the client won't register the server on the host even though they see each other.

Security Mode

The user and password is the same on the client and the host. The user on the client can access all of the files on the host. Keep in mind that this is XP Mode so it is a virtual box with both "machines" on the same physical box.

This is a stand alone machine so there is only a workgroup defined. There is no domain.

I can't figure out why the two instances of SQL Server can see each other, the user has access to files on both systems, and yet I can't get the client to communicate to the host.

Update

The issue turned out to be a problem resolving the server name. After much testing, I found that I could connect to the SQL Server on the WIN7 host if I used the IP address. From there it was simply a matter of modifying my hosts file and now everything works as I expected.

Start or search

Create a new discussion

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

Post type

Subject title

Topic Tags

Select up to 3 tags (1 tag required)

Cloud

Piracy

Security

Apple

Microsoft

IT Employment

Google

Open Source

Mobility

Social Enterprise

Community

Smartphones

Operating Systems

Windows

Mac

Malware

Tablets

Networking

Browser

Hardware

Software

Web Developerment

Linux

Off Topic

Message Body

Track this discussion and email me when there are updates

Please note: Do not post advertisements, offensive material, profanity, or personal attacks. Please remember to be considerate of other members. If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. All submitted content is subject to our Terms Of Use.