Purchasing SQL Server 2005

I have been tasked with determining which edition of SQL server 2005 to purchase for my business.

We currently have SQL server 2005 Enterprise Edition, although due to the spec of our laptops (operating system) we cannot install the full version of this on our laptops (2gb database capped limit)

The laptop specification is:
1.66 Ghz Intel Centrino Duo
1 Gb Ram
60 Gb HDD
Microsoft Windows XP Profressional Version 2002, SP2 (64 bit?)

I believe the Standard Edition will enable us to have an uncapped SQL Server 2005 database limit on the laptops.

Alternatively, please could anybody advise which edition should be purchased

Many thanks

You haven't mentioned about what kind of business you have and wanted to use SQL Server.

I believe you can look into Workgroup edition or SQLExpress of SQL and still I would like to know the size of userbase & database.

|||

I am an Analyst and I need to analyse 5gb + of financial data.

Would Standard edition or Developer edition not suffice?

|||Then Standard edition should do the job, to handle the application.

Purchasing And Licensing

If we own two standard edition SQL Server licenses that we can use for Report Services and a SQL Server running on another server, how does the report server recognize I have a valid license? The setup doesn't ask for any sort of license key... we don't want to install SQL server on our actual report server.
Also, how do I buy Report Services Standard Edition? I have an MSDN Universal subscription and have downloaded the developer edition, but it's time for me to use this tool in production.
-kind regards, Brian Parkerthe installation doesn't ask for any license information, and you don't have
to install sql server on your report server.
I'm not sure if RS really validates any licensing information. but the
license is the Microsoft document.
To Get RS Standard edition, go to the SQL Server web site, fill the form and
Microsoft send the RS CD Rom.
"Brian Parker" <BrianParker@.discussions.microsoft.com> a écrit dans le
message de news:C76B1A30-2238-4B3F-83E1-EBA902952969@.microsoft.com...
> If we own two standard edition SQL Server licenses that we can use for
Report Services and a SQL Server running on another server, how does the
report server recognize I have a valid license? The setup doesn't ask for
any sort of license key... we don't want to install SQL server on our
actual report server.
> Also, how do I buy Report Services Standard Edition? I have an MSDN
Universal subscription and have downloaded the developer edition, but it's
time for me to use this tool in production.
> -kind regards, Brian Parker|||You will need to buy a SQL Standard license for your server that runs RS if
it separate from your existing SQL Server licensed server.
Tom
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23Rjwx7xdEHA.3664@.TK2MSFTNGP12.phx.gbl...
> the installation doesn't ask for any license information, and you don't
have
> to install sql server on your report server.
> I'm not sure if RS really validates any licensing information. but the
> license is the Microsoft document.
> To Get RS Standard edition, go to the SQL Server web site, fill the form
and
> Microsoft send the RS CD Rom.
> "Brian Parker" <BrianParker@.discussions.microsoft.com> a écrit dans le
> message de news:C76B1A30-2238-4B3F-83E1-EBA902952969@.microsoft.com...
> > If we own two standard edition SQL Server licenses that we can use for
> Report Services and a SQL Server running on another server, how does the
> report server recognize I have a valid license? The setup doesn't ask for
> any sort of license key... we don't want to install SQL server on our
> actual report server.
> >
> > Also, how do I buy Report Services Standard Edition? I have an MSDN
> Universal subscription and have downloaded the developer edition, but it's
> time for me to use this tool in production.
> >
> > -kind regards, Brian Parker
>

pull subscription

My name is Tech guy,
I want to use window script program to execute a pull subscription installed on SQL 2005 express edition. Because it free for downloand.
is there a script that can call an existing pull subscription execution.I want to use window script program to execute a pull subscription installed on SQL 2005 express edition.
Do you mean VB or Java script...?

Using Enterprise Manager you can generate a SQL script.

select Pull Subscription -> Press Right Hand Key -> Generate SQL Script.

Modify script for subscriber name, subscriber DB etc.|||thanks Rajesh for replying my question.
Here is the problem. I created a pull subscription and pull subscription script file in SQL 2005 Management express. but the express does not have option to run a schedule job. I want to create a vb script to run that pull subscription script file. I cannot find a command for execute the pull subscription package in vb script.
example:
dim objserver
set objserver = createobject("SQLDMO.SQLserver")
obvjserver.loginsecure = true
objserver.connect "."
objserver.script, "myPullSubscription.sql"
set objserver = nothing

