Eternal 'Enable Pending' on SQL2005

Hi!

I have this problem... im kinda new to sql2005, and im responsible for creating some notification services.

Ive done a lot of tutorials, books and samples and every time, when i reach the step of enabling the instance, i get this...

Generator-Enable Pending

Distributor-Enable Pending

Even doing the Microsoft's Notification Services Tutorial.

Ive tried everything I could figure, registering the instance with a user with every permission there could be... doing this local or on a client... and ive been 2 weeks stuck here...

Any tip or clue will be thankfull.

M.Eng.Leandro Melendez

Have you started the Windows Service for the instance? If you enable an instance when the service hasn't been started, it'll report a status of pending.

HTH...

|||

Well, i thought that i should start the windows service after enabling the instance... but ive tried also that, ive already tried to start it from the 'SQL Server MAngment Studio' and from 'Services' and both of them give me this message:

TITLE: System.ServiceProcess
Cannot start service NS$Tutorial on computer 'CROSS-AIPZ'.

ADDITIONAL INFORMATION:

The service did not respond to the start or control request in a timely fashion

Any clue what does this means?

|||

That's usually a permissions problem. Check to make sure that the service account has the appropriate permissions in the NS databases.

HTH...

|||Ive tried to give the user the permissions that the tutorial says, also ive tried to give the user every permission i could imagine... and nothing.... do you know what permissions i must give? maybe the tutorial is missing some one|||

Generally speaking, you want to make the login account used by the NS$InstanceName service (either window or SQL Server) a member of the NSRunService database role.

Check out this page in BOL for more detail.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/5a70a24c-25cf-4b77-a3a3-1cdf696d9262.htm

HTH...

Joe

|||

Here's another BOL link that may help, too.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/c20ece76-eca0-463d-a226-ba8e93c9fcb9.htm

Joe

|||

Yeah, i did that and everything i could...

After many searches ive found a comment saying that everything worked after reinstalling sql server 2005...

I did it, ununstall and install... and guess what... it just worked smoothly... any idea why does this happends?

Aniway thanks all

|||

Ouch! That's a pretty drastic step! Glad it worked and thanks for posting the solution.

Haven't had that problem before (thank goodness), so no...no idea what's going on there.

Joe

estimation the buffer cache hit ratio

Hi

I have trouble with MSSQL2000 SP4 (without any hotfixes). During last two
weeks it start works anormally. After last optimalization (about few months
ago) it works good (fast, without blocks). Its buffer cache hit ratio was
about 99.7-99.8. Last day it starts work slow, there was many blocks and
dedlocks. There are no any queries, jobs and applications was added. Now
buffer cache hit ratio oscilate about 95-98. I try update statistics and
reindex some hard used tables, but there is no effect or effect is wery
short (after few hours problem return).

Mayby somene know what it could be?

Is it possible to estimate how each table (using DBCC SHOW_STATISTICS or
DBCC SHOWCONTIG or others) how the table affect on total buffer cache hit
ratio?

Marek

--
www.programowanieobiektowe.plMarek Wierzbicki (marek.wierzbickiiiii@.azymuttttt.pl) writes:

Quote:

Originally Posted by

I have trouble with MSSQL2000 SP4 (without any hotfixes). During last
two weeks it start works anormally. After last optimalization (about few
months ago) it works good (fast, without blocks). Its buffer cache hit
ratio was about 99.7-99.8. Last day it starts work slow, there was many
blocks and dedlocks. There are no any queries, jobs and applications was
added. Now buffer cache hit ratio oscilate about 95-98. I try update
statistics and reindex some hard used tables, but there is no effect or
effect is wery short (after few hours problem return).
>
Mayby somene know what it could be?

I would run Profiler and look for long-running queries. As your amount of
data grows and statistics changes, the optimizer may go for a new plan.

Theoretically, you could also run into that when the amount of data
increases over a threshold value, the memory does no longer suffice for the
typical mix of queries.

--
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

Escpae characters

Hi
I am looking for a reference that lists all special characters in SQL Server
that must be escaped and how
Thank you
Samuel ShulmanSamuel,
have a look in BOL for 'escape characters'. You can use the keyword ESCAPE
to escape a character, and the ones this might apply to are the wildcards
used in pattern matching.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Please view
Escape the '' character
Message that I just sent
T.Y.
Samuel
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:OxUT7b$fGHA.2032@.TK2MSFTNGP0
2.phx.gbl...
> Samuel,
> have a look in BOL for 'escape characters'. You can use the keyword ESCAPE
> to escape a character, and the ones this might apply to are the wildcards
> used in pattern matching.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
>|||Just want to add that whether a character is special and requires escape
depends on the context. The doc under 'escape characters' in BOL talks about
escape characters in search conditions. Delimited identifiers are another
context in which characters such as ] (if delimiters are [ and ]) should
be
escaped.
Linchi
"Paul Ibison" wrote:

