how to controll user access in comercial deployment?

Hello,
We have used SSAS and SSRS to develop a BI reporting suite for our data
warehouse and would like to deploy this into our customer base, but at the
same time protect our investment.
How do we control or limit the number of users that can use our cubes and
reports? We would like to control user numbers by a licence arrangement -
either concurrent or named - but fear once a user has our developments
installed they only need to increase their MS licences and away they go...
Any help and advice appreciated.
StephenYou could do the following for named users.
1. Have your own routine that authorizes. Put the user names into a table.
Then somewhere else have the total number allowed encrypted.
2. In your reports (or even better in stored procedures) use the User!UserID
global parameter and verify the user. You could do this in a custom assembly
too. You could put a nag message on each report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephen Lonsdale" <StephenLonsdale@.discussions.microsoft.com> wrote in
message news:4AE7D682-F6D1-4E60-8641-03EC900EA69D@.microsoft.com...
> Hello,
> We have used SSAS and SSRS to develop a BI reporting suite for our data
> warehouse and would like to deploy this into our customer base, but at the
> same time protect our investment.
> How do we control or limit the number of users that can use our cubes and
> reports? We would like to control user numbers by a licence arrangement -
> either concurrent or named - but fear once a user has our developments
> installed they only need to increase their MS licences and away they go...
> Any help and advice appreciated.
> Stephen

How to connect SQL Server 2000?

i want to connect SQL Server 2000 with remotely how it will work?

i have a sql server data base on server(domain) in xyz company, they give me following information:

database name

server IP address

database user name

database password

i can connect the same database using networking internet (proxy)

connect internet connection

start proxy connection

i am using a pc from network which is useing proxy for internet.

i open query analyzer

enter IP address, user name and password (which is currect)

though i can't connect sql server

else i can connect the same server which PC is using own internet connection not form network

i want to know that

how can we connect SQL Server using internet connection form network (proxy server)?

where is to enter networ pc IP address?

where is to enter port number?

Hi,

Just a bit of advice. That is a bad practice actually.You'll attract all the hackers in the world to get in to your box. That would force you to open port 1433 in your firewall to everyone else ... with out that port open you won't be able to connect to the server.

that is like saying. "hello world, we've got a 1433 port open "

if your pulling and pushing data to the server

how about using web services instead also

sql server 2000 has builtin support for IIS querries . i just forget the actual name.

just look for it in your start>programs>microsoft sql server 2000 then

look for something there with IIS.

for remote admin administration over the internet i'll strongly recommend this tool

http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en

http://www.microsoft.com/downloads/details.aspx?familyid=F0D03472-5E6C-459E-A6D8-6745A729C3C9&displaylang=en

regards,

joey

|||

Hi,r

I would suggest to refer below KBs for Proxy Configuration

http://www.support.microsoft.com/kb/890775

http://support.microsoft.com/kb/216415

and as stated it is not a best practice refer www.sqlsecurity.com 's checklist for securing sql server , i suggest to configure port nomber other then default and set appropriate firewall rules.

Regards

Hemantgiri S. Goswami

how to connect data base in sql

Hi
I have a problem with my data base.
when i run my project (ASP.NET) in Vs 2005 my data base work.
but i run in localhost isn′t work.
my data base as a .mdf(sql server)
Can help-me ?
Are you getting an error or isnt simply not working? Do you meanwhen you run it under IIS [as oppose to the development server] itdoesnt work?
|||yes it is an error message and it happens when i'm runing the IIS
The Link of my server is http://ocodigo.no-ip.info
Open a "Registar" option, you full fill then spaces and press "Registar" Botton, and next you will see the error.
|||Hello WATT
I couldn't see the error message. I think u have to change something inthe "web.config" file, so we could see the error message.
Because i got this message:

Server Error in '/' Application.

---

Runtime Error

Description:Anapplication error occurred on the server. The current custom errorsettings for this application prevent the details of the applicationerror from being viewed remotely (for security reasons). It could,however, be viewed by browsers running on the local server machine.
Details: To enable thedetails of this specific error message to be viewable on remotemachines, please create a <customErrors> tag within a"web.config" configuration file located in the root directory of thecurrent web application. This <customErrors> tag should then haveits "mode" attribute set to "Off".

<!-- Web.Config Configuration File -->
<configuration>
 <system.web>
 <customErrors mode="Off"/>
 </system.web>
</configuration>

Notes:The current error page you are seeing can be replaced by a custom errorpage by modifying the "defaultRedirect" attribute of the application's<customErrors> configuration tag to point to a custom error pageURL.

<!-- Web.Config Configuration File -->
<configuration>
 <system.web>
 <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
 </system.web>
</configuration>

Mow

How to configure SQL SERVER in local on windows xp os

Hi,

I need an suggestion how to run sql server in local. In my system sql server was not running in local, but when I connect to our remote data base with it's IP ,username and password, I can able to connect, but not in the local system sql server.I am using windows XP OS. I tried to register a new connectio to my local but i am getting an error the Acdess denied or connection faild.

Plz any one suggest me how to troubleshoot this problem

Regards
SarathyCould you tell some more details, Version of SQL Server, Firewall configured etc.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

How to configure multiple subscriber to same publisher using filte

