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. 8 3261
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
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
> 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
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
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
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
> 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
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 > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: HarveyB |
last post by:
I would like to generate non-modal popup windows from
ASP.Net code-behind. I have tried using Client Side
scripting like "function Test(){
window.open('test.htm',_blank,...
|
by: Frodo |
last post by:
I have a problem establishing a link between Visual
Studio.NET 2003 and SQL Server 2000. Both are installed on
a Windows Server 2003, standard version.
Visual Studio.NET Issues...
|
by: Hazzard |
last post by:
I just realized that the code I inherited is using all asp.net server
controls (ie. webform controls) and when I try to update textboxes on the
client side, I lose the new value of the textbox when...
|
by: Ezra |
last post by:
Our company's web server is trying to access graphics files on another
server. When I run the app from Visual Studio (1.0) on my localhost,
the server in question is available (which is accessed a...
|
by: angus |
last post by:
Hi All,
i have an aspx form for the user to input, and those data will be stored
into the database.
I would like to build up the form dynamically by using the data in the a
database table,...
|
by: CGW |
last post by:
I asked the question yesterday, but know better how to ask it, today:
I'm trying to use the File.Copy method to copy a file from a client to
server (.Net web app under IIS ). It looks to me that...
|
by: Frank Millman |
last post by:
Hi all
I am developing a multi-user business/accounting application. It is
coming along nicely :-), though rather slowly :-(
I have hit an issue which will require a lot of changes to the code...
|
by: Chris Thompson |
last post by:
Hi All,
I have a private website created using HTML/PHP. Within this site, there is
a page that has a form (question.php), which is populated depending on the
question number that has been...
|
by: den 2005 |
last post by:
Hi everybody,
Question 1: How do you set the values from server-side to a client-side
control or how do you execute a javascript function without a button click
event?
Question 2: How do you...
|
by: Engineerik |
last post by:
I am trying to create a socket server which will listen for connections from
multiple clients and call subroutines in a Fortran DLL and pass the results
back to the client. The asynchronous socket...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |