Saturday, February 25, 2012
Cannot start MSSQL Server 7
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 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
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.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 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 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 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.
Thursday, February 16, 2012
Cannot select Provider in Data Source Wizard Connection Manager
I try to create a New Data Source in Data Model project, the dropdown box for
Provider is disabled and so SQLclient Data Provider is all I can do. I would
like to add a connection to an ODBC data source, which I should be able to
do. Any suggestions on what I can change to enable me to select the Provider?Semantic modelling in Model Designer supports native SQL provider only.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shane_SDE" <ShaneSDE@.discussions.microsoft.com> wrote in message
news:054075DE-92DF-4127-9B53-0DB5FEB43670@.microsoft.com...
>I think I either have an option set wrong or installed something wrong.
>When
> I try to create a New Data Source in Data Model project, the dropdown box
> for
> Provider is disabled and so SQLclient Data Provider is all I can do. I
> would
> like to add a connection to an ODBC data source, which I should be able to
> do. Any suggestions on what I can change to enable me to select the
> Provider?
Friday, February 10, 2012
Cannot restore database
FROM DISK = C:\...........
WITH REPLACE
gets the error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could not be
obtained because the database is in use.
This is on my test SQL Server 2000 on my intranet with no other users. Both
Enterprise Manager and Query Analyser are not running.
Please advise.
Seems like someone has a connection to the database. Make sure that the connection from where you do the
restore isn't in the database. Check who is in the database using sp_who or sp_who2.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Roger Withnell" <rogerREMOVE@.THISFIRSTupperbridge.co.uk> wrote in message
news:c9g2ap$s9f$1@.hercules.btinternet.com...
> RESTORE DATABASE upperbridge
> FROM DISK = C:\...........
> WITH REPLACE
> gets the error
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could not be
> obtained because the database is in use.
> This is on my test SQL Server 2000 on my intranet with no other users. Both
> Enterprise Manager and Query Analyser are not running.
> Please advise.
>
>
|||Run sp_who or sp_who2 and see who is connected to it.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Roger Withnell" <rogerREMOVE@.THISFIRSTupperbridge.co.uk> wrote in message
news:c9g2ap$s9f$1@.hercules.btinternet.com...
RESTORE DATABASE upperbridge
FROM DISK = C:\...........
WITH REPLACE
gets the error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could not be
obtained because the database is in use.
This is on my test SQL Server 2000 on my intranet with no other users. Both
Enterprise Manager and Query Analyser are not running.
Please advise.
|||Are you sure that the QA session you're using to restore the database isn't
the one that's using the database? Use sp_who2 to see who's using it.
"Roger Withnell" <rogerREMOVE@.THISFIRSTupperbridge.co.uk> wrote in message
news:c9g2ap$s9f$1@.hercules.btinternet.com...
RESTORE DATABASE upperbridge
FROM DISK = C:\...........
WITH REPLACE
gets the error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could not be
obtained because the database is in use.
This is on my test SQL Server 2000 on my intranet with no other users. Both
Enterprise Manager and Query Analyser are not running.
Please advise.
|||Hi Roger,
Execute the below script from master to restore the database (Execute all
the lines in a together from query analyzer - Replace dbname , filename ,
directory and
logical name based on ur requirement)
use master
go
alter database <dbname> set single_user with rollback immediate
go
restore database <dbname> from disk = 'C:\filename.bak' with recovery,
move 'logical_mdf_name' to 'c:\mssql\data\filename.mdf',
move 'logical_ldf_name' to 'c:\mssql\data\filename.ldf'
Thanks
Hari
MCDBA
"Roger Withnell" <rogerREMOVE@.THISFIRSTupperbridge.co.uk> wrote in message
news:c9g2ap$s9f$1@.hercules.btinternet.com...
> RESTORE DATABASE upperbridge
> FROM DISK = C:\...........
> WITH REPLACE
> gets the error
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could not
be
> obtained because the database is in use.
> This is on my test SQL Server 2000 on my intranet with no other users.
Both
> Enterprise Manager and Query Analyser are not running.
> Please advise.
>
>
Cannot restore database
FROM DISK = C:\...........
WITH REPLACE
gets the error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could not be
obtained because the database is in use.
This is on my test SQL Server 2000 on my intranet with no other users. Both
Enterprise Manager and Query Analyser are not running.
Please advise.Run sp_who or sp_who2 and see who is connected to it.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Roger Withnell" <rogerREMOVE@.THISFIRSTupperbridge.co.uk> wrote in message
news:c9g2ap$s9f$1@.hercules.btinternet.com...
RESTORE DATABASE upperbridge
FROM DISK = C:\...........
WITH REPLACE
gets the error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could not be
obtained because the database is in use.
This is on my test SQL Server 2000 on my intranet with no other users. Both
Enterprise Manager and Query Analyser are not running.
Please advise.|||Seems like someone has a connection to the database. Make sure that the connection from where you do the
restore isn't in the database. Check who is in the database using sp_who or sp_who2.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Roger Withnell" <rogerREMOVE@.THISFIRSTupperbridge.co.uk> wrote in message
news:c9g2ap$s9f$1@.hercules.btinternet.com...
> RESTORE DATABASE upperbridge
> FROM DISK = C:\...........
> WITH REPLACE
> gets the error
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could not be
> obtained because the database is in use.
> This is on my test SQL Server 2000 on my intranet with no other users. Both
> Enterprise Manager and Query Analyser are not running.
> Please advise.
>
>|||Are you sure that the QA session you're using to restore the database isn't
the one that's using the database? Use sp_who2 to see who's using it.
"Roger Withnell" <rogerREMOVE@.THISFIRSTupperbridge.co.uk> wrote in message
news:c9g2ap$s9f$1@.hercules.btinternet.com...
RESTORE DATABASE upperbridge
FROM DISK = C:\...........
WITH REPLACE
gets the error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could not be
obtained because the database is in use.
This is on my test SQL Server 2000 on my intranet with no other users. Both
Enterprise Manager and Query Analyser are not running.
Please advise.|||Hi Roger,
Execute the below script from master to restore the database (Execute all
the lines in a together from query analyzer - Replace dbname , filename ,
directory and
logical name based on ur requirement)
use master
go
alter database <dbname> set single_user with rollback immediate
go
restore database <dbname> from disk = 'C:\filename.bak' with recovery,
move 'logical_mdf_name' to 'c:\mssql\data\filename.mdf',
move 'logical_ldf_name' to 'c:\mssql\data\filename.ldf'
Thanks
Hari
MCDBA
"Roger Withnell" <rogerREMOVE@.THISFIRSTupperbridge.co.uk> wrote in message
news:c9g2ap$s9f$1@.hercules.btinternet.com...
> RESTORE DATABASE upperbridge
> FROM DISK = C:\...........
> WITH REPLACE
> gets the error
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could not
be
> obtained because the database is in use.
> This is on my test SQL Server 2000 on my intranet with no other users.
Both
> Enterprise Manager and Query Analyser are not running.
> Please advise.
>
>
Cannot restore database
FROM DISK = C:\...........
WITH REPLACE
gets the error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access
could not be
obtained because the database is in use.
This is on my test SQL Server 2000 on my intranet with no other users. Both
Enterprise Manager and Query Analyser are not running.
Please advise.Seems like someone has a connection to the database. Make sure that the conn
ection from where you do the
restore isn't in the database. Check who is in the database using sp_who or
sp_who2.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Roger Withnell" <rogerREMOVE@.THISFIRSTupperbridge.co.uk> wrote in message
news:c9g2ap$s9f$1@.hercules.btinternet.com...
> RESTORE DATABASE upperbridge
> FROM DISK = C:\...........
> WITH REPLACE
> gets the error
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive acces
s could not be
> obtained because the database is in use.
> This is on my test SQL Server 2000 on my intranet with no other users. Bo
th
> Enterprise Manager and Query Analyser are not running.
> Please advise.
>
>|||Run sp_who or sp_who2 and see who is connected to it.
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Roger Withnell" <rogerREMOVE@.THISFIRSTupperbridge.co.uk> wrote in message
news:c9g2ap$s9f$1@.hercules.btinternet.com...
RESTORE DATABASE upperbridge
FROM DISK = C:\...........
WITH REPLACE
gets the error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access
could not be
obtained because the database is in use.
This is on my test SQL Server 2000 on my intranet with no other users. Both
Enterprise Manager and Query Analyser are not running.
Please advise.|||Are you sure that the QA session you're using to restore the database isn't
the one that's using the database? Use sp_who2 to see who's using it.
"Roger Withnell" <rogerREMOVE@.THISFIRSTupperbridge.co.uk> wrote in message
news:c9g2ap$s9f$1@.hercules.btinternet.com...
RESTORE DATABASE upperbridge
FROM DISK = C:\...........
WITH REPLACE
gets the error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access
could not be
obtained because the database is in use.
This is on my test SQL Server 2000 on my intranet with no other users. Both
Enterprise Manager and Query Analyser are not running.
Please advise.|||Hi Roger,
Execute the below script from master to restore the database (Execute all
the lines in a together from query analyzer - Replace dbname , filename ,
directory and
logical name based on ur requirement)
use master
go
alter database <dbname> set single_user with rollback immediate
go
restore database <dbname> from disk = 'C:\filename.bak' with recovery,
move 'logical_mdf_name' to 'c:\mssql\data\filename.mdf',
move 'logical_ldf_name' to 'c:\mssql\data\filename.ldf'
Thanks
Hari
MCDBA
"Roger Withnell" <rogerREMOVE@.THISFIRSTupperbridge.co.uk> wrote in message
news:c9g2ap$s9f$1@.hercules.btinternet.com...
> RESTORE DATABASE upperbridge
> FROM DISK = C:\...........
> WITH REPLACE
> gets the error
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could
not
be
> obtained because the database is in use.
> This is on my test SQL Server 2000 on my intranet with no other users.
Both
> Enterprise Manager and Query Analyser are not running.
> Please advise.
>
>