Cannot restore database: February 2012

Saturday, February 25, 2012

Cannot start SQL Server 2005 management express studio CTP?

I downloaded it from the link in
http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP version.
And it cannot be run on two machines. Both installed VS 2003.http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
--
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>I downloaded it from the link in
> http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> version.
> And it cannot be run on two machines. Both installed VS 2003.|||Still CTP:
"Get SQL Server Management Studio Express
Download a Community Technology Preview (CTP) of SQL Server Management
Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
Express that makes it easy for you to administer SQL Server Express
databases."
"William Stacey [MVP]" wrote:
> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
> --
> William Stacey [MVP]
> "nick" <nick@.discussions.microsoft.com> wrote in message
> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
> >I downloaded it from the link in
> > http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> > version.
> > And it cannot be run on two machines. Both installed VS 2003.
>
>|||No. SQL Express is RTM. SSME is CTP.
--
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:E8E707DD-793B-4D99-978A-03ECAAA3DE98@.microsoft.com...
> Still CTP:
> "Get SQL Server Management Studio Express
> Download a Community Technology Preview (CTP) of SQL Server Management
> Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
> Express that makes it easy for you to administer SQL Server Express
> databases."
> "William Stacey [MVP]" wrote:
>> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
>> --
>> William Stacey [MVP]
>> "nick" <nick@.discussions.microsoft.com> wrote in message
>> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>> >I downloaded it from the link in
>> > http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
>> > version.
>> > And it cannot be run on two machines. Both installed VS 2003.
>>

Cannot start SQL Server 2005 management express studio CTP?

I downloaded it from the link in
http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP version.
And it cannot be run on two machines. Both installed VS 2003.
http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>I downloaded it from the link in
> http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> version.
> And it cannot be run on two machines. Both installed VS 2003.
|||Still CTP:
"Get SQL Server Management Studio Express
Download a Community Technology Preview (CTP) of SQL Server Management
Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
Express that makes it easy for you to administer SQL Server Express
databases."
"William Stacey [MVP]" wrote:

> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
> --
> William Stacey [MVP]
> "nick" <nick@.discussions.microsoft.com> wrote in message
> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>
>
|||No. SQL Express is RTM. SSME is CTP.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:E8E707DD-793B-4D99-978A-03ECAAA3DE98@.microsoft.com...[vbcol=seagreen]
> Still CTP:
> "Get SQL Server Management Studio Express
> Download a Community Technology Preview (CTP) of SQL Server Management
> Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
> Express that makes it easy for you to administer SQL Server Express
> databases."
> "William Stacey [MVP]" wrote:

Cannot start SQL Server 2005 management express studio CTP?

I downloaded it from the link in
http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP version.
And it cannot be run on two machines. Both installed VS 2003.http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>I downloaded it from the link in
> http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> version.
> And it cannot be run on two machines. Both installed VS 2003.|||Still CTP:
"Get SQL Server Management Studio Express
Download a Community Technology Preview (CTP) of SQL Server Management
Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
Express that makes it easy for you to administer SQL Server Express
databases."
"William Stacey [MVP]" wrote:

> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
> --
> William Stacey [MVP]
> "nick" <nick@.discussions.microsoft.com> wrote in message
> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>
>|||No. SQL Express is RTM. SSME is CTP.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:E8E707DD-793B-4D99-978A-03ECAAA3DE98@.microsoft.com...[vbcol=seagreen]
> Still CTP:
> "Get SQL Server Management Studio Express
> Download a Community Technology Preview (CTP) of SQL Server Management
> Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
> Express that makes it easy for you to administer SQL Server Express
> databases."
> "William Stacey [MVP]" wrote:
>

Cannot Start SQL Server 2000 after installing Vista

Just installed the Vista Business Upgrade. Now I cannot start SQL Server 200
0
even though my Windows Authentication has not changed. The Service Manager
reports "Access Denied" when I try to start the server.
Do I need to reinstall the server or is there a workaround? I tried the SSMS
but had no success.
--
malcolmHi,
can you elaborate more, is you MSSQL service run under domain or local
account?...However you an use registry rebuild to rebuild sql server
instllation and accounts without effecting your databases.
Omar
"malcolm" wrote:

