Showing posts with label standard. Show all posts
Showing posts with label standard. Show all posts

Monday, March 26, 2012

Help! SQL Express, Standard or Enterprise? or Access?

I'm not a developer and would like your input to compare against what a sales rep is telling me.

I'm managing a small web project that will have a database with a max of 20,000 records with less than 50 field each. It will be hit by anything from 200 to 500 people in a day (max) via Internet connection from all over with all sorts of speed.

The users will select less than 50 filters to obtain the results of the info they are looking for among the 20000 records. Most users will only choose less than 10 filters per search.

That's all that the database will do...seems to me enterprise is way too much, but since I'm not expert, need one of you to help with your input.

Thanks very much!


Hi,

you already said, thats this is a quite small web project. I would sugest using the SQL Server Express edition, also for the reason that it can be used for free. If you are experiencing speed problems which are based on the restrictions of Express (limitation in CPU and RAM) you can later easily upgrade to Standard Edition with just a backup and restore. You will have to keep in mind that if you are using Standard or Enterprise edition you will need either user CALs for named users or named machines. So as the rules of thumbs you will have to get CALs for very user connecting to the SQL Server. (Which is quite expensive if the server is accessible through the internet). The other option would be to get a processor license. Based on the per unit prices you can calculate the breakeven for each of the models. Be also aware that although you are using a web frontend where theoretically on one users accesses the database (e.g. the service account for the webserver) the licensing from above applies (multiplexing)

HTH, Jens K. Suessmeyer.


http://www.sqlserver2005.de

|||

What about using a hosted solution? That would be cheapest and easiest way if it's available. You could get that for $5-10 a month.

|||

Thank you very much. We need user CALs for named machines, so I guess I need further research on cost for that.

I truly appreciate you the taking time to answer.

|||

Tricky part I found on that is that the services that seem to meet some of our need also limit what we can do. I'm still searching this possibility, but so far, we haven't found a packaged solution. We are in Denver and are scheduling to visit a couple of host sites in the next few weeks and see how well that fits us. Once all the phases of the deployment are completed, will have users throughout the state (potentially 15K-20K) so the host site can address our cpu demands...

Txs. for the response. I'll let you know if this route works...

Help! SQL Express, Standard or Enterprise? or Access?

I'm not a developer and would like your input to compare against what a sales rep is telling me.

I'm managing a small web project that will have a database with a max of 20,000 records with less than 50 field each. It will be hit by anything from 200 to 500 people in a day (max) via Internet connection from all over with all sorts of speed.

The users will select less than 50 filters to obtain the results of the info they are looking for among the 20000 records. Most users will only choose less than 10 filters per search.

That's all that the database will do...seems to me enterprise is way too much, but since I'm not expert, need one of you to help with your input.

Thanks very much!


Hi,

you already said, thats this is a quite small web project. I would sugest using the SQL Server Express edition, also for the reason that it can be used for free. If you are experiencing speed problems which are based on the restrictions of Express (limitation in CPU and RAM) you can later easily upgrade to Standard Edition with just a backup and restore. You will have to keep in mind that if you are using Standard or Enterprise edition you will need either user CALs for named users or named machines. So as the rules of thumbs you will have to get CALs for very user connecting to the SQL Server. (Which is quite expensive if the server is accessible through the internet). The other option would be to get a processor license. Based on the per unit prices you can calculate the breakeven for each of the models. Be also aware that although you are using a web frontend where theoretically on one users accesses the database (e.g. the service account for the webserver) the licensing from above applies (multiplexing)

HTH, Jens K. Suessmeyer.


http://www.sqlserver2005.de

|||

What about using a hosted solution? That would be cheapest and easiest way if it's available. You could get that for $5-10 a month.

|||

Thank you very much. We need user CALs for named machines, so I guess I need further research on cost for that.

I truly appreciate you the taking time to answer.

|||

