Hi,
I cannot get a connection to my local server since I changed some
configuration settings a couple of weeks ago. I used to be able to connect
without problems but now, it doesn't work anymore.
I read all I could find on the subject in this newsgroup and on MSDN and
cannot find the solution to my problem.
I get the same message as many people: "Cannot connect... the default SQL
Server parameters do not allow remote connections...".
I went to the SQL Server Surface Area Configuration tool and checked the
Allow remote connections box as adviced. I does not change a thing. I still
cannot connect to the server.
I tried to start the service without success. When I try to change the
properties of the service, I get the message "The service did not respond to
the start or control request in a timely fashion, you need administrator
privileges to be able to start/stop this service. (SQLSAC)". I am the
administrator of my computer (afaik).
I use SQL Server 2005 and Windows XP Pro.
The connection with SQL Express works well.
What else can I do?
I really need some . Thanks.
--
Jac Tremblay

We do not know what you have changed and we do not know what you have read
and known...

It seems that your SQL Server service does not run. First of all you must
make it run. And from the error message I assume the password for the SQL
Server service has been changed but it has not been changed in the
properties of SQL Server service itself. So, ensure that password is
correct. You can change your SQL Server service's password from the SQL
Server Configuration Manager and Services MMC. However it's recommended
using SSCM to make changes for SQL Server related services.

--
Ekrem Önsoy



"Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
news:434CEA60-7BFD-465E-893F-3948447C942E@microsoft.com...
> Hi,
> I cannot get a connection to my local server since I changed some
> configuration settings a couple of weeks ago. I used to be able to connect
> without problems but now, it doesn't work anymore.
> I read all I could find on the subject in this newsgroup and on MSDN and
> cannot find the solution to my problem.
> I get the same message as many people: "Cannot connect... the default SQL
> Server parameters do not allow remote connections...".
> I went to the SQL Server Surface Area Configuration tool and checked the
> Allow remote connections box as adviced. I does not change a thing. I
> still
> cannot connect to the server.
> I tried to start the service without success. When I try to change the
> properties of the service, I get the message "The service did not respond
> to
> the start or control request in a timely fashion, you need administrator
> privileges to be able to start/stop this service. (SQLSAC)". I am the
> administrator of my computer (afaik).
> I use SQL Server 2005 and Windows XP Pro.
> The connection with SQL Express works well.
> What else can I do?
> I really need some . Thanks.
> --
> Jac Tremblay

Hi Ekrem,
>We do not know what you have changed and we do not know what you have read...
I have been on this problem for 2 days now, so, unfortunately, I cannot list
all that I have done and read. But here is a brief summary.
In the SQL Server Surface Area Configuration tool, I clicked the "Local and
remote connections" checked box and after, I could connect all right to the
server via the database engine. But after that, I also checked that option
for Analysis Services, Reporting Services, SQL Server Agent and Full-Text
Search. I changed the connection type of all of those services to Automatic.
Now, the services all all running OK except for the database engine and the
SQL Server Agent.
I am trying to find out why and what I can do to fix that problem.
>...the password for the SQL Server service has been changed...
There is no need for a password because, so far, I have always used Windows
authentication (not User/Password logon) and my Windows password has not been
changed for quite a while.
In the SQL Server Configuration Manager, I can see that all the services are
running except for the two listed above. For all of them, Start mode is
Automatic. The Log On As column shows that some are on NT
AUTHORITY\NetworkService and some are on LocalSystem. I cannot change
anything for the two that are stopped because I get the message previously
posted : ""The service did not respond to the start or control request in a
timely fashion, you need administrator privileges to be able to start/stop
this service. (SQLSAC).".
I am wandering if I should uninstall the whole SQL Server application and
reinstall it. Will that ?
Can one restore the default values of the SQL Server Surface Area
Configuration tool?
I am puzzled.
Thanks for your comment.
--
Jac Tremblay


"Ekrem Önsoy" wrote:

> We do not know what you have changed and we do not know what you have read
> and known...
>
> It seems that your SQL Server service does not run. First of all you must
> make it run. And from the error message I assume the password for the SQL
> Server service has been changed but it has not been changed in the
> properties of SQL Server service itself. So, ensure that password is
> correct. You can change your SQL Server service's password from the SQL
> Server Configuration Manager and Services MMC. However it's recommended
> using SSCM to make changes for SQL Server related services.
>
> --
> Ekrem Önsoy
>
>
>
> "Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
> news:434CEA60-7BFD-465E-893F-3948447C942E@microsoft.com...
> > Hi,
> > I cannot get a connection to my local server since I changed some
> > configuration settings a couple of weeks ago. I used to be able to connect
> > without problems but now, it doesn't work anymore.
> > I read all I could find on the subject in this newsgroup and on MSDN and
> > cannot find the solution to my problem.
> > I get the same message as many people: "Cannot connect... the default SQL
> > Server parameters do not allow remote connections...".
> > I went to the SQL Server Surface Area Configuration tool and checked the
> > Allow remote connections box as adviced. I does not change a thing. I
> > still
> > cannot connect to the server.
> > I tried to start the service without success. When I try to change the
> > properties of the service, I get the message "The service did not respond
> > to
> > the start or control request in a timely fashion, you need administrator
> > privileges to be able to start/stop this service. (SQLSAC)". I am the
> > administrator of my computer (afaik).
> > I use SQL Server 2005 and Windows XP Pro.
> > The connection with SQL Express works well.
> > What else can I do?
> > I really need some . Thanks.
> > --
> > Jac Tremblay
>

