Hi,
I had registered an SQL server (same network) in the past through EM and
everything worked fine until yesterday.
If I try to register that server today, I get an error message:
SQL server does not exist or access denied ConnectionOpen(Connect())
Can anybody give me some clues on how I can resolve this?
I still have access to that server on the network, I can Ping it and I tried
stopping the service and restarting it.Hello raymond
The first thing that comes to mind is that it's a rights issue.
Did something change e.g. with the account slq sers running under?
Jan
"Raymond D'Anjou" <rdanjou@.canatradeNOSPAM.com> wrote in message
news:%23TPobo82FHA.1148@.tk2msftngp13.phx.gbl...
> Hi,
> I had registered an SQL server (same network) in the past through EM and
> everything worked fine until yesterday.
> If I try to register that server today, I get an error message:
> SQL server does not exist or access denied ConnectionOpen(Connect())
> Can anybody give me some clues on how I can resolve this?
> I still have access to that server on the network, I can Ping it and I
tried
> stopping the service and restarting it.
>|||No.
Forget it everybody, that is, for now.
Just tried again and it worked for me, but my office buddy still cannot get
a connection.
Must be a buggy network problem (a BNP).
I'll talk to my network guy.
"Jan Doggen" <j.doggen@.BLOCKqsa.nl> wrote in message
news:%23oHiAt82FHA.1148@.tk2msftngp13.phx.gbl...
> Hello raymond
> The first thing that comes to mind is that it's a rights issue.
> Did something change e.g. with the account slq sers running under?
> Jan
> "Raymond D'Anjou" <rdanjou@.canatradeNOSPAM.com> wrote in message
> news:%23TPobo82FHA.1148@.tk2msftngp13.phx.gbl...
> tried
>|||Perhaps the SQL Server service was not running, so check with the DBA.
"Raymond D'Anjou" <rdanjou@.canatradeNOSPAM.com> wrote in message
news:%23TPobo82FHA.1148@.tk2msftngp13.phx.gbl...
> Hi,
> I had registered an SQL server (same network) in the past through EM and
> everything worked fine until yesterday.
> If I try to register that server today, I get an error message:
> SQL server does not exist or access denied ConnectionOpen(Connect())
> Can anybody give me some clues on how I can resolve this?
> I still have access to that server on the network, I can Ping it and I
> tried stopping the service and restarting it.
>
Showing posts with label network. Show all posts
Showing posts with label network. Show all posts
Tuesday, March 27, 2012
Cannot register a local instance
I have SQL Server 2000 installed, client tools only. I can
access the SQL Server on my network and various remote SQL
boxes but I cannot register a local instance.
I keep getting the "SQL Server does not exist or access
denied error message".
Any advice?If you have only the client tools installed locally, you won't be able to
connect to a local instance because there's no local instance. You need to
install the actual engine to be able to connect locally. However, if you
have sql installed locally and you can't connect, make sure the service is
running. You can check this out in the services applet in administrative
tools.
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Rich" <anonymous@.discussions.microsoft.com> wrote in message
news:67db01c3e422$2409f840$7d02280a@.phx.gbl...
I have run a local instance of SQL server on a stand alone
machine in the past, SQL 7 was also installed though.
I need to be able to use SQL server offline at home on my
laptop. Any suggestions?
No SQL services apparently running locally.
won't be able to
instance. You need to
However, if you
sure the service is
administrative
message
edition or developer edition. You can find more info on
www.microsoft.com/sql
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
<anonymous@.discussions.microsoft.com> wrote in message
news:490501c3e42a$7e056cf0$a501280a@.phx.gbl...[QUOTE]
> Thanks for that.
> I have run a local instance of SQL server on a stand alone
> machine in the past, SQL 7 was also installed though.
> I need to be able to use SQL server offline at home on my
> laptop. Any suggestions?
> No SQL services apparently running locally.
> won't be able to
> instance. You need to
> However, if you
> sure the service is
> administrative
> message
> can
> SQL|||Windows 2000 Professional SP3, that is why I could only
install client tools. Desktop edition still cannot find a
local instance to install from.
SQL server 7 would allow a local instance even when not
installed on a server. There must be a way to run an
offline/stand alone version of SQL Server 2000?
sql 2000 desktop
install on a non-server edition of Windows. If you're getting an error
installing SQL Server you can post the exact error and sqlstp.log to the
setup newsgroup. If you're installing MSDE there is a slipstreamed version
that includes SP3, otherwise install the RTM version then immediately apply
SP3. Then apply the latest security rollup for SQL Server.
122352 INF: Supported Windows Versions for SQL Server
http://support.microsoft.com/?id=122352
SQL Server 2000 Evaluation Edition and Developer Edition can run on the
following operating systems:
Operating systems listed above for Enterprise and Standard Editions
Windows XP Professional
Windows XP Home Edition
Windows 2000 Professional
Windows NT Workstation 4.0 with SP5 or later
SQL Server 2000 Personal Edition and SQL Server 2000 Desktop Engine (MSDE)
can run on the following operating systems:
Operating systems listed above for Enterprise, Standard, Evaluation, and
Developer Editions
Windows Server 2003, Web Edition1 (MSDE only)
Windows 98
Windows Millennium Edition (Windows Me)
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
access the SQL Server on my network and various remote SQL
boxes but I cannot register a local instance.
I keep getting the "SQL Server does not exist or access
denied error message".
Any advice?If you have only the client tools installed locally, you won't be able to
connect to a local instance because there's no local instance. You need to
install the actual engine to be able to connect locally. However, if you
have sql installed locally and you can't connect, make sure the service is
running. You can check this out in the services applet in administrative
tools.
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Rich" <anonymous@.discussions.microsoft.com> wrote in message
news:67db01c3e422$2409f840$7d02280a@.phx.gbl...
quote:|||Thanks for that.
> I have SQL Server 2000 installed, client tools only. I can
> access the SQL Server on my network and various remote SQL
> boxes but I cannot register a local instance.
> I keep getting the "SQL Server does not exist or access
> denied error message".
> Any advice?
I have run a local instance of SQL server on a stand alone
machine in the past, SQL 7 was also installed though.
I need to be able to use SQL server offline at home on my
laptop. Any suggestions?
No SQL services apparently running locally.
quote:
>--Original Message--
>If you have only the client tools installed locally, you
won't be able to
quote:
>connect to a local instance because there's no local
instance. You need to
quote:
>install the actual engine to be able to connect locally.
However, if you
quote:
>have sql installed locally and you can't connect, make
sure the service is
quote:
>running. You can check this out in the services applet in
administrative
quote:
>tools.
>--
>Carlos E. Rojas
>SQL Server MVP
>Co-Author SQL Server 2000 programming by Example
>
>"Rich" <anonymous@.discussions.microsoft.com> wrote in
message
quote:|||What version of windows are you running? You could try sql 2000 desktop
>news:67db01c3e422$2409f840$7d02280a@.phx.gbl...
can[QUOTE]
SQL[QUOTE]
>
>.
>
edition or developer edition. You can find more info on
www.microsoft.com/sql
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
<anonymous@.discussions.microsoft.com> wrote in message
news:490501c3e42a$7e056cf0$a501280a@.phx.gbl...[QUOTE]
> Thanks for that.
> I have run a local instance of SQL server on a stand alone
> machine in the past, SQL 7 was also installed though.
> I need to be able to use SQL server offline at home on my
> laptop. Any suggestions?
> No SQL services apparently running locally.
> won't be able to
> instance. You need to
> However, if you
> sure the service is
> administrative
> message
> can
> SQL|||Windows 2000 Professional SP3, that is why I could only
install client tools. Desktop edition still cannot find a
local instance to install from.
SQL server 7 would allow a local instance even when not
installed on a server. There must be a way to run an
offline/stand alone version of SQL Server 2000?
quote:
>--Original Message--
>What version of windows are you running? You could try
sql 2000 desktop
quote:|||MSDE (desktop edition), personal edition, or developer edition should
>edition or developer edition. You can find more info on
>www.microsoft.com/sql
>--
>Carlos E. Rojas
>SQL Server MVP
>Co-Author SQL Server 2000 programming by Example
>
><anonymous@.discussions.microsoft.com> wrote in message
>news:490501c3e42a$7e056cf0$a501280a@.phx.gbl...
alone[QUOTE]
my[QUOTE]
you[QUOTE]
locally.[QUOTE]
in[QUOTE]
I[QUOTE]
remote[QUOTE]
access[QUOTE]
>
>.
>
install on a non-server edition of Windows. If you're getting an error
installing SQL Server you can post the exact error and sqlstp.log to the
setup newsgroup. If you're installing MSDE there is a slipstreamed version
that includes SP3, otherwise install the RTM version then immediately apply
SP3. Then apply the latest security rollup for SQL Server.
122352 INF: Supported Windows Versions for SQL Server
http://support.microsoft.com/?id=122352
SQL Server 2000 Evaluation Edition and Developer Edition can run on the
following operating systems:
Operating systems listed above for Enterprise and Standard Editions
Windows XP Professional
Windows XP Home Edition
Windows 2000 Professional
Windows NT Workstation 4.0 with SP5 or later
SQL Server 2000 Personal Edition and SQL Server 2000 Desktop Engine (MSDE)
can run on the following operating systems:
Operating systems listed above for Enterprise, Standard, Evaluation, and
Developer Editions
Windows Server 2003, Web Edition1 (MSDE only)
Windows 98
Windows Millennium Edition (Windows Me)
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
Sunday, March 25, 2012
Cannot register 2000 on 7 (HELP!)
I am running SQL 7 and trying to connect to a SQL2000
server on the network. I can ping the other machine, and
I have mapped a network drive, but I cannot register it.
It gives me a General Network error. Any Ideas?Brett,
If you try the Register Server Wizard on a SQL 7.0 server, you should see
the following message:
<SQL Server 2000 server name> - You must upgrade your SQL Enterprise Manager
and SQL-DMO(SQLOLE) to SQL Server 2000 (SQLDMO) to connect to this server.
Keith Wilson
This posting is provided "AS IS" without express or implied warranty,
guarantee, or rights.
"Brett" <levi71@.swbell.net> wrote in message
news:0ec801c3d9ea$61c87e50$a301280a@.phx.gbl...
server on the network. I can ping the other machine, and
I have mapped a network drive, but I cannot register it.
It gives me a General Network error. Any Ideas?Brett,
If you try the Register Server Wizard on a SQL 7.0 server, you should see
the following message:
<SQL Server 2000 server name> - You must upgrade your SQL Enterprise Manager
and SQL-DMO(SQLOLE) to SQL Server 2000 (SQLDMO) to connect to this server.
Keith Wilson
This posting is provided "AS IS" without express or implied warranty,
guarantee, or rights.
"Brett" <levi71@.swbell.net> wrote in message
news:0ec801c3d9ea$61c87e50$a301280a@.phx.gbl...
quote:
> I am running SQL 7 and trying to connect to a SQL2000
> server on the network. I can ping the other machine, and
> I have mapped a network drive, but I cannot register it.
> It gives me a General Network error. Any Ideas?
Subscribe to:
Posts (Atom)