Tricky part I found on that is that the services that seem to meet some of our need also limit what we can do. I'm still searching this possibility, but so far, we haven't found a packaged solution. We are in Denver and are scheduling to visit a couple of host sites in the next few weeks and see how well that fits us. Once all the phases of the deployment are completed, will have users throughout the state (potentially 15K-20K) so the host site can address our cpu demands...

Txs. for the response. I'll let you know if this route works...

Monday, March 19, 2012

Help! How to install Sql Svr 2k to Win2k3 Least Privilege Acct?

We are trying to install SQLSever2000 on a Windows 2003 Standard Server to an
account other than Administrator.
We used this guide (which works fine for Win2k Svr)
http://support.microsoft.com/default...;en-us;Q283811
We get an Error 5: Access Denied message when starting SQL Server Agent, but
we don't get enough information to determine what has been denied.
It is obvious that there is some other setting that must be applied in
WinSvr 2k3 that we are not doing - but we didn't see it in the guide. We have
attempted to give the "SQLAdmin" account access to all files and directories
that are related to MS SQL Server.
Unfortunately, our fall back is to install SQL Server to run as
Administrator - because that works.
Any ideas/info is greatly appreciated.
email: hal.hayes@.REMOVE_CAPS_AND_INVALIDacritech.com
I think something else must be wrong or you would not be able to start SQL
Server. Check your event logs, SQL errorlogs and SQL Agent logs for
additional information.
Use SQL Enterprise Manager whenever possible to change the start-up account
for SQL Server and SQL Agent services. SEM will set file and registry
permissions whereas Service Control Manager won't.
Most importantly, ensure that non-admin start-up accounts have following
user privileges:
. Act as Part of the Operating System = SeTcbPrivilege
. Bypass Traverse Checking = SeChangeNotify
. Lock Pages In Memory = SeLockMemory
. Log on as a Batch Job = SeBatchLogonRight
. Log on as a Service = SeServiceLogonRight
. Replace a Process Level Token = SeAssignPrimaryTokenPrivilege
If this is a cluster follow the instructions in
http://support.microsoft.com/kb/239885.
Adrian
"Hal" <Hal@.discussions.microsoft.com> wrote in message
news:D2E25E17-DE30-4AD9-AD55-96BBB5D78ABE@.microsoft.com...
> We are trying to install SQLSever2000 on a Windows 2003 Standard Server to
> an
> account other than Administrator.
> We used this guide (which works fine for Win2k Svr)
> http://support.microsoft.com/default...;en-us;Q283811
> We get an Error 5: Access Denied message when starting SQL Server Agent,
> but
> we don't get enough information to determine what has been denied.
> It is obvious that there is some other setting that must be applied in
> WinSvr 2k3 that we are not doing - but we didn't see it in the guide. We
> have
> attempted to give the "SQLAdmin" account access to all files and
> directories
> that are related to MS SQL Server.
> Unfortunately, our fall back is to install SQL Server to run as
> Administrator - because that works.
> Any ideas/info is greatly appreciated.
> email: hal.hayes@.REMOVE_CAPS_AND_INVALIDacritech.com

Help! How to install Sql Svr 2k to Win2k3 Least Privilege Acct?