> Just installed the Vista Business Upgrade. Now I cannot start SQL Server 2
000
> even though my Windows Authentication has not changed. The Service Manager
> reports "Access Denied" when I try to start the server.
> Do I need to reinstall the server or is there a workaround? I tried the SS
MS
> but had no success.
> --
> malcolm|||malcolm (ramartower@.access312.com) writes:
> Just installed the Vista Business Upgrade. Now I cannot start SQL Server
> 2000 even though my Windows Authentication has not changed. The Service
> Manager reports "Access Denied" when I try to start the server.
> Do I need to reinstall the server or is there a workaround? I tried the
> SSMS but had no success.
You could try to start it from Computer Management, or run Service Manager
by running as Admin. I guess the first showstopper is the UAC. But the
more basic problem is that SQL 2000 is not supported on Vista, so you may
not get it work at all. If you need the databases, you will need to find
another machine with a different operating system, or upgrade to SQL 2005.
(And you need SP2 of SQL 2005 to run on Vista.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Cannot start SQL Server & Sql Agent

Hi,
i am running SQL server 2000 evaluation copy on SQL server 2003 and
suddenly i cannot open my EM
From Service Manager , i can start SQL Server but not SQL Agent, From EM
, i could not connect to my SQL Database
it says : "connection could not be established ... Access denied or SQL
Server does not exist"
Appreciate any advice
tks & rdgs
Hi ,
here's the error msg from ErrorLog:
2005-03-27 00:35:51 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2005-03-27 00:35:51 - ! [298] SQLServer Error: 10060, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2005-03-27 00:35:51 - ! [000] Unable to connect to server 'WKRZ\PRODUCTION';
SQLServerAgent cannot start
2005-03-27 00:35:51 - ? [098] SQLServerAgent terminated (normally)
rdgs
"maxzsim" wrote:

> Hi,
> i am running SQL server 2000 evaluation copy on SQL server 2003 and
> suddenly i cannot open my EM
> From Service Manager , i can start SQL Server but not SQL Agent, From EM
> , i could not connect to my SQL Database
> it says : "connection could not be established ... Access denied or SQL
> Server does not exist"
> Appreciate any advice
> tks & rdgs
|||Hi
Running an evaluation copy on an instance called Production sounds very
suspicious!
Have you seen:
http://support.microsoft.com/default...b;en-us;237604
John
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:C7AB28C2-5EEA-49BA-BB33-4A834AD400CA@.microsoft.com...[vbcol=seagreen]
> Hi ,
> here's the error msg from ErrorLog:
> 2005-03-27 00:35:51 - ! [298] SQLServer Error: 17, SQL Server does not
> exist
> or access denied. [SQLSTATE 08001]
> 2005-03-27 00:35:51 - ! [298] SQLServer Error: 10060, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2005-03-27 00:35:51 - ! [000] Unable to connect to server
> 'WKRZ\PRODUCTION';
> SQLServerAgent cannot start
> 2005-03-27 00:35:51 - ? [098] SQLServerAgent terminated (normally)
> rdgs
> "maxzsim" wrote:

Cannot start SQL Server & Sql Agent

Hi,
i am running SQL server 2000 evaluation copy on SQL server 2003 and
suddenly i cannot open my EM
From Service Manager , i can start SQL Server but not SQL Agent, From EM
, i could not connect to my SQL Database
it says : "connection could not be established ... Access denied or SQL
Server does not exist"
Appreciate any advice
tks & rdgsHi ,
here's the error msg from ErrorLog:
2005-03-27 00:35:51 - ! [298] SQLServer Error: 17, SQL Server does not e
xist
or access denied. [SQLSTATE 08001]
2005-03-27 00:35:51 - ! [298] SQLServer Error: 10060, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2005-03-27 00:35:51 - ! [000] Unable to connect to server 'WKRZ\PRODUCTI
ON';
SQLServerAgent cannot start
2005-03-27 00:35:51 - ? [098] SQLServerAgent terminated (normally)
rdgs
"maxzsim" wrote:

> Hi,
> i am running SQL server 2000 evaluation copy on SQL server 2003 and
> suddenly i cannot open my EM
> From Service Manager , i can start SQL Server but not SQL Agent, From E
M
> , i could not connect to my SQL Database
> it says : "connection could not be established ... Access denied or SQL
> Server does not exist"
> Appreciate any advice
> tks & rdgs|||Hi
Running an evaluation copy on an instance called Production sounds very
suspicious!
Have you seen:
http://support.microsoft.com/defaul...kb;en-us;237604
John
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:C7AB28C2-5EEA-49BA-BB33-4A834AD400CA@.microsoft.com...[vbcol=seagreen]
> Hi ,
> here's the error msg from ErrorLog:
> 2005-03-27 00:35:51 - ! [298] SQLServer Error: 17, SQL Server does not
> exist
> or access denied. [SQLSTATE 08001]
> 2005-03-27 00:35:51 - ! [298] SQLServer Error: 10060, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2005-03-27 00:35:51 - ! [000] Unable to connect to server
> 'WKRZ\PRODUCTION';
> SQLServerAgent cannot start
> 2005-03-27 00:35:51 - ? [098] SQLServerAgent terminated (normally)
> rdgs
> "maxzsim" wrote:
>

Cannot start SQL Server & Sql Agent

Hi,
i am running SQL server 2000 evaluation copy on SQL server 2003 and
suddenly i cannot open my EM
From Service Manager , i can start SQL Server but not SQL Agent, From EM
, i could not connect to my SQL Database
it says : "connection could not be established ... Access denied or SQL
Server does not exist"
Appreciate any advice
tks & rdgsHi ,
here's the error msg from ErrorLog:
2005-03-27 00:35:51 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2005-03-27 00:35:51 - ! [298] SQLServer Error: 10060, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2005-03-27 00:35:51 - ! [000] Unable to connect to server 'WKRZ\PRODUCTION';
SQLServerAgent cannot start
2005-03-27 00:35:51 - ? [098] SQLServerAgent terminated (normally)
rdgs
"maxzsim" wrote:
> Hi,
> i am running SQL server 2000 evaluation copy on SQL server 2003 and
> suddenly i cannot open my EM
> From Service Manager , i can start SQL Server but not SQL Agent, From EM
> , i could not connect to my SQL Database
> it says : "connection could not be established ... Access denied or SQL
> Server does not exist"
> Appreciate any advice
> tks & rdgs|||Hi
Running an evaluation copy on an instance called Production sounds very
suspicious!
Have you seen:
http://support.microsoft.com/default.aspx?scid=kb;en-us;237604
John
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:C7AB28C2-5EEA-49BA-BB33-4A834AD400CA@.microsoft.com...
> Hi ,
> here's the error msg from ErrorLog:
> 2005-03-27 00:35:51 - ! [298] SQLServer Error: 17, SQL Server does not
> exist
> or access denied. [SQLSTATE 08001]
> 2005-03-27 00:35:51 - ! [298] SQLServer Error: 10060, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2005-03-27 00:35:51 - ! [000] Unable to connect to server
> 'WKRZ\PRODUCTION';
> SQLServerAgent cannot start
> 2005-03-27 00:35:51 - ? [098] SQLServerAgent terminated (normally)
> rdgs
> "maxzsim" wrote:
>> Hi,
>> i am running SQL server 2000 evaluation copy on SQL server 2003 and
>> suddenly i cannot open my EM
>> From Service Manager , i can start SQL Server but not SQL Agent, From
>> EM
>> , i could not connect to my SQL Database
>> it says : "connection could not be established ... Access denied or SQL
>> Server does not exist"
>> Appreciate any advice
>> tks & rdgs

cannot start SQL server

I was using SQL server service manager with no problem.
I've installed "Business Contact Manager" and now service manager cannot
connect to the server.
Thanks for any advise.
Is the problem that you cannot connect to sql server or that the service
itself cannot start. You can try starting the service through the services
MMC instead of through service manager, by going to:
start->run->services.msc, look for the MSSQLServer (or MSSQL$INSTANCENAME)
service and do a right click->start.
What error are you seeing?
You can check this KB for some suggestions on how to troubleshoot SQL
connectivity:
How to troubleshoot connectivity issues in SQL Server 2000 - ID: 827422
http://support.microsoft.com/?id=827422
Also, check the latest SQL Error logs (c:\program files\microsoft sql
server\mssql\LOG\errorlog - the file with no extension is the latest sql
errorlog) and the application system event logs (in event viewer) for any
errors which occur during the time you attempted to start the SQL Service.
HTH,
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

cannot start SQL server

I was using SQL server service manager with no problem.
I've installed "Business Contact Manager" and now service manager cannot
connect to the server.
Thanks for any advise.Is the problem that you cannot connect to sql server or that the service
itself cannot start. You can try starting the service through the services
MMC instead of through service manager, by going to:
start->run->services.msc, look for the MSSQLServer (or MSSQL$INSTANCENAME)
service and do a right click->start.
What error are you seeing?
You can check this KB for some suggestions on how to troubleshoot SQL
connectivity:
How to troubleshoot connectivity issues in SQL Server 2000 - ID: 827422
http://support.microsoft.com/?id=827422
Also, check the latest SQL Error logs (c:\program files\microsoft sql
server\mssql\LOG\errorlog - the file with no extension is the latest sql
errorlog) and the application system event logs (in event viewer) for any
errors which occur during the time you attempted to start the SQL Service.
HTH,
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Cannot start sql agent in 2005

I get this message when I try to start a sql 2005 server agent. Im
running windows 2003 service pack 1 and sql 2005 service pack 1. The
strange thing is the agent and sql service are running as a domain
account with sysadmin privileges.
Can anyone help?
SQLServerAgent could not be started (reason: SQLServerAgent must be
able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
member of the SysAdmin role).You can see the login attributes used by Agent if you in SSMS right-click Agent, the Connection
page. Make sure that this account/login exists and a login in SQL Server and that it has sysadmin
privileges in SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Blakmk" <M.G.Blakey@.googlemail.com> wrote in message
news:1162379472.947639.182570@.b28g2000cwb.googlegroups.com...
>I get this message when I try to start a sql 2005 server agent. Im
> running windows 2003 service pack 1 and sql 2005 service pack 1. The
> strange thing is the agent and sql service are running as a domain
> account with sysadmin privileges.
> Can anyone help?
> SQLServerAgent could not be started (reason: SQLServerAgent must be
> able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
> member of the SysAdmin role).
>

Cannot start sql agent in 2005

I get this message when I try to start a sql 2005 server agent. Im
running windows 2003 service pack 1 and sql 2005 service pack 1. The
strange thing is the agent and sql service are running as a domain
account with sysadmin privileges.
Can anyone help?
SQLServerAgent could not be started (reason: SQLServerAgent must be
able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
member of the SysAdmin role).You can see the login attributes used by Agent if you in SSMS right-click Ag
ent, the Connection
page. Make sure that this account/login exists and a login in SQL Server and
that it has sysadmin
privileges in SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Blakmk" <M.G.Blakey@.googlemail.com> wrote in message
news:1162379472.947639.182570@.b28g2000cwb.googlegroups.com...
>I get this message when I try to start a sql 2005 server agent. Im
> running windows 2003 service pack 1 and sql 2005 service pack 1. The
> strange thing is the agent and sql service are running as a domain
> account with sysadmin privileges.
> Can anyone help?
> SQLServerAgent could not be started (reason: SQLServerAgent must be
> able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
> member of the SysAdmin role).
>

Cannot start SQL 2000

I installed a SQL6.5 to a server which is already have a
SQL 2000 running. However, both sql 6.5 and 2000 are
failed to start. Anyone have an idea?
Thanks.What errors are you getting in the SQL Server error logs and the event
viewer?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Charles Lee" <leech@.dnb.com> wrote in message
news:21d3a01c45cfd$bcbd2450$a601280a@.phx.gbl...
I installed a SQL6.5 to a server which is already have a
SQL 2000 running. However, both sql 6.5 and 2000 are
failed to start. Anyone have an idea?
Thanks.|||Hi,
If you have an default instance of SQL 2000 installed already, then you can
not start the SQL 6.5 service and run in parellel.
To trobleshoot , Go to command prompt and go to the SQL 6.5 folder
(\MSSQL\BINN folder).
Now execute
SQLSERVR -m
THis will give you the correct error mesasge to troubleshoot.
Do the same for SQL 2000 as well.
Right way to do is :-
1. Install SQL 6.5
2. Install SQL 2000 Named instance.
So both the services can run in parellel.
Thanks
Hari
MCDBA
"Charles Lee" <leech@.dnb.com> wrote in message
news:21d3a01c45cfd$bcbd2450$a601280a@.phx.gbl...
> I installed a SQL6.5 to a server which is already have a
> SQL 2000 running. However, both sql 6.5 and 2000 are
> failed to start. Anyone have an idea?
> Thanks.|||Hi,
If you have an default instance of SQL 2000 installed already, then you can
not start the SQL 6.5 service and run in parellel.
To trobleshoot , Go to command prompt and go to the SQL 6.5 folder
(\MSSQL\BINN folder).
Now execute
SQLSERVR -m
THis will give you the correct error mesasge to troubleshoot.
Do the same for SQL 2000 as well.
Right way to do is :-
1. Install SQL 6.5
2. Install SQL 2000 Named instance.
So both the services can run in parellel.
Thanks
Hari
MCDBA
"Charles Lee" <leech@.dnb.com> wrote in message
news:21d3a01c45cfd$bcbd2450$a601280a@.phx.gbl...
> I installed a SQL6.5 to a server which is already have a
> SQL 2000 running. However, both sql 6.5 and 2000 are
> failed to start. Anyone have an idea?
> Thanks.|||The message is:
The system is older than SQL Ssrver 7.0 RTM version and
is not supported by this server.
>--Original Message--
>What errors are you getting in the SQL Server error logs
and the event
>viewer?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Charles Lee" <leech@.dnb.com> wrote in message
>news:21d3a01c45cfd$bcbd2450$a601280a@.phx.gbl...
>I installed a SQL6.5 to a server which is already have a
>SQL 2000 running. However, both sql 6.5 and 2000 are
>failed to start. Anyone have an idea?
>Thanks.
>
>.
>|||The message is:
The system is older than SQL Ssrver 7.0 RTM version and
is not supported by this server.
Now, I just want to get rid of 6.5 and keep 2000 since
there are database in 2000.
Thanks.
>--Original Message--
>Hi,
>If you have an default instance of SQL 2000 installed
already, then you can
>not start the SQL 6.5 service and run in parellel.
>To trobleshoot , Go to command prompt and go to the SQL
6.5 folder
>(\MSSQL\BINN folder).
>Now execute
>SQLSERVR -m
>THis will give you the correct error mesasge to
troubleshoot.
>Do the same for SQL 2000 as well.
>Right way to do is :-
>1. Install SQL 6.5
>2. Install SQL 2000 Named instance.
>So both the services can run in parellel.
>Thanks
>Hari
>MCDBA
>
>
>
>"Charles Lee" <leech@.dnb.com> wrote in message
>news:21d3a01c45cfd$bcbd2450$a601280a@.phx.gbl...
>> I installed a SQL6.5 to a server which is already have
a
>> SQL 2000 running. However, both sql 6.5 and 2000 are
>> failed to start. Anyone have an idea?
>> Thanks.
>
>.
>|||Charles
You can install diferent versions of SQL Server on the same server, however you need to install them in the right order. That is 6.5 first, then 7 and finally 2000. As you already had 2000 installed that is why you can not run 6.5. Also if you have mutiple versions of SQL Server you can only run one of them at a time. When you have mutiple versions you get the option to switch between them on your start menu.
You need to uninstall 6.5. If you really want it on the same server. After uninstall, take a backup of your 2000 master and detach all your user databases. Uninstall 2000. Install 6.5. Install 2000. Make sure 2000 is the active service and restore your master database (this is to synch user ID's and loggin's), attach your user databases and you should be up and running. You can then switch between 2000 and 6.5.
If you have some SQL jobs, you can either script them out before uninstalling 2000 or backup and recover the msdb database like the master.
Hope this helps
John|||John,
Thanks for your detailed description. However, I tried
to uninstall 6.5 but it doesn't provide me an option to
do that. It only provide me a install option. Do you
have any idea?
Thanks.
>--Original Message--
>Charles
>You can install diferent versions of SQL Server on the
same server, however you need to install them in the
right order. That is 6.5 first, then 7 and finally 2000.
As you already had 2000 installed that is why you can not
run 6.5. Also if you have mutiple versions of SQL Server
you can only run one of them at a time. When you have
mutiple versions you get the option to switch between
them on your start menu.
>You need to uninstall 6.5. If you really want it on the
same server. After uninstall, take a backup of your 2000
master and detach all your user databases. Uninstall
2000. Install 6.5. Install 2000. Make sure 2000 is the
active service and restore your master database (this is
to synch user ID's and loggin's), attach your user
databases and you should be up and running. You can then
switch between 2000 and 6.5.
>If you have some SQL jobs, you can either script them
out before uninstalling 2000 or backup and recover the
msdb database like the master.
>Hope this helps
>John
>.
>|||Hi,
Please select the SETUP program from SQL 6.5 program group and run the
setup. If you go 2 screens further you have "REMOVE SQL SERVER Option".
If you do not have setup program in SQL Server 6.5 program groups then
select the EXE from \MSSQL\BINN folder of SQL 6.5 installation folder.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:2277001c45d78$98986780$a301280a@.phx.gbl...
> John,
> Thanks for your detailed description. However, I tried
> to uninstall 6.5 but it doesn't provide me an option to
> do that. It only provide me a install option. Do you
> have any idea?
> Thanks.
> >--Original Message--
> >Charles
> >
> >You can install diferent versions of SQL Server on the
> same server, however you need to install them in the
> right order. That is 6.5 first, then 7 and finally 2000.
> As you already had 2000 installed that is why you can not
> run 6.5. Also if you have mutiple versions of SQL Server
> you can only run one of them at a time. When you have
> mutiple versions you get the option to switch between
> them on your start menu.
> >
> >You need to uninstall 6.5. If you really want it on the
> same server. After uninstall, take a backup of your 2000
> master and detach all your user databases. Uninstall
> 2000. Install 6.5. Install 2000. Make sure 2000 is the
> active service and restore your master database (this is
> to synch user ID's and loggin's), attach your user
> databases and you should be up and running. You can then
> switch between 2000 and 6.5.
> >
> >If you have some SQL jobs, you can either script them
> out before uninstalling 2000 or backup and recover the
> msdb database like the master.
> >
> >Hope this helps
> >
> >John
> >.
> >|||Hi,
I tried it but it is grey. I can't select it.
>--Original Message--
>Hi,
>Please select the SETUP program from SQL 6.5 program
group and run the
>setup. If you go 2 screens further you have "REMOVE SQL
SERVER Option".
>If you do not have setup program in SQL Server 6.5
program groups then
>select the EXE from \MSSQL\BINN folder of SQL 6.5
installation folder.
>
>Thanks
>Hari
>MCDBA
><anonymous@.discussions.microsoft.com> wrote in message
>news:2277001c45d78$98986780$a301280a@.phx.gbl...
>> John,
>> Thanks for your detailed description. However, I tried
>> to uninstall 6.5 but it doesn't provide me an option to
>> do that. It only provide me a install option. Do you
>> have any idea?
>> Thanks.
>> >--Original Message--
>> >Charles
>> >
>> >You can install diferent versions of SQL Server on the
>> same server, however you need to install them in the
>> right order. That is 6.5 first, then 7 and finally
2000.
>> As you already had 2000 installed that is why you can
not
>> run 6.5. Also if you have mutiple versions of SQL
Server
>> you can only run one of them at a time. When you have
>> mutiple versions you get the option to switch between
>> them on your start menu.
>> >
>> >You need to uninstall 6.5. If you really want it on
the
>> same server. After uninstall, take a backup of your
2000
>> master and detach all your user databases. Uninstall
>> 2000. Install 6.5. Install 2000. Make sure 2000 is the
>> active service and restore your master database (this
is
>> to synch user ID's and loggin's), attach your user
>> databases and you should be up and running. You can
then
>> switch between 2000 and 6.5.
>> >
>> >If you have some SQL jobs, you can either script them
>> out before uninstalling 2000 or backup and recover the
>> msdb database like the master.
>> >
>> >Hope this helps
>> >
>> >John
>> >.
>> >
>
>.
>|||How about in your SQL Server 2000 group? Or the "SQL Server 2000 - Switch" group?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Charles Lee" <leech@.dnb.com> wrote in message news:2279f01c45d7e$b92c57d0$a301280a@.phx.gbl...
> Hi,
> I tried it but it is grey. I can't select it.
> >--Original Message--
> >Hi,
> >
> >Please select the SETUP program from SQL 6.5 program
> group and run the
> >setup. If you go 2 screens further you have "REMOVE SQL
> SERVER Option".
> >
> >If you do not have setup program in SQL Server 6.5
> program groups then
> >select the EXE from \MSSQL\BINN folder of SQL 6.5
> installation folder.
> >
> >
> >
> >Thanks
> >Hari
> >MCDBA
> >
> ><anonymous@.discussions.microsoft.com> wrote in message
> >news:2277001c45d78$98986780$a301280a@.phx.gbl...
> >> John,
> >>
> >> Thanks for your detailed description. However, I tried
> >> to uninstall 6.5 but it doesn't provide me an option to
> >> do that. It only provide me a install option. Do you
> >> have any idea?
> >>
> >> Thanks.
> >>
> >> >--Original Message--
> >> >Charles
> >> >
> >> >You can install diferent versions of SQL Server on the
> >> same server, however you need to install them in the
> >> right order. That is 6.5 first, then 7 and finally
> 2000.
> >> As you already had 2000 installed that is why you can
> not
> >> run 6.5. Also if you have mutiple versions of SQL
> Server
> >> you can only run one of them at a time. When you have
> >> mutiple versions you get the option to switch between
> >> them on your start menu.
> >> >
> >> >You need to uninstall 6.5. If you really want it on
> the
> >> same server. After uninstall, take a backup of your
> 2000
> >> master and detach all your user databases. Uninstall
> >> 2000. Install 6.5. Install 2000. Make sure 2000 is the
> >> active service and restore your master database (this
> is
> >> to synch user ID's and loggin's), attach your user
> >> databases and you should be up and running. You can
> then
> >> switch between 2000 and 6.5.
> >> >
> >> >If you have some SQL jobs, you can either script them
> >> out before uninstalling 2000 or backup and recover the
> >> msdb database like the master.
> >> >
> >> >Hope this helps
> >> >
> >> >John
> >> >.
> >> >
> >
> >
> >.
> >|||Hi Tiber/Charles Lee,
It seems your SQL 6.5 is not installed properly, Might be a registrry issue.
In this case only solution is
remove manually. But this may not make your SQl 2000 server as default. So
solution to
make your SQL 2000 up is:- Since your SQl 2000 service is down you can
detach aswell.
1. Remove SQL 6.5 manually and tr restarting SQL 2000. If it fails then:-
2. Copy the MDF and LDF (including system databases) to a safe location.
3. Remove SQL 2000 (Use control panel add remove programs)
4. Install SQl 2000 in the same folder structure as old
5. Install the service pack saem as old
6. Stop sql server
7. COpy the MDF and LDF (taken in step -2) to the same folders
8. Start SQl server service.
Link to manually remove sql 6.5
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:
80/support/kb/articles/q198/6/80.asp&NoWebContent=1
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:#of30aaXEHA.2364@.TK2MSFTNGP12.phx.gbl...
> How about in your SQL Server 2000 group? Or the "SQL Server 2000 - Switch"
group?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Charles Lee" <leech@.dnb.com> wrote in message
news:2279f01c45d7e$b92c57d0$a301280a@.phx.gbl...
> > Hi,
> >
> > I tried it but it is grey. I can't select it.
> >
> > >--Original Message--
> > >Hi,
> > >
> > >Please select the SETUP program from SQL 6.5 program
> > group and run the
> > >setup. If you go 2 screens further you have "REMOVE SQL
> > SERVER Option".
> > >
> > >If you do not have setup program in SQL Server 6.5
> > program groups then
> > >select the EXE from \MSSQL\BINN folder of SQL 6.5
> > installation folder.
> > >
> > >
> > >
> > >Thanks
> > >Hari
> > >MCDBA
> > >
> > ><anonymous@.discussions.microsoft.com> wrote in message
> > >news:2277001c45d78$98986780$a301280a@.phx.gbl...
> > >> John,
> > >>
> > >> Thanks for your detailed description. However, I tried
> > >> to uninstall 6.5 but it doesn't provide me an option to
> > >> do that. It only provide me a install option. Do you
> > >> have any idea?
> > >>
> > >> Thanks.
> > >>
> > >> >--Original Message--
> > >> >Charles
> > >> >
> > >> >You can install diferent versions of SQL Server on the
> > >> same server, however you need to install them in the
> > >> right order. That is 6.5 first, then 7 and finally
> > 2000.
> > >> As you already had 2000 installed that is why you can
> > not
> > >> run 6.5. Also if you have mutiple versions of SQL
> > Server
> > >> you can only run one of them at a time. When you have
> > >> mutiple versions you get the option to switch between
> > >> them on your start menu.
> > >> >
> > >> >You need to uninstall 6.5. If you really want it on
> > the
> > >> same server. After uninstall, take a backup of your
> > 2000
> > >> master and detach all your user databases. Uninstall
> > >> 2000. Install 6.5. Install 2000. Make sure 2000 is the
> > >> active service and restore your master database (this
> > is
> > >> to synch user ID's and loggin's), attach your user
> > >> databases and you should be up and running. You can
> > then
> > >> switch between 2000 and 6.5.
> > >> >
> > >> >If you have some SQL jobs, you can either script them
> > >> out before uninstalling 2000 or backup and recover the
> > >> msdb database like the master.
> > >> >
> > >> >Hope this helps
> > >> >
> > >> >John
> > >> >.
> > >> >
> > >
> > >
> > >.
> > >
>

Cannot start service

I am VERY NEW to SQL server. I hope you will pardon my total ignorance.
That said:
I have installed SQL Server 2000 Developer Edition on my local PC running
Windows XP Home Edition.
From the CD I installed everything under the "SQL Server 2000 Components"
menu item on the install disk.
I now have an icon in the system tray for the SQL Server Service Manager.
When I open that icon I see a server name (the network name of my local PC,
I have 2 computers on a small network)
I see SQL Sever in the Services box.
There's a message on the bottom of that window that says:
Stopped - \\700XL - MSSQL Server (700XL is my computer name)
When I click on the Start/Continue button I get the following error message:
ERROR
The service did not start due to logon failure.
When I click OK I get the following message:
SQL Server Service Manager
An error 1069 - (The service did not start due to a logon failure.)
occurred while perfomring this service operation on teh MSSQLServer service.
According to the Enterprise Manager I am using Windows Authentication.
I don't even know where to begin. Can anyone help me please?
Thank you
MarkThis is a Windows problem. Windows tries to start the service using the
account you have specified. However, the password that Windows is using is
incorrect, so it cannot login for the service. Administrative tools,
Services, and there you need to specify the correct password for the SQL
Server service.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"markPanger" <no_spam_mpanger@.fastmail.fm> wrote in message
news:%23L1oHMD7DHA.2540@.TK2MSFTNGP11.phx.gbl...
> I am VERY NEW to SQL server. I hope you will pardon my total ignorance.
> That said:
> I have installed SQL Server 2000 Developer Edition on my local PC running
> Windows XP Home Edition.
> From the CD I installed everything under the "SQL Server 2000 Components"
> menu item on the install disk.
> I now have an icon in the system tray for the SQL Server Service Manager.
> When I open that icon I see a server name (the network name of my local
PC,
> I have 2 computers on a small network)
> I see SQL Sever in the Services box.
> There's a message on the bottom of that window that says:
> Stopped - \\700XL - MSSQL Server (700XL is my computer name)
> When I click on the Start/Continue button I get the following error
message:
> ERROR
> The service did not start due to logon failure.
> When I click OK I get the following message:
> SQL Server Service Manager
> An error 1069 - (The service did not start due to a logon
failure.)
> occurred while perfomring this service operation on teh MSSQLServer
service.
> According to the Enterprise Manager I am using Windows Authentication.
> I don't even know where to begin. Can anyone help me please?
> Thank you
> Mark
>
>
>
>|||Wohoo!! (In my best Homer Simpson voice).
When I set the MSSQL Server properties log on as "Local System account", it
worked.
I'm hoping that setting isn't going to cause me a different problem
elsewhere.
Thank you for the nearly instantaneous response,Tibor!
Mark :-)
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ODeJySD7DHA.2064@.TK2MSFTNGP11.phx.gbl...
> This is a Windows problem. Windows tries to start the service using the
> account you have specified. However, the password that Windows is using is
> incorrect, so it cannot login for the service. Administrative tools,
> Services, and there you need to specify the correct password for the SQL
> Server service.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "markPanger" <no_spam_mpanger@.fastmail.fm> wrote in message
> news:%23L1oHMD7DHA.2540@.TK2MSFTNGP11.phx.gbl...
> > I am VERY NEW to SQL server. I hope you will pardon my total ignorance.
> >
> > That said:
> > I have installed SQL Server 2000 Developer Edition on my local PC
running
> > Windows XP Home Edition.
> >
> > From the CD I installed everything under the "SQL Server 2000
Components"
> > menu item on the install disk.
> >
> > I now have an icon in the system tray for the SQL Server Service
Manager.
> >
> > When I open that icon I see a server name (the network name of my local
> PC,
> > I have 2 computers on a small network)
> >
> > I see SQL Sever in the Services box.
> >
> > There's a message on the bottom of that window that says:
> > Stopped - \\700XL - MSSQL Server (700XL is my computer name)
> >
> > When I click on the Start/Continue button I get the following error
> message:
> > ERROR
> > The service did not start due to logon failure.
> >
> > When I click OK I get the following message:
> > SQL Server Service Manager
> > An error 1069 - (The service did not start due to a logon
> failure.)
> > occurred while perfomring this service operation on teh MSSQLServer
> service.
> >
> > According to the Enterprise Manager I am using Windows Authentication.
> >
> > I don't even know where to begin. Can anyone help me please?
> >
> > Thank you
> > Mark
> >
> >
> >
> >
> >
> >
> >
>|||> Wohoo!! (In my best Homer Simpson voice).
LOL :-)
You might want to search in Books Online for "level token". That will lead you to the section which
descries the service account, and stuff like that.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"markPanger" <no_spam_mpanger@.fastmail.fm> wrote in message
news:OnD2kkD7DHA.2556@.TK2MSFTNGP09.phx.gbl...
> Wohoo!! (In my best Homer Simpson voice).
> When I set the MSSQL Server properties log on as "Local System account", it
> worked.
> I'm hoping that setting isn't going to cause me a different problem
> elsewhere.
> Thank you for the nearly instantaneous response,Tibor!
> Mark :-)
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:ODeJySD7DHA.2064@.TK2MSFTNGP11.phx.gbl...
> > This is a Windows problem. Windows tries to start the service using the
> > account you have specified. However, the password that Windows is using is
> > incorrect, so it cannot login for the service. Administrative tools,
> > Services, and there you need to specify the correct password for the SQL
> > Server service.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
> >
> http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "markPanger" <no_spam_mpanger@.fastmail.fm> wrote in message
> > news:%23L1oHMD7DHA.2540@.TK2MSFTNGP11.phx.gbl...
> > > I am VERY NEW to SQL server. I hope you will pardon my total ignorance.
> > >
> > > That said:
> > > I have installed SQL Server 2000 Developer Edition on my local PC
> running
> > > Windows XP Home Edition.
> > >
> > > From the CD I installed everything under the "SQL Server 2000
> Components"
> > > menu item on the install disk.
> > >
> > > I now have an icon in the system tray for the SQL Server Service
> Manager.
> > >
> > > When I open that icon I see a server name (the network name of my local
> > PC,
> > > I have 2 computers on a small network)
> > >
> > > I see SQL Sever in the Services box.
> > >
> > > There's a message on the bottom of that window that says:
> > > Stopped - \\700XL - MSSQL Server (700XL is my computer name)
> > >
> > > When I click on the Start/Continue button I get the following error
> > message:
> > > ERROR
> > > The service did not start due to logon failure.
> > >
> > > When I click OK I get the following message:
> > > SQL Server Service Manager
> > > An error 1069 - (The service did not start due to a logon
> > failure.)
> > > occurred while perfomring this service operation on teh MSSQLServer
> > service.
> > >
> > > According to the Enterprise Manager I am using Windows Authentication.
> > >
> > > I don't even know where to begin. Can anyone help me please?
> > >
> > > Thank you
> > > Mark
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>

