Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here






I am trying to switch from a database running on the JET engine to one that uses MSDE. However, I am having some difficulties getting the sample database NORTHWINDCS to work.

I have two computers both with WIN XP PRO installed. Let's say my computer is named A and the remote computer is named B. Both computers have NORTHWINDCS installed. MSDE is installed on computer B. I have no difficulties opening NORTWINDCS locally on computer B. Unfortunately, I am having difficulties opening NORTHWINDCS remotely from computer A. The "Data Link Properties" window pops up but I cannot connect.

The error message displayed is "Microsoft Access could not log on to the server. Verify that the log on information is correct."

I have the following settings
1. Select or enter a server name:

2. Enter information to log on to the server:
Use Windows NT Integrated security

3. Select the database on the server:

Also, when I try to "Test Connection", the following error message is given

"Test connection failed because of an error in initializing provider. Login failed for user 'B\Guest'.

I have tried many things to rectify the problem including:
1) creating a guest account on computer B
2) installing MSDE with the line SECURITY=SQL and then trying to log on remotely using user: sa; password blanked out

I think the problems result from not having an account set up on computer B.

Any help would be greatly appreciated.


RE: NorthwindCS

you need to install MSDE on computer 2 aswell then goto the
next folder
C:\Program Files\Microsoft SQL Server\80\Tools\Binn

and open the SVRNETCN program then make sure you have right protocol set up lets say TCP/IP remove all others then click on properties and chech if it is on port 1433 and make sure your firewall lets you use this port.

now it should work better.

and make sure your users have rights on the database if you are using windows integrated security

Christiaan Baes
"What a wonderfull world" - Louis armstrong

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close