By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,575 Members | 1,968 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,575 IT Pros & Developers. It's quick & easy.

C# / Sql Server question

P: n/a
M K
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.
May 8 '06 #1
Share this Question
Share on Google+
8 Replies


P: n/a
M K (sk********************@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 8 '06 #2

P: n/a
As i said below i tried to connect. Yes its SQL Server 2000 my bad

"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn**********************@127.0.0.1...
M K (sk********************@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

May 10 '06 #3

P: n/a
> 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" <sk*******@earthlink.net> wrote in message
news:Jl**************@newsread4.news.pas.earthlink .net...
As i said below i tried to connect. Yes its SQL Server 2000 my bad

"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn**********************@127.0.0.1...
M K (sk********************@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


May 10 '06 #4

P: n/a
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" <gu******@nospam-online.sbcglobal.net> wrote in message
news:lf*******************@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" <sk*******@earthlink.net> wrote in message
news:Jl**************@newsread4.news.pas.earthlink .net...
As i said below i tried to connect. Yes its SQL Server 2000 my bad

"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn**********************@127.0.0.1...
M K (sk********************@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx



May 10 '06 #5

P: n/a
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" <sk*******@earthlink.net> wrote in message
news:BI**************@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" <gu******@nospam-online.sbcglobal.net> wrote in message
news:lf*******************@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" <sk*******@earthlink.net> wrote in message
news:Jl**************@newsread4.news.pas.earthlink .net...
As i said below i tried to connect. Yes its SQL Server 2000 my bad

"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn**********************@127.0.0.1...
M K (sk********************@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx



May 10 '06 #6

P: n/a
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" <sk*******@earthlink.net> wrote in message
news:BI**************@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" <gu******@nospam-online.sbcglobal.net> wrote in message
news:lf*******************@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" <sk*******@earthlink.net> wrote in message
news:Jl**************@newsread4.news.pas.earthlink .net...
As i said below i tried to connect. Yes its SQL Server 2000 my bad

"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn**********************@127.0.0.1...
M K (sk********************@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx



May 10 '06 #7

P: n/a
> 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" <sk*******@earthlink.net> wrote in message
news:6k***************@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" <sk*******@earthlink.net> wrote in message
news:BI**************@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" <gu******@nospam-online.sbcglobal.net> wrote in message
news:lf*******************@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" <sk*******@earthlink.net> wrote in message
news:Jl**************@newsread4.news.pas.earthlink .net...
As i said below i tried to connect. Yes its SQL Server 2000 my bad

"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn**********************@127.0.0.1...
>M K (sk********************@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, es****@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx



May 10 '06 #8

P: n/a
thanks.. it makes sense now :)
"Dan Guzman" <gu******@nospam-online.sbcglobal.net> wrote in message
news:KG******************@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" <sk*******@earthlink.net> wrote in message
news:6k***************@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" <sk*******@earthlink.net> wrote in message
news:BI**************@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" <gu******@nospam-online.sbcglobal.net> wrote in message
news:lf*******************@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" <sk*******@earthlink.net> wrote in message
news:Jl**************@newsread4.news.pas.earthlink .net...
> As i said below i tried to connect. Yes its SQL Server 2000 my bad
>
> "Erland Sommarskog" <es****@sommarskog.se> wrote in message
> news:Xn**********************@127.0.0.1...
>>M K (sk********************@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, es****@sommarskog.se
>>
>> Books Online for SQL Server 2005 at
>> http://www.microsoft.com/technet/pro...ads/books.mspx
>> Books Online for SQL Server 2000 at
>> http://www.microsoft.com/sql/prodinf...ons/books.mspx
>
>



May 10 '06 #9

This discussion thread is closed

Replies have been disabled for this discussion.