Cannot start service

Cannot start Reporting Service

Hi
when i try starting http://localhost/ReportServer i get the error
(rsReportserverdatabaseLogonFailed)
The RPC server is not listenning
Can anyone helpTry starting the ReportServer windows service. If it does not start, look
in the ReportServerService<date>.log file for information on the failure.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"SJ" <SJ@.discussions.microsoft.com> wrote in message
news:C186CA94-D4ED-4717-80A6-FF97BBED8057@.microsoft.com...
> Hi
> when i try starting http://localhost/ReportServer i get the error
> (rsReportserverdatabaseLogonFailed)
> The RPC server is not listenning
> Can anyone help

cannot start report server on local computer

HI,

I tried to deploy reports on locahost. Yet, I still need to start the mssqlserver service on local computer. I tried all the possibilities shown from the help but still i can't have it started. How will i start mssqlserver service on local computer alone?

thanks

soWillingToLearn,

What are your settings for the msSQLserver service LogOn? Can you check your application log file under Event Viewer to see what error message is being generated.

Ham

cannot start or verify that SQL 2005 is running

Hi,

I am new to sql 2005.

I have installed a trial version of 2005 enterprise edition.

After installing I went to Management Studio. I noticed that the server name

dropdown menu was blank so I tried to browse. No server names appear under local

