SQL,access denied: activating

Showing posts with label activating. Show all posts

Sunday, March 11, 2012

Activating Trial Edition of SQL Server 2005

I have the following situation.
I installed a couple of months ago SQL Server 2005 Trial Edition which is En
teprise Edition I guess.
Currently I am testing replication on our company database.
Now. In a few months the Trial Version will expire.
Can I avoid setting up my Merge Replication again and re-installing everythi
ng from scratch?
Is there a way to activate NOT YET expired trial version ?
More to that I prefer to purchase the Standard Ed. which is less expensive t
han Enterprise.
Can I convert somehow the Trial Enteprise ed. into Standard WITHOUT having t
o re-install everything and possibly losing oall my settings.Issue a select @.@.version to determine what you are running. I think your
best bet is to script our your publications and subscribers, and then to
detacth the databases. Remove the trial version and install standard noting
that web synchronization and other features of merge replication present
only in EE will not be available.
Then run the publication and subscription scripts on the new server.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Yuri" <Yuri@.tester.de> wrote in message
news:5o-dnaz5Doik2dvYnZ2dnUVZ8qKdnZ2d@.giganews.com...
>I have the following situation.
> I installed a couple of months ago SQL Server 2005 Trial Edition which is
> Enteprise Edition I guess.
> Currently I am testing replication on our company database.
> Now. In a few months the Trial Version will expire.
>
> Can I avoid setting up my Merge Replication again and re-installing
> everything from scratch?
> Is there a way to activate NOT YET expired trial version ?
> More to that I prefer to purchase the Standard Ed. which is less expensive
> than Enterprise.
> Can I convert somehow the Trial Enteprise ed. into Standard WITHOUT having
> to re-install everything and possibly losing oall my settings.|||Hi Hillary,
thanks for your piece of advice.
This is actually a workaround solution.
Your are right, installing the Standard ed. over Trial Version isn't probabl
y the best idea.
But I guess you are mistaken saying that SE has no Web Merge Replication fea
utures
Look at this table: http://www.microsoft.com/sql/prodin...
es.mspx
Yuri

Activating Trial Edition of SQL Server 2005

I have the following situation.
I installed a couple of months ago SQL Server 2005 Trial Edition which is Enteprise Edition I guess.
Currently I am testing replication on our company database.
Now. In a few months the Trial Version will expire.
Can I avoid setting up my Merge Replication again and re-installing everything from scratch?
Is there a way to activate NOT YET expired trial version ?
More to that I prefer to purchase the Standard Ed. which is less expensive than Enterprise.
Can I convert somehow the Trial Enteprise ed. into Standard WITHOUT having to re-install everything and possibly losing oall my settings.Issue a select @.@.version to determine what you are running. I think your
best bet is to script our your publications and subscribers, and then to
detacth the databases. Remove the trial version and install standard noting
that web synchronization and other features of merge replication present
only in EE will not be available.
Then run the publication and subscription scripts on the new server.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Yuri" <Yuri@.tester.de> wrote in message
news:5o-dnaz5Doik2dvYnZ2dnUVZ8qKdnZ2d@.giganews.com...
>I have the following situation.
> I installed a couple of months ago SQL Server 2005 Trial Edition which is
> Enteprise Edition I guess.
> Currently I am testing replication on our company database.
> Now. In a few months the Trial Version will expire.
>
> Can I avoid setting up my Merge Replication again and re-installing
> everything from scratch?
> Is there a way to activate NOT YET expired trial version ?
> More to that I prefer to purchase the Standard Ed. which is less expensive
> than Enterprise.
> Can I convert somehow the Trial Enteprise ed. into Standard WITHOUT having
> to re-install everything and possibly losing oall my settings.

Activating the Queue

Hi,

I have created Queue with the following syntax. But it is not getting activated itself. What I have to do to get it activated itself, and what could be the frequency by default.

CREATE QUEUE NewCustomerQueue
WITH ACTIVATION
(PROCEDURE_NAME = prProcessNewCustomers,
STATUS = ON,
MAX_QUEUE_READERS = 1,
EXECUTE AS SELF)
GO

If I execute the prProcessNewCustomers procedure manually it is showing that the Queue has been activated. What change I have to make in the syntax to get it activated itself.

Actually I have two scenarios in my requirement,