I need a vb command to execute mypullscubscription.sql because the one I used above does not work.|||You could launch osql.exe (or sqlcmd.exe in 2005) to execute any .sql script from a shell script.|||Can you give me an example script using osql to execute a pull subscription file. do I need to log on SQL management in order to run qsql?|||there are many resources on the net for osql. just google "osql syntax". Here's an example:

http://www.sql-server-performance.com/rd_osql.asp

it's a console app that you can use to execute arbitrary scripts. If you are on 2005, use sqlcmd.exe though. it's better. :)|||Using osql you can run any TSQL script, it's command prompt utility. You can refer Books OnLine from Query Analyzer.

PULL replication with SQL Server Express, it is possible whether or not?

Hello!

Question of such plan, to documentation to Microsoft SQL Server 2005 Express Edition it is written, that the given product supports only PUSH replication, however in his{its} structure there is an agent replmerg.exe which description says:

replication merge. Synchronization means, that the agent of merge transfers changes from the subscriber to the publisher, and then transfers changes from the publisher on the subscriber …

And so the question if this agent is present at this edition, whether that is possible to adjust manually his{its} call, or through Windows the agent, for realization PULL replication or it is impossible and for what reasons?

Thanks.

You can find replmerg.exe in Program Files\Microsoft SQL Server\90\COM even on an Express instance.

The missing thing in Express is the SQL Server agent. Hence the merge agent cannot be started using SQL Server agent with a pull subscription. If you want to use the SQL Server agent in this setup then you will need to use push subscription. Or you can get by and use the executable or use Windows Synchronization manager or use RMO components to start the merge agent programatically.

|||

And why I cannot use instead of SQL Server Agent, Scheduled Tasks Windows, For start replmerg.exe with parameters PULL of the subscriber, or my attempt will not be possible? Why?

|||

I do not understand your question. You can use one of the following:

1. Windows sync manager (pull subscription)

2. Command line executable replmerg.exe

3. RMO objects.

|||

You have told that:

1. Windows sync manager (pull subscription) It Is possible{probable}, yes?

Probably, on SQL Server Expression to realize PULL replication with help Windows sync manager with use of the utility replmerg.exe?

I simply did not use never Windows sync manager.

|||

Windows sync manager is separate from using the replmerg.exe command line tool.

Windows Sync manager can be found in Start-->Programs-->Accessories-->SYnchronize.

For more info refer to:

http://msdn2.microsoft.com/en-us/library/ms165714.aspx

http://msdn2.microsoft.com/en-us/library/ms151863.aspx

|||

Ok, thanks!!! You have very much helped, all has turned out:-)

|||

When I have adjusted pull replication SQL Server express and have set the schedule of performance with help Windows Sync manager, at each start it{he} asks login and password for communication{connection} with Publisher and Distributer? How to make that it{he} did not ask these given, and all did{made} automatically?

|||I am not sure if you can save the credentials.|||

I have bad understood the answer, here is here detailed description of the question, I his(its) has described, read and help to solve a problem. Thank you!

http://www.replication2006.narod.ru/SQLEPW.mht

|||

Are you asking that what you could do with Windows sync manager, can it be done with Merge agent replmerg.exe?

If so, yes. You need the appropriate parameters set for the utility. Running replmerg.exe /? will show you all the available parameters and set them accordingly and run it. It should succeed.

|||

OK thank you, problem is solved.

Publishing Web Application

Hello to everybody.

I got a problem like this:

I developped a project using Visual Studio 2005 Standard Edition on a XP pro x64 Machine using a developpemet data area on a SQL 2005 Express Edition.

