minimum speed to coonectSQL Server over inernet

What the minimal speed is required to connect to SQL Server over internet to
give a good connection?
I mean where i can open forms, select item from the list boxes, generate
reports, inputing data...
Thanks
José
no technical minimum...the limitation is more in your application and where
it resides. Describe what you are using to connect to SQL Server
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Jos" <Jos@.discussions.microsoft.com> wrote in message
news:D42C3EDA-88A8-4261-BB6F-3401FADD2B0F@.microsoft.com...
> What the minimal speed is required to connect to SQL Server over internet
> to
> give a good connection?
> I mean where i can open forms, select item from the list boxes, generate
> reports, inputing data...
> Thanks
> Jos
>
|||I'm testing an aplication.
I tested up 128kb/s is acceptable, I test dial connection, is too slow...
For each form, I don't have many information. The data in table, is a table
with 70 records and 20 columns maximum...
thanks
"Kevin3NF" wrote:

> no technical minimum...the limitation is more in your application and where
> it resides. Describe what you are using to connect to SQL Server
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "José" <Jos@.discussions.microsoft.com> wrote in message
> news:D42C3EDA-88A8-4261-BB6F-3401FADD2B0F@.microsoft.com...
>
>
|||Access? .Net? Powerbuilder?
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Jose Perdigao" <JosePerdigao@.discussions.microsoft.com> wrote in message
news:552C6722-D866-47A7-976E-295638A6ED6A@.microsoft.com...[vbcol=seagreen]
> I'm testing an aplication.
> I tested up 128kb/s is acceptable, I test dial connection, is too slow...
> For each form, I don't have many information. The data in table, is a
> table
> with 70 records and 20 columns maximum...
> thanks
> "Kevin3NF" wrote:
|||I'm connecting by MS Access 2003 (ADP)
"Kevin3NF" wrote:

> Access? .Net? Powerbuilder?
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Jose Perdigao" <JosePerdigao@.discussions.microsoft.com> wrote in message
> news:552C6722-D866-47A7-976E-295638A6ED6A@.microsoft.com...
>
>

minimum speed to coonectSQL Server over inernet

What the minimal speed is required to connect to SQL Server over internet to
give a good connection?
I mean where i can open forms, select item from the list boxes, generate
reports, inputing data...
Thanks
Joséno technical minimum...the limitation is more in your application and where
it resides. Describe what you are using to connect to SQL Server
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Jos" <Jos@.discussions.microsoft.com> wrote in message
news:D42C3EDA-88A8-4261-BB6F-3401FADD2B0F@.microsoft.com...
> What the minimal speed is required to connect to SQL Server over internet
> to
> give a good connection?
> I mean where i can open forms, select item from the list boxes, generate
> reports, inputing data...
> Thanks
> Jos
>|||I'm testing an aplication.
I tested up 128kb/s is acceptable, I test dial connection, is too slow...
For each form, I don't have many information. The data in table, is a table
with 70 records and 20 columns maximum...
thanks
"Kevin3NF" wrote:

> no technical minimum...the limitation is more in your application and wher
e
> it resides. Describe what you are using to connect to SQL Server
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "José" <Jos@.discussions.microsoft.com> wrote in message
> news:D42C3EDA-88A8-4261-BB6F-3401FADD2B0F@.microsoft.com...
>
>|||Access? .Net? Powerbuilder?
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Jose Perdigao" <JosePerdigao@.discussions.microsoft.com> wrote in message
news:552C6722-D866-47A7-976E-295638A6ED6A@.microsoft.com...[vbcol=seagreen]
> I'm testing an aplication.
> I tested up 128kb/s is acceptable, I test dial connection, is too slow...
> For each form, I don't have many information. The data in table, is a
> table
> with 70 records and 20 columns maximum...
> thanks
> "Kevin3NF" wrote:
>|||I'm connecting by MS Access 2003 (ADP)
"Kevin3NF" wrote:

> Access? .Net? Powerbuilder?
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Jose Perdigao" <JosePerdigao@.discussions.microsoft.com> wrote in message
> news:552C6722-D866-47A7-976E-295638A6ED6A@.microsoft.com...
>
>

minimum privileges