or network servers. I then went to configuration manager and noticed that

although client protocols are listed under SQL client native config,

SQL server 2005 services and sql server 2005 network config are both blank. Is SQL

installed correctly? I hope this is enough info to illicit a helpful response.

Thank You.

Problem solved. I went to add remove apps and clicked change

on Microsoft SQL Server 2005 button. I am not sure what Microsoft

SQL Server Native Client is so I didn't mess with it. I saw that no instances

were listed under SQL Server 2005 instances so I clicked away until I had

added an instance - MSSQLSERVER. I am going to be using .net 2.0 framework

objects to connect to SQL so I am not sure if I messed up by Not installing in

mixed mode. Any advice on the mixed mode issue would be appreciated.

|||If you have no need for mixed mode, then don't install it. It kind of sounds like you don't so no worries.

cannot start MSSQLServerOLAPService....error 1058: the service cannot be started

sql 2000 w/ sp4 running on w2k3 using sql authenitcation......olap service
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.OS error 1058 means "The service cannot be started, either because it is
disabled or because it has no enabled devices associated with it".
So, from the services applet, have you made sure the service is not
disabled?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"madman_miceli" <madman@.amiceli.com> wrote in message
news:eVQK11JmFHA.3312@.tk2msftngp13.phx.gbl...
sql 2000 w/ sp4 running on w2k3 using sql authenitcation......olap service
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.

cannot start MSSQLServerOLAPService....error 1058: the service cannot be started

sql 2000 w/ sp4 running on w2k3 using sql authenitcation......olap service
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.
OS error 1058 means "The service cannot be started, either because it is
disabled or because it has no enabled devices associated with it".
So, from the services applet, have you made sure the service is not
disabled?
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"madman_miceli" <madman@.amiceli.com> wrote in message
news:eVQK11JmFHA.3312@.tk2msftngp13.phx.gbl...
sql 2000 w/ sp4 running on w2k3 using sql authenitcation......olap service
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.

cannot start MSSQLServerOLAPService....error 1058: the service cannot be started

sql 2000 w/ sp4 running on w2k3 using sql authenitcation......olap service
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.OS error 1058 means "The service cannot be started, either because it is
disabled or because it has no enabled devices associated with it".
So, from the services applet, have you made sure the service is not
disabled?
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"madman_miceli" <madman@.amiceli.com> wrote in message
news:eVQK11JmFHA.3312@.tk2msftngp13.phx.gbl...
sql 2000 w/ sp4 running on w2k3 using sql authenitcation......olap service
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.

Cannot start MSSQL Server 7

I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.
When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,
The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Please help.
Could you check the SQL Server error log and let us know if there are any
errors? Also check the event viewer. You can find the error log in MSSQL\Log
folder.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1115975209.034211.143030@.g49g2000cwa.googlegr oups.com...
I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.
When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,
The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Please help.