Two suggestions:
1. Check the SQL Server error log and the Windows Event log. The failure to
start, probably logged an error that may have more info.
2. Try starting the Database Engine from the Windows Services mmc snap-in.
(services.msc) Sometimes Configuration Manager doesn't pass all the error
messages through, and the Services snap-in can give a more descriptive
error.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
news6A6B0BB-811F-429D-9993-6A7986FFFF98@microsoft.com...
> Hi Ekrem,
>>We do not know what you have changed and we do not know what you have
>>read...
> I have been on this problem for 2 days now, so, unfortunately, I cannot
> list
> all that I have done and read. But here is a brief summary.
> In the SQL Server Surface Area Configuration tool, I clicked the "Local
> and
> remote connections" checked box and after, I could connect all right to
> the
> server via the database engine. But after that, I also checked that option
> for Analysis Services, Reporting Services, SQL Server Agent and Full-Text
> Search. I changed the connection type of all of those services to
> Automatic.
> Now, the services all all running OK except for the database engine and
> the
> SQL Server Agent.
> I am trying to find out why and what I can do to fix that problem.
>>...the password for the SQL Server service has been changed...
> There is no need for a password because, so far, I have always used
> Windows
> authentication (not User/Password logon) and my Windows password has not
> been
> changed for quite a while.
> In the SQL Server Configuration Manager, I can see that all the services
> are
> running except for the two listed above. For all of them, Start mode is
> Automatic. The Log On As column shows that some are on NT
> AUTHORITY\NetworkService and some are on LocalSystem. I cannot change
> anything for the two that are stopped because I get the message previously
> posted : ""The service did not respond to the start or control request in
> a
> timely fashion, you need administrator privileges to be able to start/stop
> this service. (SQLSAC).".
> I am wandering if I should uninstall the whole SQL Server application and
> reinstall it. Will that ?
> Can one restore the default values of the SQL Server Surface Area
> Configuration tool?
> I am puzzled.
> Thanks for your comment.
> --
> Jac Tremblay
>
>
> "Ekrem Önsoy" wrote:
>
>> We do not know what you have changed and we do not know what you have
>> read
>> and known...
>>
>> It seems that your SQL Server service does not run. First of all you must
>> make it run. And from the error message I assume the password for the SQL
>> Server service has been changed but it has not been changed in the
>> properties of SQL Server service itself. So, ensure that password is
>> correct. You can change your SQL Server service's password from the SQL
>> Server Configuration Manager and Services MMC. However it's recommended
>> using SSCM to make changes for SQL Server related services.
>>
>> --
>> Ekrem Önsoy
>>
>>
>>
>> "Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
>> news:434CEA60-7BFD-465E-893F-3948447C942E@microsoft.com...
>> > Hi,
>> > I cannot get a connection to my local server since I changed some
>> > configuration settings a couple of weeks ago. I used to be able to
>> > connect
>> > without problems but now, it doesn't work anymore.
>> > I read all I could find on the subject in this newsgroup and on MSDN
>> > and
>> > cannot find the solution to my problem.
>> > I get the same message as many people: "Cannot connect... the default
>> > SQL
>> > Server parameters do not allow remote connections...".
>> > I went to the SQL Server Surface Area Configuration tool and checked
>> > the
>> > Allow remote connections box as adviced. I does not change a thing. I
>> > still
>> > cannot connect to the server.
>> > I tried to start the service without success. When I try to change the
>> > properties of the service, I get the message "The service did not
>> > respond
>> > to
>> > the start or control request in a timely fashion, you need
>> > administrator
>> > privileges to be able to start/stop this service. (SQLSAC)". I am the
>> > administrator of my computer (afaik).
>> > I use SQL Server 2005 and Windows XP Pro.
>> > The connection with SQL Express works well.
>> > What else can I do?
>> > I really need some . Thanks.
>> > --
>> > Jac Tremblay
>>