> Samuel,
> have a look in BOL for 'escape characters'. You can use the keyword ESCAPE
> to escape a character, and the ones this might apply to are the wildcards
> used in pattern matching.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
>

Escaped URI

Hi
I have a valid and working template which takes 2 parameters and can be accessed
using a URI of the form
http://localhost/dbports/template/tm...65&AddrID=3084
However when I try to include this information in an XSLT transformation using the
document() function it escapes the & in the URIstring to & and accessing the
template using
http://localhost/dbports/template/tm...mp;AddrID=3084
doesn't seem to work. It just returns the following HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252"></HEAD>
<BODY></BODY></HTML>
This must be something simple mustn't it ? Any ideas ?
TIA
Feargal Hogan
Can you please forward the code fragment that does the invocation? Is that
the argument to the document() function or the output of the XSLT that you
then send over HTTP?
Thanks
Michael
"Feargal Hogan" <feargalhNO@.Spam.portinfo.co.uk> wrote in message
news:uVRIGc6rEHA.1232@.TK2MSFTNGP11.phx.gbl...
> Hi
> I have a valid and working template which takes 2 parameters and can be
> accessed
> using a URI of the form
> http://localhost/dbports/template/tm...65&AddrID=3084
> However when I try to include this information in an XSLT transformation
> using the
> document() function it escapes the & in the URIstring to & and
> accessing the
> template using
> http://localhost/dbports/template/tm...mp;AddrID=3084
> doesn't seem to work. It just returns the following HTML
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=Content-Type content="text/html;
> charset=windows-1252"></HEAD>
> <BODY></BODY></HTML>
> This must be something simple mustn't it ? Any ideas ?
> TIA
> Feargal Hogan
>
|||Michael
Thanks. I figured out the problem. I just set disable-output-escaping in
"<xsl:value-of " element
Feargal
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:OcFfI2HsEHA.2136@.TK2MSFTNGP14.phx.gbl...
> Can you please forward the code fragment that does the invocation? Is that
> the argument to the document() function or the output of the XSLT that you
> then send over HTTP?
> Thanks
> Michael
> "Feargal Hogan" <feargalhNO@.Spam.portinfo.co.uk> wrote in message
> news:uVRIGc6rEHA.1232@.TK2MSFTNGP11.phx.gbl...
>

error-1920.service mssqlserver failed

hi
i am trying to install a software package called arrayinformatics. this
comes along with msde as part of it.
when i run the setup for arrayinformatics, as admin, after sometime, the
status of the installshield wizard shows that...
generating script operations for action:......
and thats it..after that nothing happens and i get a dozen dll load
error...starting from...
REPLRES.RLL cannot load resource dll error..
run setup again to install this file...
after clicking ok for a dozen of such error...
the installshield wizard now says that...
error-1920. service mssqlserver failed to start. verify that you have
sufficient privileges to start system services...
and closes,without completing the installation.
i tried installing the msde separately..and it got installed.. and i was
even able to start and stop the services...
but the arrayinformatics doesnt install with a previously installed mssql
server...
so i am struck here...i tried to figure out this problem...searching the net
for the past 2 days and couldnt solve it...
kindly help me..to fix this problem
thanks
vijayaraj nagarajan
graduate student
the university of southern mississippi
MS - USA
hi,
vijayaraj nagarajan wrote:
> hi
> i am trying to install a software package called arrayinformatics.
> this comes along with msde as part of it.
> when i run the setup for arrayinformatics, as admin, after sometime,
> the status of the installshield wizard shows that...
> generating script operations for action:......
> and thats it..after that nothing happens and i get a dozen dll load
> error...starting from...
> REPLRES.RLL cannot load resource dll error..
> run setup again to install this file...
> after clicking ok for a dozen of such error...
> the installshield wizard now says that...
> error-1920. service mssqlserver failed to start. verify that you have
> sufficient privileges to start system services...
> and closes,without completing the installation.
> i tried installing the msde separately..and it got installed.. and i
> was even able to start and stop the services...
> but the arrayinformatics doesnt install with a previously installed
> mssql server...
> so i am struck here...i tried to figure out this problem...searching
> the net for the past 2 days and couldnt solve it...
if you separately succesfully installed MSDE with the official Microsoft
package, I think you have to check this issue with arrayinformatics
technicians... perhaps their installshield script is not correct...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

error:40 connecting with sql server 2000

Hi
I am getting this really annoying error that I cant resolve.
I have created a website that accesses a SQL SERVER 2000 database and
it works perfectly on my home machine. The error has occurred when I
have transferred it to my hosts server.
This is the error:
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: Named Pipes Provider, error: 40 - Could not
open a connection to SQL Server)
This is my connection string:
<add key="ConnectionString" value="Provider=sqloledb;Data
Source=hostsserver****,1433;Initial
Catalog=db******;User Id=dbo*******;Password=********; "/>
It says I am trying to connect to a SQL SERVER 2000 database as this is
what I devloped the site on so I do not know why it thinks I am trying
to connect to SQL SERVER 2005.
Can anyone help?Is your host database server and your home database server the same? It look
s
like that your host database server is in SQL Server 2005.
By the way do you use outside host provider? If yes, you might want to
consider giving them an e-mail. Looking at the connection string, I don't se
e
any problem:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=
Your_Database_Name;UserId=Your_Username;
Password=Your_Password;" .
So I am thinking that the host database server might be on different port
number than 1433 or use a named instance?
Lucas
"chrisbarber1@.gmail.com" wrote:

> Hi
> I am getting this really annoying error that I cant resolve.
> I have created a website that accesses a SQL SERVER 2000 database and
> it works perfectly on my home machine. The error has occurred when I
> have transferred it to my hosts server.
> This is the error:
> An error has occurred while establishing a connection to the server.
> When connecting to SQL Server 2005, this failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections. (provider: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)
>
> This is my connection string:
> <add key="ConnectionString" value="Provider=sqloledb;Data
> Source=hostsserver****,1433;Initial
> Catalog=db******;User Id=dbo*******;Password=********; "/>
>
> It says I am trying to connect to a SQL SERVER 2000 database as this is
> what I devloped the site on so I do not know why it thinks I am trying
> to connect to SQL SERVER 2005.
> Can anyone help?
>|||Thanks for your reply.

> Is your host database server and your home database server the same?
Yes both are on sql server 2000

> By the way do you use outside host provider? If yes, you might want to
> consider giving them an e-mail.
The host providor has been absolutely hopeless.

> So I am thinking that the host database server might be on different port
> number than 1433 or use a named instance?
I'll look in to this although on the hosts control panel definately
says 1433.
Any other ideas?|||<chrisbarber1@.gmail.com> wrote in message
news:1149755323.823279.142210@.u72g2000cwu.googlegroups.com...
> Hi
> I am getting this really annoying error that I cant resolve.
> I have created a website that accesses a SQL SERVER 2000 database and
> it works perfectly on my home machine. The error has occurred when I
> have transferred it to my hosts server.
> This is the error:
> An error has occurred while establishing a connection to the server.
> When connecting to SQL Server 2005, this failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections. (provider: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)
>
It really sounds like the ISP is full of it and somehow your site is trying
to connect to a 2005 server with remote connections turned off.

> This is my connection string:
> <add key="ConnectionString" value="Provider=sqloledb;Data
> Source=hostsserver****,1433;Initial
> Catalog=db******;User Id=dbo*******;Password=********; "/>
>
> It says I am trying to connect to a SQL SERVER 2000 database as this is
> what I devloped the site on so I do not know why it thinks I am trying
> to connect to SQL SERVER 2005.
> Can anyone help?
>|||Check the value of instance config parameter: "remote access" and see
whether it is enabled..
> sp_configure 'remote access'
Jayesh
<chrisbarber1@.gmail.com> wrote in message
news:1149755323.823279.142210@.u72g2000cwu.googlegroups.com...
> Hi
> I am getting this really annoying error that I cant resolve.
> I have created a website that accesses a SQL SERVER 2000 database and
> it works perfectly on my home machine. The error has occurred when I
> have transferred it to my hosts server.
> This is the error:
> An error has occurred while establishing a connection to the server.
> When connecting to SQL Server 2005, this failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections. (provider: Named Pipes Provider, error: 40 - Could not
> open a connection to SQL Server)
>
> This is my connection string:
> <add key="ConnectionString" value="Provider=sqloledb;Data
> Source=hostsserver****,1433;Initial
> Catalog=db******;User Id=dbo*******;Password=********; "/>
>
> It says I am trying to connect to a SQL SERVER 2000 database as this is
> what I devloped the site on so I do not know why it thinks I am trying
> to connect to SQL SERVER 2005.
> Can anyone help?
>