Cannot start MSSQL Server 7

I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.
When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,
The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Please help.
Check the eventlog as well as SQL Servers errorlog file for error messages from SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1115975275.910843.25370@.g44g2000cwa.googlegro ups.com...
>I am not able to start the MSSQL Server service on my system ever since
> I shifted my house and got a new network provider. Earlier, I was on
> the local cable hub, now my computer is on a DSL network. I don't know
> if the network would have something to do with it, but I am just
> providing information for the sake of completeness.
> When I try starting MSSQL Server from the Services applet in the
> Administrative Tools in Control Panel, I get a message saying,
>
> The MSSQLServer service on Local Computer started and then stopped.
> Some services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service.
>
> Please help.
>

Cannot start MSSQL Server 7

When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,

The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service."

Please help.Water Cooler v2 (wtr_clr@.yahoo.com) writes:
> I am not able to start the MSSQL Server service on my system ever since
> I shifted my house and got a new network provider. Earlier, I was on
> the local cable hub, now my computer is on a DSL network. I don't know
> if the network would have something to do with it, but I am just
> providing information for the sake of completeness.
> When I try starting MSSQL Server from the Services applet in the
> Administrative Tools in Control Panel, I get a message saying,
> The MSSQLServer service on Local Computer started and then stopped.
> Some services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service."

You need to check the SQL Server errorlog, which is in
C:\Progam Files\Microsoft SQL Server\MSSQL\Logs. There is ERRORLOG and
then ERRORLOG.1 to .6, which are the most recent logs.

The only reason I can think of why SQL Server would start and then
stop, is that it runs into a fatal error.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Cannot start MSSQL Server 7

I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.
When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,
The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Please help.
Please do not multi-post. Many people have answered this in different
newsgroups.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1115975222.812999.50190@.g49g2000cwa.googlegro ups.com...
I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.
When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,
The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Please help.

Cannot start MSSQL Server 7

I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.
When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,
The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Please help.Check the eventlog as well as SQL Servers errorlog file for error messages from SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1115975275.910843.25370@.g44g2000cwa.googlegroups.com...
>I am not able to start the MSSQL Server service on my system ever since
> I shifted my house and got a new network provider. Earlier, I was on
> the local cable hub, now my computer is on a DSL network. I don't know
> if the network would have something to do with it, but I am just
> providing information for the sake of completeness.
> When I try starting MSSQL Server from the Services applet in the
> Administrative Tools in Control Panel, I get a message saying,
>
> The MSSQLServer service on Local Computer started and then stopped.
> Some services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service.
>
> Please help.
>

Cannot start MSSQL Server 7

I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.
When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,
The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Please help.Please do not multi-post. Many people have answered this in different
newsgroups.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1115975222.812999.50190@.g49g2000cwa.googlegroups.com...
I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.
When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,
The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Please help.

cannot start more transactions on this session

when I modify data in Enterprise manager, I get the message
"cannot start more transactions on this session"
Why?Is the data your modifying contained within a view rather than a table..?
--
HTH
Ryan Waight, MCDBA, MCSE
"haode" <iamjhkang@.hotmail.com> wrote in message
news:enVQjp1oDHA.1740@.TK2MSFTNGP12.phx.gbl...
> when I modify data in Enterprise manager, I get the message
> "cannot start more transactions on this session"
> Why?
>|||It is a table for sure.
"Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:uepb573oDHA.3256@.tk2msftngp13.phx.gbl...
> Is the data your modifying contained within a view rather than a table..?
> --
> HTH
> Ryan Waight, MCDBA, MCSE
> "haode" <iamjhkang@.hotmail.com> wrote in message
> news:enVQjp1oDHA.1740@.TK2MSFTNGP12.phx.gbl...
> > when I modify data in Enterprise manager, I get the message
> > "cannot start more transactions on this session"
> >
> > Why?
> >
> >
>

Cannot start Microsoft SQL Server agent & Enterprise manager

Hi:
I am receiving the following error message while trying to open Enterprise
Manager in MSSQL 2000 Server.
A connection could not be established to ABCD
Reason : I/O error 1117(the request could not performed because of an I/O
device error.) detected during read at offset 0x00000000b1e000 in file
'Drive:\Microsoft SQL Server\MSSQL\data\master.mdf'..
Please verify SQL Server is running and check your SQL Server registration
properties (by right cliking on the ABCD node) and try again.
This is a Windows 2000 server (Service Pack 4) + MSSQL 2000 (service Pack
3). The MSSQL server service SQL Server Agent services are running under
local system. This is a Standalone machine.
Help is required on an urgent basis as this is a production server.
With Regards
Mitul
You have a problem with the mdf file for your master database file. Possibly the file is locked by
some other process (like anti-virus). If that is the case, try again. If you are unlucky, the master
mdf file is corrupt for some reason, and you have to go the rebuildm.exe route.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mitul" <Mitul@.discussions.microsoft.com> wrote in message
news:46466B5B-D821-4C07-BD8C-8996EBAD7915@.microsoft.com...
> Hi:
> I am receiving the following error message while trying to open Enterprise
> Manager in MSSQL 2000 Server.
>
> A connection could not be established to ABCD
> Reason : I/O error 1117(the request could not performed because of an I/O
> device error.) detected during read at offset 0x00000000b1e000 in file
> 'Drive:\Microsoft SQL Server\MSSQL\data\master.mdf'..
> Please verify SQL Server is running and check your SQL Server registration
> properties (by right cliking on the ABCD node) and try again.
>
> This is a Windows 2000 server (Service Pack 4) + MSSQL 2000 (service Pack
> 3). The MSSQL server service SQL Server Agent services are running under
> local system. This is a Standalone machine.
> Help is required on an urgent basis as this is a production server.
> With Regards
> Mitul