Hi Rick,
1- I checked the log files for SQL Server 2005 but I am not sure I've got
the right ones. There are many but none of them seem to provide very useful
information. I am also wandering if it is safe to display the computer name
and other technical information on the web.
One of the files in the "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG" directory is named "ERRORLOG" (without extension).
There are also 6 other files named ERRORLOG.1 to .6 and they all contain
similar information. I cannot see any thing in them about the connection
being blocked or some other error message.
The most pertinent information is the following:
**********
2008-04-23 01:04:02.17 Server Error: 17054, Severity: 16, State: 1
**********
I am wandering if this is a real SQL Server error log file or a SQL Server
Express one.
2- I do not know where to find the Windows Event log file. I think I never
had to use it before. Can you tell me where it is?
3- What is the "Windows Services mmc snap-in"? I searched for "services.msc"
on my computer and it was not found. How do I access that application and how
do I use it?
4- I found out another problem related to this situation: Outlook Business
Contact Manager (from Office 2007) cannot open because the connection is not
available.
5- I checked other things from information I found in different files:
The exact error message is:
***********
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: 28 - Server doesn't support
requested protocol) (Microsoft SQL Server, Error: -1)
***********
An explanation from the Microsoft states that "The SQL Server client
cannot connect to the server. This error could be caused by one of the
following reasons:
a-The firewall on the server has refused the connection.
b-A specified SQL Server instance name is not valid.
c-The SQL Server Browser service (sqlbrowser) is not started."
I deactivated both Windows firewall and my personal firewall.
How can I check or change the SQL Server instance name?
The the SQL Server Browser service is running. I tried to start the other
services including the "SQL Server (MSSQLSERVER)" and "SQL Server Agent
(MSSQLSERVER)" but I got the same message saying that I neded to connect
before which is the original problem.
So, as you can see, I've got a severe problem.
I really need some .
Thanks for your answer.
--
Jac Tremblay


"Rick Byham, (MSFT)" wrote:

> Two suggestions:
> 1. Check the SQL Server error log and the Windows Event log. The failure to
> start, probably logged an error that may have more info.
> 2. Try starting the Database Engine from the Windows Services mmc snap-in.
> (services.msc) Sometimes Configuration Manager doesn't pass all the error
> messages through, and the Services snap-in can give a more descriptive
> error.
> --
> Rick Byham (MSFT), SQL Server Books Online
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
> news6A6B0BB-811F-429D-9993-6A7986FFFF98@microsoft.com...
> > Hi Ekrem,
> >>We do not know what you have changed and we do not know what you have
> >>read...
> > I have been on this problem for 2 days now, so, unfortunately, I cannot
> > list
> > all that I have done and read. But here is a brief summary.
> > In the SQL Server Surface Area Configuration tool, I clicked the "Local
> > and
> > remote connections" checked box and after, I could connect all right to
> > the
> > server via the database engine. But after that, I also checked that option
> > for Analysis Services, Reporting Services, SQL Server Agent and Full-Text
> > Search. I changed the connection type of all of those services to
> > Automatic.
> > Now, the services all all running OK except for the database engine and
> > the
> > SQL Server Agent.
> > I am trying to find out why and what I can do to fix that problem.
> >>...the password for the SQL Server service has been changed...
> > There is no need for a password because, so far, I have always used
> > Windows
> > authentication (not User/Password logon) and my Windows password has not
> > been
> > changed for quite a while.
> > In the SQL Server Configuration Manager, I can see that all the services
> > are
> > running except for the two listed above. For all of them, Start mode is
> > Automatic. The Log On As column shows that some are on NT
> > AUTHORITY\NetworkService and some are on LocalSystem. I cannot change
> > anything for the two that are stopped because I get the message previously
> > posted : ""The service did not respond to the start or control request in
> > a
> > timely fashion, you need administrator privileges to be able to start/stop
> > this service. (SQLSAC).".
> > I am wandering if I should uninstall the whole SQL Server application and
> > reinstall it. Will that ?
> > Can one restore the default values of the SQL Server Surface Area
> > Configuration tool?
> > I am puzzled.
> > Thanks for your comment.
> > --
> > Jac Tremblay
> >
> >
> > "Ekrem Önsoy" wrote:
> >
> >> We do not know what you have changed and we do not know what you have
> >> read
> >> and known...
> >>
> >> It seems that your SQL Server service does not run. First of all you must
> >> make it run. And from the error message I assume the password for the SQL
> >> Server service has been changed but it has not been changed in the
> >> properties of SQL Server service itself. So, ensure that password is
> >> correct. You can change your SQL Server service's password from the SQL
> >> Server Configuration Manager and Services MMC. However it's recommended
> >> using SSCM to make changes for SQL Server related services.
> >>
> >> --
> >> Ekrem Önsoy
> >>
> >>
> >>
> >> "Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
> >> news:434CEA60-7BFD-465E-893F-3948447C942E@microsoft.com...
> >> > Hi,
> >> > I cannot get a connection to my local server since I changed some
> >> > configuration settings a couple of weeks ago. I used to be able to
> >> > connect
> >> > without problems but now, it doesn't work anymore.
> >> > I read all I could find on the subject in this newsgroup and on MSDN
> >> > and
> >> > cannot find the solution to my problem.
> >> > I get the same message as many people: "Cannot connect... the default
> >> > SQL
> >> > Server parameters do not allow remote connections...".
> >> > I went to the SQL Server Surface Area Configuration tool and checked
> >> > the
> >> > Allow remote connections box as adviced. I does not change a thing. I
> >> > still
> >> > cannot connect to the server.
> >> > I tried to start the service without success. When I try to change the
> >> > properties of the service, I get the message "The service did not
> >> > respond
> >> > to
> >> > the start or control request in a timely fashion, you need
> >> > administrator
> >> > privileges to be able to start/stop this service. (SQLSAC)". I am the
> >> > administrator of my computer (afaik).
> >> > I use SQL Server 2005 and Windows XP Pro.
> >> > The connection with SQL Express works well.
> >> > What else can I do?
> >> > I really need some . Thanks.
> >> > --
> >> > Jac Tremblay
> >>
>

