Access is denied - SQL server

  • Thread starter Thread starter Zdenek Hostinsky
  • Start date Start date
Z

Zdenek Hostinsky

Hello everyone.

I installed new Win 2000 server(instead of Profi),
Since then I can't connect to SQL server that is in
another comuter although I used the same code and slq
server is still the same.

I have still exception : "System.ApplicationException:
Access is denied." in SqlConnection.Open().

I use MDAC 2.8, but I also tryed 2.7 SP1 2.7 and 2.6
with the same result.

Thanks
 
Hi,

Since I do not know your network/infrastructure set up, this is a shot in
the dark. But one thing about SQL2K is that the unpatched version only
accepts connections from clients that belong to and is logged onto the
Domain. So if you are not logging on to the domain, you will not be given
access to the SQL server. MS did solve this problem with a later service
pack, so make sure that you have applied the latest service pack to your SQL
server.

OK, that was my stab at it. If it is not the case, you will have to provide
more information such as the Authentication mode you are using etc.

Hope this helps

Chris Taylor
 
I know that it is shot in the dark.
I'm logged in the domain, i have all service pack(I hope).
I use trusted connection.Remember again that with W2000
Professional was all right.

What should bw wrong next?
Thanks
 
you are using a trusted connection?
who are you logged in as?
are you sure you are in the same domain?
 
Just a thought....

When you had W2KPro installed, then reinstalled to W2KSvr, did you keep the
machine name EXACTLY the same????
If not, then, 10-1, the database has the old domain/machine name with access
to it and you need to add the new domain/machine name to the permissions
list... I think the stored procedure is sp_adduser or something, easier just
to do it in the Enterprise manager.... Just an idea to check...
 
Back
Top