Cannot start Microsoft SQL Server agent & Enterprise manager

Hi:
I am receiving the following error message while trying to open Enterprise
Manager in MSSQL 2000 Server.
---
A connection could not be established to ABCD
Reason : I/O error 1117(the request could not performed because of an I/O
device error.) detected during read at offset 0x00000000b1e000 in file
'Drive:\Microsoft SQL Server\MSSQL\data\master.mdf'..
Please verify SQL Server is running and check your SQL Server registration
properties (by right cliking on the ABCD node) and try again.
---
This is a Windows 2000 server (Service Pack 4) + MSSQL 2000 (service Pack
3). The MSSQL server service SQL Server Agent services are running under
local system. This is a Standalone machine.
Help is required on an urgent basis as this is a production server.
With Regards
MitulYou have a problem with the mdf file for your master database file. Possibly the file is locked by
some other process (like anti-virus). If that is the case, try again. If you are unlucky, the master
mdf file is corrupt for some reason, and you have to go the rebuildm.exe route.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mitul" <Mitul@.discussions.microsoft.com> wrote in message
news:46466B5B-D821-4C07-BD8C-8996EBAD7915@.microsoft.com...
> Hi:
> I am receiving the following error message while trying to open Enterprise
> Manager in MSSQL 2000 Server.
> ---
> A connection could not be established to ABCD
> Reason : I/O error 1117(the request could not performed because of an I/O
> device error.) detected during read at offset 0x00000000b1e000 in file
> 'Drive:\Microsoft SQL Server\MSSQL\data\master.mdf'..
> Please verify SQL Server is running and check your SQL Server registration
> properties (by right cliking on the ABCD node) and try again.
> ---
> This is a Windows 2000 server (Service Pack 4) + MSSQL 2000 (service Pack
> 3). The MSSQL server service SQL Server Agent services are running under
> local system. This is a Standalone machine.
> Help is required on an urgent basis as this is a production server.
> With Regards
> Mitul

Cannot start Log Reader Agent and Snapshot Agent

I am testing peer to peer replication in our environment. I simulated a three node peer to peer topology and a local distributor.

For some wierd reason I cannot get the Log Reader Agent and snapshot agent to start. The domain account under which SQL Server Agent runs has administrator previlage on the box. I also use a domain account for SQL Server Service. (none of the passwords changed).

This is the error I am getting - "Executed as user: abc. A required privilege is not held by the client. The step failed"

Any ideas?

Also this domain account is a member of

SQLServer2005MSSQLUsers$ServerName$MSSQLSERVER

SQLServer2005MSAgentUser$ServerName$MSSQLSERVER

open the properties of each job and change the owner to sa and it should work fine.|||I tried it. No luck...it gives the same error message

Cannot start Integration Services

Hi,
I would like to use the features of the Integration Service on SQL Server
2005.
Therefore I have to connect to Server type Integration Services.
When I connect, it is trying to connect for 30 seconds and then it displays
the message that the service did not respond to the start or control request
in a timely fashion.
When I try to start the integrated services service, it won't start.
The error I am getting is:
Could not start the SQL Server Integration Services service on Local
Computer.
Error 1053: The service did not respond to the start or control request in a
timely fashion.
In the Event Log the following 2 errors are created:
ID 7000:
The SQL Server Integration Services service failed to start due to the
following error:
The service did not respond to the start or control request in a timely
fashion.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
ID 7009:
Timeout (30000 milliseconds) waiting for the SQL Server Integration Services
service to connect.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
When I follow this hyperlink, a page is displayed with information how to
display the WIN32_EXIT_CODE error.
It tells me to type sc query <service name> from the command prompt.
I have not been able to see this error code, because I don't know the exact
name of the service.
I tried all kinds of variations of the name, in- and excluding spaces and
qoutes, but everytime I got this error:
The specified service does not exist as an installed service.
I am working with SQL Server 2005 on a Windows 2003 server.
Any ideas?Please see if this applies: http://support.microsoft.com/kb/918644
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||It is working fine now, although there were lots of errors in the
installation logs of each update.
The errors reported failures of verifying the correct version of installed
files and some registry keys.
Thanks,
John.
Paul Ibison <Paul.Ibison@.Pygmalion.Com> wrote in message
news:#qFHBrnLHHA.4928@.TK2MSFTNGP06.phx.gbl...
> Please see if this applies: http://support.microsoft.com/kb/918644
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>

Saturday, February 25, 2012

Cannot start SQL Server 2005 management express studio CTP?

Cannot start SQL Server 2005 management express studio CTP?

Cannot start SQL Server 2005 management express studio CTP?

Cannot Start SQL Server 2000 after installing Vista

Cannot start SQL Server & Sql Agent

Cannot start SQL Server & Sql Agent

Cannot start SQL Server & Sql Agent

cannot start SQL server

cannot start SQL server

Cannot start sql agent in 2005

Cannot start sql agent in 2005

Cannot start SQL 2000

Cannot start SQL 2000

Cannot start SQL 2000

Cannot start service

Cannot start service

Cannot start Reporting Service

cannot start report server on local computer

cannot start or verify that SQL 2005 is running

cannot start MSSQLServerOLAPService....error 1058: the service cannot be started

cannot start MSSQLServerOLAPService....error 1058: the service cannot be started

cannot start MSSQLServerOLAPService....error 1058: the service cannot be started

Cannot start MSSQL Server 7

Cannot start MSSQL Server 7

Cannot start MSSQL Server 7

Cannot start MSSQL Server 7

Cannot start MSSQL Server 7

Cannot start MSSQL Server 7

cannot start more transactions on this session

Cannot start Microsoft SQL Server agent & Enterprise manager

Cannot start Microsoft SQL Server agent & Enterprise manager

Cannot start Log Reader Agent and Snapshot Agent

Cannot start Integration Services

Cannot start Integration Services

Cannot restore database

Blog Archive

About Me