We are trying to install SQLSever2000 on a Windows 2003 Standard Server to an
account other than Administrator.
We used this guide (which works fine for Win2k Svr)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q283811
We get an Error 5: Access Denied message when starting SQL Server Agent, but
we don't get enough information to determine what has been denied.
It is obvious that there is some other setting that must be applied in
WinSvr 2k3 that we are not doing - but we didn't see it in the guide. We have
attempted to give the "SQLAdmin" account access to all files and directories
that are related to MS SQL Server.
Unfortunately, our fall back is to install SQL Server to run as
Administrator - because that works.
Any ideas/info is greatly appreciated.
email: hal.hayes@.REMOVE_CAPS_AND_INVALIDacritech.comI think something else must be wrong or you would not be able to start SQL
Server. Check your event logs, SQL errorlogs and SQL Agent logs for
additional information.
Use SQL Enterprise Manager whenever possible to change the start-up account
for SQL Server and SQL Agent services. SEM will set file and registry
permissions whereas Service Control Manager won't.
Most importantly, ensure that non-admin start-up accounts have following
user privileges:
. Act as Part of the Operating System = SeTcbPrivilege
. Bypass Traverse Checking = SeChangeNotify
. Lock Pages In Memory = SeLockMemory
. Log on as a Batch Job = SeBatchLogonRight
. Log on as a Service = SeServiceLogonRight
. Replace a Process Level Token = SeAssignPrimaryTokenPrivilege
If this is a cluster follow the instructions in
http://support.microsoft.com/kb/239885.
Adrian
"Hal" <Hal@.discussions.microsoft.com> wrote in message
news:D2E25E17-DE30-4AD9-AD55-96BBB5D78ABE@.microsoft.com...
> We are trying to install SQLSever2000 on a Windows 2003 Standard Server to
> an
> account other than Administrator.
> We used this guide (which works fine for Win2k Svr)
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q283811
> We get an Error 5: Access Denied message when starting SQL Server Agent,
> but
> we don't get enough information to determine what has been denied.
> It is obvious that there is some other setting that must be applied in
> WinSvr 2k3 that we are not doing - but we didn't see it in the guide. We
> have
> attempted to give the "SQLAdmin" account access to all files and
> directories
> that are related to MS SQL Server.
> Unfortunately, our fall back is to install SQL Server to run as
> Administrator - because that works.
> Any ideas/info is greatly appreciated.
> email: hal.hayes@.REMOVE_CAPS_AND_INVALIDacritech.com

Help! How to install Sql Svr 2k to Win2k3 Least Privilege Acct?

We are trying to install SQLSever2000 on a Windows 2003 Standard Server to a
n
account other than Administrator.
We used this guide (which works fine for Win2k Svr)
http://support.microsoft.com/defaul...b;en-us;Q283811
We get an Error 5: Access Denied message when starting SQL Server Agent, but
we don't get enough information to determine what has been denied.
It is obvious that there is some other setting that must be applied in
WinSvr 2k3 that we are not doing - but we didn't see it in the guide. We hav
e
attempted to give the "SQLAdmin" account access to all files and directories
that are related to MS SQL Server.
Unfortunately, our fall back is to install SQL Server to run as
Administrator - because that works.
Any ideas/info is greatly appreciated.
email: hal.hayes@.REMOVE_CAPS_AND_INVALIDacritech.comI think something else must be wrong or you would not be able to start SQL
Server. Check your event logs, SQL errorlogs and SQL Agent logs for
additional information.
Use SQL Enterprise Manager whenever possible to change the start-up account
for SQL Server and SQL Agent services. SEM will set file and registry
permissions whereas Service Control Manager won't.
Most importantly, ensure that non-admin start-up accounts have following
user privileges:
. Act as Part of the Operating System = SeTcbPrivilege
. Bypass Traverse Checking = SeChangeNotify
. Lock Pages In Memory = SeLockMemory
. Log on as a Batch Job = SeBatchLogonRight
. Log on as a Service = SeServiceLogonRight
. Replace a Process Level Token = SeAssignPrimaryTokenPrivilege
If this is a cluster follow the instructions in
http://support.microsoft.com/kb/239885.
Adrian
"Hal" <Hal@.discussions.microsoft.com> wrote in message
news:D2E25E17-DE30-4AD9-AD55-96BBB5D78ABE@.microsoft.com...
> We are trying to install SQLSever2000 on a Windows 2003 Standard Server to
> an
> account other than Administrator.
> We used this guide (which works fine for Win2k Svr)
> http://support.microsoft.com/defaul...b;en-us;Q283811
> We get an Error 5: Access Denied message when starting SQL Server Agent,
> but
> we don't get enough information to determine what has been denied.
> It is obvious that there is some other setting that must be applied in
> WinSvr 2k3 that we are not doing - but we didn't see it in the guide. We
> have
> attempted to give the "SQLAdmin" account access to all files and
> directories
> that are related to MS SQL Server.
> Unfortunately, our fall back is to install SQL Server to run as
> Administrator - because that works.
> Any ideas/info is greatly appreciated.
> email: hal.hayes@.REMOVE_CAPS_AND_INVALIDacritech.com

