Bulkload XML Code: C# / Sql Server question

I am a newbie at C# (VS 2005) and SQL Server(2003). I was able to create a
db using my old pc and then copied it to my laptop to my project folder, I
cannot connect to it nor can i create a db on my laptop. I belive its an
access issue but I don't know what to do.

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?

I am ultimately trying to connect to the db i created on my old pc
(terminology used to distinguish the 2). Both have XP SP2 installed.

I would also like to create dbs but i believe once this issue is fixed i
should be able to.

Any help is greatly appreciated... remember i am new at this :)

Mark

if this is the wrong group please forgive me and please point me to the
correct one.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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||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/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx|||> 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/pr...oads/books.mspx
>> Books Online for SQL Server 2000 at
>> http://www.microsoft.com/sql/prodin...ions/books.mspx|||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/pr...oads/books.mspx
>>> Books Online for SQL Server 2000 at
>>> http://www.microsoft.com/sql/prodin...ions/books.mspx
>>
>>|||Oops again. HOMEPC is not the same computer, i did try using the MKLAPTOP
which IS the current computer name . I got the same message using
MKLAPTOP - SQL Server does not exist...

"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/pr...oads/books.mspx
>>>> Books Online for SQL Server 2000 at
>>>> http://www.microsoft.com/sql/prodin...ions/books.mspx
>>>
>>>
>>
>>|||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.

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.earthlin k.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/pr...oads/books.mspx
>>>>> Books Online for SQL Server 2000 at
>>>>> http://www.microsoft.com/sql/prodin...ions/books.mspx
>>>>
>>>>
>>>
>>>
>>
>>|||thanks.. it makes sense now :)

"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:KG%7g.24382$4L1.2682@.newssvr11.news.prodigy.c om...
>> 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.earthlin k.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/pr...oads/books.mspx
>>>>>> Books Online for SQL Server 2000 at
>>>>>> http://www.microsoft.com/sql/prodin...ions/books.mspx
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>

Sunday, February 19, 2012

C# / Sql Server question

No comments:

Post a Comment

Bulkload XML Code

Blog Archive

About Me