Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL server does not exist or access is denied

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-07-28 : 07:11:29
Jay writes "I just installed SQL Server 2000 Developer edition on my pc which is running Windows XP Pro. I can get into enterprise manager but when I open the tree view to where the databases should be listed it says it can't connect (SQL Server does not exist or Access is denied). There has to be some type of permissions/account problem either with SQL Server or XP. Any help to lead me in the right direction is very much appreciated.

Thanks."

smccreadie
Aged Yak Warrior

505 Posts

Posted - 2003-07-28 : 07:47:37
Did you register the database in EM?

Usually this is a case of where the database is setup to only allow windows authentication and you are trying to connect with a local sql account. Switch the mode to local and windows accounts.
Go to Top of Page
   

- Advertisement -