access denied

Question

access denied

tsc1

SSC-Addicted

Points: 493
More actions
September 8, 2003 at 2:20 am

#59008

Hi,
I have the following problem.
I have a SQL server 2000 which 2 catalogs.
I can reach the first one but not the second.
I can create an ODBC connexion to the both.
The message is :
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
I do my tests with sa account.
Thierry

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

ckempste SSCoach Points: 17983 More actions · Answer 1

Hi there

Do you mean... "i have 2 named instances on a single server and can only connect to one?" not sure what you mean by "catalog" thats all. The second is probably listening on a different that you expect, check this via the sql server instances log, or, the server network manager properties. Once confirmed, check the protocols used, ports in use and re-try from there. YOu may need to configure up an alias to connect with.

Also - all instances running ok? (just checking)

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"

Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"

tsc1 SSC-Addicted Points: 493 More actions · Answer 2

Hi,

I have an instance and 2 DB.

So is it possible to have different network configuration here ? I hope not !

satishbt SSC Eights! Points: 828 More actions · Answer 3

U mean to say that, both the Databases are on one server and you are able to access one and not the other? Also, just your user id has access permissions on the database that u can't access. I guess u need to be more descriptive about u'r problem.

shoayb Say Hey Kid Points: 709 More actions · Answer 4

hi, like satishbt said, you need to provide more info... but try this.

in Enterprise Manager, expand the node for the database that does work and then expand the Users node.

Check the Users that you have for that database and check to see what permissions they have.

Now... make sure the database that does not work has the same Users and permissions.

let us know how you get on. if the above is the same for both databases are you using the same connection string?

sho

tsc1 SSC-Addicted Points: 493 More actions · Answer 5

thank you for your answers.

Both DB uses the same connection string.

I use sa to be sure that it's not an autorization problem.

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 6

Do the objects in second database owned by DBO? I guees they are not.

tsc1 SSC-Addicted Points: 493 More actions · Answer 7

I found !!!

This is a problem on the cluster. The 1433 isn't listening on the virtual server but only the physical server.

And the application doen't use the same mode of connexion with the two db !

I didn't write this one...

Thanks a lot !