Everything is ok, even the user and profile management. But when I try to publish my application on IIS (we're talking about a little Intranet), I get my problems. I think is important to say that the server is a Windows Server 2003 and data (database reproduced as a backup of the developpement one) are under an SQL 2005 Standard. The strange thing is that by publishing the "site" VS create a DB under SQL Std named with the path of local ASPNETDB.MDF.

I can reach everything, all data are ok, but when I pass the login page going to main menu on my web-application, I get this 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I think the problem is SQL STD and the fact that it's not "able" to manage MDF files.

I even tried to re-map the SQL DB (named simply as ASPNETDB on the SQL std) by adjusting the web.config file on connection type and user and password to reach the DB ASPNETDB but it does't work anyway.

Can anybody solve my problem?

Thank You

Can you post your connection string please|||

This first is the original connection string in web.config defined in the developpement area:

<add name="ASPNETDBConnectionString1" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

This one is the connection to the server (SQL STD):

<add name="ASPNETDBConnectionString1" connectionString="Data Source=SERVER\SQLSERVER;Initial Catalog=ASPNETDB;Persist Security Info=True;User ID=user;Password=password" providerName="System.Data.SqlClient"/>

Thank You.

Mauro

Publisher Issues

Right i have two sql 2005 standard edition boxes within a Windows 2003 R2 active directory environment. All updates sp1 etc.

I have an mssql service account setup in AD which all the mssql services on both servers startup with.
I went to setup replication between the two servers for one db.
Firstly i setup distribution no problems no errors.

Then i went to setup the publication, all went well no errors in management studio gui but in the application event logs i got the following:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 14151
Date: 05/10/2006
Time: 12:37:43
User: DNETWORK\mssqlservice
Computer: SGC
Description:
Replication-Replication Transaction-Log Reader Subsystem: agent SGC-MerakDB-2 failed. Executed as user: dnetwork\sqlrep. A required privilege is not held by the client. The step failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 47 37 00 00 12 00 00 00 G7......
0008: 04 00 00 00 53 00 47 00 ....S.G.
0010: 43 00 00 00 0d 00 00 00 C.......
0018: 64 00 69 00 73 00 74 00 d.i.s.t.
0020: 72 00 69 00 62 00 75 00 r.i.b.u.
0028: 74 00 69 00 6f 00 6e 00 t.i.o.n.
0030: 00 00

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 14151
Date: 05/10/2006
Time: 12:37:51
User: DNETWORK\mssqlservice
Computer: SGC
Description:
Replication-Replication Snapshot Subsystem: agent SGC-MerakDB-Merak Mail DB-2 failed. Executed as user: dnetwork\sqlrep. A required privilege is not held by the client. The step failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 47 37 00 00 12 00 00 00 G7......
0008: 04 00 00 00 53 00 47 00 ....S.G.
0010: 43 00 00 00 0d 00 00 00 C.......
0018: 64 00 69 00 73 00 74 00 d.i.s.t.
0020: 72 00 69 00 62 00 75 00 r.i.b.u.
0028: 74 00 69 00 6f 00 6e 00 t.i.o.n.
0030: 00 00

I've tried all sorts to get this to work, the sqlrep user is db_owner for the distro db, ive tried the sqlrep user as domain admin to see if it was a system priv issue, no luck :(

Anyone have any ideas?

Is the account dnetwork\sqlrep the same as SQL Server service account? You can try to add dnetwork\sqlrep to windows user group SQLServer2005SQLAgentUser$<MachineName>$MSSQLSERVER, SQLServer2005MSSQLUser$<MachineName>$MSSQLSERVER, then restart SQL Server service, or reboot the machine to see if the problem goes away. Also can you let us know if you have changed SQL Server service account after installation? If so, it has to be done through SQL Server configuration manager.

Thanks,

Zhiqiang Feng

|||

I tried what you suggested, no luck,

theres a service account for mssql which i named mssqlservice :)
That was set during setup and never changed.

sqlrep was created for replication only, i had already added it to the groups you suggested with no luck. The same error etc.

So i uninstalled then reinstalled mssql from scratch no problems this time.

I believe it was down to a active directory issue when we had to run gpofix it may have altered something down the line. The issue was effecting both servers so i assume it was caused by the active directory issue.

Bit strange though but its sorted now, well so far so good :)

Publisher is empty under Replication Monitor - Publisher.! But replication is still runnin