Hi again Rick,
What are the protocols I should activate in my case?
1- Shared Memory
2- Named Pipes
3- TCP/IP
4- VIA
I use SQL Server on my personal (and business) station (no network yet) and
I develop VB.NET application that require an active connection.
--
Jac Tremblay


"Rick Byham, (MSFT)" wrote:

> Two suggestions:
> 1. Check the SQL Server error log and the Windows Event log. The failure to
> start, probably logged an error that may have more info.
> 2. Try starting the Database Engine from the Windows Services mmc snap-in.
> (services.msc) Sometimes Configuration Manager doesn't pass all the error
> messages through, and the Services snap-in can give a more descriptive
> error.
> --
> Rick Byham (MSFT), SQL Server Books Online
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
> news6A6B0BB-811F-429D-9993-6A7986FFFF98@microsoft.com...
> > Hi Ekrem,
> >>We do not know what you have changed and we do not know what you have
> >>read...
> > I have been on this problem for 2 days now, so, unfortunately, I cannot
> > list
> > all that I have done and read. But here is a brief summary.
> > In the SQL Server Surface Area Configuration tool, I clicked the "Local
> > and
> > remote connections" checked box and after, I could connect all right to
> > the
> > server via the database engine. But after that, I also checked that option
> > for Analysis Services, Reporting Services, SQL Server Agent and Full-Text
> > Search. I changed the connection type of all of those services to
> > Automatic.
> > Now, the services all all running OK except for the database engine and
> > the
> > SQL Server Agent.
> > I am trying to find out why and what I can do to fix that problem.
> >>...the password for the SQL Server service has been changed...
> > There is no need for a password because, so far, I have always used
> > Windows
> > authentication (not User/Password logon) and my Windows password has not
> > been
> > changed for quite a while.
> > In the SQL Server Configuration Manager, I can see that all the services
> > are
> > running except for the two listed above. For all of them, Start mode is
> > Automatic. The Log On As column shows that some are on NT
> > AUTHORITY\NetworkService and some are on LocalSystem. I cannot change
> > anything for the two that are stopped because I get the message previously
> > posted : ""The service did not respond to the start or control request in
> > a
> > timely fashion, you need administrator privileges to be able to start/stop
> > this service. (SQLSAC).".
> > I am wandering if I should uninstall the whole SQL Server application and
> > reinstall it. Will that ?
> > Can one restore the default values of the SQL Server Surface Area
> > Configuration tool?
> > I am puzzled.
> > Thanks for your comment.
> > --
> > Jac Tremblay
> >
> >
> > "Ekrem Önsoy" wrote:
> >
> >> We do not know what you have changed and we do not know what you have
> >> read
> >> and known...
> >>
> >> It seems that your SQL Server service does not run. First of all you must
> >> make it run. And from the error message I assume the password for the SQL
> >> Server service has been changed but it has not been changed in the
> >> properties of SQL Server service itself. So, ensure that password is
> >> correct. You can change your SQL Server service's password from the SQL
> >> Server Configuration Manager and Services MMC. However it's recommended
> >> using SSCM to make changes for SQL Server related services.
> >>
> >> --
> >> Ekrem Önsoy
> >>
> >>
> >>
> >> "Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
> >> news:434CEA60-7BFD-465E-893F-3948447C942E@microsoft.com...
> >> > Hi,
> >> > I cannot get a connection to my local server since I changed some
> >> > configuration settings a couple of weeks ago. I used to be able to
> >> > connect
> >> > without problems but now, it doesn't work anymore.
> >> > I read all I could find on the subject in this newsgroup and on MSDN
> >> > and
> >> > cannot find the solution to my problem.
> >> > I get the same message as many people: "Cannot connect... the default
> >> > SQL
> >> > Server parameters do not allow remote connections...".
> >> > I went to the SQL Server Surface Area Configuration tool and checked
> >> > the
> >> > Allow remote connections box as adviced. I does not change a thing. I
> >> > still
> >> > cannot connect to the server.
> >> > I tried to start the service without success. When I try to change the
> >> > properties of the service, I get the message "The service did not
> >> > respond
> >> > to
> >> > the start or control request in a timely fashion, you need
> >> > administrator
> >> > privileges to be able to start/stop this service. (SQLSAC)". I am the
> >> > administrator of my computer (afaik).
> >> > I use SQL Server 2005 and Windows XP Pro.
> >> > The connection with SQL Express works well.
> >> > What else can I do?
> >> > I really need some . Thanks.
> >> > --
> >> > Jac Tremblay
> >>
>