what are the minimum privileges required by the sql server id used by
reporting services to access it's data store (ReportingServices and
ReportingServicesTempDB)? The install gives the id specified in the install
dbo privilliges and our DBA is complaningThe minimum should be that the ID needs the right to login to report server
and it needs the RSExec role for the following:
ReportServer
ReportServerTempDB
MSDB
Master
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:7FE38CB6-0BD4-441A-8B1C-E06FCB89D103@.microsoft.com...
> what are the minimum privileges required by the sql server id used by
> reporting services to access it's data store (ReportingServices and
> ReportingServicesTempDB)? The install gives the id specified in the
> install
> dbo privilliges and our DBA is complaning

Minimum NTFS Permissions required for SQL Server Reporting Services to run

I posted elsewhere my troubles in installing SQL Server Reporting services
on my development server. This server is locked down in (almost) the exact
same way as our production server in order to prove the ability of
applications to run and to protect our software under development.
I used two documents from Microsoft to set the NTFS Permissions:
Minimum NTFS Permissions Required for IIS 5.0 To work:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q271071
and Aspnet_wp.exe Could Not Be Started Error Message When You View an
ASP.Net Page:
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B811320
I was not able to install SQL Server Reporting Services when the NTFS
permissions were set as documented. I was forced to make the ASPNet user an
administrator to install, this proves that the issue is permission related.
I have not been able to find a document outlining the permissions needed for
SQL Server Reporting Services. Is anyone aware of one? Our servers must be
as secure as is reasonably possible so I need this information.
Thank you.Hmm.Were you trying to install RS while logged in as ASPnet user? As is not
atypical, when installing a server application you need to be logged in as
someone with Administrator priveleges on the server. However, this does not
mean that the accounts that run need to be in the admin group. When I
install it I log in as log administrator and install it. There is no reason
for aspnet user to be adminstrator (it isn't in my configuration).
Bruce L-C
"Roger Twomey" <rogerdev@.vnet.on.ca> wrote in message
news:%237ydtdTWEHA.1048@.tk2msftngp13.phx.gbl...
> I posted elsewhere my troubles in installing SQL Server Reporting services
> on my development server. This server is locked down in (almost) the exact
> same way as our production server in order to prove the ability of
> applications to run and to protect our software under development.
> I used two documents from Microsoft to set the NTFS Permissions:
> Minimum NTFS Permissions Required for IIS 5.0 To work:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q271071
> and Aspnet_wp.exe Could Not Be Started Error Message When You View an
> ASP.Net Page:
> http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B811320
> I was not able to install SQL Server Reporting Services when the NTFS
> permissions were set as documented. I was forced to make the ASPNet user
an
> administrator to install, this proves that the issue is permission
related.
> I have not been able to find a document outlining the permissions needed
for
> SQL Server Reporting Services. Is anyone aware of one? Our servers must be
> as secure as is reasonably possible so I need this information.
> Thank you.
>

Minimum components required to create 2005 database/tables programmatically

I want to know what are the minimum SQL Server 2005 tools required to perform the following task, and how do I install them:

1. I have a server with SQLS 2005 (and all of its management components) installed. Let's call this Server A. I want to create a database and tables in an instance on this machine.

2. I have another machine (Workstation B) on the same domain from which I want to programmatically create the database on Server A with legacy code that uses SQL-DMO.

What are the minimum components (i.e. SQLDMO for 2005?) I need to install on Workstation B and how/where are they available/packaged? I know that SMO is the replacement for SQLDMO, but we're not ready to upgrade to it yet and we still want to create databases on the 2005 instance.

Thanks in advance,

jd

You just have to install SQLDMO for SQL 2005. It is available as a separate download as part of SQL Server 2005 Feature Pack.

You can get it from here:

http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

Regards,

Minimum components required to create 2005 database/tables programmatically

I want to know what are the minimum SQL Server 2005 tools required to perform the following task, and how do I install them:

1. I have a server with SQLS 2005 (and all of its management components) installed. Let's call this Server A. I want to create a database and tables in an instance on this machine.

2. I have another machine (Workstation B) on the same domain from which I want to programmatically create the database on Server A with legacy code that uses SQL-DMO.

What are the minimum components (i.e. SQLDMO for 2005?) I need to install on Workstation B and how/where are they available/packaged? I know that SMO is the replacement for SQLDMO, but we're not ready to upgrade to it yet and we still want to create databases on the 2005 instance.

Thanks in advance,

jd

You just have to install SQLDMO for SQL 2005. It is available as a separate download as part of SQL Server 2005 Feature Pack.

You can get it from here:

http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

Regards,

Minimal required DLLS for Named Pipes connection?

I have a work around for an application use Integrated Security
instead of SQL Security (which is great). I need to use named pipes
for this to work.
I only got it to work after I did a SQL 2005 Connectivity and Client
Tools install which
installed everything but the Server services. Boss doesn't like this
approach, wants minimal install.
My questions:
Are there just a few DLLs that I need to connect to SQL Server with
named pipes only?
Do I need to Register the DLLs using REGSRV32.EXE?
Thanks
ErikYou can probably get this to work with only installing the client
connectivity. I wouldn't try to hack it.
Jason Massie
http://statisticsio.com
"Erik G" <info@.fdaregulatory.com> wrote in message
news:1194885570.885338.225030@.v3g2000hsg.googlegroups.com...
>I have a work around for an application use Integrated Security
> instead of SQL Security (which is great). I need to use named pipes
> for this to work.
> I only got it to work after I did a SQL 2005 Connectivity and Client
> Tools install which
> installed everything but the Server services. Boss doesn't like this
> approach, wants minimal install.
> My questions:
> Are there just a few DLLs that I need to connect to SQL Server with
> named pipes only?
> Do I need to Register the DLLs using REGSRV32.EXE?
> Thanks
> Erik
>

Minimal required DLLS for Named Pipes connection?

I have a work around for an application use Integrated Security
instead of SQL Security (which is great). I need to use named pipes
for this to work.
I only got it to work after I did a SQL 2005 Connectivity and Client
Tools install which
installed everything but the Server services. Boss doesn't like this
approach, wants minimal install.
My questions:
Are there just a few DLLs that I need to connect to SQL Server with
named pipes only?
Do I need to Register the DLLs using REGSRV32.EXE?
Thanks
Erik
You can probably get this to work with only installing the client
connectivity. I wouldn't try to hack it.
Jason Massie
http://statisticsio.com
"Erik G" <info@.fdaregulatory.com> wrote in message
news:1194885570.885338.225030@.v3g2000hsg.googlegro ups.com...
>I have a work around for an application use Integrated Security
> instead of SQL Security (which is great). I need to use named pipes
> for this to work.
> I only got it to work after I did a SQL 2005 Connectivity and Client
> Tools install which
> installed everything but the Server services. Boss doesn't like this
> approach, wants minimal install.
> My questions:
> Are there just a few DLLs that I need to connect to SQL Server with
> named pipes only?
> Do I need to Register the DLLs using REGSRV32.EXE?
> Thanks
> Erik
>
sql

min rights required to schedule a sql server job

Hello,

I need to create a user that can schedule jobs. I cannot use the 'sa' account.

What rights should I assign this user?

Michael

Michael,

You need a user that is a memeber of SQLAgentUserRole database role in msdb database.

You can read more about that in BOL topics:

"How to: Configure a User to Create and Manage SQL Server Agent Jobs"

"Security for SQL Server Agent Administration"

Regards,

|||

Here is the link to the Books Online topic for SQL Server Agent security: http://msdn2.microsoft.com/en-us/library/ms190978.aspx

Cheers,
Dan

min rights required to schedule a sql server job

Hello,

I need to create a user that can schedule jobs. I cannot use the 'sa' account.

What rights should I assign this user?

Michael

Michael,

You need a user that is a memeber of SQLAgentUserRole database role in msdb database.

You can read more about that in BOL topics:

"How to: Configure a User to Create and Manage SQL Server Agent Jobs"

"Security for SQL Server Agent Administration"

Regards,

|||

Here is the link to the Books Online topic for SQL Server Agent security: http://msdn2.microsoft.com/en-us/library/ms190978.aspx

Cheers,
Dan

Migration of crystal reports from oracle to DB2

Crystal Reports is currently using Oracle. If the database is migrated to DB2 what are the changes required to be done for crystal reports to continue to work with DB2?
Can you please point me to relevant documentation?
TIA.Is it right to assume that the following changes are needed?

- Oracle driver to be replaced with appropriate DB2 driver
- SQL statements in crystal reports that use Oracle proprietary functions/features, join syntax, etc., to be replaced with corresponding / equivalent in DB2

Please let me have your input.

Thanks in advance.