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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-14 : 07:26:09
|
| writes "New instal of Win 2000 Prof + SP3 (administrator login).After that SQL Server 2000 + SP3(Client Tools Only and Windows authentication)Normaly (by SQL server 7) the first time I run Enterprise Manager and expand the SQL Server Group there is already an entry that represents my local computer: Paul (Windows NT)But by this Sql server 2000 installtion there is no entry.When I try to add a new sql server registration. and enter the local machine name (Paul) and try to register with sql server authenification (or Server authen), it gives me:"SQL server does not exist or access denied. ConnectionOPen(COnnect())."Thanks in advance for any help." |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-14 : 08:17:10
|
| you have installed only Client Tools so there will not be any database existing on your system. try to connect to some other system which has installed sql server standard/enterprise edition.Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-14 : 12:39:48
|
| You did not install the server portion of SQL Server, so the server Paul really does not exist. If you really want your machine to be a server, then reinstall SQL Server and do not only specify client tools. If you just want to connect to another SQL Server in your organization, then you have installed the correct parts, so just register that server in Enterprise Manager.Tara |
|
|
|
|
|
|
server 2000 - No local machine name entry and registration fails