1. One Queue processing immediately when it receives data (Order Processing)

2. Another Queue, Process when the server is idle i.e., off-peak time (for mailing)

What syntax I have to use for these.

Please help.

Thanks in advance

Babu

Activation can be turned on and off using ALTER QUEUE

ALTER QUEUE NewCustomerQueue WITH ACTIVATION (STATUS = ON|OFF);

So in your first scenario you can keep activation on always. In your second scenario, you can keep it off by default and turn it on whenever desired.

Activation launches the specified stored procedure in the background upon receipt of incoming messages. If the procedure cannot keep with the rate of incoming messages, it can launch concurrent instances of the stored procedure (you need to set max_queue_readers > 1 for that).

Hope that helps,

Rushi

|||

Hi Rushi,

Thanks for your reply.

I have created the Queue with the ACTIVATION (STATUS = ON) only.

Currently I'm trying with a typical example what I got from some books. When a new customer is added, the trigger in the Customer table will "BEGIN DIALOG CONVERSATION" and send a message. I think when a message is sent, the Queue should get activated. It is not happening in this case. What could be the reason.

Please help.

Regards

Babu

|||

Hi Babu:

First make sure the trigger runs by checking in query analyser. Check the sql profiler to see whats the errror your getting.

Pramod

|||

Do you see the message in the target queue?

select * from [target queue]

(where [target queue] is the name of your target queue)

Rushi

|||

Hi Rushi, Pramod,

Thank you both for the responses.

The problem was occured because the 'Idle CPU Condition' was not defined.

I'll come back with new doubts . Thank you once again.

Regards

Babu

Activating Server Logs

I have two remote Win2000 servers running SQL2000. There are no items under
SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log database
activity?
Thanks,
John Steen
remove (nospam) from e-mail address to send me a messageNever heard we must activate something for the log. What do you see in
\Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be files
named ERRORLOG.
"John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
>I have two remote Win2000 servers running SQL2000. There are no items
>under
> SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
> database
> activity?
> Thanks,
> John Steen
> remove (nospam) from e-mail address to send me a message|||Hi
SQL Server does not log activity like inserts and deletes. You need to run
SQL Server Profiler to do that.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ME" <ME@.hotmail.com> wrote in message
news:eIj85KVYFHA.3164@.TK2MSFTNGP12.phx.gbl...
> Never heard we must activate something for the log. What do you see in
> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be
> files named ERRORLOG.
>
> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
>>I have two remote Win2000 servers running SQL2000. There are no items
>>under
>> SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
>> database
>> activity?
>> Thanks,
>> John Steen
>> remove (nospam) from e-mail address to send me a message
>|||My bad. Didn't read the last part of the post.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ugABXMVYFHA.2572@.TK2MSFTNGP14.phx.gbl...
> Hi
> SQL Server does not log activity like inserts and deletes. You need to run
> SQL Server Profiler to do that.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ME" <ME@.hotmail.com> wrote in message
> news:eIj85KVYFHA.3164@.TK2MSFTNGP12.phx.gbl...
>> Never heard we must activate something for the log. What do you see in
>> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be
>> files named ERRORLOG.
>>
>> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
>> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
>>I have two remote Win2000 servers running SQL2000. There are no items
>>under
>> SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
>> database
>> activity?
>> Thanks,
>> John Steen
>> remove (nospam) from e-mail address to send me a message
>>
>|||There are log files in the log folder, but the latest one is dated May 17,
2004, which is around the time they were moved there from the location where
they were set up. The IP addresses were also changed when they were moved to
their current location. I don't what else may have changed.
Could that have something to do with why the logs stopped recording?
Thanks,
John
"ME" wrote:
> Never heard we must activate something for the log. What do you see in
> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be files
> named ERRORLOG.
>
> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
> >I have two remote Win2000 servers running SQL2000. There are no items
> >under
> > SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
> > database
> > activity?
> >
> > Thanks,
> > John Steen
> > remove (nospam) from e-mail address to send me a message
>
>|||I'm not trying to log inserts and such, Mike, just normal DB activtiy
(startups, shutdowns, recoveries, DBCC jobs, etc.) you see in the server logs.
Thanks,
John
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> SQL Server does not log activity like inserts and deletes. You need to run
> SQL Server Profiler to do that.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ME" <ME@.hotmail.com> wrote in message
> news:eIj85KVYFHA.3164@.TK2MSFTNGP12.phx.gbl...
> > Never heard we must activate something for the log. What do you see in
> > \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be
> > files named ERRORLOG.
> >
> >
> > "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> > news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
> >>I have two remote Win2000 servers running SQL2000. There are no items
> >>under
> >> SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
> >> database
> >> activity?
> >>
> >> Thanks,
> >> John Steen
> >> remove (nospam) from e-mail address to send me a message
> >
> >
>
>|||Right-click the server in EM, properties, Parameters. Verify that you have an -e parameter and the
path that the parameter points to.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
news:04B3D2BC-6E90-4103-96E6-EB998BD613A0@.microsoft.com...
> There are log files in the log folder, but the latest one is dated May 17,
> 2004, which is around the time they were moved there from the location where
> they were set up. The IP addresses were also changed when they were moved to
> their current location. I don't what else may have changed.
> Could that have something to do with why the logs stopped recording?
> Thanks,
> John
> "ME" wrote:
>> Never heard we must activate something for the log. What do you see in
>> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be files
>> named ERRORLOG.
>>
>> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
>> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
>> >I have two remote Win2000 servers running SQL2000. There are no items
>> >under
>> > SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
>> > database
>> > activity?
>> >
>> > Thanks,
>> > John Steen
>> > remove (nospam) from e-mail address to send me a message
>>|||Thanks, Tibor, that did it!
John
"Tibor Karaszi" wrote:
> Right-click the server in EM, properties, Parameters. Verify that you have an -e parameter and the
> path that the parameter points to.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> news:04B3D2BC-6E90-4103-96E6-EB998BD613A0@.microsoft.com...
> > There are log files in the log folder, but the latest one is dated May 17,
> > 2004, which is around the time they were moved there from the location where
> > they were set up. The IP addresses were also changed when they were moved to
> > their current location. I don't what else may have changed.
> >
> > Could that have something to do with why the logs stopped recording?
> >
> > Thanks,
> > John
> >
> > "ME" wrote:
> >
> >> Never heard we must activate something for the log. What do you see in
> >> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be files
> >> named ERRORLOG.
> >>
> >>
> >> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> >> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
> >> >I have two remote Win2000 servers running SQL2000. There are no items
> >> >under
> >> > SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
> >> > database
> >> > activity?
> >> >
> >> > Thanks,
> >> > John Steen
> >> > remove (nospam) from e-mail address to send me a message
> >>
> >>
> >>
>
>

Activating Nested Trigger with DTC

Hello,

I built a trigger that activates another trigger (Nested Trigger).

The First trigger which is located on table A inserts data into table B and in return the second trigger which is located on table B updates data in table A.

The whole process works fine when both tables are on the same server but when the tables are on different servers i get the following error:

"[Microsoft][ODBC SQL Server Driver][SQL Server]The operation could not be performed because the OLE DB Provider 'SQLOLEDB' was unable to begin a distributed transaction.
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator.]"

Any ideas?Under the server properties goto connection tab and check option for 'Enforce Distributed Transactions (DTS)", make sure to uncheck the option.|||I tried it and it didn't work - I even got the same error message.

Any more ideas?|||Make sure to check whether MSDTC is running on all involved servers.|||I checked the servers and MS-DTC runs on both of them.

Could it be connected to the settings of MS-DTC? something in the settings of MS-DTC that doesn't allow a trigger to activate another trigger?|||It always helps try to refresh the services and MSDTC to get it worked.|||no, sorry, still doesn't help

I stopped and played MS-DTC on both servers + refreshed services but still no good|||I'm out of ideas now in this regard, BTW what is the SP Level?
You may refer the case of MS Support for a fix or search under KB for any fix.|||Both servers are running MS-SQL 2K, SP3

Thanks for your time,

I'll update on any solution, if will be founded..|||For information refer thru:
run SP_SERVEROPTION from QA and deliver the result.

Try to implement :

SET ANSI_DEFAULTS ON
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET XACT_ABORT ON
.... before the transaction begins...|||all parameters were already set as mentioned.

sp_serveroption enables changing several server parameters, which one did u mean?

Activating MSDE for remote Access

I'm finding that when I install MSDE, by default no protocols are enabled
for remote access. I've found that I can use the SQL Server Network Utility
to enable the TCP/IP protocol and then the MSDE instance is accessible from
remote workstations.
But how can I do this without having the SQL Server Client Tools installed?
Is there a command line or configuration option I can use?
Thanks for your help,
Joe Geretz
I think I found it. DISABLENETWORKPROTOCOLS=0.
- Joe Geretz -
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:uoPxQ8DYEHA.3300@.TK2MSFTNGP09.phx.gbl...
> I'm finding that when I install MSDE, by default no protocols are enabled
> for remote access. I've found that I can use the SQL Server Network
Utility
> to enable the TCP/IP protocol and then the MSDE instance is accessible
from
> remote workstations.
> But how can I do this without having the SQL Server Client Tools
installed?
> Is there a command line or configuration option I can use?
> Thanks for your help,
> Joe Geretz
>
|||But how would I do this after the instance is already installed? I can't
rely on SQL Server Client Tools because presumably, they won't exist locally
on the MSDE box.
Thanks for your help,
- Joe Geretz -
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:ucsgMAEYEHA.716@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> I think I found it. DISABLENETWORKPROTOCOLS=0.
> - Joe Geretz -
> "Joseph Geretz" <jgeretz@.nospam.com> wrote in message
> news:uoPxQ8DYEHA.3300@.TK2MSFTNGP09.phx.gbl...
enabled
> Utility
> from
> installed?
>
|||Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe
Enable tcp/ip and restart MSDE
David P. Lurie
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:e$2DuCEYEHA.3988@.tk2msftngp13.phx.gbl...
> But how would I do this after the instance is already installed? I can't
> rely on SQL Server Client Tools because presumably, they won't exist
locally
> on the MSDE box.
>
|||hi Joseph,
"Joseph Geretz" <jgeretz@.nospam.com> ha scritto nel messaggio
news:e$2DuCEYEHA.3988@.tk2msftngp13.phx.gbl...
> But how would I do this after the instance is already installed? I can't
> rely on SQL Server Client Tools because presumably, they won't exist
locally
> on the MSDE box.
on the box where MSDE has been installed, the Server Network Tools will be
alwayse available (as David already pointed out), and the Client Network
Tools (cliconfg.exe) too...
on all client, only the Client Network Tools will be available, installed by
MDAC...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank David and Andrea!
I hadn't noticed that these tools are actually installed with MSDE. This is
great, exactly what I'll need.
Thanks,
- Joe Geretz -
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2kladsF3m4fmU1@.uni-berlin.de...
> hi Joseph,
> "Joseph Geretz" <jgeretz@.nospam.com> ha scritto nel messaggio
> news:e$2DuCEYEHA.3988@.tk2msftngp13.phx.gbl...
> locally
> on the box where MSDE has been installed, the Server Network Tools will be
> alwayse available (as David already pointed out), and the Client Network
> Tools (cliconfg.exe) too...
> on all client, only the Client Network Tools will be available, installed
by
> MDAC...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Activating a Second Server in an NLB Cluster

Hi,
I'm having problems activating a second server that is participating in
an NLB cluster. The common response I see here is to run rsactivate
from the first node using the -m switch to activate the second node.
The problem with this is that when in an NLB cluster you cannot even
ping the second server so there is no way to do it this way. Is there
an alternative way of activating it. I have tried doing the rskeymgt
-d on the servers but it seems like whenever I do that only one server
will pickup (or perhaps create) the key so the other server will go
back into the "not activated" mode. Is there a way to perhaps
"extract" the key from one server and "install" it on the second
server?
Thanks in advance!
BillOK...I saw how I could extract a key to a file. I then applied the
key to the second server, but that didn't really seem to change
anything. I am still getting a "not activated" message when I bring up
report manager. Any thoughts? Am I going to have to uninstall NLB,
then do the install and then redo NLB?
Thanks,
Bill

Sunday, March 11, 2012

Activating Trial Edition of SQL Server 2005

Activating Trial Edition of SQL Server 2005

Activating the Queue

Activating Server Logs

Activating Server Logs

Activating Server Logs

Activating Nested Trigger with DTC

Activating MSDE for remote Access

Activating a Second Server in an NLB Cluster

SQL,access denied

Blog Archive

About Me