I just got a new laptop for work, and our local IT/Hardware guy used
PCMover from Laplink to migrate the apps and settings from my old
machine to this new one. I was skeptical, but it's actually worked
quite well, the biggest issue that I'm having is getting SQL Server to
run on the new machine.
Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
After the migration, I did have to recreate the services for the
server and agent (those services weren't migrated):
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlservr.exe"
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
If I don't include the SQL Server dependency on the SQL Agent, then
the Agent starts just fine. When I try to start the SQL Server
service, it displays a dialog error:
The MSSQLServer service on Local Computer started and then stopped.
Some Services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Here's the contents of the server log:
2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-02-08 10:38:58.14 server All rights reserved.
2007-02-08 10:38:58.14 server Server Process ID is 5860.
2007-02-08 10:38:58.14 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2007-02-08 10:38:58.17 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2007-02-08 10:38:58.84 server SQL Server configured for thread mode
processing.
2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
Lock Blocks, [5000] Lock Owner Blocks.
2007-02-08 10:38:58.87 server Attempting to initialize Distributed
Transaction Coordinator.
2007-02-08 10:38:58.89 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
shutting down.
2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
The failure to obtain TransactionDispenserInterface message was
occurring on the old machine, so I conclude that isn't part of the
issue.
The Server Network Utility does show TCP/IP as the only protocol
enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
listed and that dll is residing in the expected location (C:\Program
Files\Microsoft SQL Server\MSSQL\Binn).
The service properties page page Log On tab shows the Local System
Account to be used for logon.
So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
and re-installing SQL Server, how can I get my SQL Server back up and
running?
Thanks in advance
Mark>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical,
And you should have been. The errorlog clearly states that SQL Server cannot load any netlibs, so it
refuses to start. I.e., the installation isn't OK...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<mark.a.lemoine@.gmail.com> wrote in message
news:1170950095.972400.293760@.s48g2000cws.googlegroups.com...
>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical, but it's actually worked
> quite well, the biggest issue that I'm having is getting SQL Server to
> run on the new machine.
> Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
> After the migration, I did have to recreate the services for the
> server and agent (those services weren't migrated):
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlservr.exe"
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
> If I don't include the SQL Server dependency on the SQL Agent, then
> the Agent starts just fine. When I try to start the SQL Server
> service, it displays a dialog error:
> The MSSQLServer service on Local Computer started and then stopped.
> Some Services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service.
> Here's the contents of the server log:
> 2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
> 2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-02-08 10:38:58.14 server All rights reserved.
> 2007-02-08 10:38:58.14 server Server Process ID is 5860.
> 2007-02-08 10:38:58.14 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2007-02-08 10:38:58.17 server SQL Server is starting at priority
> class 'normal'(2 CPUs detected).
> 2007-02-08 10:38:58.84 server SQL Server configured for thread mode
> processing.
> 2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
> Lock Blocks, [5000] Lock Owner Blocks.
> 2007-02-08 10:38:58.87 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2007-02-08 10:38:58.89 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
> shutting down.
> 2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
> The failure to obtain TransactionDispenserInterface message was
> occurring on the old machine, so I conclude that isn't part of the
> issue.
> The Server Network Utility does show TCP/IP as the only protocol
> enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
> listed and that dll is residing in the expected location (C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn).
> The service properties page page Log On tab shows the Local System
> Account to be used for logon.
> So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
> and re-installing SQL Server, how can I get my SQL Server back up and
> running?
> Thanks in advance
> Mark
>sql
Showing posts with label local. Show all posts
Showing posts with label local. Show all posts
Tuesday, March 27, 2012
Can't start the MSSQLServer Service
I just got a new laptop for work, and our local IT/Hardware guy used
PCMover from Laplink to migrate the apps and settings from my old
machine to this new one. I was skeptical, but it's actually worked
quite well, the biggest issue that I'm having is getting SQL Server to
run on the new machine.
Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
After the migration, I did have to recreate the services for the
server and agent (those services weren't migrated):
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlservr.exe"
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
If I don't include the SQL Server dependency on the SQL Agent, then
the Agent starts just fine. When I try to start the SQL Server
service, it displays a dialog error:
The MSSQLServer service on Local Computer started and then stopped.
Some Services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Here's the contents of the server log:
2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-02-08 10:38:58.14 server All rights reserved.
2007-02-08 10:38:58.14 server Server Process ID is 5860.
2007-02-08 10:38:58.14 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2007-02-08 10:38:58.17 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2007-02-08 10:38:58.84 server SQL Server configured for thread mode
processing.
2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
Lock Blocks, [5000] Lock Owner Blocks.
2007-02-08 10:38:58.87 server Attempting to initialize Distributed
Transaction Coordinator.
2007-02-08 10:38:58.89 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
shutting down.
2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
The failure to obtain TransactionDispenserInterface message was
occurring on the old machine, so I conclude that isn't part of the
issue.
The Server Network Utility does show TCP/IP as the only protocol
enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
listed and that dll is residing in the expected location (C:\Program
Files\Microsoft SQL Server\MSSQL\Binn).
The service properties page page Log On tab shows the Local System
Account to be used for logon.
So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
and re-installing SQL Server, how can I get my SQL Server back up and
running?
Thanks in advance
Mark>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical,
And you should have been. The errorlog clearly states that SQL Server cannot
load any netlibs, so it
refuses to start. I.e., the installation isn't OK...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<mark.a.lemoine@.gmail.com> wrote in message
news:1170950095.972400.293760@.s48g2000cws.googlegroups.com...
>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical, but it's actually worked
> quite well, the biggest issue that I'm having is getting SQL Server to
> run on the new machine.
> Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
> After the migration, I did have to recreate the services for the
> server and agent (those services weren't migrated):
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlservr.exe"
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
> If I don't include the SQL Server dependency on the SQL Agent, then
> the Agent starts just fine. When I try to start the SQL Server
> service, it displays a dialog error:
> The MSSQLServer service on Local Computer started and then stopped.
> Some Services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service.
> Here's the contents of the server log:
> 2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
> 2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-02-08 10:38:58.14 server All rights reserved.
> 2007-02-08 10:38:58.14 server Server Process ID is 5860.
> 2007-02-08 10:38:58.14 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2007-02-08 10:38:58.17 server SQL Server is starting at priority
> class 'normal'(2 CPUs detected).
> 2007-02-08 10:38:58.84 server SQL Server configured for thread mode
> processing.
> 2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
> Lock Blocks, [5000] Lock Owner Blocks.
> 2007-02-08 10:38:58.87 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2007-02-08 10:38:58.89 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
> shutting down.
> 2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
> The failure to obtain TransactionDispenserInterface message was
> occurring on the old machine, so I conclude that isn't part of the
> issue.
> The Server Network Utility does show TCP/IP as the only protocol
> enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
> listed and that dll is residing in the expected location (C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn).
> The service properties page page Log On tab shows the Local System
> Account to be used for logon.
> So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
> and re-installing SQL Server, how can I get my SQL Server back up and
> running?
> Thanks in advance
> Mark
>
PCMover from Laplink to migrate the apps and settings from my old
machine to this new one. I was skeptical, but it's actually worked
quite well, the biggest issue that I'm having is getting SQL Server to
run on the new machine.
Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
After the migration, I did have to recreate the services for the
server and agent (those services weren't migrated):
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlservr.exe"
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
If I don't include the SQL Server dependency on the SQL Agent, then
the Agent starts just fine. When I try to start the SQL Server
service, it displays a dialog error:
The MSSQLServer service on Local Computer started and then stopped.
Some Services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Here's the contents of the server log:
2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-02-08 10:38:58.14 server All rights reserved.
2007-02-08 10:38:58.14 server Server Process ID is 5860.
2007-02-08 10:38:58.14 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2007-02-08 10:38:58.17 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2007-02-08 10:38:58.84 server SQL Server configured for thread mode
processing.
2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
Lock Blocks, [5000] Lock Owner Blocks.
2007-02-08 10:38:58.87 server Attempting to initialize Distributed
Transaction Coordinator.
2007-02-08 10:38:58.89 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
shutting down.
2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
The failure to obtain TransactionDispenserInterface message was
occurring on the old machine, so I conclude that isn't part of the
issue.
The Server Network Utility does show TCP/IP as the only protocol
enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
listed and that dll is residing in the expected location (C:\Program
Files\Microsoft SQL Server\MSSQL\Binn).
The service properties page page Log On tab shows the Local System
Account to be used for logon.
So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
and re-installing SQL Server, how can I get my SQL Server back up and
running?
Thanks in advance
Mark>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical,
And you should have been. The errorlog clearly states that SQL Server cannot
load any netlibs, so it
refuses to start. I.e., the installation isn't OK...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<mark.a.lemoine@.gmail.com> wrote in message
news:1170950095.972400.293760@.s48g2000cws.googlegroups.com...
>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical, but it's actually worked
> quite well, the biggest issue that I'm having is getting SQL Server to
> run on the new machine.
> Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
> After the migration, I did have to recreate the services for the
> server and agent (those services weren't migrated):
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlservr.exe"
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
> If I don't include the SQL Server dependency on the SQL Agent, then
> the Agent starts just fine. When I try to start the SQL Server
> service, it displays a dialog error:
> The MSSQLServer service on Local Computer started and then stopped.
> Some Services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service.
> Here's the contents of the server log:
> 2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
> 2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-02-08 10:38:58.14 server All rights reserved.
> 2007-02-08 10:38:58.14 server Server Process ID is 5860.
> 2007-02-08 10:38:58.14 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2007-02-08 10:38:58.17 server SQL Server is starting at priority
> class 'normal'(2 CPUs detected).
> 2007-02-08 10:38:58.84 server SQL Server configured for thread mode
> processing.
> 2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
> Lock Blocks, [5000] Lock Owner Blocks.
> 2007-02-08 10:38:58.87 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2007-02-08 10:38:58.89 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
> shutting down.
> 2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
> The failure to obtain TransactionDispenserInterface message was
> occurring on the old machine, so I conclude that isn't part of the
> issue.
> The Server Network Utility does show TCP/IP as the only protocol
> enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
> listed and that dll is residing in the expected location (C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn).
> The service properties page page Log On tab shows the Local System
> Account to be used for logon.
> So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
> and re-installing SQL Server, how can I get my SQL Server back up and
> running?
> Thanks in advance
> Mark
>
Can't start sql agent
Hi there,
I install SQL server 2000 in Win 2000 server with SQL SP3
and Win 2000 SP4.
The SQL is default instance and use local system as
service startup account.
Currently I change the startup services account from local
system to domain user account.
SQL Server success start but the sql agant no! I don't
know why? I check the error message - it say cannot
connect local server.
Now I change back the sql agent startup agent to local
system but it still can't start!!
Please help cause I need SQL agent!!
ThanksMay be that the BUILTIN\Administrators group was dropped from SQL Server. If
so, recreate it.
--
Sérgio Monteiro - Brasil
www.sqlpass.org
"Chai" <wingschai@.hotmail.com> escreveu na mensagem
news:082a01c38a25$78aa36f0$a401280a@.phx.gbl...
> Hi there,
> I install SQL server 2000 in Win 2000 server with SQL SP3
> and Win 2000 SP4.
> The SQL is default instance and use local system as
> service startup account.
> Currently I change the startup services account from local
> system to domain user account.
> SQL Server success start but the sql agant no! I don't
> know why? I check the error message - it say cannot
> connect local server.
> Now I change back the sql agent startup agent to local
> system but it still can't start!!
> Please help cause I need SQL agent!!
> Thanks|||I'd check what the SQL Server instance is listening on. In the errorlog, you
should find entries similar to the following:
2003-10-03 20:45:28.95 server SQL server listening on 67.83.16.85: 1058.
2003-10-03 20:45:28.95 server SQL server listening on 127.0.0.1: 1058.
2003-10-03 20:45:32.49 server SQL server listening on TCP, Shared Memory,
Named Pipes.
Also, you may want to log into the SQL Server box with the SQL Agent account
and try osql -S<ServerName> -E from the command line.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Chai" <wingschai@.hotmail.com> wrote in message
news:082a01c38a25$78aa36f0$a401280a@.phx.gbl...
> Hi there,
> I install SQL server 2000 in Win 2000 server with SQL SP3
> and Win 2000 SP4.
> The SQL is default instance and use local system as
> service startup account.
> Currently I change the startup services account from local
> system to domain user account.
> SQL Server success start but the sql agant no! I don't
> know why? I check the error message - it say cannot
> connect local server.
> Now I change back the sql agent startup agent to local
> system but it still can't start!!
> Please help cause I need SQL agent!!
> Thanks|||If I'm not mistaken, a different error (other than cannot connect to local
server) would be issued if you drop BUILTIN\Administrators from SQL Server
and then try to start SQLServerAgent.
By the way, SQL Server Agent log file SQLAgent.out may contain useful info.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Sérgio Monteiro" <shsmonteiro@.horizon.com.br> wrote in message
news:ucRO6piiDHA.3204@.TK2MSFTNGP11.phx.gbl...
> May be that the BUILTIN\Administrators group was dropped from SQL Server.
If
> so, recreate it.
> --
> Sérgio Monteiro - Brasil
> www.sqlpass.org
> "Chai" <wingschai@.hotmail.com> escreveu na mensagem
> news:082a01c38a25$78aa36f0$a401280a@.phx.gbl...
> > Hi there,
> >
> > I install SQL server 2000 in Win 2000 server with SQL SP3
> > and Win 2000 SP4.
> >
> > The SQL is default instance and use local system as
> > service startup account.
> >
> > Currently I change the startup services account from local
> > system to domain user account.
> >
> > SQL Server success start but the sql agant no! I don't
> > know why? I check the error message - it say cannot
> > connect local server.
> >
> > Now I change back the sql agent startup agent to local
> > system but it still can't start!!
> >
> > Please help cause I need SQL agent!!
> >
> > Thanks
>|||You're right. The exact message is "SQLServerAgent could not be started
(reason: SQLServerAgent must be able to
connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the
SysAdmin role). "
But I remember one situation in which I faced this issue and somebody had
dropped the BUILTIN\Administrators. May be I'm confusing the situations.
Sérgio Monteiro - Brasil
www.sqlpass.org
"Linchi Shea" <linchi_shea@.NOSPAMml.com> escreveu na mensagem
news:#kncH4iiDHA.1692@.TK2MSFTNGP10.phx.gbl...
> If I'm not mistaken, a different error (other than cannot connect to local
> server) would be issued if you drop BUILTIN\Administrators from SQL Server
> and then try to start SQLServerAgent.
> By the way, SQL Server Agent log file SQLAgent.out may contain useful
info.
> --
> Linchi Shea
> linchi_shea@.NOSPAMml.com
>
> "Sérgio Monteiro" <shsmonteiro@.horizon.com.br> wrote in message
> news:ucRO6piiDHA.3204@.TK2MSFTNGP11.phx.gbl...
> > May be that the BUILTIN\Administrators group was dropped from SQL
Server.
> If
> > so, recreate it.
> >
> > --
> > Sérgio Monteiro - Brasil
> > www.sqlpass.org
> > "Chai" <wingschai@.hotmail.com> escreveu na mensagem
> > news:082a01c38a25$78aa36f0$a401280a@.phx.gbl...
> > > Hi there,
> > >
> > > I install SQL server 2000 in Win 2000 server with SQL SP3
> > > and Win 2000 SP4.
> > >
> > > The SQL is default instance and use local system as
> > > service startup account.
> > >
> > > Currently I change the startup services account from local
> > > system to domain user account.
> > >
> > > SQL Server success start but the sql agant no! I don't
> > > know why? I check the error message - it say cannot
> > > connect local server.
> > >
> > > Now I change back the sql agent startup agent to local
> > > system but it still can't start!!
> > >
> > > Please help cause I need SQL agent!!
> > >
> > > Thanks
> >
> >
>
I install SQL server 2000 in Win 2000 server with SQL SP3
and Win 2000 SP4.
The SQL is default instance and use local system as
service startup account.
Currently I change the startup services account from local
system to domain user account.
SQL Server success start but the sql agant no! I don't
know why? I check the error message - it say cannot
connect local server.
Now I change back the sql agent startup agent to local
system but it still can't start!!
Please help cause I need SQL agent!!
ThanksMay be that the BUILTIN\Administrators group was dropped from SQL Server. If
so, recreate it.
--
Sérgio Monteiro - Brasil
www.sqlpass.org
"Chai" <wingschai@.hotmail.com> escreveu na mensagem
news:082a01c38a25$78aa36f0$a401280a@.phx.gbl...
> Hi there,
> I install SQL server 2000 in Win 2000 server with SQL SP3
> and Win 2000 SP4.
> The SQL is default instance and use local system as
> service startup account.
> Currently I change the startup services account from local
> system to domain user account.
> SQL Server success start but the sql agant no! I don't
> know why? I check the error message - it say cannot
> connect local server.
> Now I change back the sql agent startup agent to local
> system but it still can't start!!
> Please help cause I need SQL agent!!
> Thanks|||I'd check what the SQL Server instance is listening on. In the errorlog, you
should find entries similar to the following:
2003-10-03 20:45:28.95 server SQL server listening on 67.83.16.85: 1058.
2003-10-03 20:45:28.95 server SQL server listening on 127.0.0.1: 1058.
2003-10-03 20:45:32.49 server SQL server listening on TCP, Shared Memory,
Named Pipes.
Also, you may want to log into the SQL Server box with the SQL Agent account
and try osql -S<ServerName> -E from the command line.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Chai" <wingschai@.hotmail.com> wrote in message
news:082a01c38a25$78aa36f0$a401280a@.phx.gbl...
> Hi there,
> I install SQL server 2000 in Win 2000 server with SQL SP3
> and Win 2000 SP4.
> The SQL is default instance and use local system as
> service startup account.
> Currently I change the startup services account from local
> system to domain user account.
> SQL Server success start but the sql agant no! I don't
> know why? I check the error message - it say cannot
> connect local server.
> Now I change back the sql agent startup agent to local
> system but it still can't start!!
> Please help cause I need SQL agent!!
> Thanks|||If I'm not mistaken, a different error (other than cannot connect to local
server) would be issued if you drop BUILTIN\Administrators from SQL Server
and then try to start SQLServerAgent.
By the way, SQL Server Agent log file SQLAgent.out may contain useful info.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Sérgio Monteiro" <shsmonteiro@.horizon.com.br> wrote in message
news:ucRO6piiDHA.3204@.TK2MSFTNGP11.phx.gbl...
> May be that the BUILTIN\Administrators group was dropped from SQL Server.
If
> so, recreate it.
> --
> Sérgio Monteiro - Brasil
> www.sqlpass.org
> "Chai" <wingschai@.hotmail.com> escreveu na mensagem
> news:082a01c38a25$78aa36f0$a401280a@.phx.gbl...
> > Hi there,
> >
> > I install SQL server 2000 in Win 2000 server with SQL SP3
> > and Win 2000 SP4.
> >
> > The SQL is default instance and use local system as
> > service startup account.
> >
> > Currently I change the startup services account from local
> > system to domain user account.
> >
> > SQL Server success start but the sql agant no! I don't
> > know why? I check the error message - it say cannot
> > connect local server.
> >
> > Now I change back the sql agent startup agent to local
> > system but it still can't start!!
> >
> > Please help cause I need SQL agent!!
> >
> > Thanks
>|||You're right. The exact message is "SQLServerAgent could not be started
(reason: SQLServerAgent must be able to
connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the
SysAdmin role). "
But I remember one situation in which I faced this issue and somebody had
dropped the BUILTIN\Administrators. May be I'm confusing the situations.
Sérgio Monteiro - Brasil
www.sqlpass.org
"Linchi Shea" <linchi_shea@.NOSPAMml.com> escreveu na mensagem
news:#kncH4iiDHA.1692@.TK2MSFTNGP10.phx.gbl...
> If I'm not mistaken, a different error (other than cannot connect to local
> server) would be issued if you drop BUILTIN\Administrators from SQL Server
> and then try to start SQLServerAgent.
> By the way, SQL Server Agent log file SQLAgent.out may contain useful
info.
> --
> Linchi Shea
> linchi_shea@.NOSPAMml.com
>
> "Sérgio Monteiro" <shsmonteiro@.horizon.com.br> wrote in message
> news:ucRO6piiDHA.3204@.TK2MSFTNGP11.phx.gbl...
> > May be that the BUILTIN\Administrators group was dropped from SQL
Server.
> If
> > so, recreate it.
> >
> > --
> > Sérgio Monteiro - Brasil
> > www.sqlpass.org
> > "Chai" <wingschai@.hotmail.com> escreveu na mensagem
> > news:082a01c38a25$78aa36f0$a401280a@.phx.gbl...
> > > Hi there,
> > >
> > > I install SQL server 2000 in Win 2000 server with SQL SP3
> > > and Win 2000 SP4.
> > >
> > > The SQL is default instance and use local system as
> > > service startup account.
> > >
> > > Currently I change the startup services account from local
> > > system to domain user account.
> > >
> > > SQL Server success start but the sql agant no! I don't
> > > know why? I check the error message - it say cannot
> > > connect local server.
> > >
> > > Now I change back the sql agent startup agent to local
> > > system but it still can't start!!
> > >
> > > Please help cause I need SQL agent!!
> > >
> > > Thanks
> >
> >
>
can't start sql 2005 service
Hi guys, I have sql 2005 beta 2 installed.. It used to work before, toda
y I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!Have you checked the SQL Server 2005 error log?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Britney" <britneychen_2001@.yahoo.com> wrote in message news:urW5U81oFHA.303
6@.TK2MSFTNGP14.phx.gbl...
Hi guys, I have sql 2005 beta 2 installed.. It used to work before, today
I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!|||where do I look for the log?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message news:%23F
eit92oFHA.3304@.tk2msftngp13.phx.gbl...
Have you checked the SQL Server 2005 error log?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Britney" <britneychen_2001@.yahoo.com> wrote in message news:urW5U81oFHA.303
6@.TK2MSFTNGP14.phx.gbl...
Hi guys, I have sql 2005 beta 2 installed.. It used to work before, toda
y I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!
y I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!Have you checked the SQL Server 2005 error log?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Britney" <britneychen_2001@.yahoo.com> wrote in message news:urW5U81oFHA.303
6@.TK2MSFTNGP14.phx.gbl...
Hi guys, I have sql 2005 beta 2 installed.. It used to work before, today
I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!|||where do I look for the log?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message news:%23F
eit92oFHA.3304@.tk2msftngp13.phx.gbl...
Have you checked the SQL Server 2005 error log?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Britney" <britneychen_2001@.yahoo.com> wrote in message news:urW5U81oFHA.303
6@.TK2MSFTNGP14.phx.gbl...
Hi guys, I have sql 2005 beta 2 installed.. It used to work before, toda
y I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!
Can't start MSSQLServer services.
Hi,
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services on Local Computer started and then stopped. Some services stop
automatically if they have no work to do, for example, the Performance Logs
and Alerts services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny Chow
Johny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services on Local Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>
|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>
|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services on Local Computer started and then stopped. Some services stop
automatically if they have no work to do, for example, the Performance Logs
and Alerts services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny Chow
Johny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services on Local Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>
|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>
|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>
Can't start MSSQLServer services.
Hi,
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services on Local Computer started and then stopped. Some services stop
automatically if they have no work to do, for example, the Performance Logs
and Alerts services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny ChowJohny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services on Local Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services on Local Computer started and then stopped. Some services stop
automatically if they have no work to do, for example, the Performance Logs
and Alerts services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny ChowJohny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services on Local Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>
Sunday, March 25, 2012
Can't start MSSQLServer services.
Hi,
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services on Local Computer started and then stopped. Some services stop
automatically if they have no work to do, for example, the Performance Logs
and Alerts services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny ChowJohny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services on Local Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>> Hi,
>> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
>> services on Local Computer started and then stopped. Some services stop
>> automatically if they have no work to do, for example, the Performance
>> Logs and Alerts services." message. The service is using local computer
>> account to start. Where should I start to trouble shooting this problem?
>> I will be appreciated your tips and information.
>> Thanks,
>> Johnny Chow
>|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>> Johny,
>> Are you using EM, Control Panel - Services or the Sevices Applet to start
>> the service? Might try using the local system account as a test to
>> ensure the service can start then check the permissions of the local
>> account you are using. Are there any informational errors reported in
>> the application event log?
>> A couple of things to look at.
>> HTH
>> Jerry
>> "Johnny Chow" <jchow10@.gmail.com> wrote in message
>> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>> Hi,
>> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
>> services on Local Computer started and then stopped. Some services stop
>> automatically if they have no work to do, for example, the Performance
>> Logs and Alerts services." message. The service is using local computer
>> account to start. Where should I start to trouble shooting this
>> problem? I will be appreciated your tips and information.
>> Thanks,
>> Johnny Chow
>>
>sql
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services on Local Computer started and then stopped. Some services stop
automatically if they have no work to do, for example, the Performance Logs
and Alerts services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny ChowJohny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services on Local Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>> Hi,
>> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
>> services on Local Computer started and then stopped. Some services stop
>> automatically if they have no work to do, for example, the Performance
>> Logs and Alerts services." message. The service is using local computer
>> account to start. Where should I start to trouble shooting this problem?
>> I will be appreciated your tips and information.
>> Thanks,
>> Johnny Chow
>|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>> Johny,
>> Are you using EM, Control Panel - Services or the Sevices Applet to start
>> the service? Might try using the local system account as a test to
>> ensure the service can start then check the permissions of the local
>> account you are using. Are there any informational errors reported in
>> the application event log?
>> A couple of things to look at.
>> HTH
>> Jerry
>> "Johnny Chow" <jchow10@.gmail.com> wrote in message
>> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>> Hi,
>> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
>> services on Local Computer started and then stopped. Some services stop
>> automatically if they have no work to do, for example, the Performance
>> Logs and Alerts services." message. The service is using local computer
>> account to start. Where should I start to trouble shooting this
>> problem? I will be appreciated your tips and information.
>> Thanks,
>> Johnny Chow
>>
>sql
Can't setup SQL AgentMail
Dear all:
I've setup Outlook 2003 for my MAPI client, and setup service that not run
the local machine. And my SQL Mail can work. However, the profile in SQL
AgentMail still can't setup. How should I setup the SQL Agent Mail?Sorry that forgot post my environment:
Win2003 + AD
SQL 2000 + sp3a
Exchange 2003
Outlook 2003
Thank you very much for your reply!
"David" <david@.ms59.ideanote.org.NOSPAM> glsD
:uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
Outlook profile's user account.
Try to use the Outlook user login to your SQL server, then create the
Outlook profile.
Then check again that SQL agentmail profile can setup or not.
2.Verify the MAPI32.dll version, you can see this to check your version.
http://support.microsoft.com/defaul...kb;en-us;263556
Microsoft MVP
Alvin Chen for Windows Server
MCP,MCSE,MCSA,MCSA+Messenger,RHCE,CCNA,T
CSE.
"David" <david@.ms59.ideanote.org.NOSPAM> glsD
:ORmhc4B5DHA.1936@.TK2MSFTNGP12.phx.gbl...
I've setup Outlook 2003 for my MAPI client, and setup service that not run
the local machine. And my SQL Mail can work. However, the profile in SQL
AgentMail still can't setup. How should I setup the SQL Agent Mail?Sorry that forgot post my environment:
Win2003 + AD
SQL 2000 + sp3a
Exchange 2003
Outlook 2003
Thank you very much for your reply!
"David" <david@.ms59.ideanote.org.NOSPAM> glsD
:uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
quote:|||1.And make sure that SQL service account have permission to access the
> Dear all:
> I've setup Outlook 2003 for my MAPI client, and setup service that not run
> the local machine. And my SQL Mail can work. However, the profile in SQL
> AgentMail still can't setup. How should I setup the SQL Agent Mail?
>
Outlook profile's user account.
Try to use the Outlook user login to your SQL server, then create the
Outlook profile.
Then check again that SQL agentmail profile can setup or not.
2.Verify the MAPI32.dll version, you can see this to check your version.
http://support.microsoft.com/defaul...kb;en-us;263556
Microsoft MVP
Alvin Chen for Windows Server
MCP,MCSE,MCSA,MCSA+Messenger,RHCE,CCNA,T
CSE.
"David" <david@.ms59.ideanote.org.NOSPAM> glsD
:ORmhc4B5DHA.1936@.TK2MSFTNGP12.phx.gbl...
quote:
> Sorry that forgot post my environment:
> Win2003 + AD
> SQL 2000 + sp3a
> Exchange 2003
> Outlook 2003
> Thank you very much for your reply!
> "David" <david@.ms59.ideanote.org.NOSPAM> glsD
> :uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
run[QUOTE]
>
Can't setup SQL AgentMail
Dear all:
I've setup Outlook 2003 for my MAPI client, and setup service that not run
the local machine. And my SQL Mail can work. However, the profile in SQL
AgentMail still can't setup. How should I setup the SQL Agent Mail?Sorry that forgot post my environment:
Win2003 + AD
SQL 2000 + sp3a
Exchange 2003
Outlook 2003
Thank you very much for your reply!
"David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
:uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
> Dear all:
> I've setup Outlook 2003 for my MAPI client, and setup service that not run
> the local machine. And my SQL Mail can work. However, the profile in SQL
> AgentMail still can't setup. How should I setup the SQL Agent Mail?
>|||1.And make sure that SQL service account have permission to access the
Outlook profile's user account.
Try to use the Outlook user login to your SQL server, then create the
Outlook profile.
Then check again that SQL agentmail profile can setup or not.
2.Verify the MAPI32.dll version, you can see this to check your version.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
Microsoft MVP
Alvin Chen for Windows Server
MCP,MCSE,MCSA,MCSA+Messenger,RHCE,CCNA,TCSE.
"David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
:ORmhc4B5DHA.1936@.TK2MSFTNGP12.phx.gbl...
> Sorry that forgot post my environment:
> Win2003 + AD
> SQL 2000 + sp3a
> Exchange 2003
> Outlook 2003
> Thank you very much for your reply!
> "David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
> :uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
> > Dear all:
> >
> > I've setup Outlook 2003 for my MAPI client, and setup service that not
run
> > the local machine. And my SQL Mail can work. However, the profile in SQL
> > AgentMail still can't setup. How should I setup the SQL Agent Mail?
> >
> >
>
I've setup Outlook 2003 for my MAPI client, and setup service that not run
the local machine. And my SQL Mail can work. However, the profile in SQL
AgentMail still can't setup. How should I setup the SQL Agent Mail?Sorry that forgot post my environment:
Win2003 + AD
SQL 2000 + sp3a
Exchange 2003
Outlook 2003
Thank you very much for your reply!
"David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
:uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
> Dear all:
> I've setup Outlook 2003 for my MAPI client, and setup service that not run
> the local machine. And my SQL Mail can work. However, the profile in SQL
> AgentMail still can't setup. How should I setup the SQL Agent Mail?
>|||1.And make sure that SQL service account have permission to access the
Outlook profile's user account.
Try to use the Outlook user login to your SQL server, then create the
Outlook profile.
Then check again that SQL agentmail profile can setup or not.
2.Verify the MAPI32.dll version, you can see this to check your version.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
Microsoft MVP
Alvin Chen for Windows Server
MCP,MCSE,MCSA,MCSA+Messenger,RHCE,CCNA,TCSE.
"David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
:ORmhc4B5DHA.1936@.TK2MSFTNGP12.phx.gbl...
> Sorry that forgot post my environment:
> Win2003 + AD
> SQL 2000 + sp3a
> Exchange 2003
> Outlook 2003
> Thank you very much for your reply!
> "David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
> :uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
> > Dear all:
> >
> > I've setup Outlook 2003 for my MAPI client, and setup service that not
run
> > the local machine. And my SQL Mail can work. However, the profile in SQL
> > AgentMail still can't setup. How should I setup the SQL Agent Mail?
> >
> >
>
Tuesday, March 20, 2012
Can't see the SQL Server Express Instance on SQL Browser
Hi All,
I am using SQL Server Express to connect to the network using VPN on a local machine. I have done the following..
a.) Enabled the remote connections for the Express Instance and rebooted the machine.
b.) Connected to the machine with Express Edition locally and can also connect other SQL Server instances from it to verify connectivity.
c.) Yes, SQL Browser Service is running.
d.) Firewall is not turned on, so I do not have to configure any exceptions.
Now here is the big problem: When I browse for SQL Servers on the network the machine does not show up on the list, i.e "macinename\SQLExpress". I had uninstalled and reinstalled the Express edition and rebooted the machine several times with no luck on the SQL Express Instance showing up on the browser list. I even changed the default instance name to "machinename\MACHINE1" on one of the reinstalls. However, I can connect to other SQL Instances from it. But, I cannot connect to it from other machines since its not registered on the network. I have been working on this for the past few days by looking for a solution via this and other forumns. Is there some setting somewhere that I am missing that prevents this instance from not showing up on the browser list. This issue with SQL Express Edition is baffling as well as frustrating and any ideas that can resolve this issue is very much appreciated.
when you say you cant see it on the list, do you mean in the ODBC dialog list? or some other list? if its involves the ODBC dialog, ive had to actually type in the whole machinename \SQLExpress since it didnt show up initially for it to work.|||I am talking about the SQL Server Browser list, that one can see all of the live SQL Server database Instances. Not the dialog list...|||I have several of them that refuse to show up in any browser list. But, I can connect to just about all of them even though they don't show up in the browser list by just typing in the instance name. Is there a particular error that you are getting? Can you give us more detail on your configuration and exactly what steps you are doing?|||After installing SQL Server Express Edition on a new HP laptop with WIN 2K sp2, I went to see if it was registered on the Network as "machinename/SQLEXPRESS", and what I can see on the Network is just the "machinename", with the instance name missing. So I reinstalled it with a new instance name "machinename/Machine1", and again it was missing the instance name "Machine1", but I can see the machinename. I tried to connect with the instance name only "Machine1" and believe me I have tried it every which way but I always get the infamous error:
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)"
Now here is the odd part, I had installed SQL Server Express Edition on a older (1 year) IBM laptop with WIN 2K sp2, about 1 month back and was able to see the complete instance name on the network and can connect just fine. The only difference in these two machines is the age, but they both have the same OS Software installed. I have been pulling my hair in trying to figure out what is going on with SQL Server Express Edition on this new HP laptop with WIN 2K sp2 installed. It just refuses to register itself correctly on the network.
|||I have several that the browser only sees the machine name. That still doesn't mean that is what you use for the connection string. If you are using a default instance of Express Edition, then you still need to connect to machinename\SQLExpress even if browsing only shows you just the machine name. Now, that doesn't mean that you aren't having issues similar to mine on one of my clients which refuses to allow me to connect, we just need to make sure there isn't something else wrong first.|||As I have mentioned before, I tried using "machinename\MACHINE1" as the complete instance name and it throws out the error as I posted before. I can connect other instances from this HP Laptop but cannot connect to it from other machines. Perhaps we are having the same issue. I have been asking our Network Admin, System Admin and Security Admin and they are all puzzled by this SQL Express behavior on this HP laptop. I am wondering if it has anything to do with particular PC machines as the IBM pc works fine, but not the HP, this is just a guess. But I am running out of ideas and my users are running out of patience as I try to find a solution to this big problem....|||Not sure if this has anything to do with your issue, but you mentioned that you were using Win2000 SP2, that is not a supported platform for SQL 2005, you need to be running SP4. I'm surprised that install didn't block.
Mike
|||Yes, it looks like you are having exactly the same issue as I'm having on one of my machines. I have everything configured correctly with all of the access configured the way it needs to be. I can quite literally do anything I want to on the client when I'm RDPed into the server including remotely launching applications, remotely stopping start services, etc. The only that that it refuses to do is recognize and connect to the SQL Server Express Edition instance. I'm having problem doing further troubleshooting and opening a support case is rather difficult since the problem machine is in CA and I'm in TX without any direct ability to get hands on with the machine. I thought I had another one exhibiting this behavior, but when I plugged the laptop into my network, it magically started working and it hasn't thrown the error since. Yes, I'm rather baffled. My only saving grace is that I don't have any more hair to pull out at this point. :)
I have several more machines to work through and I'm hoping that I can get at least one of them to exhibit this behavior.
|||I'm getting a bit closer on my side and now have 2 machines that are having issues. So, I want to try something and see if your results duplicate mine.
Log on to the machine that is having problems using your accouunt. Once it is up and running, go over to another instance and login to the Express instance from the other machine using your Windows credentials. Let me know if that magically makes it work.
|||Hi Michael,
Nope, I tried as you suggested and I keep getting that same error, from the other machine when I try to connect to the problem machine. However, I can connect from the problem machine to any other SQL Server 2005 instance...Do not know what to do at this point. Perhaps Microsoft needs to help out...I hope they are reading this Message.
|||I am wondering if this issue has anything to do with having 2 NIC cards in a Laptop machine, one for the Local Network and the other for the Wireless Network...That is the only difference I see with the 2 different Laptops I am working with. The IBM machine does not have a Wireless Network NIC and it works...The other newer HP has a Wireless NIC and it does not work..Is Microsoft listening.....|||I can rule that one out. I have machines that connect just fine with multiple NICs and a couple that don't that also have multiple NICs.|||Have you tried opening a support case with Microsoft. I am not sure how this particular Software is supported since it is freely distributed..|||SQL Server Express Edition is fully supported. Just like you can call in and get support on Internet Explorer.
I found a couple of other things when I was doing additional configuration. Verify that your WINS scopes are set properly. Also verify that the machine is actually getting its IP address correctly registered into DNS. These two items fixed 100% of the connectivity issues that I was having within SQL Server.
Can't see mapped drives
Hi,
Am unable to see mapped drive when going to restore db in
sql 2000 enterprise manager. Service is set to start
with a lan acct. acct is in the local machine admin grp
and remote machine admin grp.
Any suggestions:-)
Thanks in advanceDo not use mapped drives for backup\restore with SQL server. Use UNC names
instead. SQL may or may not see a mapped drive correctly but will always
find a UNC share that it has permission and connection to.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:8f9b01c40541$3ade3230$a301280a@.phx.gbl...
> Hi,
> Am unable to see mapped drive when going to restore db in
> sql 2000 enterprise manager. Service is set to start
> with a lan acct. acct is in the local machine admin grp
> and remote machine admin grp.
> Any suggestions:-)
> Thanks in advance|||Hi,
You cant see the mapped drives in Enterprise manager. Rather you can
directly mention the UNC path directly in Enterprise manager or use
Restore database command from Query Analyzer.
Restore database <dbname> from disk='\\machinename\share\backupfile.bak'
with stats=10 With
Move 'logicaldatafile' to physcaldatafile',
Move 'logiallogfile' to physcallogfile'
stats will show the restore status
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:8f9b01c40541$3ade3230$a301280a@.phx.gbl...
> Hi,
> Am unable to see mapped drive when going to restore db in
> sql 2000 enterprise manager. Service is set to start
> with a lan acct. acct is in the local machine admin grp
> and remote machine admin grp.
> Any suggestions:-)
> Thanks in advance|||It is possible to get SQL Server to use mapped network drives, through the u
se of trace flag 1807.
Check out knowledge base article #304261 for full details
http://support.microsoft.com/defaul...1&Product=sql2k
Am unable to see mapped drive when going to restore db in
sql 2000 enterprise manager. Service is set to start
with a lan acct. acct is in the local machine admin grp
and remote machine admin grp.
Any suggestions:-)
Thanks in advanceDo not use mapped drives for backup\restore with SQL server. Use UNC names
instead. SQL may or may not see a mapped drive correctly but will always
find a UNC share that it has permission and connection to.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:8f9b01c40541$3ade3230$a301280a@.phx.gbl...
> Hi,
> Am unable to see mapped drive when going to restore db in
> sql 2000 enterprise manager. Service is set to start
> with a lan acct. acct is in the local machine admin grp
> and remote machine admin grp.
> Any suggestions:-)
> Thanks in advance|||Hi,
You cant see the mapped drives in Enterprise manager. Rather you can
directly mention the UNC path directly in Enterprise manager or use
Restore database command from Query Analyzer.
Restore database <dbname> from disk='\\machinename\share\backupfile.bak'
with stats=10 With
Move 'logicaldatafile' to physcaldatafile',
Move 'logiallogfile' to physcallogfile'
stats will show the restore status
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:8f9b01c40541$3ade3230$a301280a@.phx.gbl...
> Hi,
> Am unable to see mapped drive when going to restore db in
> sql 2000 enterprise manager. Service is set to start
> with a lan acct. acct is in the local machine admin grp
> and remote machine admin grp.
> Any suggestions:-)
> Thanks in advance|||It is possible to get SQL Server to use mapped network drives, through the u
se of trace flag 1807.
Check out knowledge base article #304261 for full details
http://support.microsoft.com/defaul...1&Product=sql2k
Sunday, March 11, 2012
Can't run LDAP Query From Remote Machine
Hi all,
I have a SQL 2005 server with a linked server which points to our
active directory. I am able to query the active directory from the
local machine when RDC'ed into the server, but when I run the query
from a remote machine using Management Studio, I get this error:
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT *
FROM 'LDAP://prudc/DC=<domain>,DC=com'
" against OLE DB provider "ADSDSOObject" for linked server "ADSI".
The query is:
SELECT *
FROM OPENQUERY( ADSI,
'SELECT *
FROM ''LDAP://prudc/DC=<domain>,DC=com''
'
)
(note I replaced our domain name with <domain> in the above query and
error message)
This issue isn't specific to the above query as I've tried many ldap
queries and they have all worked on the local machine but failed on the
remote machine.
I'm completely stomped on this and would greatly appreciate any help I
can get.
ThanksHi Jim
This was a previous post when someone had the same error
http://tinyurl.com/pjg7s I am not sure how much use it will be!
If the query works on the server then I would expect it to be ok, which
probably leaves permission/access as the main issue. Can you use VB script to
query the AD e.g. using the scripts from http://www.rlmueller.net/?
John
"Jim" wrote:
> Hi all,
> I have a SQL 2005 server with a linked server which points to our
> active directory. I am able to query the active directory from the
> local machine when RDC'ed into the server, but when I run the query
> from a remote machine using Management Studio, I get this error:
>
> Msg 7320, Level 16, State 2, Line 1
> Cannot execute the query "SELECT *
> FROM 'LDAP://prudc/DC=<domain>,DC=com'
> " against OLE DB provider "ADSDSOObject" for linked server "ADSI".
>
> The query is:
> SELECT *
> FROM OPENQUERY( ADSI,
> 'SELECT *
> FROM ''LDAP://prudc/DC=<domain>,DC=com''
> '
> )
> (note I replaced our domain name with <domain> in the above query and
> error message)
>
> This issue isn't specific to the above query as I've tried many ldap
> queries and they have all worked on the local machine but failed on the
> remote machine.
> I'm completely stomped on this and would greatly appreciate any help I
> can get.
> Thanks
>|||Thanks for the help but unfortunately, I've already looked at that post
and the issue is a bit different.
The issue I'm having seems to have something to do with running a query
from a remote machine. So if I run a query on our SQL Server box from
my local desktop machine, I get the error. Running the query directly
on the SQL Server box while RDCed into the machine works flawlessly.
I did try to run a .vbs script from my machine which was able to query
the active directory...thanks for the link =). This leads me to
believe that it has something to do with SQL server security
restricting queries run from remote machines. I ran the surface area
configuration utility and didn't really see anything that jumped out at
me...
Anyone have any ideas?|||Alright, I've figured out a fix..
The AD linked server that I originally created was set to login to AD
with the credentials of the current security context. I changed this
to log in with a specified login and it worked fine. Whats strange is
that I set it to my own login account which I was using to run the
query remotely anyways. I guess SQL server queries ran remotely are
not run under the logged in users' security context after all?
Thanks for your help John =).
I have a SQL 2005 server with a linked server which points to our
active directory. I am able to query the active directory from the
local machine when RDC'ed into the server, but when I run the query
from a remote machine using Management Studio, I get this error:
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT *
FROM 'LDAP://prudc/DC=<domain>,DC=com'
" against OLE DB provider "ADSDSOObject" for linked server "ADSI".
The query is:
SELECT *
FROM OPENQUERY( ADSI,
'SELECT *
FROM ''LDAP://prudc/DC=<domain>,DC=com''
'
)
(note I replaced our domain name with <domain> in the above query and
error message)
This issue isn't specific to the above query as I've tried many ldap
queries and they have all worked on the local machine but failed on the
remote machine.
I'm completely stomped on this and would greatly appreciate any help I
can get.
ThanksHi Jim
This was a previous post when someone had the same error
http://tinyurl.com/pjg7s I am not sure how much use it will be!
If the query works on the server then I would expect it to be ok, which
probably leaves permission/access as the main issue. Can you use VB script to
query the AD e.g. using the scripts from http://www.rlmueller.net/?
John
"Jim" wrote:
> Hi all,
> I have a SQL 2005 server with a linked server which points to our
> active directory. I am able to query the active directory from the
> local machine when RDC'ed into the server, but when I run the query
> from a remote machine using Management Studio, I get this error:
>
> Msg 7320, Level 16, State 2, Line 1
> Cannot execute the query "SELECT *
> FROM 'LDAP://prudc/DC=<domain>,DC=com'
> " against OLE DB provider "ADSDSOObject" for linked server "ADSI".
>
> The query is:
> SELECT *
> FROM OPENQUERY( ADSI,
> 'SELECT *
> FROM ''LDAP://prudc/DC=<domain>,DC=com''
> '
> )
> (note I replaced our domain name with <domain> in the above query and
> error message)
>
> This issue isn't specific to the above query as I've tried many ldap
> queries and they have all worked on the local machine but failed on the
> remote machine.
> I'm completely stomped on this and would greatly appreciate any help I
> can get.
> Thanks
>|||Thanks for the help but unfortunately, I've already looked at that post
and the issue is a bit different.
The issue I'm having seems to have something to do with running a query
from a remote machine. So if I run a query on our SQL Server box from
my local desktop machine, I get the error. Running the query directly
on the SQL Server box while RDCed into the machine works flawlessly.
I did try to run a .vbs script from my machine which was able to query
the active directory...thanks for the link =). This leads me to
believe that it has something to do with SQL server security
restricting queries run from remote machines. I ran the surface area
configuration utility and didn't really see anything that jumped out at
me...
Anyone have any ideas?|||Alright, I've figured out a fix..
The AD linked server that I originally created was set to login to AD
with the credentials of the current security context. I changed this
to log in with a specified login and it worked fine. Whats strange is
that I set it to my own login account which I was using to run the
query remotely anyways. I guess SQL server queries ran remotely are
not run under the logged in users' security context after all?
Thanks for your help John =).
Can't Route to another LOCAL Broker Instance
Hi Remus,
I am experiencing the same problem, and I can't get the easy fix to work. I drop and create the DB's in between tests, so it is not related to having an old certificate in the DB, as in the case of Tilfried.
The situation is as follows:
DB1 owned by login1, has a user for login2; this DB is for the initiator
DB2 owned by login2, has a user for login1; this DB hosts the target
Both DB's have TRUSTWORTHY flag set to ON
Error in sys.transmission_queue: 'Error 916, State 3: The server principal "Login1" is not able to access the database "DB2" under the current security context.
Going on a limp, I decide to add a remote service binding in DB1, binding the user for Login2 to the target service, even though BOL explicitly states that this is only required for cross-server communications. This does change the situation - I still get an error, but a new message is sys.transmission_queue: "Dialog security is unavailable for this covnersation because there is no certificate bound to the database principal (Id: 5). Either create a certificate for the principal, or specify ENCRYPTION = OFF when beginning the conversation." I already know that the first option works, but I wanted to get the simple solution running. As for the second option, I doublechecked and the initiating procedure DOES already specify ENCRYPTION = OFF in the BEGIN DIALOG CONVERSATION command. My theory is that the remote service binding somehow forces SB to use encryption, but (a) that is not stated in the error message, and (b) if so, then how to get the messages sent over to the target service without using the binding?
==> EDIT: Just saw that you confirmed this theory in your last reply to Tlifried. So I am indeed back to having to find out how to get this to work without remote service binding - it should be possible, but how?
BTW, SELECT @.@.VERSION shows that I'm on build 3054, in case it matters.
Between all the errors in BOL and less than helpfull error messages produced by SB, I feel like I'm slowly losing my sanity. Please help!
Best regards,
Hugo Kornelis
Hi Remus (or whoever is listening),
Just to make sure that I'm not looking in the wrong corner, I decided to make sure that the absence of certificates is the ONLY reason that the services won't talk to each other. So I made certificates for the dbo owner in each of the DBs, dumped them to file and used those files to create certificates for the corresponding users in the other DBs.
After setting up certificates like that, I still got the same error (Error 916, State 3) - but once I added a remote service binding, my dialog ran without further problems.
I still don't understand why a remote service binding is required even though BOL says (quote from the CREATE REMOTE SERVICE BINDING page): "A remote service binding is only necessary for initiating services that communicate with target services outside of the SQL Server instance." - but at least I am now certain that my problems with the version without certificates and with the trustworthy option set on are not related to any other errors in my setup.
Best, Hugo
|||On the interaction between ENCRYPTION = ON/OFF and the presence/absence of a remote service binding see http://blogs.msdn.com/remusrusanu/archive/2006/07/07/659319.aspx. When a RSB is present, the login mapping between databases is discarded in favour of certificates. This is intentional, as a way to circumvent the problem of no wanting to enable TRUSTWORTHY bit (with all the instance level implications).
To map users trough logins, having TRUSTWORTHY ON is a required condition, but not suficcient. The complete story is detailed at http://msdn2.microsoft.com/en-us/library/ms188304.aspx. What you need is for DB2 to grant AUTHENTICATE permision to login1. TRUSTWORTHY bit is required only on DB1. This is nothing specific to Service Broker, using EXECUTE AS user = 'foo' in DB1 and then issue a USE DB2 statement would run into the same error.
I understand the errors are somehow cryptic and misterious, now the cat is out of the bag we hope to get better at next iteration. Tools would shorley help, give a shot to www.codeplex.com/slm
|||
Hugo Kornelis wrote:
I still don't understand why a remote service binding is required even though BOL says (quote from the CREATE REMOTE SERVICE BINDING page): "A remote service binding is only necessary for initiating services that communicate with target services outside of the SQL Server instance."
Remote service bindings are required for remote dialog security. However, altough not required, if present, they are honored for local dialogs.
|||without reading the whole thread in detail, I found that the SQL Profiler lets you find problems within minutes, for which you would normally take hours or days of checking everything!
Trace shows messages and errors, you will never receive through SSB directly!
Wednesday, March 7, 2012
cant register sql2k5
I have a local instance of sql2k5, as well as a remote one. From my local
Management Studio, I try to register the remote one, and I get the message...
A connection was successfully established to the server, but then an error
occured during the login process. (provider: TCP Provider, error:0 - An
existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
10054)
Any ideas?
TIA,
ChrisR
Did you enable TCP/IP connections from remote machines in SQL Surface
Area Configuration Tool? They're not turned on by default in 2005.
ChrisR wrote:
> I have a local instance of sql2k5, as well as a remote one. From my local
> Management Studio, I try to register the remote one, and I get the message...
> A connection was successfully established to the server, but then an error
> occured during the login process. (provider: TCP Provider, error:0 - An
> existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> 10054)
> Any ideas?
> --
> TIA,
> ChrisR
|||I don't have a Configurations tab on the remote box... I just realized its
Beta2. Could this have sometihng to do with it?
TIA,
ChrisR
"Corey Bunch" wrote:
> Did you enable TCP/IP connections from remote machines in SQL Surface
> Area Configuration Tool? They're not turned on by default in 2005.
> ChrisR wrote:
>
|||Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
Configuration tool?
"ChrisR" wrote:
[vbcol=seagreen]
> I don't have a Configurations tab on the remote box... I just realized its
> Beta2. Could this have sometihng to do with it?
> --
> TIA,
> ChrisR
>
> "Corey Bunch" wrote:
|||Start\ Programs\ there is no Configuration Tools option.
TIA,
ChrisR
"burt_king" wrote:
[vbcol=seagreen]
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
|||Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
TIA,
ChrisR
"ChrisR" wrote:
[vbcol=seagreen]
> Start\ Programs\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "burt_king" wrote:
|||How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
you can enable the netlibs.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...[vbcol=seagreen]
> Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "ChrisR" wrote:
|||And do what to the netlibs? I dont see anything like enable remote connections.
TIA,
ChrisR
"Tibor Karaszi" wrote:
> How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
> you can enable the netlibs.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
>
|||Also, I tried to register in reverse.
1; In my local box, I went into
I logged into the remote box and tried to register my local box. I went into
SQL Server Surface Area Config/ Services and Connections/ Remote Connections/
Local and Remote Connections is checked.
When I try to register it says Unknown ProviderConnection string is invalid.
(MSSQL error: 87)
TIA,
ChrisR
"burt_king" wrote:
[vbcol=seagreen]
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
|||Hard to know what your setup look like as you are on an older version (beta). On my machines, I use
the following folder structure:
SQL Server Configuration Manager
SQL Server 2005 Network Configuration
Protocols for [instancename]
In above folder I can right-click a netlib (TCP/IP, for instance) and enable it.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:F19474D2-3815-4B06-B549-FE357816A8C9@.microsoft.com...[vbcol=seagreen]
> And do what to the netlibs? I dont see anything like enable remote connections.
> --
> TIA,
> ChrisR
>
> "Tibor Karaszi" wrote:
Management Studio, I try to register the remote one, and I get the message...
A connection was successfully established to the server, but then an error
occured during the login process. (provider: TCP Provider, error:0 - An
existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
10054)
Any ideas?
TIA,
ChrisR
Did you enable TCP/IP connections from remote machines in SQL Surface
Area Configuration Tool? They're not turned on by default in 2005.
ChrisR wrote:
> I have a local instance of sql2k5, as well as a remote one. From my local
> Management Studio, I try to register the remote one, and I get the message...
> A connection was successfully established to the server, but then an error
> occured during the login process. (provider: TCP Provider, error:0 - An
> existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> 10054)
> Any ideas?
> --
> TIA,
> ChrisR
|||I don't have a Configurations tab on the remote box... I just realized its
Beta2. Could this have sometihng to do with it?
TIA,
ChrisR
"Corey Bunch" wrote:
> Did you enable TCP/IP connections from remote machines in SQL Surface
> Area Configuration Tool? They're not turned on by default in 2005.
> ChrisR wrote:
>
|||Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
Configuration tool?
"ChrisR" wrote:
[vbcol=seagreen]
> I don't have a Configurations tab on the remote box... I just realized its
> Beta2. Could this have sometihng to do with it?
> --
> TIA,
> ChrisR
>
> "Corey Bunch" wrote:
|||Start\ Programs\ there is no Configuration Tools option.
TIA,
ChrisR
"burt_king" wrote:
[vbcol=seagreen]
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
|||Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
TIA,
ChrisR
"ChrisR" wrote:
[vbcol=seagreen]
> Start\ Programs\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "burt_king" wrote:
|||How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
you can enable the netlibs.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...[vbcol=seagreen]
> Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "ChrisR" wrote:
|||And do what to the netlibs? I dont see anything like enable remote connections.
TIA,
ChrisR
"Tibor Karaszi" wrote:
> How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
> you can enable the netlibs.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
>
|||Also, I tried to register in reverse.
1; In my local box, I went into
I logged into the remote box and tried to register my local box. I went into
SQL Server Surface Area Config/ Services and Connections/ Remote Connections/
Local and Remote Connections is checked.
When I try to register it says Unknown ProviderConnection string is invalid.
(MSSQL error: 87)
TIA,
ChrisR
"burt_king" wrote:
[vbcol=seagreen]
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
|||Hard to know what your setup look like as you are on an older version (beta). On my machines, I use
the following folder structure:
SQL Server Configuration Manager
SQL Server 2005 Network Configuration
Protocols for [instancename]
In above folder I can right-click a netlib (TCP/IP, for instance) and enable it.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:F19474D2-3815-4B06-B549-FE357816A8C9@.microsoft.com...[vbcol=seagreen]
> And do what to the netlibs? I dont see anything like enable remote connections.
> --
> TIA,
> ChrisR
>
> "Tibor Karaszi" wrote:
cant register sql2k5
I have a local instance of sql2k5, as well as a remote one. From my local
Management Studio, I try to register the remote one, and I get the message...
A connection was successfully established to the server, but then an error
occured during the login process. (provider: TCP Provider, error:0 - An
existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
10054)
Any ideas?
--
TIA,
ChrisRDid you enable TCP/IP connections from remote machines in SQL Surface
Area Configuration Tool? They're not turned on by default in 2005.
ChrisR wrote:
> I have a local instance of sql2k5, as well as a remote one. From my local
> Management Studio, I try to register the remote one, and I get the message...
> A connection was successfully established to the server, but then an error
> occured during the login process. (provider: TCP Provider, error:0 - An
> existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> 10054)
> Any ideas?
> --
> TIA,
> ChrisR|||I don't have a Configurations tab on the remote box... I just realized its
Beta2. Could this have sometihng to do with it?
--
TIA,
ChrisR
"Corey Bunch" wrote:
> Did you enable TCP/IP connections from remote machines in SQL Surface
> Area Configuration Tool? They're not turned on by default in 2005.
> ChrisR wrote:
> > I have a local instance of sql2k5, as well as a remote one. From my local
> > Management Studio, I try to register the remote one, and I get the message...
> >
> > A connection was successfully established to the server, but then an error
> > occured during the login process. (provider: TCP Provider, error:0 - An
> > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > 10054)
> >
> > Any ideas?
> > --
> > TIA,
> > ChrisR
>|||Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
Configuration tool?
"ChrisR" wrote:
> I don't have a Configurations tab on the remote box... I just realized its
> Beta2. Could this have sometihng to do with it?
> --
> TIA,
> ChrisR
>
> "Corey Bunch" wrote:
> > Did you enable TCP/IP connections from remote machines in SQL Surface
> > Area Configuration Tool? They're not turned on by default in 2005.
> >
> > ChrisR wrote:
> > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > Management Studio, I try to register the remote one, and I get the message...
> > >
> > > A connection was successfully established to the server, but then an error
> > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > 10054)
> > >
> > > Any ideas?
> > > --
> > > TIA,
> > > ChrisR
> >
> >|||Start\ Programs\ there is no Configuration Tools option.
--
TIA,
ChrisR
"burt_king" wrote:
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
> > I don't have a Configurations tab on the remote box... I just realized its
> > Beta2. Could this have sometihng to do with it?
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Corey Bunch" wrote:
> >
> > > Did you enable TCP/IP connections from remote machines in SQL Surface
> > > Area Configuration Tool? They're not turned on by default in 2005.
> > >
> > > ChrisR wrote:
> > > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > > Management Studio, I try to register the remote one, and I get the message...
> > > >
> > > > A connection was successfully established to the server, but then an error
> > > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > > 10054)
> > > >
> > > > Any ideas?
> > > > --
> > > > TIA,
> > > > ChrisR
> > >
> > >|||Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
--
TIA,
ChrisR
"ChrisR" wrote:
> Start\ Programs\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "burt_king" wrote:
> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> > Configuration tool?
> >
> > "ChrisR" wrote:
> >
> > > I don't have a Configurations tab on the remote box... I just realized its
> > > Beta2. Could this have sometihng to do with it?
> > > --
> > > TIA,
> > > ChrisR
> > >
> > >
> > > "Corey Bunch" wrote:
> > >
> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
> > > > Area Configuration Tool? They're not turned on by default in 2005.
> > > >
> > > > ChrisR wrote:
> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > > > Management Studio, I try to register the remote one, and I get the message...
> > > > >
> > > > > A connection was successfully established to the server, but then an error
> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > > > 10054)
> > > > >
> > > > > Any ideas?
> > > > > --
> > > > > TIA,
> > > > > ChrisR
> > > >
> > > >|||How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
you can enable the netlibs.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
> Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "ChrisR" wrote:
>> Start\ Programs\ there is no Configuration Tools option.
>> --
>> TIA,
>> ChrisR
>>
>> "burt_king" wrote:
>> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
>> > Configuration tool?
>> >
>> > "ChrisR" wrote:
>> >
>> > > I don't have a Configurations tab on the remote box... I just realized its
>> > > Beta2. Could this have sometihng to do with it?
>> > > --
>> > > TIA,
>> > > ChrisR
>> > >
>> > >
>> > > "Corey Bunch" wrote:
>> > >
>> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
>> > > > Area Configuration Tool? They're not turned on by default in 2005.
>> > > >
>> > > > ChrisR wrote:
>> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
>> > > > > Management Studio, I try to register the remote one, and I get the message...
>> > > > >
>> > > > > A connection was successfully established to the server, but then an error
>> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
>> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
>> > > > > 10054)
>> > > > >
>> > > > > Any ideas?
>> > > > > --
>> > > > > TIA,
>> > > > > ChrisR
>> > > >
>> > > >|||And do what to the netlibs? I dont see anything like enable remote connections.
--
TIA,
ChrisR
"Tibor Karaszi" wrote:
> How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
> you can enable the netlibs.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
> > Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> >
> > --
> > TIA,
> > ChrisR
> >
> >
> > "ChrisR" wrote:
> >
> >> Start\ Programs\ there is no Configuration Tools option.
> >> --
> >> TIA,
> >> ChrisR
> >>
> >>
> >> "burt_king" wrote:
> >>
> >> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> >> > Configuration tool?
> >> >
> >> > "ChrisR" wrote:
> >> >
> >> > > I don't have a Configurations tab on the remote box... I just realized its
> >> > > Beta2. Could this have sometihng to do with it?
> >> > > --
> >> > > TIA,
> >> > > ChrisR
> >> > >
> >> > >
> >> > > "Corey Bunch" wrote:
> >> > >
> >> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
> >> > > > Area Configuration Tool? They're not turned on by default in 2005.
> >> > > >
> >> > > > ChrisR wrote:
> >> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
> >> > > > > Management Studio, I try to register the remote one, and I get the message...
> >> > > > >
> >> > > > > A connection was successfully established to the server, but then an error
> >> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
> >> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> >> > > > > 10054)
> >> > > > >
> >> > > > > Any ideas?
> >> > > > > --
> >> > > > > TIA,
> >> > > > > ChrisR
> >> > > >
> >> > > >
>|||Also, I tried to register in reverse.
1; In my local box, I went into
I logged into the remote box and tried to register my local box. I went into
SQL Server Surface Area Config/ Services and Connections/ Remote Connections/
Local and Remote Connections is checked.
When I try to register it says Unknown ProviderConnection string is invalid.
(MSSQL error: 87)
TIA,
ChrisR
"burt_king" wrote:
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
> > I don't have a Configurations tab on the remote box... I just realized its
> > Beta2. Could this have sometihng to do with it?
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Corey Bunch" wrote:
> >
> > > Did you enable TCP/IP connections from remote machines in SQL Surface
> > > Area Configuration Tool? They're not turned on by default in 2005.
> > >
> > > ChrisR wrote:
> > > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > > Management Studio, I try to register the remote one, and I get the message...
> > > >
> > > > A connection was successfully established to the server, but then an error
> > > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > > 10054)
> > > >
> > > > Any ideas?
> > > > --
> > > > TIA,
> > > > ChrisR
> > >
> > >|||Hard to know what your setup look like as you are on an older version (beta). On my machines, I use
the following folder structure:
SQL Server Configuration Manager
SQL Server 2005 Network Configuration
Protocols for [instancename]
In above folder I can right-click a netlib (TCP/IP, for instance) and enable it.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:F19474D2-3815-4B06-B549-FE357816A8C9@.microsoft.com...
> And do what to the netlibs? I dont see anything like enable remote connections.
> --
> TIA,
> ChrisR
>
> "Tibor Karaszi" wrote:
>> How about Computer Manager, under Services, you should have some SQL Server Configuration Node.
>> Here
>> you can enable the netlibs.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
>> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
>> > Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
>> >
>> > --
>> > TIA,
>> > ChrisR
>> >
>> >
>> > "ChrisR" wrote:
>> >
>> >> Start\ Programs\ there is no Configuration Tools option.
>> >> --
>> >> TIA,
>> >> ChrisR
>> >>
>> >>
>> >> "burt_king" wrote:
>> >>
>> >> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
>> >> > Configuration tool?
>> >> >
>> >> > "ChrisR" wrote:
>> >> >
>> >> > > I don't have a Configurations tab on the remote box... I just realized its
>> >> > > Beta2. Could this have sometihng to do with it?
>> >> > > --
>> >> > > TIA,
>> >> > > ChrisR
>> >> > >
>> >> > >
>> >> > > "Corey Bunch" wrote:
>> >> > >
>> >> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
>> >> > > > Area Configuration Tool? They're not turned on by default in 2005.
>> >> > > >
>> >> > > > ChrisR wrote:
>> >> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
>> >> > > > > Management Studio, I try to register the remote one, and I get the message...
>> >> > > > >
>> >> > > > > A connection was successfully established to the server, but then an error
>> >> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
>> >> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
>> >> > > > > 10054)
>> >> > > > >
>> >> > > > > Any ideas?
>> >> > > > > --
>> >> > > > > TIA,
>> >> > > > > ChrisR
>> >> > > >
>> >> > > >
>>|||Im going to reinstall with a more current version and see what happens.
--
TIA,
ChrisR
"Tibor Karaszi" wrote:
> Hard to know what your setup look like as you are on an older version (beta). On my machines, I use
> the following folder structure:
> SQL Server Configuration Manager
> SQL Server 2005 Network Configuration
> Protocols for [instancename]
> In above folder I can right-click a netlib (TCP/IP, for instance) and enable it.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:F19474D2-3815-4B06-B549-FE357816A8C9@.microsoft.com...
> > And do what to the netlibs? I dont see anything like enable remote connections.
> >
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> How about Computer Manager, under Services, you should have some SQL Server Configuration Node.
> >> Here
> >> you can enable the netlibs.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >>
> >>
> >> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> >> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
> >> > Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> >> >
> >> > --
> >> > TIA,
> >> > ChrisR
> >> >
> >> >
> >> > "ChrisR" wrote:
> >> >
> >> >> Start\ Programs\ there is no Configuration Tools option.
> >> >> --
> >> >> TIA,
> >> >> ChrisR
> >> >>
> >> >>
> >> >> "burt_king" wrote:
> >> >>
> >> >> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> >> >> > Configuration tool?
> >> >> >
> >> >> > "ChrisR" wrote:
> >> >> >
> >> >> > > I don't have a Configurations tab on the remote box... I just realized its
> >> >> > > Beta2. Could this have sometihng to do with it?
> >> >> > > --
> >> >> > > TIA,
> >> >> > > ChrisR
> >> >> > >
> >> >> > >
> >> >> > > "Corey Bunch" wrote:
> >> >> > >
> >> >> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
> >> >> > > > Area Configuration Tool? They're not turned on by default in 2005.
> >> >> > > >
> >> >> > > > ChrisR wrote:
> >> >> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
> >> >> > > > > Management Studio, I try to register the remote one, and I get the message...
> >> >> > > > >
> >> >> > > > > A connection was successfully established to the server, but then an error
> >> >> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
> >> >> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> >> >> > > > > 10054)
> >> >> > > > >
> >> >> > > > > Any ideas?
> >> >> > > > > --
> >> >> > > > > TIA,
> >> >> > > > > ChrisR
> >> >> > > >
> >> >> > > >
> >>
> >>
>
Management Studio, I try to register the remote one, and I get the message...
A connection was successfully established to the server, but then an error
occured during the login process. (provider: TCP Provider, error:0 - An
existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
10054)
Any ideas?
--
TIA,
ChrisRDid you enable TCP/IP connections from remote machines in SQL Surface
Area Configuration Tool? They're not turned on by default in 2005.
ChrisR wrote:
> I have a local instance of sql2k5, as well as a remote one. From my local
> Management Studio, I try to register the remote one, and I get the message...
> A connection was successfully established to the server, but then an error
> occured during the login process. (provider: TCP Provider, error:0 - An
> existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> 10054)
> Any ideas?
> --
> TIA,
> ChrisR|||I don't have a Configurations tab on the remote box... I just realized its
Beta2. Could this have sometihng to do with it?
--
TIA,
ChrisR
"Corey Bunch" wrote:
> Did you enable TCP/IP connections from remote machines in SQL Surface
> Area Configuration Tool? They're not turned on by default in 2005.
> ChrisR wrote:
> > I have a local instance of sql2k5, as well as a remote one. From my local
> > Management Studio, I try to register the remote one, and I get the message...
> >
> > A connection was successfully established to the server, but then an error
> > occured during the login process. (provider: TCP Provider, error:0 - An
> > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > 10054)
> >
> > Any ideas?
> > --
> > TIA,
> > ChrisR
>|||Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
Configuration tool?
"ChrisR" wrote:
> I don't have a Configurations tab on the remote box... I just realized its
> Beta2. Could this have sometihng to do with it?
> --
> TIA,
> ChrisR
>
> "Corey Bunch" wrote:
> > Did you enable TCP/IP connections from remote machines in SQL Surface
> > Area Configuration Tool? They're not turned on by default in 2005.
> >
> > ChrisR wrote:
> > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > Management Studio, I try to register the remote one, and I get the message...
> > >
> > > A connection was successfully established to the server, but then an error
> > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > 10054)
> > >
> > > Any ideas?
> > > --
> > > TIA,
> > > ChrisR
> >
> >|||Start\ Programs\ there is no Configuration Tools option.
--
TIA,
ChrisR
"burt_king" wrote:
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
> > I don't have a Configurations tab on the remote box... I just realized its
> > Beta2. Could this have sometihng to do with it?
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Corey Bunch" wrote:
> >
> > > Did you enable TCP/IP connections from remote machines in SQL Surface
> > > Area Configuration Tool? They're not turned on by default in 2005.
> > >
> > > ChrisR wrote:
> > > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > > Management Studio, I try to register the remote one, and I get the message...
> > > >
> > > > A connection was successfully established to the server, but then an error
> > > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > > 10054)
> > > >
> > > > Any ideas?
> > > > --
> > > > TIA,
> > > > ChrisR
> > >
> > >|||Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
--
TIA,
ChrisR
"ChrisR" wrote:
> Start\ Programs\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "burt_king" wrote:
> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> > Configuration tool?
> >
> > "ChrisR" wrote:
> >
> > > I don't have a Configurations tab on the remote box... I just realized its
> > > Beta2. Could this have sometihng to do with it?
> > > --
> > > TIA,
> > > ChrisR
> > >
> > >
> > > "Corey Bunch" wrote:
> > >
> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
> > > > Area Configuration Tool? They're not turned on by default in 2005.
> > > >
> > > > ChrisR wrote:
> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > > > Management Studio, I try to register the remote one, and I get the message...
> > > > >
> > > > > A connection was successfully established to the server, but then an error
> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > > > 10054)
> > > > >
> > > > > Any ideas?
> > > > > --
> > > > > TIA,
> > > > > ChrisR
> > > >
> > > >|||How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
you can enable the netlibs.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
> Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "ChrisR" wrote:
>> Start\ Programs\ there is no Configuration Tools option.
>> --
>> TIA,
>> ChrisR
>>
>> "burt_king" wrote:
>> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
>> > Configuration tool?
>> >
>> > "ChrisR" wrote:
>> >
>> > > I don't have a Configurations tab on the remote box... I just realized its
>> > > Beta2. Could this have sometihng to do with it?
>> > > --
>> > > TIA,
>> > > ChrisR
>> > >
>> > >
>> > > "Corey Bunch" wrote:
>> > >
>> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
>> > > > Area Configuration Tool? They're not turned on by default in 2005.
>> > > >
>> > > > ChrisR wrote:
>> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
>> > > > > Management Studio, I try to register the remote one, and I get the message...
>> > > > >
>> > > > > A connection was successfully established to the server, but then an error
>> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
>> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
>> > > > > 10054)
>> > > > >
>> > > > > Any ideas?
>> > > > > --
>> > > > > TIA,
>> > > > > ChrisR
>> > > >
>> > > >|||And do what to the netlibs? I dont see anything like enable remote connections.
--
TIA,
ChrisR
"Tibor Karaszi" wrote:
> How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
> you can enable the netlibs.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
> > Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> >
> > --
> > TIA,
> > ChrisR
> >
> >
> > "ChrisR" wrote:
> >
> >> Start\ Programs\ there is no Configuration Tools option.
> >> --
> >> TIA,
> >> ChrisR
> >>
> >>
> >> "burt_king" wrote:
> >>
> >> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> >> > Configuration tool?
> >> >
> >> > "ChrisR" wrote:
> >> >
> >> > > I don't have a Configurations tab on the remote box... I just realized its
> >> > > Beta2. Could this have sometihng to do with it?
> >> > > --
> >> > > TIA,
> >> > > ChrisR
> >> > >
> >> > >
> >> > > "Corey Bunch" wrote:
> >> > >
> >> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
> >> > > > Area Configuration Tool? They're not turned on by default in 2005.
> >> > > >
> >> > > > ChrisR wrote:
> >> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
> >> > > > > Management Studio, I try to register the remote one, and I get the message...
> >> > > > >
> >> > > > > A connection was successfully established to the server, but then an error
> >> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
> >> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> >> > > > > 10054)
> >> > > > >
> >> > > > > Any ideas?
> >> > > > > --
> >> > > > > TIA,
> >> > > > > ChrisR
> >> > > >
> >> > > >
>|||Also, I tried to register in reverse.
1; In my local box, I went into
I logged into the remote box and tried to register my local box. I went into
SQL Server Surface Area Config/ Services and Connections/ Remote Connections/
Local and Remote Connections is checked.
When I try to register it says Unknown ProviderConnection string is invalid.
(MSSQL error: 87)
TIA,
ChrisR
"burt_king" wrote:
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
> > I don't have a Configurations tab on the remote box... I just realized its
> > Beta2. Could this have sometihng to do with it?
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Corey Bunch" wrote:
> >
> > > Did you enable TCP/IP connections from remote machines in SQL Surface
> > > Area Configuration Tool? They're not turned on by default in 2005.
> > >
> > > ChrisR wrote:
> > > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > > Management Studio, I try to register the remote one, and I get the message...
> > > >
> > > > A connection was successfully established to the server, but then an error
> > > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > > 10054)
> > > >
> > > > Any ideas?
> > > > --
> > > > TIA,
> > > > ChrisR
> > >
> > >|||Hard to know what your setup look like as you are on an older version (beta). On my machines, I use
the following folder structure:
SQL Server Configuration Manager
SQL Server 2005 Network Configuration
Protocols for [instancename]
In above folder I can right-click a netlib (TCP/IP, for instance) and enable it.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:F19474D2-3815-4B06-B549-FE357816A8C9@.microsoft.com...
> And do what to the netlibs? I dont see anything like enable remote connections.
> --
> TIA,
> ChrisR
>
> "Tibor Karaszi" wrote:
>> How about Computer Manager, under Services, you should have some SQL Server Configuration Node.
>> Here
>> you can enable the netlibs.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
>> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
>> > Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
>> >
>> > --
>> > TIA,
>> > ChrisR
>> >
>> >
>> > "ChrisR" wrote:
>> >
>> >> Start\ Programs\ there is no Configuration Tools option.
>> >> --
>> >> TIA,
>> >> ChrisR
>> >>
>> >>
>> >> "burt_king" wrote:
>> >>
>> >> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
>> >> > Configuration tool?
>> >> >
>> >> > "ChrisR" wrote:
>> >> >
>> >> > > I don't have a Configurations tab on the remote box... I just realized its
>> >> > > Beta2. Could this have sometihng to do with it?
>> >> > > --
>> >> > > TIA,
>> >> > > ChrisR
>> >> > >
>> >> > >
>> >> > > "Corey Bunch" wrote:
>> >> > >
>> >> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
>> >> > > > Area Configuration Tool? They're not turned on by default in 2005.
>> >> > > >
>> >> > > > ChrisR wrote:
>> >> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
>> >> > > > > Management Studio, I try to register the remote one, and I get the message...
>> >> > > > >
>> >> > > > > A connection was successfully established to the server, but then an error
>> >> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
>> >> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
>> >> > > > > 10054)
>> >> > > > >
>> >> > > > > Any ideas?
>> >> > > > > --
>> >> > > > > TIA,
>> >> > > > > ChrisR
>> >> > > >
>> >> > > >
>>|||Im going to reinstall with a more current version and see what happens.
--
TIA,
ChrisR
"Tibor Karaszi" wrote:
> Hard to know what your setup look like as you are on an older version (beta). On my machines, I use
> the following folder structure:
> SQL Server Configuration Manager
> SQL Server 2005 Network Configuration
> Protocols for [instancename]
> In above folder I can right-click a netlib (TCP/IP, for instance) and enable it.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:F19474D2-3815-4B06-B549-FE357816A8C9@.microsoft.com...
> > And do what to the netlibs? I dont see anything like enable remote connections.
> >
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> How about Computer Manager, under Services, you should have some SQL Server Configuration Node.
> >> Here
> >> you can enable the netlibs.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >>
> >>
> >> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> >> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
> >> > Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> >> >
> >> > --
> >> > TIA,
> >> > ChrisR
> >> >
> >> >
> >> > "ChrisR" wrote:
> >> >
> >> >> Start\ Programs\ there is no Configuration Tools option.
> >> >> --
> >> >> TIA,
> >> >> ChrisR
> >> >>
> >> >>
> >> >> "burt_king" wrote:
> >> >>
> >> >> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> >> >> > Configuration tool?
> >> >> >
> >> >> > "ChrisR" wrote:
> >> >> >
> >> >> > > I don't have a Configurations tab on the remote box... I just realized its
> >> >> > > Beta2. Could this have sometihng to do with it?
> >> >> > > --
> >> >> > > TIA,
> >> >> > > ChrisR
> >> >> > >
> >> >> > >
> >> >> > > "Corey Bunch" wrote:
> >> >> > >
> >> >> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
> >> >> > > > Area Configuration Tool? They're not turned on by default in 2005.
> >> >> > > >
> >> >> > > > ChrisR wrote:
> >> >> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
> >> >> > > > > Management Studio, I try to register the remote one, and I get the message...
> >> >> > > > >
> >> >> > > > > A connection was successfully established to the server, but then an error
> >> >> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
> >> >> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> >> >> > > > > 10054)
> >> >> > > > >
> >> >> > > > > Any ideas?
> >> >> > > > > --
> >> >> > > > > TIA,
> >> >> > > > > ChrisR
> >> >> > > >
> >> >> > > >
> >>
> >>
>
cant register sql2k5
I have a local instance of sql2k5, as well as a remote one. From my local
Management Studio, I try to register the remote one, and I get the message..
.
A connection was successfully established to the server, but then an error
occured during the login process. (provider: TCP Provider, error:0 - An
existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
10054)
Any ideas?
--
TIA,
ChrisRDid you enable TCP/IP connections from remote machines in SQL Surface
Area Configuration Tool? They're not turned on by default in 2005.
ChrisR wrote:
> I have a local instance of sql2k5, as well as a remote one. From my local
> Management Studio, I try to register the remote one, and I get the message
..
> A connection was successfully established to the server, but then an error
> occured during the login process. (provider: TCP Provider, error:0 - An
> existing connection was forcibly closed by the remote host. ) (MSSQL, Erro
r:
> 10054)
> Any ideas?
> --
> TIA,
> ChrisR|||I don't have a Configurations tab on the remote box... I just realized its
Beta2. Could this have sometihng to do with it?
--
TIA,
ChrisR
"Corey Bunch" wrote:
> Did you enable TCP/IP connections from remote machines in SQL Surface
> Area Configuration Tool? They're not turned on by default in 2005.
> ChrisR wrote:
>|||Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
Configuration tool?
"ChrisR" wrote:
[vbcol=seagreen]
> I don't have a Configurations tab on the remote box... I just realized its
> Beta2. Could this have sometihng to do with it?
> --
> TIA,
> ChrisR
>
> "Corey Bunch" wrote:
>|||Start\ Programs\ there is no Configuration Tools option.
--
TIA,
ChrisR
"burt_king" wrote:
[vbcol=seagreen]
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
>|||Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
TIA,
ChrisR
"ChrisR" wrote:
[vbcol=seagreen]
> Start\ Programs\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "burt_king" wrote:
>|||How about Computer Manager, under Services, you should have some SQL Server
Configuration Node. Here
you can enable the netlibs.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...[vbcol=seagreen]
> Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "ChrisR" wrote:
>|||And do what to the netlibs? I dont see anything like enable remote connectio
ns.
TIA,
ChrisR
"Tibor Karaszi" wrote:
> How about Computer Manager, under Services, you should have some SQL Serve
r Configuration Node. Here
> you can enable the netlibs.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
>|||Also, I tried to register in reverse.
1; In my local box, I went into
I logged into the remote box and tried to register my local box. I went into
SQL Server Surface Area Config/ Services and Connections/ Remote Connections
/
Local and Remote Connections is checked.
When I try to register it says Unknown ProviderConnection string is invalid.
(MSSQL error: 87)
TIA,
ChrisR
"burt_king" wrote:
[vbcol=seagreen]
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
>|||Hard to know what your setup look like as you are on an older version (beta)
. On my machines, I use
the following folder structure:
SQL Server Configuration Manager
SQL Server 2005 Network Configuration
Protocols for [instancename]
In above folder I can right-click a netlib (TCP/IP, for instance) and enable
it.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:F19474D2-3815-4B06-B549-FE357816A8C9@.microsoft.com...[vbcol=seagreen]
> And do what to the netlibs? I dont see anything like enable remote connect
ions.
> --
> TIA,
> ChrisR
>
> "Tibor Karaszi" wrote:
>
Management Studio, I try to register the remote one, and I get the message..
.
A connection was successfully established to the server, but then an error
occured during the login process. (provider: TCP Provider, error:0 - An
existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
10054)
Any ideas?
--
TIA,
ChrisRDid you enable TCP/IP connections from remote machines in SQL Surface
Area Configuration Tool? They're not turned on by default in 2005.
ChrisR wrote:
> I have a local instance of sql2k5, as well as a remote one. From my local
> Management Studio, I try to register the remote one, and I get the message
..
> A connection was successfully established to the server, but then an error
> occured during the login process. (provider: TCP Provider, error:0 - An
> existing connection was forcibly closed by the remote host. ) (MSSQL, Erro
r:
> 10054)
> Any ideas?
> --
> TIA,
> ChrisR|||I don't have a Configurations tab on the remote box... I just realized its
Beta2. Could this have sometihng to do with it?
--
TIA,
ChrisR
"Corey Bunch" wrote:
> Did you enable TCP/IP connections from remote machines in SQL Surface
> Area Configuration Tool? They're not turned on by default in 2005.
> ChrisR wrote:
>|||Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
Configuration tool?
"ChrisR" wrote:
[vbcol=seagreen]
> I don't have a Configurations tab on the remote box... I just realized its
> Beta2. Could this have sometihng to do with it?
> --
> TIA,
> ChrisR
>
> "Corey Bunch" wrote:
>|||Start\ Programs\ there is no Configuration Tools option.
--
TIA,
ChrisR
"burt_king" wrote:
[vbcol=seagreen]
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
>|||Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
TIA,
ChrisR
"ChrisR" wrote:
[vbcol=seagreen]
> Start\ Programs\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "burt_king" wrote:
>|||How about Computer Manager, under Services, you should have some SQL Server
Configuration Node. Here
you can enable the netlibs.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...[vbcol=seagreen]
> Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "ChrisR" wrote:
>|||And do what to the netlibs? I dont see anything like enable remote connectio
ns.
TIA,
ChrisR
"Tibor Karaszi" wrote:
> How about Computer Manager, under Services, you should have some SQL Serve
r Configuration Node. Here
> you can enable the netlibs.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
>|||Also, I tried to register in reverse.
1; In my local box, I went into
I logged into the remote box and tried to register my local box. I went into
SQL Server Surface Area Config/ Services and Connections/ Remote Connections
/
Local and Remote Connections is checked.
When I try to register it says Unknown ProviderConnection string is invalid.
(MSSQL error: 87)
TIA,
ChrisR
"burt_king" wrote:
[vbcol=seagreen]
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
>|||Hard to know what your setup look like as you are on an older version (beta)
. On my machines, I use
the following folder structure:
SQL Server Configuration Manager
SQL Server 2005 Network Configuration
Protocols for [instancename]
In above folder I can right-click a netlib (TCP/IP, for instance) and enable
it.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:F19474D2-3815-4B06-B549-FE357816A8C9@.microsoft.com...[vbcol=seagreen]
> And do what to the netlibs? I dont see anything like enable remote connect
ions.
> --
> TIA,
> ChrisR
>
> "Tibor Karaszi" wrote:
>
Can't register remote SQL
When I try to register a remote SQL Server from a local desktop XP Pro PC, I
get the error:
"Client unable to establish connection. Named Pipes Provider: the network
path was not found. Timeout expired."
I checked and this is not a firewall problem because SQL ports are open. We
normally don't have a problem registering SQL servers like this; just this
one server. Any clues?
Thanks!!!
Is that particular server using Named Pipes, or is it set for TCP/IP? Check
the Server Network Utility to ensure Named Pipes is turned on on the server,
since your client appears to be using Named Pipes instead of TCP/IP.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:e4otsANKFHA.904@.tk2msftngp13.phx.gbl...
> When I try to register a remote SQL Server from a local desktop XP Pro PC,
> I
> get the error:
> "Client unable to establish connection. Named Pipes Provider: the network
> path was not found. Timeout expired."
> I checked and this is not a firewall problem because SQL ports are open.
> We
> normally don't have a problem registering SQL servers like this; just this
> one server. Any clues?
> Thanks!!!
>
|||Hello,
Yes, I thought of that before, but I just checked again and the Server
Network Util says enabled protocols:
Named Pipes
TCP/IP
We are trying to register the SQL server remotely using the server's IP addr
which has always worked in the past. Anyone know what is wrong?
Thanks!!!
"Michael C#" <xyz@.yomomma.com> wrote in message
news:#HM9QONKFHA.3064@.TK2MSFTNGP12.phx.gbl...
> Is that particular server using Named Pipes, or is it set for TCP/IP?
Check
> the Server Network Utility to ensure Named Pipes is turned on on the
server,[vbcol=seagreen]
> since your client appears to be using Named Pipes instead of TCP/IP.
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:e4otsANKFHA.904@.tk2msftngp13.phx.gbl...
PC,[vbcol=seagreen]
network[vbcol=seagreen]
this
>
|||Interesting. You're using the TCP/IP address, but it's trying to connect
via Named Pipes? Have you checked the Client Network Utility on your client
box to see if TCP/IP is enabled locally? Also have you established
connectivity to the remote server? i.e., can you Ping the remote box? It
sounds like you're trying to connect via TCP/IP, but it's falling back to
Named Pipes. I'd check the network settings on the server and make sure
it's reachable from the local box. There's a utility called SQLPing at
http://sqlsecurity.com/DesktopDefault.aspx (w/ source code) that can help
determine if you can see the other server from the local box.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:OYoG%236NKFHA.2812@.TK2MSFTNGP15.phx.gbl...
> Hello,
> Yes, I thought of that before, but I just checked again and the Server
> Network Util says enabled protocols:
> Named Pipes
> TCP/IP
> We are trying to register the SQL server remotely using the server's IP
> addr
> which has always worked in the past. Anyone know what is wrong?
> Thanks!!!
>
> "Michael C#" <xyz@.yomomma.com> wrote in message
> news:#HM9QONKFHA.3064@.TK2MSFTNGP12.phx.gbl...
> Check
> server,
> PC,
> network
> this
>
get the error:
"Client unable to establish connection. Named Pipes Provider: the network
path was not found. Timeout expired."
I checked and this is not a firewall problem because SQL ports are open. We
normally don't have a problem registering SQL servers like this; just this
one server. Any clues?
Thanks!!!
Is that particular server using Named Pipes, or is it set for TCP/IP? Check
the Server Network Utility to ensure Named Pipes is turned on on the server,
since your client appears to be using Named Pipes instead of TCP/IP.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:e4otsANKFHA.904@.tk2msftngp13.phx.gbl...
> When I try to register a remote SQL Server from a local desktop XP Pro PC,
> I
> get the error:
> "Client unable to establish connection. Named Pipes Provider: the network
> path was not found. Timeout expired."
> I checked and this is not a firewall problem because SQL ports are open.
> We
> normally don't have a problem registering SQL servers like this; just this
> one server. Any clues?
> Thanks!!!
>
|||Hello,
Yes, I thought of that before, but I just checked again and the Server
Network Util says enabled protocols:
Named Pipes
TCP/IP
We are trying to register the SQL server remotely using the server's IP addr
which has always worked in the past. Anyone know what is wrong?
Thanks!!!
"Michael C#" <xyz@.yomomma.com> wrote in message
news:#HM9QONKFHA.3064@.TK2MSFTNGP12.phx.gbl...
> Is that particular server using Named Pipes, or is it set for TCP/IP?
Check
> the Server Network Utility to ensure Named Pipes is turned on on the
server,[vbcol=seagreen]
> since your client appears to be using Named Pipes instead of TCP/IP.
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:e4otsANKFHA.904@.tk2msftngp13.phx.gbl...
PC,[vbcol=seagreen]
network[vbcol=seagreen]
this
>
|||Interesting. You're using the TCP/IP address, but it's trying to connect
via Named Pipes? Have you checked the Client Network Utility on your client
box to see if TCP/IP is enabled locally? Also have you established
connectivity to the remote server? i.e., can you Ping the remote box? It
sounds like you're trying to connect via TCP/IP, but it's falling back to
Named Pipes. I'd check the network settings on the server and make sure
it's reachable from the local box. There's a utility called SQLPing at
http://sqlsecurity.com/DesktopDefault.aspx (w/ source code) that can help
determine if you can see the other server from the local box.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:OYoG%236NKFHA.2812@.TK2MSFTNGP15.phx.gbl...
> Hello,
> Yes, I thought of that before, but I just checked again and the Server
> Network Util says enabled protocols:
> Named Pipes
> TCP/IP
> We are trying to register the SQL server remotely using the server's IP
> addr
> which has always worked in the past. Anyone know what is wrong?
> Thanks!!!
>
> "Michael C#" <xyz@.yomomma.com> wrote in message
> news:#HM9QONKFHA.3064@.TK2MSFTNGP12.phx.gbl...
> Check
> server,
> PC,
> network
> this
>
Can't register remote SQL
When I try to register a remote SQL Server from a local desktop XP Pro PC, I
get the error:
"Client unable to establish connection. Named Pipes Provider: the network
path was not found. Timeout expired."
I checked and this is not a firewall problem because SQL ports are open. We
normally don't have a problem registering SQL servers like this; just this
one server. Any clues?
Thanks!!!Is that particular server using Named Pipes, or is it set for TCP/IP? Check
the Server Network Utility to ensure Named Pipes is turned on on the server,
since your client appears to be using Named Pipes instead of TCP/IP.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:e4otsANKFHA.904@.tk2msftngp13.phx.gbl...
> When I try to register a remote SQL Server from a local desktop XP Pro PC,
> I
> get the error:
> "Client unable to establish connection. Named Pipes Provider: the network
> path was not found. Timeout expired."
> I checked and this is not a firewall problem because SQL ports are open.
> We
> normally don't have a problem registering SQL servers like this; just this
> one server. Any clues?
> Thanks!!!
>|||Hello,
Yes, I thought of that before, but I just checked again and the Server
Network Util says enabled protocols:
Named Pipes
TCP/IP
We are trying to register the SQL server remotely using the server's IP addr
which has always worked in the past. Anyone know what is wrong?
Thanks!!!
"Michael C#" <xyz@.yomomma.com> wrote in message
news:#HM9QONKFHA.3064@.TK2MSFTNGP12.phx.gbl...
> Is that particular server using Named Pipes, or is it set for TCP/IP?
Check
> the Server Network Utility to ensure Named Pipes is turned on on the
server,
> since your client appears to be using Named Pipes instead of TCP/IP.
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:e4otsANKFHA.904@.tk2msftngp13.phx.gbl...
> > When I try to register a remote SQL Server from a local desktop XP Pro
PC,
> > I
> > get the error:
> >
> > "Client unable to establish connection. Named Pipes Provider: the
network
> > path was not found. Timeout expired."
> >
> > I checked and this is not a firewall problem because SQL ports are open.
> > We
> > normally don't have a problem registering SQL servers like this; just
this
> > one server. Any clues?
> >
> > Thanks!!!
> >
> >
>|||Interesting. You're using the TCP/IP address, but it's trying to connect
via Named Pipes? Have you checked the Client Network Utility on your client
box to see if TCP/IP is enabled locally? Also have you established
connectivity to the remote server? i.e., can you Ping the remote box? It
sounds like you're trying to connect via TCP/IP, but it's falling back to
Named Pipes. I'd check the network settings on the server and make sure
it's reachable from the local box. There's a utility called SQLPing at
http://sqlsecurity.com/DesktopDefault.aspx (w/ source code) that can help
determine if you can see the other server from the local box.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:OYoG%236NKFHA.2812@.TK2MSFTNGP15.phx.gbl...
> Hello,
> Yes, I thought of that before, but I just checked again and the Server
> Network Util says enabled protocols:
> Named Pipes
> TCP/IP
> We are trying to register the SQL server remotely using the server's IP
> addr
> which has always worked in the past. Anyone know what is wrong?
> Thanks!!!
>
> "Michael C#" <xyz@.yomomma.com> wrote in message
> news:#HM9QONKFHA.3064@.TK2MSFTNGP12.phx.gbl...
>> Is that particular server using Named Pipes, or is it set for TCP/IP?
> Check
>> the Server Network Utility to ensure Named Pipes is turned on on the
> server,
>> since your client appears to be using Named Pipes instead of TCP/IP.
>> "Dean J Garrett" <info@.amuletc.com> wrote in message
>> news:e4otsANKFHA.904@.tk2msftngp13.phx.gbl...
>> > When I try to register a remote SQL Server from a local desktop XP Pro
> PC,
>> > I
>> > get the error:
>> >
>> > "Client unable to establish connection. Named Pipes Provider: the
> network
>> > path was not found. Timeout expired."
>> >
>> > I checked and this is not a firewall problem because SQL ports are
>> > open.
>> > We
>> > normally don't have a problem registering SQL servers like this; just
> this
>> > one server. Any clues?
>> >
>> > Thanks!!!
>> >
>> >
>>
>
get the error:
"Client unable to establish connection. Named Pipes Provider: the network
path was not found. Timeout expired."
I checked and this is not a firewall problem because SQL ports are open. We
normally don't have a problem registering SQL servers like this; just this
one server. Any clues?
Thanks!!!Is that particular server using Named Pipes, or is it set for TCP/IP? Check
the Server Network Utility to ensure Named Pipes is turned on on the server,
since your client appears to be using Named Pipes instead of TCP/IP.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:e4otsANKFHA.904@.tk2msftngp13.phx.gbl...
> When I try to register a remote SQL Server from a local desktop XP Pro PC,
> I
> get the error:
> "Client unable to establish connection. Named Pipes Provider: the network
> path was not found. Timeout expired."
> I checked and this is not a firewall problem because SQL ports are open.
> We
> normally don't have a problem registering SQL servers like this; just this
> one server. Any clues?
> Thanks!!!
>|||Hello,
Yes, I thought of that before, but I just checked again and the Server
Network Util says enabled protocols:
Named Pipes
TCP/IP
We are trying to register the SQL server remotely using the server's IP addr
which has always worked in the past. Anyone know what is wrong?
Thanks!!!
"Michael C#" <xyz@.yomomma.com> wrote in message
news:#HM9QONKFHA.3064@.TK2MSFTNGP12.phx.gbl...
> Is that particular server using Named Pipes, or is it set for TCP/IP?
Check
> the Server Network Utility to ensure Named Pipes is turned on on the
server,
> since your client appears to be using Named Pipes instead of TCP/IP.
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:e4otsANKFHA.904@.tk2msftngp13.phx.gbl...
> > When I try to register a remote SQL Server from a local desktop XP Pro
PC,
> > I
> > get the error:
> >
> > "Client unable to establish connection. Named Pipes Provider: the
network
> > path was not found. Timeout expired."
> >
> > I checked and this is not a firewall problem because SQL ports are open.
> > We
> > normally don't have a problem registering SQL servers like this; just
this
> > one server. Any clues?
> >
> > Thanks!!!
> >
> >
>|||Interesting. You're using the TCP/IP address, but it's trying to connect
via Named Pipes? Have you checked the Client Network Utility on your client
box to see if TCP/IP is enabled locally? Also have you established
connectivity to the remote server? i.e., can you Ping the remote box? It
sounds like you're trying to connect via TCP/IP, but it's falling back to
Named Pipes. I'd check the network settings on the server and make sure
it's reachable from the local box. There's a utility called SQLPing at
http://sqlsecurity.com/DesktopDefault.aspx (w/ source code) that can help
determine if you can see the other server from the local box.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:OYoG%236NKFHA.2812@.TK2MSFTNGP15.phx.gbl...
> Hello,
> Yes, I thought of that before, but I just checked again and the Server
> Network Util says enabled protocols:
> Named Pipes
> TCP/IP
> We are trying to register the SQL server remotely using the server's IP
> addr
> which has always worked in the past. Anyone know what is wrong?
> Thanks!!!
>
> "Michael C#" <xyz@.yomomma.com> wrote in message
> news:#HM9QONKFHA.3064@.TK2MSFTNGP12.phx.gbl...
>> Is that particular server using Named Pipes, or is it set for TCP/IP?
> Check
>> the Server Network Utility to ensure Named Pipes is turned on on the
> server,
>> since your client appears to be using Named Pipes instead of TCP/IP.
>> "Dean J Garrett" <info@.amuletc.com> wrote in message
>> news:e4otsANKFHA.904@.tk2msftngp13.phx.gbl...
>> > When I try to register a remote SQL Server from a local desktop XP Pro
> PC,
>> > I
>> > get the error:
>> >
>> > "Client unable to establish connection. Named Pipes Provider: the
> network
>> > path was not found. Timeout expired."
>> >
>> > I checked and this is not a firewall problem because SQL ports are
>> > open.
>> > We
>> > normally don't have a problem registering SQL servers like this; just
> this
>> > one server. Any clues?
>> >
>> > Thanks!!!
>> >
>> >
>>
>
Can't register remote SQL
When I try to register a remote SQL Server from a local desktop XP Pro PC, I
get the error:
"Client unable to establish connection. Named Pipes Provider: the network
path was not found. Timeout expired."
I checked and this is not a firewall problem because SQL ports are open. We
normally don't have a problem registering SQL servers like this; just this
one server. Any clues?
Thanks!!!Is that particular server using Named Pipes, or is it set for TCP/IP? Check
the Server Network Utility to ensure Named Pipes is turned on on the server,
since your client appears to be using Named Pipes instead of TCP/IP.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:e4otsANKFHA.904@.tk2msftngp13.phx.gbl...
> When I try to register a remote SQL Server from a local desktop XP Pro PC,
> I
> get the error:
> "Client unable to establish connection. Named Pipes Provider: the network
> path was not found. Timeout expired."
> I checked and this is not a firewall problem because SQL ports are open.
> We
> normally don't have a problem registering SQL servers like this; just this
> one server. Any clues?
> Thanks!!!
>|||Hello,
Yes, I thought of that before, but I just checked again and the Server
Network Util says enabled protocols:
Named Pipes
TCP/IP
We are trying to register the SQL server remotely using the server's IP addr
which has always worked in the past. Anyone know what is wrong?
Thanks!!!
"Michael C#" <xyz@.yomomma.com> wrote in message
news:#HM9QONKFHA.3064@.TK2MSFTNGP12.phx.gbl...
> Is that particular server using Named Pipes, or is it set for TCP/IP?
Check
> the Server Network Utility to ensure Named Pipes is turned on on the
server,
> since your client appears to be using Named Pipes instead of TCP/IP.
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:e4otsANKFHA.904@.tk2msftngp13.phx.gbl...
PC,[vbcol=seagreen]
network[vbcol=seagreen]
this[vbcol=seagreen]
>|||Interesting. You're using the TCP/IP address, but it's trying to connect
via Named Pipes? Have you checked the Client Network Utility on your client
box to see if TCP/IP is enabled locally? Also have you established
connectivity to the remote server? i.e., can you Ping the remote box? It
sounds like you're trying to connect via TCP/IP, but it's falling back to
Named Pipes. I'd check the network settings on the server and make sure
it's reachable from the local box. There's a utility called SQLPing at
http://sqlsecurity.com/DesktopDefault.aspx (w/ source code) that can help
determine if you can see the other server from the local box.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:OYoG%236NKFHA.2812@.TK2MSFTNGP15.phx.gbl...
> Hello,
> Yes, I thought of that before, but I just checked again and the Server
> Network Util says enabled protocols:
> Named Pipes
> TCP/IP
> We are trying to register the SQL server remotely using the server's IP
> addr
> which has always worked in the past. Anyone know what is wrong?
> Thanks!!!
>
> "Michael C#" <xyz@.yomomma.com> wrote in message
> news:#HM9QONKFHA.3064@.TK2MSFTNGP12.phx.gbl...
> Check
> server,
> PC,
> network
> this
>
get the error:
"Client unable to establish connection. Named Pipes Provider: the network
path was not found. Timeout expired."
I checked and this is not a firewall problem because SQL ports are open. We
normally don't have a problem registering SQL servers like this; just this
one server. Any clues?
Thanks!!!Is that particular server using Named Pipes, or is it set for TCP/IP? Check
the Server Network Utility to ensure Named Pipes is turned on on the server,
since your client appears to be using Named Pipes instead of TCP/IP.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:e4otsANKFHA.904@.tk2msftngp13.phx.gbl...
> When I try to register a remote SQL Server from a local desktop XP Pro PC,
> I
> get the error:
> "Client unable to establish connection. Named Pipes Provider: the network
> path was not found. Timeout expired."
> I checked and this is not a firewall problem because SQL ports are open.
> We
> normally don't have a problem registering SQL servers like this; just this
> one server. Any clues?
> Thanks!!!
>|||Hello,
Yes, I thought of that before, but I just checked again and the Server
Network Util says enabled protocols:
Named Pipes
TCP/IP
We are trying to register the SQL server remotely using the server's IP addr
which has always worked in the past. Anyone know what is wrong?
Thanks!!!
"Michael C#" <xyz@.yomomma.com> wrote in message
news:#HM9QONKFHA.3064@.TK2MSFTNGP12.phx.gbl...
> Is that particular server using Named Pipes, or is it set for TCP/IP?
Check
> the Server Network Utility to ensure Named Pipes is turned on on the
server,
> since your client appears to be using Named Pipes instead of TCP/IP.
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:e4otsANKFHA.904@.tk2msftngp13.phx.gbl...
PC,[vbcol=seagreen]
network[vbcol=seagreen]
this[vbcol=seagreen]
>|||Interesting. You're using the TCP/IP address, but it's trying to connect
via Named Pipes? Have you checked the Client Network Utility on your client
box to see if TCP/IP is enabled locally? Also have you established
connectivity to the remote server? i.e., can you Ping the remote box? It
sounds like you're trying to connect via TCP/IP, but it's falling back to
Named Pipes. I'd check the network settings on the server and make sure
it's reachable from the local box. There's a utility called SQLPing at
http://sqlsecurity.com/DesktopDefault.aspx (w/ source code) that can help
determine if you can see the other server from the local box.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:OYoG%236NKFHA.2812@.TK2MSFTNGP15.phx.gbl...
> Hello,
> Yes, I thought of that before, but I just checked again and the Server
> Network Util says enabled protocols:
> Named Pipes
> TCP/IP
> We are trying to register the SQL server remotely using the server's IP
> addr
> which has always worked in the past. Anyone know what is wrong?
> Thanks!!!
>
> "Michael C#" <xyz@.yomomma.com> wrote in message
> news:#HM9QONKFHA.3064@.TK2MSFTNGP12.phx.gbl...
> Check
> server,
> PC,
> network
> this
>
Subscribe to:
Posts (Atom)