I have a problem getting connected to an instance of MSDE remotely. I can
register the instance in Enterprise Manager, and work with it locally on the
machine it is installed on but cannot get connected remotely. I get the
famous SQL Server does not exist or access is denied.
It is a named instance.
The security mode is set to SQL.
Network Protocols are enabled.
netstat tells me that it is listening on the correct port.
I'm logging in remotely as sa with the correct password.
Any help here would be appreciated.
Also for some reason the name of the server doesn't show up in the list in
Enterprise manager on the remote machine when trying to register the server.
I typed in the name of the server, the sa login and password, but still the
same error. Server doesn't exist or access is denied.
"jdehne" wrote:
> I have a problem getting connected to an instance of MSDE remotely. I can
> register the instance in Enterprise Manager, and work with it locally on the
> machine it is installed on but cannot get connected remotely. I get the
> famous SQL Server does not exist or access is denied.
> It is a named instance.
> The security mode is set to SQL.
> Network Protocols are enabled.
> netstat tells me that it is listening on the correct port.
> I'm logging in remotely as sa with the correct password.
> Any help here would be appreciated.
|||I have also tried adding the alias with the same port as MSDE is configured.
"jdehne" wrote:
[vbcol=seagreen]
> Also for some reason the name of the server doesn't show up in the list in
> Enterprise manager on the remote machine when trying to register the server.
> I typed in the name of the server, the sa login and password, but still the
> same error. Server doesn't exist or access is denied.
> "jdehne" wrote:
|||i have also noticed that when running osql -L on the remote machine the MSDE
instance does not show up.
"jdehne" wrote:
[vbcol=seagreen]
> I have also tried adding the alias with the same port as MSDE is configured.
> "jdehne" wrote:
|||Am Mon, 17 Oct 2005 15:06:03 -0700 schrieb jdehne:
[vbcol=seagreen]
> i have also noticed that when running osql -L on the remote machine the MSDE
> instance does not show up.
> "jdehne" wrote:
I can only guess:
a) TCP is enabled on the server but not on the client
b) connect doesn't work with servername but with server-IP
c) MDAC's are different versions
bye,
Helmut
|||hi,
jdehne wrote:
> i have also noticed that when running osql -L on the remote machine
> the MSDE instance does not show up.
try having a look at http://support.microsoft.com/kb/841251/en-us ,
http://support.microsoft.com/kb/841249/en-us
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I managed to figure it out. SP2 Secruity center was blocking the port and I
had add the sqlserver.exe to the list of programs that can get through the
firewall.
"Andrea Montanari" wrote:
> hi,
> jdehne wrote:
> try having a look at http://support.microsoft.com/kb/841251/en-us ,
> http://support.microsoft.com/kb/841249/en-us
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
Showing posts with label locally. Show all posts
Showing posts with label locally. Show all posts
Tuesday, March 27, 2012
Wednesday, March 7, 2012
Can't create databases in Management Studio
I seem to be having a number of problems using managment studio (MS) against my locally installed SQL 2005 Standard Edition. E.g. when I create a default database using MS it says...
TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The server could not load DCOM. (Microsoft SQL Server, Error: 7404)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=7404&LinkId=20476
However, the hyperlinks are less than helpful. I also get problems doing various maintance work from MS. I don't think its a database engine problem 'cause I can do all the work via TSQL DDL but the interface is so much easier to use (or should be). BTW it's running on XP Pro (firewall problem?).
I've also found an Event Log entry but don't know what it's asking me to enable...
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17102
Date: 06/02/2006
Time: 20:12:06
User: N/A
Computer: TITAN
Description:
Failed to initialize Distributed COM (CoInitializeEx returned 80010119). Heterogeneous queries and remote procedure calls are disabled. Check the DCOM configuration using Component Services in Control Panel.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
|||Finally sorted it out. It was the NVidia client to the motherboards Hardware Firewall that was causing the problem. I had to remove that to get IE7 working and now SQL Server is creating databases!
|||I am getting all those exact same error messages when creating a database. My IE 7 is working just fine however. Can you tell me what you had to do to disable an nVidia motherboard hardware firewall thing? I've never heard of that, it sounds like it is worth a try at this point.
npack@.hotmail.com
|||Sure, you need to uninstall the nVidia firewall software.Can't create databases in Management Studio
I seem to be having a number of problems using managment studio (MS) against my locally installed SQL 2005 Standard Edition. E.g. when I create a default database using MS it says...
TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The server could not load DCOM. (Microsoft SQL Server, Error: 7404)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=7404&LinkId=20476
However, the hyperlinks are less than helpful. I also get problems doing various maintance work from MS. I don't think its a database engine problem 'cause I can do all the work via TSQL DDL but the interface is so much easier to use (or should be). BTW it's running on XP Pro (firewall problem?).
I've also found an Event Log entry but don't know what it's asking me to enable...
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17102
Date: 06/02/2006
Time: 20:12:06
User: N/A
Computer: TITAN
Description:
Failed to initialize Distributed COM (CoInitializeEx returned 80010119). Heterogeneous queries and remote procedure calls are disabled. Check the DCOM configuration using Component Services in Control Panel.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
|||Finally sorted it out. It was the NVidia client to the motherboards Hardware Firewall that was causing the problem. I had to remove that to get IE7 working and now SQL Server is creating databases!
|||I am getting all those exact same error messages when creating a database. My IE 7 is working just fine however. Can you tell me what you had to do to disable an nVidia motherboard hardware firewall thing? I've never heard of that, it sounds like it is worth a try at this point.
npack@.hotmail.com
|||Sure, you need to uninstall the nVidia firewall software.Saturday, February 25, 2012
Can't connection to SQL 2000 on Windows 2003 from web application running on windows x
I'm developing a web application that is running locally on my Windows XP PC
. It connects to remote database server which sits on a Windows 2003 server.
When i try to open the connection, i recieve an error, "SQL Server does not
exist or access denied". I
know for fact this connection string works, because I can use the same conne
ction string in a console application, and retrieve data. So far I have esta
blished the following:
-- I can connect to the DB via all client applications (query analyzer, .net
console appliation etc.), except from .net web application.
-- Other developers running windows 2003 and II6 can connect to DB using the
same configuration.
-- Developers, like myself, running on XP and IIS 5.1 can NOT connect.
-- from the .net web application I can connect to SQL servers that reside on
Windows 2000 server.
thanksThanks for posting what you've tried:
This helps enormously. <g>
-- I can connect to the DB via all client applications (query analyzer,
.net console appliation etc.), except from .net web application.
-- Other developers running windows 2003 and II6 can connect to DB using
the same configuration.
-- Developers, like myself, running on XP and IIS 5.1 can NOT connect.
-- from the .net web application I can connect to SQL servers that reside
on Windows 2000 serv
So, what's missing here is what security context or that your web
application is using and what security mode
IIS is in.
Are you running the IIS site in Annony, Basic or Windows Auth ?
Are you attempting to connect to SQL from IIS using an account with
username & password or
with a Trusted Connection?
Does the .NET app attempt to Impersonate?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Kevin,
thank you for the reply. The settings on the IIS and the web application are
fairly generic, I believe I'm using all the default values for configuratio
n.
>Are you running the IIS site in Annony, Basic or Windows Auth ?
Annonymous access is enable on the IIS.
>Are you attempting to connect to SQL from IIS using an account with
username & password or with a Trusted Connection?
I'm using an SQL account with username and password to connect to the DB
>Does the .NET app attempt to Impersonate?
there is no impersonation involved.
-- Kevin McDonnell [MSFT] wrote: --
Thanks for posting what you've tried:
This helps enormously. <g>
-- I can connect to the DB via all client applications (query analyzer,
.net console appliation etc.), except from .net web application.
-- Other developers running windows 2003 and II6 can connect to DB using
the same configuration.
-- Developers, like myself, running on XP and IIS 5.1 can NOT connect.
-- from the .net web application I can connect to SQL servers that reside
on Windows 2000 serv
So, what's missing here is what security context or that your web
application is using and what security mode
IIS is in.
Are you running the IIS site in Annony, Basic or Windows Auth ?
Are you attempting to connect to SQL from IIS using an account with
username & password or
with a Trusted Connection?
Does the .NET app attempt to Impersonate?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||it turns out, to resolve the issue, we just needed to install sp3 a couple o
f times on the SQL server.|||Hi,
I'm having the same problem. And these are mine settings:
Q: Are you running the IIS site in Annony, Basic or Windows Auth ?
A: I'm using FORMS-authentification (web.config)
Q: Are you attempting to connect to SQL from IIS using an account with usern
ame & password or with a Trusted Connection?
A: I want to connect throug username and password
Q: Does the .NET app attempt to Impersonate?
A: As far as i know i don't.
I hope u can explain me the problem.
Thanx Bram
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.
. It connects to remote database server which sits on a Windows 2003 server.
When i try to open the connection, i recieve an error, "SQL Server does not
exist or access denied". I
know for fact this connection string works, because I can use the same conne
ction string in a console application, and retrieve data. So far I have esta
blished the following:
-- I can connect to the DB via all client applications (query analyzer, .net
console appliation etc.), except from .net web application.
-- Other developers running windows 2003 and II6 can connect to DB using the
same configuration.
-- Developers, like myself, running on XP and IIS 5.1 can NOT connect.
-- from the .net web application I can connect to SQL servers that reside on
Windows 2000 server.
thanksThanks for posting what you've tried:
This helps enormously. <g>
-- I can connect to the DB via all client applications (query analyzer,
.net console appliation etc.), except from .net web application.
-- Other developers running windows 2003 and II6 can connect to DB using
the same configuration.
-- Developers, like myself, running on XP and IIS 5.1 can NOT connect.
-- from the .net web application I can connect to SQL servers that reside
on Windows 2000 serv
So, what's missing here is what security context or that your web
application is using and what security mode
IIS is in.
Are you running the IIS site in Annony, Basic or Windows Auth ?
Are you attempting to connect to SQL from IIS using an account with
username & password or
with a Trusted Connection?
Does the .NET app attempt to Impersonate?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Kevin,
thank you for the reply. The settings on the IIS and the web application are
fairly generic, I believe I'm using all the default values for configuratio
n.
>Are you running the IIS site in Annony, Basic or Windows Auth ?
Annonymous access is enable on the IIS.
>Are you attempting to connect to SQL from IIS using an account with
username & password or with a Trusted Connection?
I'm using an SQL account with username and password to connect to the DB
>Does the .NET app attempt to Impersonate?
there is no impersonation involved.
-- Kevin McDonnell [MSFT] wrote: --
Thanks for posting what you've tried:
This helps enormously. <g>
-- I can connect to the DB via all client applications (query analyzer,
.net console appliation etc.), except from .net web application.
-- Other developers running windows 2003 and II6 can connect to DB using
the same configuration.
-- Developers, like myself, running on XP and IIS 5.1 can NOT connect.
-- from the .net web application I can connect to SQL servers that reside
on Windows 2000 serv
So, what's missing here is what security context or that your web
application is using and what security mode
IIS is in.
Are you running the IIS site in Annony, Basic or Windows Auth ?
Are you attempting to connect to SQL from IIS using an account with
username & password or
with a Trusted Connection?
Does the .NET app attempt to Impersonate?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||it turns out, to resolve the issue, we just needed to install sp3 a couple o
f times on the SQL server.|||Hi,
I'm having the same problem. And these are mine settings:
Q: Are you running the IIS site in Annony, Basic or Windows Auth ?
A: I'm using FORMS-authentification (web.config)
Q: Are you attempting to connect to SQL from IIS using an account with usern
ame & password or with a Trusted Connection?
A: I want to connect throug username and password
Q: Does the .NET app attempt to Impersonate?
A: As far as i know i don't.
I hope u can explain me the problem.
Thanx Bram
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.
Friday, February 24, 2012
Can't connect via HTTP remotely...
Hello-
I've just set up HTTP Access to SSAS and can connect locally, but when trying to connect remotely, as the same domain user, I receive the message:
The connection either timed out or was lost
Unable to connect to the remote server
No connection could be made because the target machine actively refused it
I can connect remotely if I connect using just the servername (rather than http://...)
Anyone else runinto this one?
Hi Tristan,
For troubleshooting connectivity problems, one great resource is Edward's blog at: http://www.sqljunkies.com/WebLog/edwardm/.
If you still have connectivity issues after following the guidelines described in this blog, please let us know and give more details.
Hope this helps,
Artur
Can't connect to SS2005
Hello,
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
Thanks in advance,
sck10
Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>
|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
[vbcol=seagreen]
> --
Once[vbcol=seagreen]
> I
|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there[vbcol=seagreen]
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>browser"
Add/Remove
>Once
>
>
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
Thanks in advance,
sck10
Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>
|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
[vbcol=seagreen]
> --
Once[vbcol=seagreen]
> I
|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there[vbcol=seagreen]
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>browser"
Add/Remove
>Once
>
>
Can't connect to SS2005
Hello,
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
--
Thanks in advance,
sck10Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
--
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
--
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> --
> >From: "sck10" <sck10@.online.nospam>
> >Hello,
> >
> >I had SS2K running on my local machine (everything worked). Then I
> >installed SS2005 and was able to connect the server running locally.
Once
> I
> >uninstalled SQL Server 2000, I was unable to connect. Even if I try to
> >create a new registration, I get the error that I can't connect to the
> >server. Any help with this would be greatly appreciated.
> >
> >--
> >Thanks in advance,
> >
> >sck10|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>> Hello,
>> It seems issues in client tools. You may want to check "sql server
>browser"
>> service is started. Also, please remove/reinstall SQL tools via
Add/Remove
>> programs to test the situation.
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> --
>> >From: "sck10" <sck10@.online.nospam>
>> >Hello,
>> >
>> >I had SS2K running on my local machine (everything worked). Then I
>> >installed SS2005 and was able to connect the server running locally.
>Once
>> I
>> >uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>> >create a new registration, I get the error that I can't connect to the
>> >server. Any help with this would be greatly appreciated.
>> >
>> >--
>> >Thanks in advance,
>> >
>> >sck10
>
>
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
--
Thanks in advance,
sck10Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
--
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
--
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> --
> >From: "sck10" <sck10@.online.nospam>
> >Hello,
> >
> >I had SS2K running on my local machine (everything worked). Then I
> >installed SS2005 and was able to connect the server running locally.
Once
> I
> >uninstalled SQL Server 2000, I was unable to connect. Even if I try to
> >create a new registration, I get the error that I can't connect to the
> >server. Any help with this would be greatly appreciated.
> >
> >--
> >Thanks in advance,
> >
> >sck10|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>> Hello,
>> It seems issues in client tools. You may want to check "sql server
>browser"
>> service is started. Also, please remove/reinstall SQL tools via
Add/Remove
>> programs to test the situation.
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> --
>> >From: "sck10" <sck10@.online.nospam>
>> >Hello,
>> >
>> >I had SS2K running on my local machine (everything worked). Then I
>> >installed SS2005 and was able to connect the server running locally.
>Once
>> I
>> >uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>> >create a new registration, I get the error that I can't connect to the
>> >server. Any help with this would be greatly appreciated.
>> >
>> >--
>> >Thanks in advance,
>> >
>> >sck10
>
>
Can't connect to SS2005
Hello,
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
Thanks in advance,
sck10Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
--
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
--
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
[vbcol=seagreen]
> --
Once[vbcol=seagreen]
> I|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>browser"
Add/Remove[vbcol=seagreen]
>
>Once
>
>
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
Thanks in advance,
sck10Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
--
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
--
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
[vbcol=seagreen]
> --
Once[vbcol=seagreen]
> I|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>browser"
Add/Remove[vbcol=seagreen]
>
>Once
>
>
can't connect to SQLEXPRESS locally
I have SQLEXPRESS installed on a Windows 2003 Server. The SQL Tools show that TCP and Named Pipes are Enabled. I can't connect using either the command line or the Mgmt Studio with either of these protocols.
Following is excerpt from program I'm trying to install:
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)
And this from the command line
C:\Documents and Settings\edulog>sqlcmd -E -S localhost
HResult 0x274D, Level 16, State 1
TCP Provider: No connection could be made because the target machine actively re
fused it.
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
Thanks,
That's expected. Enable shared memory and you'll be good to go.
Paul
|||The MS documentation ( in the SQL Server Express Readme) says shared memory is enabled by default. I am trying to connect locally, and have named pipes, and tcp enabled as well as shared memory. All 3 methods fail.Wendell
Sunday, February 19, 2012
Can't connect to SQL server after hibernating
Hi,
I currently have a development SQL server running locally on my laptop.
After my laptop comes out of hibernation, existing connections to the server
,
such as from Query Analyzer, work fine, but I can not make new connections t
o
the server. I've tried restarting the server through the SQL Server Service
Manager, but it doesn't solve the problem. The only way to be able to
re-establish a connection is to reboot; which makes developing on the laptop
difficult.
Here is the result of "select @.@.Version":
Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)What exact errors do you get when you can't connect?
Did you check the event logs for errors?
-Sue
On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
Rondeau@.discussions.microsoft.com> wrote:
>Hi,
>I currently have a development SQL server running locally on my laptop.
>After my laptop comes out of hibernation, existing connections to the serve
r,
>such as from Query Analyzer, work fine, but I can not make new connections
to
>the server. I've tried restarting the server through the SQL Server Servic
e
>Manager, but it doesn't solve the problem. The only way to be able to
>re-establish a connection is to reboot; which makes developing on the lapto
p
>difficult.
>Here is the result of "select @.@.Version":
>Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
>Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
>NT 5.1 (Build 2600: Service Pack 2)|||The error message that I'm getting (from SQL Query Analyzer) is:
"Unable to connect to server [my laptop's server name]"
"Server: Msg 17, Level 16, State 1"
"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server d
oes not
exist or access denied."
With regard to the event log, I'm assuming that you're refering to the Event
Viewer in Administrative Tools. There's nothing SQL related in there about
a
connection failure.
Again, an existing connection in SQL Query Analyzer runs fine.
"Sue Hoegemeier" wrote:
> What exact errors do you get when you can't connect?
> Did you check the event logs for errors?
> -Sue
> On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
> Rondeau@.discussions.microsoft.com> wrote:
>
>|||Could be your NIC - they can switch off in hibernation mode.
Try to telnet to the listening port.
Yes...the Event viewer displays the event logs. I'd look for
network, networking component related issues, not
necessarily just SQL errors related to connection failure.
-Sue
On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>The error message that I'm getting (from SQL Query Analyzer) is:
>"Unable to connect to server [my laptop's server name]"
>"Server: Msg 17, Level 16, State 1"
>"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server
does not
>exist or access denied."
>With regard to the event log, I'm assuming that you're refering to the Even
t
>Viewer in Administrative Tools. There's nothing SQL related in there about
a
>connection failure.
>Again, an existing connection in SQL Query Analyzer runs fine.
>"Sue Hoegemeier" wrote:
>|||When I telnet into the server, it connects and the connection stays open for
about a second, and then the connection breaks.
With regard to networking events in the event log, there's some generic
adaptor connected / disconnected around the time that I went into and out of
hibernation, but nothing that would indicate that the adaptor shut down.
"Sue Hoegemeier" wrote:
> Could be your NIC - they can switch off in hibernation mode.
> Try to telnet to the listening port.
> Yes...the Event viewer displays the event logs. I'd look for
> network, networking component related issues, not
> necessarily just SQL errors related to connection failure.
> -Sue
> On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>|||They don't always come back very well once disconnected so I
would really suspect it has something to do with that.
-Sue
On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>When I telnet into the server, it connects and the connection stays open fo
r
>about a second, and then the connection breaks.
>With regard to networking events in the event log, there's some generic
>adaptor connected / disconnected around the time that I went into and out o
f
>hibernation, but nothing that would indicate that the adaptor shut down.
>"Sue Hoegemeier" wrote:
>|||But that doesn't solve my problem. I AM making a successful, but short,
connection in telnet after a hibernation, which means that my network adapto
r
is not the culprit.
Is there some way of restarting the SQL server so that it'll accept
connections? Could this be an issue with the client?
"Sue Hoegemeier" wrote:
> They don't always come back very well once disconnected so I
> would really suspect it has something to do with that.
> -Sue
> On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>|||I just wouldn't use hibernate with SQL Server running. I
wouldn't trust it with SQL anyway
-Sue
On Wed, 19 Oct 2005 10:20:01 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>But that doesn't solve my problem. I AM making a successful, but short,
>connection in telnet after a hibernation, which means that my network adapt
or
>is not the culprit.
>Is there some way of restarting the SQL server so that it'll accept
>connections? Could this be an issue with the client?
>"Sue Hoegemeier" wrote:
>
I currently have a development SQL server running locally on my laptop.
After my laptop comes out of hibernation, existing connections to the server
,
such as from Query Analyzer, work fine, but I can not make new connections t
o
the server. I've tried restarting the server through the SQL Server Service
Manager, but it doesn't solve the problem. The only way to be able to
re-establish a connection is to reboot; which makes developing on the laptop
difficult.
Here is the result of "select @.@.Version":
Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)What exact errors do you get when you can't connect?
Did you check the event logs for errors?
-Sue
On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
Rondeau@.discussions.microsoft.com> wrote:
>Hi,
>I currently have a development SQL server running locally on my laptop.
>After my laptop comes out of hibernation, existing connections to the serve
r,
>such as from Query Analyzer, work fine, but I can not make new connections
to
>the server. I've tried restarting the server through the SQL Server Servic
e
>Manager, but it doesn't solve the problem. The only way to be able to
>re-establish a connection is to reboot; which makes developing on the lapto
p
>difficult.
>Here is the result of "select @.@.Version":
>Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
>Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
>NT 5.1 (Build 2600: Service Pack 2)|||The error message that I'm getting (from SQL Query Analyzer) is:
"Unable to connect to server [my laptop's server name]"
"Server: Msg 17, Level 16, State 1"
"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server d
oes not
exist or access denied."
With regard to the event log, I'm assuming that you're refering to the Event
Viewer in Administrative Tools. There's nothing SQL related in there about
a
connection failure.
Again, an existing connection in SQL Query Analyzer runs fine.
"Sue Hoegemeier" wrote:
> What exact errors do you get when you can't connect?
> Did you check the event logs for errors?
> -Sue
> On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
> Rondeau@.discussions.microsoft.com> wrote:
>
>|||Could be your NIC - they can switch off in hibernation mode.
Try to telnet to the listening port.
Yes...the Event viewer displays the event logs. I'd look for
network, networking component related issues, not
necessarily just SQL errors related to connection failure.
-Sue
On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>The error message that I'm getting (from SQL Query Analyzer) is:
>"Unable to connect to server [my laptop's server name]"
>"Server: Msg 17, Level 16, State 1"
>"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server
does not
>exist or access denied."
>With regard to the event log, I'm assuming that you're refering to the Even
t
>Viewer in Administrative Tools. There's nothing SQL related in there about
a
>connection failure.
>Again, an existing connection in SQL Query Analyzer runs fine.
>"Sue Hoegemeier" wrote:
>|||When I telnet into the server, it connects and the connection stays open for
about a second, and then the connection breaks.
With regard to networking events in the event log, there's some generic
adaptor connected / disconnected around the time that I went into and out of
hibernation, but nothing that would indicate that the adaptor shut down.
"Sue Hoegemeier" wrote:
> Could be your NIC - they can switch off in hibernation mode.
> Try to telnet to the listening port.
> Yes...the Event viewer displays the event logs. I'd look for
> network, networking component related issues, not
> necessarily just SQL errors related to connection failure.
> -Sue
> On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>|||They don't always come back very well once disconnected so I
would really suspect it has something to do with that.
-Sue
On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>When I telnet into the server, it connects and the connection stays open fo
r
>about a second, and then the connection breaks.
>With regard to networking events in the event log, there's some generic
>adaptor connected / disconnected around the time that I went into and out o
f
>hibernation, but nothing that would indicate that the adaptor shut down.
>"Sue Hoegemeier" wrote:
>|||But that doesn't solve my problem. I AM making a successful, but short,
connection in telnet after a hibernation, which means that my network adapto
r
is not the culprit.
Is there some way of restarting the SQL server so that it'll accept
connections? Could this be an issue with the client?
"Sue Hoegemeier" wrote:
> They don't always come back very well once disconnected so I
> would really suspect it has something to do with that.
> -Sue
> On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>|||I just wouldn't use hibernate with SQL Server running. I
wouldn't trust it with SQL anyway
-Sue
On Wed, 19 Oct 2005 10:20:01 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>But that doesn't solve my problem. I AM making a successful, but short,
>connection in telnet after a hibernation, which means that my network adapt
or
>is not the culprit.
>Is there some way of restarting the SQL server so that it'll accept
>connections? Could this be an issue with the client?
>"Sue Hoegemeier" wrote:
>
Can't connect to SQL server after hibernating
Hi,
I currently have a development SQL server running locally on my laptop.
After my laptop comes out of hibernation, existing connections to the server,
such as from Query Analyzer, work fine, but I can not make new connections to
the server. I've tried restarting the server through the SQL Server Service
Manager, but it doesn't solve the problem. The only way to be able to
re-establish a connection is to reboot; which makes developing on the laptop
difficult.
Here is the result of "select @.@.Version":
Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
What exact errors do you get when you can't connect?
Did you check the event logs for errors?
-Sue
On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
Rondeau@.discussions.microsoft.com> wrote:
>Hi,
>I currently have a development SQL server running locally on my laptop.
>After my laptop comes out of hibernation, existing connections to the server,
>such as from Query Analyzer, work fine, but I can not make new connections to
>the server. I've tried restarting the server through the SQL Server Service
>Manager, but it doesn't solve the problem. The only way to be able to
>re-establish a connection is to reboot; which makes developing on the laptop
>difficult.
>Here is the result of "select @.@.Version":
>Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
>Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
>NT 5.1 (Build 2600: Service Pack 2)
|||The error message that I'm getting (from SQL Query Analyzer) is:
"Unable to connect to server [my laptop's server name]"
"Server: Msg 17, Level 16, State 1"
"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
exist or access denied."
With regard to the event log, I'm assuming that you're refering to the Event
Viewer in Administrative Tools. There's nothing SQL related in there about a
connection failure.
Again, an existing connection in SQL Query Analyzer runs fine.
"Sue Hoegemeier" wrote:
> What exact errors do you get when you can't connect?
> Did you check the event logs for errors?
> -Sue
> On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
> Rondeau@.discussions.microsoft.com> wrote:
>
>
|||Could be your NIC - they can switch off in hibernation mode.
Try to telnet to the listening port.
Yes...the Event viewer displays the event logs. I'd look for
network, networking component related issues, not
necessarily just SQL errors related to connection failure.
-Sue
On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>The error message that I'm getting (from SQL Query Analyzer) is:
>"Unable to connect to server [my laptop's server name]"
>"Server: Msg 17, Level 16, State 1"
>"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
>exist or access denied."
>With regard to the event log, I'm assuming that you're refering to the Event
>Viewer in Administrative Tools. There's nothing SQL related in there about a
>connection failure.
>Again, an existing connection in SQL Query Analyzer runs fine.
>"Sue Hoegemeier" wrote:
|||When I telnet into the server, it connects and the connection stays open for
about a second, and then the connection breaks.
With regard to networking events in the event log, there's some generic
adaptor connected / disconnected around the time that I went into and out of
hibernation, but nothing that would indicate that the adaptor shut down.
"Sue Hoegemeier" wrote:
> Could be your NIC - they can switch off in hibernation mode.
> Try to telnet to the listening port.
> Yes...the Event viewer displays the event logs. I'd look for
> network, networking component related issues, not
> necessarily just SQL errors related to connection failure.
> -Sue
> On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>
|||They don't always come back very well once disconnected so I
would really suspect it has something to do with that.
-Sue
On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>When I telnet into the server, it connects and the connection stays open for
>about a second, and then the connection breaks.
>With regard to networking events in the event log, there's some generic
>adaptor connected / disconnected around the time that I went into and out of
>hibernation, but nothing that would indicate that the adaptor shut down.
>"Sue Hoegemeier" wrote:
|||But that doesn't solve my problem. I AM making a successful, but short,
connection in telnet after a hibernation, which means that my network adaptor
is not the culprit.
Is there some way of restarting the SQL server so that it'll accept
connections? Could this be an issue with the client?
"Sue Hoegemeier" wrote:
> They don't always come back very well once disconnected so I
> would really suspect it has something to do with that.
> -Sue
> On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>
|||I just wouldn't use hibernate with SQL Server running. I
wouldn't trust it with SQL anyway
-Sue
On Wed, 19 Oct 2005 10:20:01 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>But that doesn't solve my problem. I AM making a successful, but short,
>connection in telnet after a hibernation, which means that my network adaptor
>is not the culprit.
>Is there some way of restarting the SQL server so that it'll accept
>connections? Could this be an issue with the client?
>"Sue Hoegemeier" wrote:
I currently have a development SQL server running locally on my laptop.
After my laptop comes out of hibernation, existing connections to the server,
such as from Query Analyzer, work fine, but I can not make new connections to
the server. I've tried restarting the server through the SQL Server Service
Manager, but it doesn't solve the problem. The only way to be able to
re-establish a connection is to reboot; which makes developing on the laptop
difficult.
Here is the result of "select @.@.Version":
Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
What exact errors do you get when you can't connect?
Did you check the event logs for errors?
-Sue
On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
Rondeau@.discussions.microsoft.com> wrote:
>Hi,
>I currently have a development SQL server running locally on my laptop.
>After my laptop comes out of hibernation, existing connections to the server,
>such as from Query Analyzer, work fine, but I can not make new connections to
>the server. I've tried restarting the server through the SQL Server Service
>Manager, but it doesn't solve the problem. The only way to be able to
>re-establish a connection is to reboot; which makes developing on the laptop
>difficult.
>Here is the result of "select @.@.Version":
>Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
>Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
>NT 5.1 (Build 2600: Service Pack 2)
|||The error message that I'm getting (from SQL Query Analyzer) is:
"Unable to connect to server [my laptop's server name]"
"Server: Msg 17, Level 16, State 1"
"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
exist or access denied."
With regard to the event log, I'm assuming that you're refering to the Event
Viewer in Administrative Tools. There's nothing SQL related in there about a
connection failure.
Again, an existing connection in SQL Query Analyzer runs fine.
"Sue Hoegemeier" wrote:
> What exact errors do you get when you can't connect?
> Did you check the event logs for errors?
> -Sue
> On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
> Rondeau@.discussions.microsoft.com> wrote:
>
>
|||Could be your NIC - they can switch off in hibernation mode.
Try to telnet to the listening port.
Yes...the Event viewer displays the event logs. I'd look for
network, networking component related issues, not
necessarily just SQL errors related to connection failure.
-Sue
On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>The error message that I'm getting (from SQL Query Analyzer) is:
>"Unable to connect to server [my laptop's server name]"
>"Server: Msg 17, Level 16, State 1"
>"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
>exist or access denied."
>With regard to the event log, I'm assuming that you're refering to the Event
>Viewer in Administrative Tools. There's nothing SQL related in there about a
>connection failure.
>Again, an existing connection in SQL Query Analyzer runs fine.
>"Sue Hoegemeier" wrote:
|||When I telnet into the server, it connects and the connection stays open for
about a second, and then the connection breaks.
With regard to networking events in the event log, there's some generic
adaptor connected / disconnected around the time that I went into and out of
hibernation, but nothing that would indicate that the adaptor shut down.
"Sue Hoegemeier" wrote:
> Could be your NIC - they can switch off in hibernation mode.
> Try to telnet to the listening port.
> Yes...the Event viewer displays the event logs. I'd look for
> network, networking component related issues, not
> necessarily just SQL errors related to connection failure.
> -Sue
> On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>
|||They don't always come back very well once disconnected so I
would really suspect it has something to do with that.
-Sue
On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>When I telnet into the server, it connects and the connection stays open for
>about a second, and then the connection breaks.
>With regard to networking events in the event log, there's some generic
>adaptor connected / disconnected around the time that I went into and out of
>hibernation, but nothing that would indicate that the adaptor shut down.
>"Sue Hoegemeier" wrote:
|||But that doesn't solve my problem. I AM making a successful, but short,
connection in telnet after a hibernation, which means that my network adaptor
is not the culprit.
Is there some way of restarting the SQL server so that it'll accept
connections? Could this be an issue with the client?
"Sue Hoegemeier" wrote:
> They don't always come back very well once disconnected so I
> would really suspect it has something to do with that.
> -Sue
> On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>
|||I just wouldn't use hibernate with SQL Server running. I
wouldn't trust it with SQL anyway
-Sue
On Wed, 19 Oct 2005 10:20:01 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>But that doesn't solve my problem. I AM making a successful, but short,
>connection in telnet after a hibernation, which means that my network adaptor
>is not the culprit.
>Is there some way of restarting the SQL server so that it'll accept
>connections? Could this be an issue with the client?
>"Sue Hoegemeier" wrote:
Tuesday, February 14, 2012
can't connect to server
My server is running, but I can't connect to it.
access find te server but can't connect.
I can locally make an access project
What did I wrong?
(I'm a beginner)
hi,
korsakow wrote:
> My server is running, but I can't connect to it.
> access find te server but can't connect.
> I can locally make an access project
> What did I wrong?
> (I'm a beginner)
what kind of authentication are you using when connecting to the instance?
can you show the connection string and the instance name?
perhapes you are specifying an invalid name, eg only the computer name for a
named instance that requires the full two part name made up by the
computername\instancename
or you are using an unaccepted authentication mode, eg SQL Server
authenticated connection providing username and password where MSDE, by
default on WinNT platforms only accept trusted WinNT authenticated
connections...
if you did not specify the SECURITYMODE=SQL at install time only WinNT
authenticated connections are viable, and you have to manually change a
registry key to modify it as exposed in
http://support.microsoft.com/default...b;en-us;285097
what kind of exception is raised?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
access find te server but can't connect.
I can locally make an access project
What did I wrong?
(I'm a beginner)
hi,
korsakow wrote:
> My server is running, but I can't connect to it.
> access find te server but can't connect.
> I can locally make an access project
> What did I wrong?
> (I'm a beginner)
what kind of authentication are you using when connecting to the instance?
can you show the connection string and the instance name?
perhapes you are specifying an invalid name, eg only the computer name for a
named instance that requires the full two part name made up by the
computername\instancename
or you are using an unaccepted authentication mode, eg SQL Server
authenticated connection providing username and password where MSDE, by
default on WinNT platforms only accept trusted WinNT authenticated
connections...
if you did not specify the SECURITYMODE=SQL at install time only WinNT
authenticated connections are viable, and you have to manually change a
registry key to modify it as exposed in
http://support.microsoft.com/default...b;en-us;285097
what kind of exception is raised?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Subscribe to:
Posts (Atom)