I have a wired situation..!
I set up transactional replication on one of my development server (SQL
2000 Dev Edition with sp4).
It is running fine without any issues and all of a sudden, i noticed in
my repication monitor tab under Publisher where I usually see the
publication is empty now.
I do see the snapshot agent, log reader and distribution agent under my
agents inside the replication Monitor. But its usefull to see all 3
agents in one window under publisher before. What happend? Is there any
way to get that inside that monitor? Has someone encountered this
sitation before? Please advise...
After that I tried to create a new set of replication on different
database on the same server and i dont see those either under
Replication Monitor - Publishers...
All it says is (No Items)...
I would appreciate any help to correct this issue... Thanks in advance..
You could try running sp_MSload_replication_status.
To investigate further I'd like to know if you see the publication under the
"Replication" folder and/or the "Publications" folder in the published
database.
Also, there was an issue with this prior to sp4
(http://support.microsoft.com/kb/814032) so please ensure that you've got
the latest sp.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||I still have this issue.. Any thoughts? ... ideas.. ?
Thanks in advance..
Query Builder wrote:[vbcol=seagreen]
> Yes, I do see the publications under the Replication --> Publication
> tab. I can also confirm that the replication is working as it is
> pushing those updates to the subscriber. I am unable to run the
> sp_MSload_replication_status as it is returning the following error..
> Server: Msg 8152, Level 16, State 6, Procedure
> sp_MSload_replication_status, Line 19
> String or binary data would be truncated.
> The statement has been terminated.
> Thanks for the update. I would appreciate if you can help me figure out
> the issue...
> Thanks again..
>
> On Nov 3, 4:42 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
|||I had finally figured out the issue... I changed the SQL Jobs
associated with the replication and when i changed back the sql job
names it appeared under my Replication monitor group window...
Query Builder wrote:[vbcol=seagreen]
> I still have this issue.. Any thoughts? ... ideas.. ?
> Thanks in advance..
>
> Query Builder wrote:

Publisher is empty under Replication Monitor - Publisher.! But replication is still runnin

I have a wired situation..!

I set up transactional replication on one of my development server (SQL
2000 Dev Edition with sp4).

It is running fine without any issues and all of a sudden, i noticed in
my repication monitor tab under Publisher where I usually see the
publication is empty now.

I do see the snapshot agent, log reader and distribution agent under my
agents inside the replication Monitor. But its usefull to see all 3
agents in one window under publisher before. What happend? Is there any
way to get that inside that monitor? Has someone encountered this
sitation before? Please advise...

After that I tried to create a new set of replication on different
database on the same server and i dont see those either under
Replication Monitor - Publishers...

All it says is (No Items)...

I would appreciate any help to correct this issue... Thanks in advance..Has anyone seen this issue? Any thoughts? Thanks in advance..

Query Builder wrote:

Quote:

Originally Posted by

I have a wired situation..!
>
I set up transactional replication on one of my development server (SQL
2000 Dev Edition with sp4).
>
It is running fine without any issues and all of a sudden, i noticed in
my repication monitor tab under Publisher where I usually see the
publication is empty now.
>
I do see the snapshot agent, log reader and distribution agent under my
agents inside the replication Monitor. But its usefull to see all 3
agents in one window under publisher before. What happend? Is there any
way to get that inside that monitor? Has someone encountered this
sitation before? Please advise...
>
After that I tried to create a new set of replication on different
database on the same server and i dont see those either under
Replication Monitor - Publishers...
>
All it says is (No Items)...
>
I would appreciate any help to correct this issue... Thanks in advance..

|||I finally found the solution. The problem started when I renamed the
sql jobs related to the replication. When I changed the name back to
what it was, and now I can see the replication tree under the
replication Monitor window...

Query Builder wrote:

Quote:

Originally Posted by

Has anyone seen this issue? Any thoughts? Thanks in advance..
>
>
Query Builder wrote:

Quote:

Originally Posted by

I have a wired situation..!

I set up transactional replication on one of my development server (SQL
2000 Dev Edition with sp4).

It is running fine without any issues and all of a sudden, i noticed in
my repication monitor tab under Publisher where I usually see the
publication is empty now.

I do see the snapshot agent, log reader and distribution agent under my
agents inside the replication Monitor. But its usefull to see all 3
agents in one window under publisher before. What happend? Is there any
way to get that inside that monitor? Has someone encountered this
sitation before? Please advise...

After that I tried to create a new set of replication on different
database on the same server and i dont see those either under
Replication Monitor - Publishers...

All it says is (No Items)...

I would appreciate any help to correct this issue... Thanks in advance..

Publisher is empty under Replication Monitor - Publisher.! But replication is still runnin

I have a wired situation..!
I set up transactional replication on one of my development server (SQL
2000 Dev Edition with sp4).
It is running fine without any issues and all of a sudden, i noticed in
my repication monitor tab under Publisher where I usually see the
publication is empty now.
I do see the snapshot agent, log reader and distribution agent under my
agents inside the replication Monitor. But its usefull to see all 3
agents in one window under publisher before. What happend? Is there any
way to get that inside that monitor? Has someone encountered this
sitation before? Please advise...
After that I tried to create a new set of replication on different
database on the same server and i dont see those either under
Replication Monitor - Publishers...
All it says is (No Items)...
I would appreciate any help to correct this issue... Thanks in advance..You could try running sp_MSload_replication_status.
To investigate further I'd like to know if you see the publication under the
"Replication" folder and/or the "Publications" folder in the published
database.
Also, there was an issue with this prior to sp4
(http://support.microsoft.com/kb/814032) so please ensure that you've got
the latest sp.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Yes, I do see the publications under the Replication --> Publication
tab. I can also confirm that the replication is working as it is
pushing those updates to the subscriber. I am unable to run the
sp_MSload_replication_status as it is returning the following error..
Server: Msg 8152, Level 16, State 6, Procedure
sp_MSload_replication_status, Line 19
String or binary data would be truncated.
The statement has been terminated.
Thanks for the update. I would appreciate if you can help me figure out
the issue...
Thanks again..
On Nov 3, 4:42 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> You could try running sp_MSload_replication_status.
> To investigate further I'd like to know if you see the publication under the
> "Replication" folder and/or the "Publications" folder in the published
> database.
> Also, there was an issue with this prior to sp4
> (http://support.microsoft.com/kb/814032) so please ensure that you've got
> the latest sp.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com.|||I still have this issue.. Any thoughts? ... ideas.. ?
Thanks in advance..
Query Builder wrote:
> Yes, I do see the publications under the Replication --> Publication
> tab. I can also confirm that the replication is working as it is
> pushing those updates to the subscriber. I am unable to run the
> sp_MSload_replication_status as it is returning the following error..
> Server: Msg 8152, Level 16, State 6, Procedure
> sp_MSload_replication_status, Line 19
> String or binary data would be truncated.
> The statement has been terminated.
> Thanks for the update. I would appreciate if you can help me figure out
> the issue...
> Thanks again..
>
> On Nov 3, 4:42 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> > You could try running sp_MSload_replication_status.
> > To investigate further I'd like to know if you see the publication under the
> > "Replication" folder and/or the "Publications" folder in the published
> > database.
> > Also, there was an issue with this prior to sp4
> > (http://support.microsoft.com/kb/814032) so please ensure that you've got
> > the latest sp.
> > Cheers,
> > Paul Ibison SQL Server MVP,www.replicationanswers.com.|||I had finally figured out the issue... I changed the SQL Jobs
associated with the replication and when i changed back the sql job
names it appeared under my Replication monitor group window...
Query Builder wrote:
> I still have this issue.. Any thoughts? ... ideas.. ?
> Thanks in advance..
>
> Query Builder wrote:
> > Yes, I do see the publications under the Replication --> Publication
> > tab. I can also confirm that the replication is working as it is
> > pushing those updates to the subscriber. I am unable to run the
> > sp_MSload_replication_status as it is returning the following error..
> >
> > Server: Msg 8152, Level 16, State 6, Procedure
> > sp_MSload_replication_status, Line 19
> > String or binary data would be truncated.
> > The statement has been terminated.
> >
> > Thanks for the update. I would appreciate if you can help me figure out
> > the issue...
> >
> > Thanks again..
> >
> >
> > On Nov 3, 4:42 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> > > You could try running sp_MSload_replication_status.
> > > To investigate further I'd like to know if you see the publication under the
> > > "Replication" folder and/or the "Publications" folder in the published
> > > database.
> > > Also, there was an issue with this prior to sp4
> > > (http://support.microsoft.com/kb/814032) so please ensure that you've got
> > > the latest sp.
> > > Cheers,
> > > Paul Ibison SQL Server MVP,www.replicationanswers.com.

Published tables locked

Hi,
I am using SQL 2000 standard edition. When i do a
snapshot replication, all the published tables are locked
while creating the snapshot. Result is i cannot do a
snapshot during work hours.
My understanding was that there is an improvement in SQL
Server 2000 where by tables do not get locked while
creating the snapshot.
Can someone throw some light on this.
thanks
venk
Nonblocking snapshots are only available when you use transactional. Why?
I really don't know, but that is the restriction.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

Publications... Im a beginner

Hi people
I m just beginning with SQL Server 2005 Express Edition and I need some help.
I want to have a small database in a server (I've already created) and it will be used to synchronize it with PDAs (Pocket PC 2002) through MS SQL Server CE 2.0.
I have "SQL Server 2005 Express Edition" and "SQL Server Management Studio Express", and I don′t know how to create a publication of my database (I need a merge publication). I think it is necessary in order to make replications.
Any answer, idea or suggestion would be welcome.
Thanks in advance.
Best regards.
Ok I found this at http://msdn2.microsoft.com/en-us/library/ms165686.aspx
SQL Server Express cannot serve as a Publisher or Distributor.
I don't want to (or can not) pay a SQL Server license so... I will try to do it through web services.
ciao!