|
|
Posted by Dan Guzman on 05/09/06 15:12
> MKLAPTOP\VAIO_VEDB (Windows NT)
>
This is a named instance. You can install zero or more named instances plus
zero or one 'default' instance (server name only) on a single computer.
Each instance is independent with only the client tools shared among
instances.
It looks like you might have only a named instance installed with no default
instance. You will have an entry in Add/Programs titled 'Microsoft SQL
Server 2000' if you have a default SQL 2000 instance. Your named instance
is titled 'Microsoft SQL Server 2000 (VAIO_VEDB)'
> I was able to start, connect and create a db. I dont think i want to use
> VIAO_VEDB do i?
You should have no problem using this named instance instead of a default
instance. If you want a default instance instead, you can rerun setup.exe
to create a default instance and then uninstall the VAIO_VEDB instance
afterward.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Mark Kopple" <ski_freak@earthlink.net> wrote in message
news:6k_7g.1893$u4.302@newsread1.news.pas.earthlink.net...
> OK I stopped and started Enterprise Manager and found this
>
> MKLAPTOP\VAIO_VEDB (Windows NT)
>
> I was able to start, connect and create a db. I dont think i want to use
> VIAO_VEDB do i?
>
> (local) is just above it and i still cant start it.
>
> "Mark Kopple" <ski_freak@earthlink.net> wrote in message
> news:BIZ7g.443$y4.256@newsread2.news.pas.earthlink.net...
>> Ahh i found it (dont know why i didnt see it in the first place) but when
>> i click on it nothing happens and it doesnt start.
>>
>> i then tried to delete it which worked. When i tried to add it back
>> there was no option for (local) just my computer name. I then tried to
>> use it and it said login failed for 'COMPUTERNAME\Guest'
>>
>> The actual computer name is HOMEPC
>>
>> I no longer have (local) in the list
>> I tried adding back (local) and got the following - SQL Server does not
>> exist or access denied.ConnectionOpen(Connect())
>>
>> "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
>> news:lfT7g.70018$F_3.26304@newssvr29.news.prodigy.net...
>>>> As i said below i tried to connect.
>>>
>>> SQL Server normally runs as a service so you need to *start* it before
>>> you try to connect. Right click on the server node and select 'Start'.
>>> If the service fails to start, you should have related messages in the
>>> Windows or SQL Server logs.
>>>
>>> --
>>> Hope this helps.
>>>
>>> Dan Guzman
>>> SQL Server MVP
>>>
>>> "Mark Kopple" <ski_freak@earthlink.net> wrote in message
>>> news:JlS7g.366$Jf.316@newsread4.news.pas.earthlink.net...
>>>> As i said below i tried to connect. Yes its SQL Server 2000 my bad
>>>>
>>>> "Erland Sommarskog" <esquel@sommarskog.se> wrote in message
>>>> news:Xns97BDF05838506Yazorman@127.0.0.1...
>>>>>M K (ski_freakREMOVETHECAPS@yahoo.com) writes:
>>>>>> I am a newbie at C# (VS 2005) and SQL Server(2003).
>>>>>
>>>>> There is no SQL Server 2003. Since you talk about Enterprise Manager,
>>>>> I assume that you mean SQL Server 2000.
>>>>>
>>>>>> When i go into Enterprise Manager it shows a red dot for (local) and
>>>>>> when i try to connect(click) to it i get the following:
>>>>>>
>>>>>> A connection could nto be established to (local)
>>>>>> Reason: SQL Server does not exist or access denied
>>>>>> ConnectionOpen (Connect ())
>>>>>> Please verify SQL Server is running and check your SQL Server
>>>>>> registration
>>>>>> properties
>>>>>>
>>>>>> any suggestions as what to try?
>>>>>
>>>>> The red dot means that SQL Server is not running, so you need to start
>>>>> it first.
>>>>>
>>>>>
>>>>> --
>>>>> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>>>>>
>>>>> Books Online for SQL Server 2005 at
>>>>> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
>>>>> Books Online for SQL Server 2000 at
>>>>> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>>>>
>>>>
>>>
>>>
>>
>>
>
>
Navigation:
[Reply to this message]
|