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"
Showing posts with label nt4. Show all posts
Showing posts with label nt4. Show all posts
Friday, February 10, 2012
Subscribe to:
Posts (Atom)