Help! getting errors when trying to connect to SQL Server Management Studio

Hi All,

I have Windows 2003 Server with MSSQL 2005 Standard.

I am able to connect via Windows Authentication, but when I try to change it to SQL Server Authentication with user 'sa' I'm then being prompted with the error msg:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)
Here is the entire list of msgs that are showing up:

===================================

Cannot connect to SOLELL-QGL5PG9D.

===================================

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

Server Name: SOLELL-QGL5PG9D
Error Number: 233
Severity: 20
State: 0

Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Any pointers?

-Alon.
Hi,

didi you enable mixed authentication or did you just enable the Windows Authentication ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||Hi Jens,

I installed the MSSQL a week and a half ago, and I believe it was set to Mixed. I simply don't remember.
Is there a way to know?
Can it be changed to Mixed mode in the event that I missed that? or do I need to uninstall and re-install from scratch?

thanks,

-Alon.
|||Hi Jens,

Since I didn't have any database created yet, I've uninstalled MSSQL and Re-installed it.
This time, I made sure it was set to the Mixed Mode.
I don't know if there was a way to verify an early install or if there is a way to change from
Windows Auth Only to Mixed mode, but Uninstalling and Re-installing took only 30 minutes and I had no databases that I needed to check previously,. so that was my solution.

Thanks for the interest.

-Alon.
|||

Hi,

just for the completion of your answer, the authentication mode can be investigated by using the SQL Server Management Studio and right clicking on the server, choosing the properties and viewing the setting in the Security pane. If you don′t have any visual tool for editing this you can use the registry key

Default instance:
"HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode"

to 2 for mixed-mode or 1 for integrated.

Have in mind that changing the setting will need a restart of the server to apply.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Hey,

I had this same issue. My MSSQL 2005 server was setup on a port other than the default 1433. Once I added the port number to the connect string, I was able to connect. ie.: SERVERNAME, 9999

Good Luck.

Monday, March 12, 2012

Help! getting errors when trying to connect to SQL Server Management Studio

Hi All,

I have Windows 2003 Server with MSSQL 2005 Standard.

I am able to connect via Windows Authentication, but when I try to change it to SQL Server Authentication with user 'sa' I'm then being prompted with the error msg:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)
Here is the entire list of msgs that are showing up:

===================================

Cannot connect to SOLELL-QGL5PG9D.

===================================

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

Server Name: SOLELL-QGL5PG9D
Error Number: 233
Severity: 20
State: 0

Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Any pointers?

-Alon.
Hi,

didi you enable mixed authentication or did you just enable the Windows Authentication ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||Hi Jens,

I installed the MSSQL a week and a half ago, and I believe it was set to Mixed. I simply don't remember.
Is there a way to know?
Can it be changed to Mixed mode in the event that I missed that? or do I need to uninstall and re-install from scratch?

thanks,

-Alon.
|||Hi Jens,

Since I didn't have any database created yet, I've uninstalled MSSQL and Re-installed it.
This time, I made sure it was set to the Mixed Mode.
I don't know if there was a way to verify an early install or if there is a way to change from
Windows Auth Only to Mixed mode, but Uninstalling and Re-installing took only 30 minutes and I had no databases that I needed to check previously,. so that was my solution.

Thanks for the interest.

-Alon.
|||

Hi,

just for the completion of your answer, the authentication mode can be investigated by using the SQL Server Management Studio and right clicking on the server, choosing the properties and viewing the setting in the Security pane. If you don′t have any visual tool for editing this you can use the registry key

Default instance:
"HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode"

to 2 for mixed-mode or 1 for integrated.

Have in mind that changing the setting will need a restart of the server to apply.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Hey,

I had this same issue. My MSSQL 2005 server was setup on a port other than the default 1433. Once I added the port number to the connect string, I was able to connect. ie.: SERVERNAME, 9999

Good Luck.