Hi again Rick,
I used mmc.exe from the Start menu and it doesn't change anything. All my
services are running now because yesterday, I changed the protocols for SQL
Server 2005. I disabled all of them, stopped all the services and them
enabled TCP/IP and Named Pipes (in this order). I restarted all the services
and all went well including the two that wouldn't start before (SQL Server
and SQL Server Agent).
But I still cannot connect to my server.
How can I try to connect with mmc.exe? I am not sure that I have done the
right thing? I added the SQL Server Configuration Manager and IIS Services
but I cannot add the SQL Server Surface Area Configuration tool because it is
not available in the list and there seem to be no way to browse for it.
I hope I get an answer soon because I am wasting precious working time.
Thanks.
--
Jac Tremblay


"Rick Byham, (MSFT)" wrote:

> Two suggestions:
> 1. Check the SQL Server error log and the Windows Event log. The failure to
> start, probably logged an error that may have more info.
> 2. Try starting the Database Engine from the Windows Services mmc snap-in.
> (services.msc) Sometimes Configuration Manager doesn't pass all the error
> messages through, and the Services snap-in can give a more descriptive
> error.
> --
> Rick Byham (MSFT), SQL Server Books Online
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
> news6A6B0BB-811F-429D-9993-6A7986FFFF98@microsoft.com...
> > Hi Ekrem,
> >>We do not know what you have changed and we do not know what you have
> >>read...
> > I have been on this problem for 2 days now, so, unfortunately, I cannot
> > list
> > all that I have done and read. But here is a brief summary.
> > In the SQL Server Surface Area Configuration tool, I clicked the "Local
> > and
> > remote connections" checked box and after, I could connect all right to
> > the
> > server via the database engine. But after that, I also checked that option
> > for Analysis Services, Reporting Services, SQL Server Agent and Full-Text
> > Search. I changed the connection type of all of those services to
> > Automatic.
> > Now, the services all all running OK except for the database engine and
> > the
> > SQL Server Agent.
> > I am trying to find out why and what I can do to fix that problem.
> >>...the password for the SQL Server service has been changed...
> > There is no need for a password because, so far, I have always used
> > Windows
> > authentication (not User/Password logon) and my Windows password has not
> > been
> > changed for quite a while.
> > In the SQL Server Configuration Manager, I can see that all the services
> > are
> > running except for the two listed above. For all of them, Start mode is
> > Automatic. The Log On As column shows that some are on NT
> > AUTHORITY\NetworkService and some are on LocalSystem. I cannot change
> > anything for the two that are stopped because I get the message previously
> > posted : ""The service did not respond to the start or control request in
> > a
> > timely fashion, you need administrator privileges to be able to start/stop
> > this service. (SQLSAC).".
> > I am wandering if I should uninstall the whole SQL Server application and
> > reinstall it. Will that ?
> > Can one restore the default values of the SQL Server Surface Area
> > Configuration tool?
> > I am puzzled.
> > Thanks for your comment.
> > --
> > Jac Tremblay
> >
> >
> > "Ekrem Önsoy" wrote:
> >
> >> We do not know what you have changed and we do not know what you have
> >> read
> >> and known...
> >>
> >> It seems that your SQL Server service does not run. First of all you must
> >> make it run. And from the error message I assume the password for the SQL
> >> Server service has been changed but it has not been changed in the
> >> properties of SQL Server service itself. So, ensure that password is
> >> correct. You can change your SQL Server service's password from the SQL
> >> Server Configuration Manager and Services MMC. However it's recommended
> >> using SSCM to make changes for SQL Server related services.
> >>
> >> --
> >> Ekrem Önsoy
> >>
> >>
> >>
> >> "Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
> >> news:434CEA60-7BFD-465E-893F-3948447C942E@microsoft.com...
> >> > Hi,
> >> > I cannot get a connection to my local server since I changed some
> >> > configuration settings a couple of weeks ago. I used to be able to
> >> > connect
> >> > without problems but now, it doesn't work anymore.
> >> > I read all I could find on the subject in this newsgroup and on MSDN
> >> > and
> >> > cannot find the solution to my problem.
> >> > I get the same message as many people: "Cannot connect... the default
> >> > SQL
> >> > Server parameters do not allow remote connections...".
> >> > I went to the SQL Server Surface Area Configuration tool and checked
> >> > the
> >> > Allow remote connections box as adviced. I does not change a thing. I
> >> > still
> >> > cannot connect to the server.
> >> > I tried to start the service without success. When I try to change the
> >> > properties of the service, I get the message "The service did not
> >> > respond
> >> > to
> >> > the start or control request in a timely fashion, you need
> >> > administrator
> >> > privileges to be able to start/stop this service. (SQLSAC)". I am the
> >> > administrator of my computer (afaik).
> >> > I use SQL Server 2005 and Windows XP Pro.
> >> > The connection with SQL Express works well.
> >> > What else can I do?
> >> > I really need some . Thanks.
> >> > --
> >> > Jac Tremblay
> >>
>