Hi,
I have a base table in publisher db. I have a column, using which i want to
filter it and replicate it to certain dbs. how do i dynamically do it ?
Like for eg, consider this table :
ID Project name center
1 A NY
2 B LON
3 C PAR
now, i want to filter using the column "center". if center = 'NY', then i
must direct it to a particular subscriber. if it is "LON" then it must be
directed to someother subscriber. also, i must accomplish this using merge
replication
for my requirement, i am not able to use multiple publishers to accomplish
it. i must use one publisher, with a filter which varies dynamically
depending on the subscriber.
please explain how i can accomplish this.
PS : I'm new to databases. sorry if this question is very basic
Ki,
this question is not at all basic
You can use dynamic filtering in merge replication. Set up the filter as
center = HOST_NAME(). In the merge agent, before initializing, edit the
command-line parameters and add -HOSTNAME NY for the NY subscriber and so on
for the others.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

How to choose the hardware for SQL Server wit large data

Hi,
I have a large data base and data keeps adding daily. I have the current
number of rows and row size. How do i calculate the hardware power required
for such data? is there any method to calculate that? using which i may go
for server with 10 processcer with 1tb hard drive and some 5gb ram.
Below is my data detail.
Table Current Rows Daily addition Chars per Row
table 1 6,900,000 10000 30
table 2 4,000,000 5000 85
table 3 4,000,000 5000 35
table 4 2,000,000 2500 30
table 5 20,000 2500 65
table 6 4,000,000 5000 105
Please help me.
Regards,
Kiran7,000,000 is not a big table in database ...
I had one back in 2002 with more than 150,000,000 rows (in an automatic
partitionned view - ok) (Hardware : 2 processors, < 40GBytes).
By the way, you need to evaluate more points:
* peek number of simultaneous connections / peek value of 'count per minute'
* mean size of row data stored and returned
...
Sl.
"N Kiran Kumar" <N Kiran Kumar@.discussions.microsoft.com> a écrit dans le
message de news: 46BB099A-37CB-4D25-9728-1110CB9804CD@.microsoft.com...
> Hi,
> I have a large data base and data keeps adding daily. I have the
> current
> number of rows and row size. How do i calculate the hardware power
> required
> for such data? is there any method to calculate that? using which i may go
> for server with 10 processcer with 1tb hard drive and some 5gb ram.
> Below is my data detail.
> Table Current Rows Daily addition Chars per Row
> table 1 6,900,000 10000 30
> table 2 4,000,000 5000 85
> table 3 4,000,000 5000 35
> table 4 2,000,000 2500 30
> table 5 20,000 2500 65
> table 6 4,000,000 5000 105
> Please help me.
> Regards,
> Kiran
>
>|||Hi
Along with other posts!!
You should also talk to your hardware supplier! The hardware does depend on
what you are doing with your database and usually that tends to change over
time with new releases/requirements etc... Looking at the current hardware
and performance counters you may get some idea, whatever you come up with may
have to be compromised by budget.
As far as disc space goes you will probably need to intellegently place your
data, therefore look for more spindles (or the ability to add more) rather
than fewer discs with higher capacity.
This site and these articles may help
http://www.sql-server-performance.com/articles/per/hardware_planning_p1.aspx
John
"N Kiran Kumar" wrote:
> Hi,
> I have a large data base and data keeps adding daily. I have the current
> number of rows and row size. How do i calculate the hardware power required
> for such data? is there any method to calculate that? using which i may go
> for server with 10 processcer with 1tb hard drive and some 5gb ram.
> Below is my data detail.
> Table Current Rows Daily addition Chars per Row
> table 1 6,900,000 10000 30
> table 2 4,000,000 5000 85
> table 3 4,000,000 5000 35
> table 4 2,000,000 2500 30
> table 5 20,000 2500 65
> table 6 4,000,000 5000 105
> Please help me.
> Regards,
> Kiran
>
>

How to choose the hardware for SQL Server wit large data

Hi,
I have a large data base and data keeps adding daily. I have the current
number of rows and row size. How do i calculate the hardware power required
for such data? is there any method to calculate that? using which i may go
for server with 10 processcer with 1tb hard drive and some 5gb ram.
Below is my data detail.
Table Current Rows Daily addition Chars per Row
table 1 6,900,000 10000 30
table 2 4,000,000 5000 85
table 3 4,000,0005000 35
table 4 2,000,000 2500 30
table 5 20,000 2500 65
table 6 4,000,000 5000 105
Please help me.
Regards,
Kiran
Hi
Along with other posts!!
You should also talk to your hardware supplier! The hardware does depend on
what you are doing with your database and usually that tends to change over
time with new releases/requirements etc... Looking at the current hardware
and performance counters you may get some idea, whatever you come up with may
have to be compromised by budget.
As far as disc space goes you will probably need to intellegently place your
data, therefore look for more spindles (or the ability to add more) rather
than fewer discs with higher capacity.
This site and these articles may help
http://www.sql-server-performance.com/articles/per/hardware_planning_p1.aspx
John
"N Kiran Kumar" wrote:

> Hi,
> I have a large data base and data keeps adding daily. I have the current
> number of rows and row size. How do i calculate the hardware power required
> for such data? is there any method to calculate that? using which i may go
> for server with 10 processcer with 1tb hard drive and some 5gb ram.
> Below is my data detail.
> Table Current Rows Daily addition Chars per Row
> table 1 6,900,000 10000 30
> table 2 4,000,000 5000 85
> table 3 4,000,0005000 35
> table 4 2,000,000 2500 30
> table 5 20,000 2500 65
> table 6 4,000,000 5000 105
> Please help me.
> Regards,
> Kiran
>
>