|
Posted by Mark Kopple on 05/09/06 12:57
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]
|