vinoth wrote:
> hi ,
> thanks Montanari.
> but still i have problem.
> i downoaded a gui tool . when i try to connect to the server .it says
> no server exists.
> i gave MSSQLSERVER as instance name. SAPWD= "sa"
> in cpntrol panel-> services MSSQLSERVER is running.
>

"Andrea Montanari" wrote:

> hi,
> vinoth wrote:
> > hi ,
> > thanks Montanari.
> > but still i have problem.
> > i downoaded a gui tool . when i try to connect to the server .it says
> > no server exists.
> > i gave MSSQLSERVER as instance name. SAPWD= "sa"
> > in cpntrol panel-> services MSSQLSERVER is running.
> >
> at connection time you have to provide the full name of the MSDE instance...
> if it is a default instance you only need to specify the ServerName (or
> (Local) for local connections) where, for named instances, the full name is
> composed by ServerName\InstanceName (or (Local)\InstanceName for a local
> named instance)
> please check in control panel->management tools->services applet what your
> instance name is...
> if you only find an entry like
> MSSQLSERVER
> this is a default instance...
> if your see something like
> MSSQLSERVER$some_name
> this will be a named instance... so you'll have to connect providing
> ComputerName\some_instance
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>
>