security - SQL server Error 4060 - Stack Overflow

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Learn more about Collectives

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Learn more about Teams from where are you trying to connect to the sql server? if from code, then it would be good to give us the connection string that you are using – Kostas Konstantinidis Apr 9, 2009 at 11:18

This error also occurs if the Database not exists

so make sure that there is a database with the name you provided in Catalog=MyDB

Do you have permission to access the database using the credentials that you are supplying? What provider are you trying to use? TCP/IP, Named Pipes? Has that provider been enabled? Is there a firewall in place and have you opened up the port to the client? Does this happen intermittently? If so, do you have enough licenses available when the error occurs? You might want to check the server error logs (and your client event log, too) for more information.

what happens is that the user/pass are provided to sql, AND credentials are correct, AND before connecting the user to the database requested for the connection, sql tries to connect the user to the user's default database, which turns to be, in Haranadh's case not granted to the user in question. that's it. – que dal Jun 6, 2013 at 14:31 And how would you change the information you specify? I'm getting the same error when trying to update a table through the Linked Table Manager. – Shawn Aug 24, 2011 at 0:22

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question . Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers .