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.

accessing sql server via IP is very slow

Hello,
we got a situation with sql 2005 server that configured to be access with
both name pipes and tcp/ip.
while accessing the server via name pipes is very fast other method ip is
very slow
someone could put a light on this issue
ThanksCan you give some information about your network config?
"Tal Bar-Or" <TalBarOr@.discussions.microsoft.com> wrote in message
news:4584EDEB-61AA-4439-9A5D-D03CBAE4BD33@.microsoft.com...
> Hello,
> we got a situation with sql 2005 server that configured to be access with
> both name pipes and tcp/ip.
> while accessing the server via name pipes is very fast other method ip is
> very slow
> someone could put a light on this issue
> Thanks|||we have standard active directory with dns and wins all connected to switch
with one vlan without any restriction.
"Aaron Bertrand [SQL Server MVP]" wrote:
> Can you give some information about your network config?
>
> "Tal Bar-Or" <TalBarOr@.discussions.microsoft.com> wrote in message
> news:4584EDEB-61AA-4439-9A5D-D03CBAE4BD33@.microsoft.com...
> > Hello,
> >
> > we got a situation with sql 2005 server that configured to be access with
> > both name pipes and tcp/ip.
> > while accessing the server via name pipes is very fast other method ip is
> > very slow
> > someone could put a light on this issue
> > Thanks
>
>|||Have you talked to your network administrator? This could be how the LAN is
configured (e.g. it could be that IPs are routed differently...)
"Tal Bar-Or" <TalBarOr@.discussions.microsoft.com> wrote in message
news:45F5967B-B303-4E44-9F63-8096A9C22006@.microsoft.com...
> we have standard active directory with dns and wins all connected to
> switch
> with one vlan without any restriction.
> "Aaron Bertrand [SQL Server MVP]" wrote:
>> Can you give some information about your network config?
>>
>> "Tal Bar-Or" <TalBarOr@.discussions.microsoft.com> wrote in message
>> news:4584EDEB-61AA-4439-9A5D-D03CBAE4BD33@.microsoft.com...
>> > Hello,
>> >
>> > we got a situation with sql 2005 server that configured to be access
>> > with
>> > both name pipes and tcp/ip.
>> > while accessing the server via name pipes is very fast other method ip
>> > is
>> > very slow
>> > someone could put a light on this issue
>> > Thanks
>>|||Also, is it just SQL traffic? What do ping, tracert, file copy etc. look
like using both connection methods?
And if IP is slow, then why not just use named pipes? I gather that you
want to understand the problem, but personally I would rather spend my time
on software performance issues and leave the hardware stuff to the hardware
folks. :-)|||This is definitely a question for your network admin to address.
You could try using the tracert dos command to see if there is a single
point in the path that is causing the majority of the slowdown.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Tal Bar-Or" <TalBarOr@.discussions.microsoft.com> wrote in message
news:4584EDEB-61AA-4439-9A5D-D03CBAE4BD33@.microsoft.com...
> Hello,
> we got a situation with sql 2005 server that configured to be access with
> both name pipes and tcp/ip.
> while accessing the server via name pipes is very fast other method ip is
> very slow
> someone could put a light on this issue
> Thanks|||Thanks for the answer
could you please point me to an article how difference made by connecting
via name pipes and tcp/ip
thanks
"Aaron Bertrand [SQL Server MVP]" wrote:
> Also, is it just SQL traffic? What do ping, tracert, file copy etc. look
> like using both connection methods?
> And if IP is slow, then why not just use named pipes? I gather that you
> want to understand the problem, but personally I would rather spend my time
> on software performance issues and leave the hardware stuff to the hardware
> folks. :-)
>
>|||Just to be clear, the clients in question are not on the same server?
Quoting the Books On Line:
"It is also important to clarify if you are talking about local pipes
or network pipes. If the server application is running locally on the
computer that is running an instance of SQL Server, the local Named
Pipes protocol is an option. Local named pipes runs in kernel mode and
is very fast."
Roy Harvey
Beacon Falls, CT
On Mon, 28 Apr 2008 04:59:01 -0700, Tal Bar-Or
<TalBarOr@.discussions.microsoft.com> wrote:
>Hello,
>we got a situation with sql 2005 server that configured to be access with
>both name pipes and tcp/ip.
>while accessing the server via name pipes is very fast other method ip is
>very slow
>someone could put a light on this issue
>Thanks|||> could you please point me to an article how difference made by connecting
> via name pipes and tcp/ip
I don't know of one specifically off-hand. Did you try Google?

Accessing reports through URL

Hello, All !!

I'm now getting problems with access reports through URL.
The situation is:
I'm posting the form to the frame, action attribute's URL includes
querystring.
Also I have some inputs in the form.
I'm using method=post.

Problem is that Report Server ignores parameters from query of the action.

I think it should work with them but it doesn't.

If anyone knows what's the matter here, please !

Thank you,
Alexander Yaremchuk

What version of the SQL RS are you using. The latest SQL 2005 CTP drop had this bug, which has been fixed since then.
Thanks
Tudor

Accessing QueryString from within a report.

I have a situation where MSRS is being used as a part of a number of web
based applications.
One of the requirements of these applications is that a SessionID can be
logged with every call made to an application component. The purpose of
this is to allow end-to-end auditing of all the user actions that have been
taken during the course of a session
The strategy that we were going to take with MSRS was to include a dummy
parameter SessionID in every report and then extract that parameter from the
MSRS logs. This strategy comes unstuck when snapshots are used. Parameters
in request for the rendering of a report based on a snapshot are discarded,
and the original parameters are placed in the execution log.
I was wondering if anyone else had come across a way to access the
querystring or user entered report parameters on a snapshot based report.
regards,
Adrian.Hello Adrian,
Based on my scope, it seems this behavior is as designed and we are not
able to access the query string when execution the report.
The workaround is to use a Web appliatoin and a proxy to reporting services
so that you will get more customized features. Also, it will bring more
coding work. The following link is just for your reference:
http://www.codeproject.com/useritems/SQLRSViewer.asp
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Reply-To: "Adrian Russell" <adrianru@.avanade.com>
| From: "Adrian Russell" <adrianru@.avanade.com>
| Subject: Accessing QueryString from within a report.
| Date: Wed, 20 Apr 2005 09:25:19 +1000
| Lines: 22
| Organization: Avanade
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <OtdNRcTRFHA.3496@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 220-245-208-182-act.tpgi.com.au 220.245.208.182
| Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
2.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:48136
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have a situation where MSRS is being used as a part of a number of web
| based applications.
|
| One of the requirements of these applications is that a SessionID can be
| logged with every call made to an application component. The purpose of
| this is to allow end-to-end auditing of all the user actions that have
been
| taken during the course of a session
|
| The strategy that we were going to take with MSRS was to include a dummy
| parameter SessionID in every report and then extract that parameter from
the
| MSRS logs. This strategy comes unstuck when snapshots are used.
Parameters
| in request for the rendering of a report based on a snapshot are
discarded,
| and the original parameters are placed in the execution log.
|
| I was wondering if anyone else had come across a way to access the
| querystring or user entered report parameters on a snapshot based report.
|
| regards,
|
| Adrian.
|
|
|

Accessing one db by two sql server instances (eg. native vs vmware)

Hi there
As many people do nowadays, I have 2 XP installations on my laptop -
one
running natively and one in vmware box running on ubuntu (situation
even more common with osx on intelmacs).
Since I would like to be able to work on same development projects in
both these environments, depending on the situation, I was wondering
how should I cope with DBs synchronization between two sql server
instances running under those two environments.
The simplest solution would be deploy the database in native windows
sql server installation, and attach the _same_ database files when
running from vmware (via sharing their folder on mounted ntfs
partition). So the DB files would attached to two servers, but of
course they would never be accessed at the same time.
Would it be possible at all without any data corruption assuming I
would run the same server versions (same SPs applied etc. - for the
time being it's 2kSP4)?
thanks
HP> So the DB files would attached to two servers, but of
> course they would never be accessed at the same time.
This should work fine. Regular backups won't hurt either.
Note that the Best Practice in development is to keep database DDL scripts
under source control rather than only in a physical database.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"HP" <ha5en1@.gmail.com> wrote in message
news:1187778620.953857.97210@.x40g2000prg.googlegroups.com...
> Hi there
> As many people do nowadays, I have 2 XP installations on my laptop -
> one
> running natively and one in vmware box running on ubuntu (situation
> even more common with osx on intelmacs).
> Since I would like to be able to work on same development projects in
> both these environments, depending on the situation, I was wondering
> how should I cope with DBs synchronization between two sql server
> instances running under those two environments.
> The simplest solution would be deploy the database in native windows
> sql server installation, and attach the _same_ database files when
> running from vmware (via sharing their folder on mounted ntfs
> partition). So the DB files would attached to two servers, but of
> course they would never be accessed at the same time.
> Would it be possible at all without any data corruption assuming I
> would run the same server versions (same SPs applied etc. - for the
> time being it's 2kSP4)?
> thanks
> HP
>