So it sounds like the SQL Server Database Engine is now running. (Because
one of your messages said "All my
services are running now because yesterday, I changed the protocols for SQL
Server 2005. ") I only mentioned MMC in order to get it running, so you
don't need to use that anymore. Since it's running you probably don't need
references to the Windows event log anymore either.

You have enabled TCP, so I will provide more info about connecting using
TCP. I suggest you enable TCP and shared memory and forget about named pipes
and VIA, unless you have some particular reason for those..

About the instance name. When you had SQL Server Configuration Manager open,
in the SQL Server 2005 Services section the Database Engine will be listed
as SQL Server (MSSQLSERVER) if it is a default (un-named instance). If it
lists something else, such as SQL Server (SQLEXPRESS) then the text in the
( ) is the instance name. SQL Server Express edition installs as a named
instance named SQLEXPRESS.
When you connect to the default instance, just use the computer name as the
server, like ACCTG.
When you connect to a named instance, you connect to
computername\instancename like ACCTG\PAYROLL. In some applications you may
need brackets around the name, as in [ACCTG\PAYROLL] .

Are you testing your connection ability using Microsoft's tools? The regular
editions of SQL Server have a tool called SQL Server Management Studio. It
is not always installed. You may need to run setup again and select Tools.
If you are only running SQL Server Express, then you should download the
free version of Managment Studio from
http://www.microsoft.com/downloads/d...displaylang=en
If you can connect with Management Studio, then start testing the connection
from your code.

I think your three messages had contradictory information. Sorry if I
misunderstood you. Regrettably I will be out tomorrow and not checking this
thread. The tutorials may you.
http://msdn2.microsoft.com/en-us/library/ms345318.aspx
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
news:697C187F-9555-446B-BA9A-5893B890C24B@microsoft.com...
> Hi again Rick,
> I used mmc.exe from the Start menu and it doesn't change anything. All my
> services are running now because yesterday, I changed the protocols for
> SQL
> Server 2005. I disabled all of them, stopped all the services and them
> enabled TCP/IP and Named Pipes (in this order). I restarted all the
> services
> and all went well including the two that wouldn't start before (SQL Server
> and SQL Server Agent).
> But I still cannot connect to my server.
> How can I try to connect with mmc.exe? I am not sure that I have done the
> right thing? I added the SQL Server Configuration Manager and IIS Services
> but I cannot add the SQL Server Surface Area Configuration tool because it
> is
> not available in the list and there seem to be no way to browse for it.
> I hope I get an answer soon because I am wasting precious working time.
> Thanks.
> --
> Jac Tremblay
>
>
> "Rick Byham, (MSFT)" wrote:
>
>> Two suggestions:
>> 1. Check the SQL Server error log and the Windows Event log. The failure
>> to
>> start, probably logged an error that may have more info.
>> 2. Try starting the Database Engine from the Windows Services mmc
>> snap-in.
>> (services.msc) Sometimes Configuration Manager doesn't pass all the error
>> messages through, and the Services snap-in can give a more descriptive
>> error.
>> --
>> Rick Byham (MSFT), SQL Server Books Online
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
>> news6A6B0BB-811F-429D-9993-6A7986FFFF98@microsoft.com...
>> > Hi Ekrem,
>> >>We do not know what you have changed and we do not know what you have
>> >>read...
>> > I have been on this problem for 2 days now, so, unfortunately, I cannot
>> > list
>> > all that I have done and read. But here is a brief summary.
>> > In the SQL Server Surface Area Configuration tool, I clicked the "Local
>> > and
>> > remote connections" checked box and after, I could connect all right to
>> > the
>> > server via the database engine. But after that, I also checked that
>> > option
>> > for Analysis Services, Reporting Services, SQL Server Agent and
>> > Full-Text
>> > Search. I changed the connection type of all of those services to
>> > Automatic.
>> > Now, the services all all running OK except for the database engine and
>> > the
>> > SQL Server Agent.
>> > I am trying to find out why and what I can do to fix that problem.
>> >>...the password for the SQL Server service has been changed...
>> > There is no need for a password because, so far, I have always used
>> > Windows
>> > authentication (not User/Password logon) and my Windows password has
>> > not
>> > been
>> > changed for quite a while.
>> > In the SQL Server Configuration Manager, I can see that all the
>> > services
>> > are
>> > running except for the two listed above. For all of them, Start mode is
>> > Automatic. The Log On As column shows that some are on NT
>> > AUTHORITY\NetworkService and some are on LocalSystem. I cannot change
>> > anything for the two that are stopped because I get the message
>> > previously
>> > posted : ""The service did not respond to the start or control request
>> > in
>> > a
>> > timely fashion, you need administrator privileges to be able to
>> > start/stop
>> > this service. (SQLSAC).".
>> > I am wandering if I should uninstall the whole SQL Server application
>> > and
>> > reinstall it. Will that ?
>> > Can one restore the default values of the SQL Server Surface Area
>> > Configuration tool?
>> > I am puzzled.
>> > Thanks for your comment.
>> > --
>> > Jac Tremblay
>> >
>> >
>> > "Ekrem Önsoy" wrote:
>> >
>> >> We do not know what you have changed and we do not know what you have
>> >> read
>> >> and known...
>> >>
>> >> It seems that your SQL Server service does not run. First of all you
>> >> must
>> >> make it run. And from the error message I assume the password for the
>> >> SQL
>> >> Server service has been changed but it has not been changed in the
>> >> properties of SQL Server service itself. So, ensure that password is
>> >> correct. You can change your SQL Server service's password from the
>> >> SQL
>> >> Server Configuration Manager and Services MMC. However it's
>> >> recommended
>> >> using SSCM to make changes for SQL Server related services.
>> >>
>> >> --
>> >> Ekrem Önsoy
>> >>
>> >>
>> >>
>> >> "Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
>> >> news:434CEA60-7BFD-465E-893F-3948447C942E@microsoft.com...
>> >> > Hi,
>> >> > I cannot get a connection to my local server since I changed some
>> >> > configuration settings a couple of weeks ago. I used to be able to
>> >> > connect
>> >> > without problems but now, it doesn't work anymore.
>> >> > I read all I could find on the subject in this newsgroup and on MSDN
>> >> > and
>> >> > cannot find the solution to my problem.
>> >> > I get the same message as many people: "Cannot connect... the
>> >> > default
>> >> > SQL
>> >> > Server parameters do not allow remote connections...".
>> >> > I went to the SQL Server Surface Area Configuration tool and checked
>> >> > the
>> >> > Allow remote connections box as adviced. I does not change a thing.
>> >> > I
>> >> > still
>> >> > cannot connect to the server.
>> >> > I tried to start the service without success. When I try to change
>> >> > the
>> >> > properties of the service, I get the message "The service did not
>> >> > respond
>> >> > to
>> >> > the start or control request in a timely fashion, you need
>> >> > administrator
>> >> > privileges to be able to start/stop this service. (SQLSAC)". I am
>> >> > the
>> >> > administrator of my computer (afaik).
>> >> > I use SQL Server 2005 and Windows XP Pro.
>> >> > The connection with SQL Express works well.
>> >> > What else can I do?
>> >> > I really need some . Thanks.
>> >> > --
>> >> > Jac Tremblay
>> >>
>>

