Showing posts with label receive. Show all posts
Showing posts with label receive. Show all posts

Friday, February 10, 2012

Connection problem with NT4

Ive installed SQL2000 in a NT4-SP6 server, but I cant connect from another machine.
I receive the following msg in Query analizer : "sql server does not exists or access denied"
Ive tried both authentications methods, created alias with IP and server name but nothing works.

If I use query analizer locally I can connect using the server name, but cant if use the ip.

Please, save me :)

thanks in advanceHi Felipe,

I faced a similiar problem when using a Business-Intelligence Client
to connect from a NT-Client to our cube located on a XP-PC with
MS SQL and MS OLAP.

I tried realy everthing:
At the end the following worked.

I added every user, who wants to connect locally(!) as an account.
I added a role to the MS OLAP cube and added the new user to this
role.

Hint:
These users must be domain-users
(and in our case local users too )

hth

Michael|||thanks for your time Michael, but I cant connect with "sa"