Hi Rick,
Thank you for your answer. I will check that out and post the results of my
work in the near future.
I appreciate all the information you gave me.
--
Jac Tremblay


"Rick Byham, (MSFT)" wrote:

> So it sounds like the SQL Server Database Engine is now running. (Because
> one of your messages said "All my
> services are running now because yesterday, I changed the protocols for SQL
> Server 2005. ") I only mentioned MMC in order to get it running, so you
> don't need to use that anymore. Since it's running you probably don't need
> references to the Windows event log anymore either.
>
> You have enabled TCP, so I will provide more info about connecting using
> TCP. I suggest you enable TCP and shared memory and forget about named pipes
> and VIA, unless you have some particular reason for those..
>
> About the instance name. When you had SQL Server Configuration Manager open,
> in the SQL Server 2005 Services section the Database Engine will be listed
> as SQL Server (MSSQLSERVER) if it is a default (un-named instance). If it
> lists something else, such as SQL Server (SQLEXPRESS) then the text in the
> ( ) is the instance name. SQL Server Express edition installs as a named
> instance named SQLEXPRESS.
> When you connect to the default instance, just use the computer name as the
> server, like ACCTG.
> When you connect to a named instance, you connect to
> computername\instancename like ACCTG\PAYROLL. In some applications you may
> need brackets around the name, as in [ACCTG\PAYROLL] .
>
> Are you testing your connection ability using Microsoft's tools? The regular
> editions of SQL Server have a tool called SQL Server Management Studio. It
> is not always installed. You may need to run setup again and select Tools.
> If you are only running SQL Server Express, then you should download the
> free version of Managment Studio from
> http://www.microsoft.com/downloads/d...displaylang=en
> If you can connect with Management Studio, then start testing the connection
> from your code.
>
> I think your three messages had contradictory information. Sorry if I
> misunderstood you. Regrettably I will be out tomorrow and not checking this
> thread. The tutorials may you.
> http://msdn2.microsoft.com/en-us/library/ms345318.aspx
> --
> Rick Byham (MSFT), SQL Server Books Online
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
> news:697C187F-9555-446B-BA9A-5893B890C24B@microsoft.com...
> > Hi again Rick,
> > I used mmc.exe from the Start menu and it doesn't change anything. All my
> > services are running now because yesterday, I changed the protocols for
> > SQL
> > Server 2005. I disabled all of them, stopped all the services and them
> > enabled TCP/IP and Named Pipes (in this order). I restarted all the
> > services
> > and all went well including the two that wouldn't start before (SQL Server
> > and SQL Server Agent).
> > But I still cannot connect to my server.
> > How can I try to connect with mmc.exe? I am not sure that I have done the
> > right thing? I added the SQL Server Configuration Manager and IIS Services
> > but I cannot add the SQL Server Surface Area Configuration tool because it
> > is
> > not available in the list and there seem to be no way to browse for it.
> > I hope I get an answer soon because I am wasting precious working time.
> > Thanks.
> > --
> > Jac Tremblay
> >
> >
> > "Rick Byham, (MSFT)" wrote:
> >
> >> Two suggestions:
> >> 1. Check the SQL Server error log and the Windows Event log. The failure
> >> to
> >> start, probably logged an error that may have more info.
> >> 2. Try starting the Database Engine from the Windows Services mmc
> >> snap-in.
> >> (services.msc) Sometimes Configuration Manager doesn't pass all the error
> >> messages through, and the Services snap-in can give a more descriptive
> >> error.
> >> --
> >> Rick Byham (MSFT), SQL Server Books Online
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
> >> news6A6B0BB-811F-429D-9993-6A7986FFFF98@microsoft.com...
> >> > Hi Ekrem,
> >> >>We do not know what you have changed and we do not know what you have
> >> >>read...
> >> > I have been on this problem for 2 days now, so, unfortunately, I cannot
> >> > list
> >> > all that I have done and read. But here is a brief summary.
> >> > In the SQL Server Surface Area Configuration tool, I clicked the "Local
> >> > and
> >> > remote connections" checked box and after, I could connect all right to
> >> > the
> >> > server via the database engine. But after that, I also checked that
> >> > option
> >> > for Analysis Services, Reporting Services, SQL Server Agent and
> >> > Full-Text
> >> > Search. I changed the connection type of all of those services to
> >> > Automatic.
> >> > Now, the services all all running OK except for the database engine and
> >> > the
> >> > SQL Server Agent.
> >> > I am trying to find out why and what I can do to fix that problem.
> >> >>...the password for the SQL Server service has been changed...
> >> > There is no need for a password because, so far, I have always used
> >> > Windows
> >> > authentication (not User/Password logon) and my Windows password has
> >> > not
> >> > been
> >> > changed for quite a while.
> >> > In the SQL Server Configuration Manager, I can see that all the
> >> > services
> >> > are
> >> > running except for the two listed above. For all of them, Start mode is
> >> > Automatic. The Log On As column shows that some are on NT
> >> > AUTHORITY\NetworkService and some are on LocalSystem. I cannot change
> >> > anything for the two that are stopped because I get the message
> >> > previously
> >> > posted : ""The service did not respond to the start or control request
> >> > in
> >> > a
> >> > timely fashion, you need administrator privileges to be able to
> >> > start/stop
> >> > this service. (SQLSAC).".
> >> > I am wandering if I should uninstall the whole SQL Server application
> >> > and
> >> > reinstall it. Will that ?
> >> > Can one restore the default values of the SQL Server Surface Area
> >> > Configuration tool?
> >> > I am puzzled.
> >> > Thanks for your comment.
> >> > --
> >> > Jac Tremblay
> >> >
> >> >
> >> > "Ekrem Önsoy" wrote:
> >> >
> >> >> We do not know what you have changed and we do not know what you have
> >> >> read
> >> >> and known...
> >> >>
> >> >> It seems that your SQL Server service does not run. First of all you
> >> >> must
> >> >> make it run. And from the error message I assume the password for the
> >> >> SQL
> >> >> Server service has been changed but it has not been changed in the
> >> >> properties of SQL Server service itself. So, ensure that password is
> >> >> correct. You can change your SQL Server service's password from the
> >> >> SQL
> >> >> Server Configuration Manager and Services MMC. However it's
> >> >> recommended
> >> >> using SSCM to make changes for SQL Server related services.
> >> >>
> >> >> --
> >> >> Ekrem Önsoy
> >> >>
> >> >>
> >> >>
> >> >> "Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
> >> >> news:434CEA60-7BFD-465E-893F-3948447C942E@microsoft.com...
> >> >> > Hi,
> >> >> > I cannot get a connection to my local server since I changed some
> >> >> > configuration settings a couple of weeks ago. I used to be able to
> >> >> > connect
> >> >> > without problems but now, it doesn't work anymore.
> >> >> > I read all I could find on the subject in this newsgroup and on MSDN
> >> >> > and
> >> >> > cannot find the solution to my problem.
> >> >> > I get the same message as many people: "Cannot connect... the
> >> >> > default
> >> >> > SQL
> >> >> > Server parameters do not allow remote connections...".
> >> >> > I went to the SQL Server Surface Area Configuration tool and checked
> >> >> > the
> >> >> > Allow remote connections box as adviced. I does not change a thing.
> >> >> > I
> >> >> > still
> >> >> > cannot connect to the server.
> >> >> > I tried to start the service without success. When I try to change
> >> >> > the
> >> >> > properties of the service, I get the message "The service did not
> >> >> > respond
> >> >> > to
> >> >> > the start or control request in a timely fashion, you need
> >> >> > administrator
> >> >> > privileges to be able to start/stop this service. (SQLSAC)". I am
> >> >> > the
> >> >> > administrator of my computer (afaik).
> >> >> > I use SQL Server 2005 and Windows XP Pro.
> >> >> > The connection with SQL Express works well.
> >> >> > What else can I do?
> >> >> > I really need some . Thanks.
> >> >> > --
> >> >> > Jac Tremblay
> >> >>
> >>
>