I would like to offer SQL Database with my shared hosting and don't know how
to do this. Please note that both SQL and IIS are in the same machine. I
appriciate any help on this.
Thanks,
MikeIn a nutshell, you create a blank database for each customer, create a user
account that has dbo rights to that database (and no rights to any other),
and for goodness sake...make sure you back it up for them.
By the way...limit the number of databases, keep an eye on the usage and
performance of the server, and please make sure you call Microsoft to ensure
you have the proper licensing fees paid. Failure to do this opens you up to
legal liabililty.
Having IIS and SQL on the same box and doing shared hosting is a really bad
idea. Are you sure you are ready to go into SQL Server hosting?
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:90A6A1EC-E3F6-4268-B938-5CAC626030D2@.microsoft.com...
>I would like to offer SQL Database with my shared hosting and don't know
>how
> to do this. Please note that both SQL and IIS are in the same machine. I
> appriciate any help on this.
> Thanks,
> Mike|||Thanks Kevin for the quick reply.
I already had a user to give the rights to for this particular database.
So after reading your post I went into SQL Server Enterprise Manager and
created an empty database for that user. Then under Users of that database I
added the user from the Active Directory. I gave this user public and
db_owner role.
I tried to connect to this database remotely and I'm getting below error:
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access deined.
Can you please advice me? Thank you very much.
"Kevin3NF" wrote:
> In a nutshell, you create a blank database for each customer, create a user
> account that has dbo rights to that database (and no rights to any other),
> and for goodness sake...make sure you back it up for them.
> By the way...limit the number of databases, keep an eye on the usage and
> performance of the server, and please make sure you call Microsoft to ensure
> you have the proper licensing fees paid. Failure to do this opens you up to
> legal liabililty.
> Having IIS and SQL on the same box and doing shared hosting is a really bad
> idea. Are you sure you are ready to go into SQL Server hosting?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> news:90A6A1EC-E3F6-4268-B938-5CAC626030D2@.microsoft.com...
> >I would like to offer SQL Database with my shared hosting and don't know
> >how
> > to do this. Please note that both SQL and IIS are in the same machine. I
> > appriciate any help on this.
> >
> > Thanks,
> >
> > Mike
>
>|||First off, if you are a web host, you would be using SQL Server logins, not
Active Directory.
Remote connections more than likely need to be done via IP address, and the
correct port opened through the firewall.
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:09F06CF0-4A01-4B7C-97A0-902667EAE649@.microsoft.com...
> Thanks Kevin for the quick reply.
> I already had a user to give the rights to for this particular database.
> So after reading your post I went into SQL Server Enterprise Manager and
> created an empty database for that user. Then under Users of that database
> I
> added the user from the Active Directory. I gave this user public and
> db_owner role.
> I tried to connect to this database remotely and I'm getting below error:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 53
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
> access deined.
> Can you please advice me? Thank you very much.
>
> "Kevin3NF" wrote:
>> In a nutshell, you create a blank database for each customer, create a
>> user
>> account that has dbo rights to that database (and no rights to any
>> other),
>> and for goodness sake...make sure you back it up for them.
>> By the way...limit the number of databases, keep an eye on the usage and
>> performance of the server, and please make sure you call Microsoft to
>> ensure
>> you have the proper licensing fees paid. Failure to do this opens you up
>> to
>> legal liabililty.
>> Having IIS and SQL on the same box and doing shared hosting is a really
>> bad
>> idea. Are you sure you are ready to go into SQL Server hosting?
>> --
>> Kevin Hill
>> President
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>> www.experts-exchange.com - experts compete for points to answer your
>> questions
>>
>> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
>> news:90A6A1EC-E3F6-4268-B938-5CAC626030D2@.microsoft.com...
>> >I would like to offer SQL Database with my shared hosting and don't know
>> >how
>> > to do this. Please note that both SQL and IIS are in the same machine.
>> > I
>> > appriciate any help on this.
>> >
>> > Thanks,
>> >
>> > Mike
>>|||Thank you very much. I created a SQL user and opened the firewall port and
it's working now :)
"Kevin3NF" wrote:
> First off, if you are a web host, you would be using SQL Server logins, not
> Active Directory.
> Remote connections more than likely need to be done via IP address, and the
> correct port opened through the firewall.
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> news:09F06CF0-4A01-4B7C-97A0-902667EAE649@.microsoft.com...
> > Thanks Kevin for the quick reply.
> >
> > I already had a user to give the rights to for this particular database.
> >
> > So after reading your post I went into SQL Server Enterprise Manager and
> > created an empty database for that user. Then under Users of that database
> > I
> > added the user from the Active Directory. I gave this user public and
> > db_owner role.
> >
> > I tried to connect to this database remotely and I'm getting below error:
> >
> > Connection failed:
> > SQLState: '01000'
> > SQL Server Error: 53
> > [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
> > Connection failed:
> > SQLState: '08001'
> > SQL Server Error: 17
> > [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
> > access deined.
> >
> > Can you please advice me? Thank you very much.
> >
> >
> > "Kevin3NF" wrote:
> >
> >> In a nutshell, you create a blank database for each customer, create a
> >> user
> >> account that has dbo rights to that database (and no rights to any
> >> other),
> >> and for goodness sake...make sure you back it up for them.
> >>
> >> By the way...limit the number of databases, keep an eye on the usage and
> >> performance of the server, and please make sure you call Microsoft to
> >> ensure
> >> you have the proper licensing fees paid. Failure to do this opens you up
> >> to
> >> legal liabililty.
> >>
> >> Having IIS and SQL on the same box and doing shared hosting is a really
> >> bad
> >> idea. Are you sure you are ready to go into SQL Server hosting?
> >>
> >> --
> >> Kevin Hill
> >> President
> >> 3NF Consulting
> >>
> >> www.3nf-inc.com/NewsGroups.htm
> >>
> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> >>
> >> www.experts-exchange.com - experts compete for points to answer your
> >> questions
> >>
> >>
> >> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> >> news:90A6A1EC-E3F6-4268-B938-5CAC626030D2@.microsoft.com...
> >> >I would like to offer SQL Database with my shared hosting and don't know
> >> >how
> >> > to do this. Please note that both SQL and IIS are in the same machine.
> >> > I
> >> > appriciate any help on this.
> >> >
> >> > Thanks,
> >> >
> >> > Mike
> >>
> >>
> >>
>
>|||For security reasons, you may want to consider changing the default port
that SQL Server listens on to something other than 1433, since every script
kiddie on the planet knows that one...
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:DED2207A-8934-485D-A944-67D7D8C43557@.microsoft.com...
> Thank you very much. I created a SQL user and opened the firewall port and
> it's working now :)
> "Kevin3NF" wrote:
>> First off, if you are a web host, you would be using SQL Server logins,
>> not
>> Active Directory.
>> Remote connections more than likely need to be done via IP address, and
>> the
>> correct port opened through the firewall.
>> --
>> Kevin Hill
>> President
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>> www.experts-exchange.com - experts compete for points to answer your
>> questions
>>
>> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
>> news:09F06CF0-4A01-4B7C-97A0-902667EAE649@.microsoft.com...
>> > Thanks Kevin for the quick reply.
>> >
>> > I already had a user to give the rights to for this particular
>> > database.
>> >
>> > So after reading your post I went into SQL Server Enterprise Manager
>> > and
>> > created an empty database for that user. Then under Users of that
>> > database
>> > I
>> > added the user from the Active Directory. I gave this user public and
>> > db_owner role.
>> >
>> > I tried to connect to this database remotely and I'm getting below
>> > error:
>> >
>> > Connection failed:
>> > SQLState: '01000'
>> > SQL Server Error: 53
>> > [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
>> > (Connect()).
>> > Connection failed:
>> > SQLState: '08001'
>> > SQL Server Error: 17
>> > [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist
>> > or
>> > access deined.
>> >
>> > Can you please advice me? Thank you very much.
>> >
>> >
>> > "Kevin3NF" wrote:
>> >
>> >> In a nutshell, you create a blank database for each customer, create a
>> >> user
>> >> account that has dbo rights to that database (and no rights to any
>> >> other),
>> >> and for goodness sake...make sure you back it up for them.
>> >>
>> >> By the way...limit the number of databases, keep an eye on the usage
>> >> and
>> >> performance of the server, and please make sure you call Microsoft to
>> >> ensure
>> >> you have the proper licensing fees paid. Failure to do this opens you
>> >> up
>> >> to
>> >> legal liabililty.
>> >>
>> >> Having IIS and SQL on the same box and doing shared hosting is a
>> >> really
>> >> bad
>> >> idea. Are you sure you are ready to go into SQL Server hosting?
>> >>
>> >> --
>> >> Kevin Hill
>> >> President
>> >> 3NF Consulting
>> >>
>> >> www.3nf-inc.com/NewsGroups.htm
>> >>
>> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area
>> >> DBAs.
>> >>
>> >> www.experts-exchange.com - experts compete for points to answer your
>> >> questions
>> >>
>> >>
>> >> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
>> >> news:90A6A1EC-E3F6-4268-B938-5CAC626030D2@.microsoft.com...
>> >> >I would like to offer SQL Database with my shared hosting and don't
>> >> >know
>> >> >how
>> >> > to do this. Please note that both SQL and IIS are in the same
>> >> > machine.
>> >> > I
>> >> > appriciate any help on this.
>> >> >
>> >> > Thanks,
>> >> >
>> >> > Mike
>> >>
>> >>
>> >>
>>|||Thanks but how can I change that port on my server?
"Kevin3NF" wrote:
> For security reasons, you may want to consider changing the default port
> that SQL Server listens on to something other than 1433, since every script
> kiddie on the planet knows that one...
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> news:DED2207A-8934-485D-A944-67D7D8C43557@.microsoft.com...
> > Thank you very much. I created a SQL user and opened the firewall port and
> > it's working now :)
> >
> > "Kevin3NF" wrote:
> >
> >> First off, if you are a web host, you would be using SQL Server logins,
> >> not
> >> Active Directory.
> >>
> >> Remote connections more than likely need to be done via IP address, and
> >> the
> >> correct port opened through the firewall.
> >>
> >> --
> >> Kevin Hill
> >> President
> >> 3NF Consulting
> >>
> >> www.3nf-inc.com/NewsGroups.htm
> >>
> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> >>
> >> www.experts-exchange.com - experts compete for points to answer your
> >> questions
> >>
> >>
> >> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> >> news:09F06CF0-4A01-4B7C-97A0-902667EAE649@.microsoft.com...
> >> > Thanks Kevin for the quick reply.
> >> >
> >> > I already had a user to give the rights to for this particular
> >> > database.
> >> >
> >> > So after reading your post I went into SQL Server Enterprise Manager
> >> > and
> >> > created an empty database for that user. Then under Users of that
> >> > database
> >> > I
> >> > added the user from the Active Directory. I gave this user public and
> >> > db_owner role.
> >> >
> >> > I tried to connect to this database remotely and I'm getting below
> >> > error:
> >> >
> >> > Connection failed:
> >> > SQLState: '01000'
> >> > SQL Server Error: 53
> >> > [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
> >> > (Connect()).
> >> > Connection failed:
> >> > SQLState: '08001'
> >> > SQL Server Error: 17
> >> > [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist
> >> > or
> >> > access deined.
> >> >
> >> > Can you please advice me? Thank you very much.
> >> >
> >> >
> >> > "Kevin3NF" wrote:
> >> >
> >> >> In a nutshell, you create a blank database for each customer, create a
> >> >> user
> >> >> account that has dbo rights to that database (and no rights to any
> >> >> other),
> >> >> and for goodness sake...make sure you back it up for them.
> >> >>
> >> >> By the way...limit the number of databases, keep an eye on the usage
> >> >> and
> >> >> performance of the server, and please make sure you call Microsoft to
> >> >> ensure
> >> >> you have the proper licensing fees paid. Failure to do this opens you
> >> >> up
> >> >> to
> >> >> legal liabililty.
> >> >>
> >> >> Having IIS and SQL on the same box and doing shared hosting is a
> >> >> really
> >> >> bad
> >> >> idea. Are you sure you are ready to go into SQL Server hosting?
> >> >>
> >> >> --
> >> >> Kevin Hill
> >> >> President
> >> >> 3NF Consulting
> >> >>
> >> >> www.3nf-inc.com/NewsGroups.htm
> >> >>
> >> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area
> >> >> DBAs.
> >> >>
> >> >> www.experts-exchange.com - experts compete for points to answer your
> >> >> questions
> >> >>
> >> >>
> >> >> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> >> >> news:90A6A1EC-E3F6-4268-B938-5CAC626030D2@.microsoft.com...
> >> >> >I would like to offer SQL Database with my shared hosting and don't
> >> >> >know
> >> >> >how
> >> >> > to do this. Please note that both SQL and IIS are in the same
> >> >> > machine.
> >> >> > I
> >> >> > appriciate any help on this.
> >> >> >
> >> >> > Thanks,
> >> >> >
> >> >> > Mike
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Look at the server network utility, tcp parameters. New port number takes
effect when you restart the SQL Server service
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:4C7E4EA5-E9AA-4C22-BE8C-96FE2DDE67A2@.microsoft.com...
> Thanks but how can I change that port on my server?
> "Kevin3NF" wrote:
>> For security reasons, you may want to consider changing the default port
>> that SQL Server listens on to something other than 1433, since every
>> script
>> kiddie on the planet knows that one...
>> --
>> Kevin Hill
>> President
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>> www.experts-exchange.com - experts compete for points to answer your
>> questions
>>
>> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
>> news:DED2207A-8934-485D-A944-67D7D8C43557@.microsoft.com...
>> > Thank you very much. I created a SQL user and opened the firewall port
>> > and
>> > it's working now :)
>> >
>> > "Kevin3NF" wrote:
>> >
>> >> First off, if you are a web host, you would be using SQL Server
>> >> logins,
>> >> not
>> >> Active Directory.
>> >>
>> >> Remote connections more than likely need to be done via IP address,
>> >> and
>> >> the
>> >> correct port opened through the firewall.
>> >>
>> >> --
>> >> Kevin Hill
>> >> President
>> >> 3NF Consulting
>> >>
>> >> www.3nf-inc.com/NewsGroups.htm
>> >>
>> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area
>> >> DBAs.
>> >>
>> >> www.experts-exchange.com - experts compete for points to answer your
>> >> questions
>> >>
>> >>
>> >> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
>> >> news:09F06CF0-4A01-4B7C-97A0-902667EAE649@.microsoft.com...
>> >> > Thanks Kevin for the quick reply.
>> >> >
>> >> > I already had a user to give the rights to for this particular
>> >> > database.
>> >> >
>> >> > So after reading your post I went into SQL Server Enterprise Manager
>> >> > and
>> >> > created an empty database for that user. Then under Users of that
>> >> > database
>> >> > I
>> >> > added the user from the Active Directory. I gave this user public
>> >> > and
>> >> > db_owner role.
>> >> >
>> >> > I tried to connect to this database remotely and I'm getting below
>> >> > error:
>> >> >
>> >> > Connection failed:
>> >> > SQLState: '01000'
>> >> > SQL Server Error: 53
>> >> > [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
>> >> > (Connect()).
>> >> > Connection failed:
>> >> > SQLState: '08001'
>> >> > SQL Server Error: 17
>> >> > [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
>> >> > exist
>> >> > or
>> >> > access deined.
>> >> >
>> >> > Can you please advice me? Thank you very much.
>> >> >
>> >> >
>> >> > "Kevin3NF" wrote:
>> >> >
>> >> >> In a nutshell, you create a blank database for each customer,
>> >> >> create a
>> >> >> user
>> >> >> account that has dbo rights to that database (and no rights to any
>> >> >> other),
>> >> >> and for goodness sake...make sure you back it up for them.
>> >> >>
>> >> >> By the way...limit the number of databases, keep an eye on the
>> >> >> usage
>> >> >> and
>> >> >> performance of the server, and please make sure you call Microsoft
>> >> >> to
>> >> >> ensure
>> >> >> you have the proper licensing fees paid. Failure to do this opens
>> >> >> you
>> >> >> up
>> >> >> to
>> >> >> legal liabililty.
>> >> >>
>> >> >> Having IIS and SQL on the same box and doing shared hosting is a
>> >> >> really
>> >> >> bad
>> >> >> idea. Are you sure you are ready to go into SQL Server hosting?
>> >> >>
>> >> >> --
>> >> >> Kevin Hill
>> >> >> President
>> >> >> 3NF Consulting
>> >> >>
>> >> >> www.3nf-inc.com/NewsGroups.htm
>> >> >>
>> >> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area
>> >> >> DBAs.
>> >> >>
>> >> >> www.experts-exchange.com - experts compete for points to answer
>> >> >> your
>> >> >> questions
>> >> >>
>> >> >>
>> >> >> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
>> >> >> news:90A6A1EC-E3F6-4268-B938-5CAC626030D2@.microsoft.com...
>> >> >> >I would like to offer SQL Database with my shared hosting and
>> >> >> >don't
>> >> >> >know
>> >> >> >how
>> >> >> > to do this. Please note that both SQL and IIS are in the same
>> >> >> > machine.
>> >> >> > I
>> >> >> > appriciate any help on this.
>> >> >> >
>> >> >> > Thanks,
>> >> >> >
>> >> >> > Mike
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
Showing posts with label note. Show all posts
Showing posts with label note. Show all posts
Wednesday, March 21, 2012
How to setup a SQL Database for a shared web hosting?
I would like to offer SQL Database with my shared hosting and don't know how
to do this. Please note that both SQL and IIS are in the same machine. I
appriciate any help on this.
Thanks,
Mike
In a nutshell, you create a blank database for each customer, create a user
account that has dbo rights to that database (and no rights to any other),
and for goodness sake...make sure you back it up for them.
By the way...limit the number of databases, keep an eye on the usage and
performance of the server, and please make sure you call Microsoft to ensure
you have the proper licensing fees paid. Failure to do this opens you up to
legal liabililty.
Having IIS and SQL on the same box and doing shared hosting is a really bad
idea. Are you sure you are ready to go into SQL Server hosting?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:90A6A1EC-E3F6-4268-B938-5CAC626030D2@.microsoft.com...
>I would like to offer SQL Database with my shared hosting and don't know
>how
> to do this. Please note that both SQL and IIS are in the same machine. I
> appriciate any help on this.
> Thanks,
> Mike
|||Thanks Kevin for the quick reply.
I already had a user to give the rights to for this particular database.
So after reading your post I went into SQL Server Enterprise Manager and
created an empty database for that user. Then under Users of that database I
added the user from the Active Directory. I gave this user public and
db_owner role.
I tried to connect to this database remotely and I'm getting below error:
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access deined.
Can you please advice me? Thank you very much.
"Kevin3NF" wrote:
> In a nutshell, you create a blank database for each customer, create a user
> account that has dbo rights to that database (and no rights to any other),
> and for goodness sake...make sure you back it up for them.
> By the way...limit the number of databases, keep an eye on the usage and
> performance of the server, and please make sure you call Microsoft to ensure
> you have the proper licensing fees paid. Failure to do this opens you up to
> legal liabililty.
> Having IIS and SQL on the same box and doing shared hosting is a really bad
> idea. Are you sure you are ready to go into SQL Server hosting?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> news:90A6A1EC-E3F6-4268-B938-5CAC626030D2@.microsoft.com...
>
>
|||First off, if you are a web host, you would be using SQL Server logins, not
Active Directory.
Remote connections more than likely need to be done via IP address, and the
correct port opened through the firewall.
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:09F06CF0-4A01-4B7C-97A0-902667EAE649@.microsoft.com...[vbcol=seagreen]
> Thanks Kevin for the quick reply.
> I already had a user to give the rights to for this particular database.
> So after reading your post I went into SQL Server Enterprise Manager and
> created an empty database for that user. Then under Users of that database
> I
> added the user from the Active Directory. I gave this user public and
> db_owner role.
> I tried to connect to this database remotely and I'm getting below error:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 53
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
> access deined.
> Can you please advice me? Thank you very much.
>
> "Kevin3NF" wrote:
|||Thank you very much. I created a SQL user and opened the firewall port and
it's working now
"Kevin3NF" wrote:
> First off, if you are a web host, you would be using SQL Server logins, not
> Active Directory.
> Remote connections more than likely need to be done via IP address, and the
> correct port opened through the firewall.
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> news:09F06CF0-4A01-4B7C-97A0-902667EAE649@.microsoft.com...
>
>
|||For security reasons, you may want to consider changing the default port
that SQL Server listens on to something other than 1433, since every script
kiddie on the planet knows that one...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:DED2207A-8934-485D-A944-67D7D8C43557@.microsoft.com...[vbcol=seagreen]
> Thank you very much. I created a SQL user and opened the firewall port and
> it's working now
> "Kevin3NF" wrote:
|||Thanks but how can I change that port on my server?
"Kevin3NF" wrote:
> For security reasons, you may want to consider changing the default port
> that SQL Server listens on to something other than 1433, since every script
> kiddie on the planet knows that one...
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> news:DED2207A-8934-485D-A944-67D7D8C43557@.microsoft.com...
>
>
|||Look at the server network utility, tcp parameters. New port number takes
effect when you restart the SQL Server service
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:4C7E4EA5-E9AA-4C22-BE8C-96FE2DDE67A2@.microsoft.com...[vbcol=seagreen]
> Thanks but how can I change that port on my server?
> "Kevin3NF" wrote:
to do this. Please note that both SQL and IIS are in the same machine. I
appriciate any help on this.
Thanks,
Mike
In a nutshell, you create a blank database for each customer, create a user
account that has dbo rights to that database (and no rights to any other),
and for goodness sake...make sure you back it up for them.
By the way...limit the number of databases, keep an eye on the usage and
performance of the server, and please make sure you call Microsoft to ensure
you have the proper licensing fees paid. Failure to do this opens you up to
legal liabililty.
Having IIS and SQL on the same box and doing shared hosting is a really bad
idea. Are you sure you are ready to go into SQL Server hosting?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:90A6A1EC-E3F6-4268-B938-5CAC626030D2@.microsoft.com...
>I would like to offer SQL Database with my shared hosting and don't know
>how
> to do this. Please note that both SQL and IIS are in the same machine. I
> appriciate any help on this.
> Thanks,
> Mike
|||Thanks Kevin for the quick reply.
I already had a user to give the rights to for this particular database.
So after reading your post I went into SQL Server Enterprise Manager and
created an empty database for that user. Then under Users of that database I
added the user from the Active Directory. I gave this user public and
db_owner role.
I tried to connect to this database remotely and I'm getting below error:
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access deined.
Can you please advice me? Thank you very much.
"Kevin3NF" wrote:
> In a nutshell, you create a blank database for each customer, create a user
> account that has dbo rights to that database (and no rights to any other),
> and for goodness sake...make sure you back it up for them.
> By the way...limit the number of databases, keep an eye on the usage and
> performance of the server, and please make sure you call Microsoft to ensure
> you have the proper licensing fees paid. Failure to do this opens you up to
> legal liabililty.
> Having IIS and SQL on the same box and doing shared hosting is a really bad
> idea. Are you sure you are ready to go into SQL Server hosting?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> news:90A6A1EC-E3F6-4268-B938-5CAC626030D2@.microsoft.com...
>
>
|||First off, if you are a web host, you would be using SQL Server logins, not
Active Directory.
Remote connections more than likely need to be done via IP address, and the
correct port opened through the firewall.
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:09F06CF0-4A01-4B7C-97A0-902667EAE649@.microsoft.com...[vbcol=seagreen]
> Thanks Kevin for the quick reply.
> I already had a user to give the rights to for this particular database.
> So after reading your post I went into SQL Server Enterprise Manager and
> created an empty database for that user. Then under Users of that database
> I
> added the user from the Active Directory. I gave this user public and
> db_owner role.
> I tried to connect to this database remotely and I'm getting below error:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 53
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
> access deined.
> Can you please advice me? Thank you very much.
>
> "Kevin3NF" wrote:
|||Thank you very much. I created a SQL user and opened the firewall port and
it's working now
"Kevin3NF" wrote:
> First off, if you are a web host, you would be using SQL Server logins, not
> Active Directory.
> Remote connections more than likely need to be done via IP address, and the
> correct port opened through the firewall.
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> news:09F06CF0-4A01-4B7C-97A0-902667EAE649@.microsoft.com...
>
>
|||For security reasons, you may want to consider changing the default port
that SQL Server listens on to something other than 1433, since every script
kiddie on the planet knows that one...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:DED2207A-8934-485D-A944-67D7D8C43557@.microsoft.com...[vbcol=seagreen]
> Thank you very much. I created a SQL user and opened the firewall port and
> it's working now
> "Kevin3NF" wrote:
|||Thanks but how can I change that port on my server?
"Kevin3NF" wrote:
> For security reasons, you may want to consider changing the default port
> that SQL Server listens on to something other than 1433, since every script
> kiddie on the planet knows that one...
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> news:DED2207A-8934-485D-A944-67D7D8C43557@.microsoft.com...
>
>
|||Look at the server network utility, tcp parameters. New port number takes
effect when you restart the SQL Server service
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:4C7E4EA5-E9AA-4C22-BE8C-96FE2DDE67A2@.microsoft.com...[vbcol=seagreen]
> Thanks but how can I change that port on my server?
> "Kevin3NF" wrote:
How to setup a SQL Database for a shared web hosting?
I would like to offer SQL Database with my shared hosting and don't know how
to do this. Please note that both SQL and IIS are in the same machine. I
appriciate any help on this.
Thanks,
MikeIn a nutshell, you create a blank database for each customer, create a user
account that has dbo rights to that database (and no rights to any other),
and for goodness sake...make sure you back it up for them.
By the way...limit the number of databases, keep an eye on the usage and
performance of the server, and please make sure you call Microsoft to ensure
you have the proper licensing fees paid. Failure to do this opens you up to
legal liabililty.
Having IIS and SQL on the same box and doing shared hosting is a really bad
idea. Are you sure you are ready to go into SQL Server hosting?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:90A6A1EC-E3F6-4268-B938-5CAC626030D2@.microsoft.com...
>I would like to offer SQL Database with my shared hosting and don't know
>how
> to do this. Please note that both SQL and IIS are in the same machine. I
> appriciate any help on this.
> Thanks,
> Mike|||Thanks Kevin for the quick reply.
I already had a user to give the rights to for this particular database.
So after reading your post I went into SQL Server Enterprise Manager and
created an empty database for that user. Then under Users of that database I
added the user from the Active Directory. I gave this user public and
db_owner role.
I tried to connect to this database remotely and I'm getting below error:
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Con
nect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or
access deined.
Can you please advice me? Thank you very much.
"Kevin3NF" wrote:
> In a nutshell, you create a blank database for each customer, create a use
r
> account that has dbo rights to that database (and no rights to any other),
> and for goodness sake...make sure you back it up for them.
> By the way...limit the number of databases, keep an eye on the usage and
> performance of the server, and please make sure you call Microsoft to ensu
re
> you have the proper licensing fees paid. Failure to do this opens you up
to
> legal liabililty.
> Having IIS and SQL on the same box and doing shared hosting is a really ba
d
> idea. Are you sure you are ready to go into SQL Server hosting?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> news:90A6A1EC-E3F6-4268-B938-5CAC626030D2@.microsoft.com...
>
>|||First off, if you are a web host, you would be using SQL Server logins, not
Active Directory.
Remote connections more than likely need to be done via IP address, and the
correct port opened through the firewall.
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:09F06CF0-4A01-4B7C-97A0-902667EAE649@.microsoft.com...[vbcol=seagreen]
> Thanks Kevin for the quick reply.
> I already had a user to give the rights to for this particular database.
> So after reading your post I went into SQL Server Enterprise Manager and
> created an empty database for that user. Then under Users of that database
> I
> added the user from the Active Directory. I gave this user public and
> db_owner role.
> I tried to connect to this database remotely and I'm getting below error:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 53
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (C
onnect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does n
ot exist or
> access deined.
> Can you please advice me? Thank you very much.
>
> "Kevin3NF" wrote:
>|||Thank you very much. I created a SQL user and opened the firewall port and
it's working now
"Kevin3NF" wrote:
> First off, if you are a web host, you would be using SQL Server logins, no
t
> Active Directory.
> Remote connections more than likely need to be done via IP address, and th
e
> correct port opened through the firewall.
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> news:09F06CF0-4A01-4B7C-97A0-902667EAE649@.microsoft.com...
>
>|||For security reasons, you may want to consider changing the default port
that SQL Server listens on to something other than 1433, since every script
kiddie on the planet knows that one...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:DED2207A-8934-485D-A944-67D7D8C43557@.microsoft.com...[vbcol=seagreen]
> Thank you very much. I created a SQL user and opened the firewall port and
> it's working now
> "Kevin3NF" wrote:
>|||Thanks but how can I change that port on my server?
"Kevin3NF" wrote:
> For security reasons, you may want to consider changing the default port
> that SQL Server listens on to something other than 1433, since every scrip
t
> kiddie on the planet knows that one...
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> news:DED2207A-8934-485D-A944-67D7D8C43557@.microsoft.com...
>
>|||Look at the server network utility, tcp parameters. New port number takes
effect when you restart the SQL Server service
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:4C7E4EA5-E9AA-4C22-BE8C-96FE2DDE67A2@.microsoft.com...[vbcol=seagreen]
> Thanks but how can I change that port on my server?
> "Kevin3NF" wrote:
>
to do this. Please note that both SQL and IIS are in the same machine. I
appriciate any help on this.
Thanks,
MikeIn a nutshell, you create a blank database for each customer, create a user
account that has dbo rights to that database (and no rights to any other),
and for goodness sake...make sure you back it up for them.
By the way...limit the number of databases, keep an eye on the usage and
performance of the server, and please make sure you call Microsoft to ensure
you have the proper licensing fees paid. Failure to do this opens you up to
legal liabililty.
Having IIS and SQL on the same box and doing shared hosting is a really bad
idea. Are you sure you are ready to go into SQL Server hosting?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:90A6A1EC-E3F6-4268-B938-5CAC626030D2@.microsoft.com...
>I would like to offer SQL Database with my shared hosting and don't know
>how
> to do this. Please note that both SQL and IIS are in the same machine. I
> appriciate any help on this.
> Thanks,
> Mike|||Thanks Kevin for the quick reply.
I already had a user to give the rights to for this particular database.
So after reading your post I went into SQL Server Enterprise Manager and
created an empty database for that user. Then under Users of that database I
added the user from the Active Directory. I gave this user public and
db_owner role.
I tried to connect to this database remotely and I'm getting below error:
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Con
nect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or
access deined.
Can you please advice me? Thank you very much.
"Kevin3NF" wrote:
> In a nutshell, you create a blank database for each customer, create a use
r
> account that has dbo rights to that database (and no rights to any other),
> and for goodness sake...make sure you back it up for them.
> By the way...limit the number of databases, keep an eye on the usage and
> performance of the server, and please make sure you call Microsoft to ensu
re
> you have the proper licensing fees paid. Failure to do this opens you up
to
> legal liabililty.
> Having IIS and SQL on the same box and doing shared hosting is a really ba
d
> idea. Are you sure you are ready to go into SQL Server hosting?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> news:90A6A1EC-E3F6-4268-B938-5CAC626030D2@.microsoft.com...
>
>|||First off, if you are a web host, you would be using SQL Server logins, not
Active Directory.
Remote connections more than likely need to be done via IP address, and the
correct port opened through the firewall.
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:09F06CF0-4A01-4B7C-97A0-902667EAE649@.microsoft.com...[vbcol=seagreen]
> Thanks Kevin for the quick reply.
> I already had a user to give the rights to for this particular database.
> So after reading your post I went into SQL Server Enterprise Manager and
> created an empty database for that user. Then under Users of that database
> I
> added the user from the Active Directory. I gave this user public and
> db_owner role.
> I tried to connect to this database remotely and I'm getting below error:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 53
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (C
onnect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does n
ot exist or
> access deined.
> Can you please advice me? Thank you very much.
>
> "Kevin3NF" wrote:
>|||Thank you very much. I created a SQL user and opened the firewall port and
it's working now
"Kevin3NF" wrote:
> First off, if you are a web host, you would be using SQL Server logins, no
t
> Active Directory.
> Remote connections more than likely need to be done via IP address, and th
e
> correct port opened through the firewall.
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> news:09F06CF0-4A01-4B7C-97A0-902667EAE649@.microsoft.com...
>
>|||For security reasons, you may want to consider changing the default port
that SQL Server listens on to something other than 1433, since every script
kiddie on the planet knows that one...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:DED2207A-8934-485D-A944-67D7D8C43557@.microsoft.com...[vbcol=seagreen]
> Thank you very much. I created a SQL user and opened the firewall port and
> it's working now
> "Kevin3NF" wrote:
>|||Thanks but how can I change that port on my server?
"Kevin3NF" wrote:
> For security reasons, you may want to consider changing the default port
> that SQL Server listens on to something other than 1433, since every scrip
t
> kiddie on the planet knows that one...
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Mike R." <MikeR@.discussions.microsoft.com> wrote in message
> news:DED2207A-8934-485D-A944-67D7D8C43557@.microsoft.com...
>
>|||Look at the server network utility, tcp parameters. New port number takes
effect when you restart the SQL Server service
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mike R." <MikeR@.discussions.microsoft.com> wrote in message
news:4C7E4EA5-E9AA-4C22-BE8C-96FE2DDE67A2@.microsoft.com...[vbcol=seagreen]
> Thanks but how can I change that port on my server?
> "Kevin3NF" wrote:
>
Sunday, February 19, 2012
how to set a dimension attribute as a simple "note" field?
I have a simple cube,
dimensions are time and customers (id, name, address, contry, etc), fact are
quantity
On Y axes I have to show the customer name AND the address.
if I drag and drop only the id and name, the query is fast, and it works
fine, If after the name I also add the address, the query becames very slow
I belive this is because of aggregation on the address attribute, that I
really don't need, the address is specific to every customer and it does not
make any sense to do calculation on this.
I only need to show che address near the name, without any aggregation
How can I do it?
Is there any property I have to set?
Thank you
Alessandro Belli
Hello Alessandro,
I understand that you'd like to specify an dimension attribute as a
property not to be aggregated. If I'm off-base, please let me know.
You may want to consider define attribute relationship bewteen attribute
name and address, thus you could display address as member property of name
and do not necessary to drag name attribute to the browser which cause more
calculations and overhead even if they are 1:1 relationship. When you drag
a dimension attribute into the browser it is used as normal attribute
anyway though at running time, it will gain performance improvement when
engine may find it has 1:1 relationship with another attribute.
By default, dimension attribute are related to key dimension attribute by a
attribute relationship. In VS 2005, you could open the dimension in VS
project, and check the attribute relationships defined on the key attribute
( I assume it is "id" in the dimension).
You may want to create a attribute relationship directly on name attribute
and define the relationship bweteen name and address. You will be able to
see address as the member property of the name attribute in browser. You
could right click the a name cell->Show properties in report->Show All
properties in report.
The other option that you could display name/address at the same time ( I
assume it is 1:1 relationship) is that you create a new column on dimension
source table, and merge (name, address) column to a new column such as
name-address. You could use this new column as a attribute directly in the
dimension attribute.
If you have further questions or concerns on the issue, please feel free to
let's know. Than you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications
<http://msdn.microsoft.com/subscripti...s/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscripti...t/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Peter Yang [MSFT] wrote:
> Hello Alessandro,
> I understand that you'd like to specify an dimension attribute as a
> property not to be aggregated. If I'm off-base, please let me know.
> You may want to consider define attribute relationship bewteen attribute
> name and address, thus you could display address as member property of name
> and do not necessary to drag name attribute to the browser which cause more
> calculations and overhead even if they are 1:1 relationship. When you drag
> a dimension attribute into the browser it is used as normal attribute
> anyway though at running time, it will gain performance improvement when
> engine may find it has 1:1 relationship with another attribute.
> By default, dimension attribute are related to key dimension attribute by a
> attribute relationship. In VS 2005, you could open the dimension in VS
> project, and check the attribute relationships defined on the key attribute
> ( I assume it is "id" in the dimension).
> You may want to create a attribute relationship directly on name attribute
> and define the relationship bweteen name and address. You will be able to
> see address as the member property of the name attribute in browser. You
> could right click the a name cell->Show properties in report->Show All
> properties in report.
> The other option that you could display name/address at the same time ( I
> assume it is 1:1 relationship) is that you create a new column on dimension
> source table, and merge (name, address) column to a new column such as
> name-address. You could use this new column as a attribute directly in the
> dimension attribute.
> If you have further questions or concerns on the issue, please feel free to
> let's know. Than you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscripti...ult.aspx#notif
> ications
> <http://msdn.microsoft.com/subscripti...s/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscripti...t/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
You can add address as property for name attribute and can create
calculated measure on this property.
Regards
Amish Shah
http://shahamishm.tripod.com
|||Peter Yang [MSFT] wrote:
> Hello Alessandro,
> I understand that you'd like to specify an dimension attribute as a
> property not to be aggregated. If I'm off-base, please let me know.
> You may want to consider define attribute relationship bewteen attribute
> name and address, thus you could display address as member property of name
> and do not necessary to drag name attribute to the browser which cause more
> calculations and overhead even if they are 1:1 relationship. When you drag
> a dimension attribute into the browser it is used as normal attribute
> anyway though at running time, it will gain performance improvement when
> engine may find it has 1:1 relationship with another attribute.
> By default, dimension attribute are related to key dimension attribute by a
> attribute relationship. In VS 2005, you could open the dimension in VS
> project, and check the attribute relationships defined on the key attribute
> ( I assume it is "id" in the dimension).
> You may want to create a attribute relationship directly on name attribute
> and define the relationship bweteen name and address. You will be able to
> see address as the member property of the name attribute in browser. You
> could right click the a name cell->Show properties in report->Show All
> properties in report.
> The other option that you could display name/address at the same time ( I
> assume it is 1:1 relationship) is that you create a new column on dimension
> source table, and merge (name, address) column to a new column such as
> name-address. You could use this new column as a attribute directly in the
> dimension attribute.
> If you have further questions or concerns on the issue, please feel free to
> let's know. Than you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscripti...ult.aspx#notif
> ications
> <http://msdn.microsoft.com/subscripti...s/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscripti...t/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
You can add address as property for name attribute and can create
calculated measure on this property.
Regards
Amish Shah
http://shahamishm.tripod.com
|||Thank you for you suggestion, but is not clear to me how to make a
relationship between name and address.
Is enought to set address.keycolumn= customers.name and
addess.namecolumn=address?
Or what I have to do to make the realtionship?
The key of the dimension is a field named "code". Do I also have to set
name.keycolumn=customers.code?
After this when I browse the cube and I right click the name cell->Show
properties in report->Show All
> properties in report the option is grayed.
Thank's
Alessandro
"Peter Yang [MSFT]" <petery@.online.microsoft.com> ha scritto nel messaggio
news:gdsQ4cR4GHA.2336@.TK2MSFTNGXA01.phx.gbl...
> Hello Alessandro,
> I understand that you'd like to specify an dimension attribute as a
> property not to be aggregated. If I'm off-base, please let me know.
> You may want to consider define attribute relationship bewteen attribute
> name and address, thus you could display address as member property of
> name
> and do not necessary to drag name attribute to the browser which cause
> more
> calculations and overhead even if they are 1:1 relationship. When you drag
> a dimension attribute into the browser it is used as normal attribute
> anyway though at running time, it will gain performance improvement when
> engine may find it has 1:1 relationship with another attribute.
> By default, dimension attribute are related to key dimension attribute by
> a
> attribute relationship. In VS 2005, you could open the dimension in VS
> project, and check the attribute relationships defined on the key
> attribute
> ( I assume it is "id" in the dimension).
> You may want to create a attribute relationship directly on name attribute
> and define the relationship bweteen name and address. You will be able to
> see address as the member property of the name attribute in browser. You
> could right click the a name cell->Show properties in report->Show All
> properties in report.
> The other option that you could display name/address at the same time ( I
> assume it is 1:1 relationship) is that you create a new column on
> dimension
> source table, and merge (name, address) column to a new column such as
> name-address. You could use this new column as a attribute directly in the
> dimension attribute.
> If you have further questions or concerns on the issue, please feel free
> to
> let's know. Than you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscripti...ult.aspx#notif
> ications
> <http://msdn.microsoft.com/subscripti...s/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscripti...t/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
|||Hello Alessandro,
You could try the following steps to add attribute relationship between
name and address attribute.
1. Open customer dimension by double click the dimension on the right panel
2. Drag Address column from the source table in Data Source View to the
Name Attribute on the left panel, and you shall see a new Attribute
relationship under attribute Name.
3. Process the dimension and cube and you shall see member property Address
under Name Attribute
Please see if this could meet your requirement. If you have any concerns or
questions, please let me know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
dimensions are time and customers (id, name, address, contry, etc), fact are
quantity
On Y axes I have to show the customer name AND the address.
if I drag and drop only the id and name, the query is fast, and it works
fine, If after the name I also add the address, the query becames very slow
I belive this is because of aggregation on the address attribute, that I
really don't need, the address is specific to every customer and it does not
make any sense to do calculation on this.
I only need to show che address near the name, without any aggregation
How can I do it?
Is there any property I have to set?
Thank you
Alessandro Belli
Hello Alessandro,
I understand that you'd like to specify an dimension attribute as a
property not to be aggregated. If I'm off-base, please let me know.
You may want to consider define attribute relationship bewteen attribute
name and address, thus you could display address as member property of name
and do not necessary to drag name attribute to the browser which cause more
calculations and overhead even if they are 1:1 relationship. When you drag
a dimension attribute into the browser it is used as normal attribute
anyway though at running time, it will gain performance improvement when
engine may find it has 1:1 relationship with another attribute.
By default, dimension attribute are related to key dimension attribute by a
attribute relationship. In VS 2005, you could open the dimension in VS
project, and check the attribute relationships defined on the key attribute
( I assume it is "id" in the dimension).
You may want to create a attribute relationship directly on name attribute
and define the relationship bweteen name and address. You will be able to
see address as the member property of the name attribute in browser. You
could right click the a name cell->Show properties in report->Show All
properties in report.
The other option that you could display name/address at the same time ( I
assume it is 1:1 relationship) is that you create a new column on dimension
source table, and merge (name, address) column to a new column such as
name-address. You could use this new column as a attribute directly in the
dimension attribute.
If you have further questions or concerns on the issue, please feel free to
let's know. Than you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications
<http://msdn.microsoft.com/subscripti...s/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscripti...t/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Peter Yang [MSFT] wrote:
> Hello Alessandro,
> I understand that you'd like to specify an dimension attribute as a
> property not to be aggregated. If I'm off-base, please let me know.
> You may want to consider define attribute relationship bewteen attribute
> name and address, thus you could display address as member property of name
> and do not necessary to drag name attribute to the browser which cause more
> calculations and overhead even if they are 1:1 relationship. When you drag
> a dimension attribute into the browser it is used as normal attribute
> anyway though at running time, it will gain performance improvement when
> engine may find it has 1:1 relationship with another attribute.
> By default, dimension attribute are related to key dimension attribute by a
> attribute relationship. In VS 2005, you could open the dimension in VS
> project, and check the attribute relationships defined on the key attribute
> ( I assume it is "id" in the dimension).
> You may want to create a attribute relationship directly on name attribute
> and define the relationship bweteen name and address. You will be able to
> see address as the member property of the name attribute in browser. You
> could right click the a name cell->Show properties in report->Show All
> properties in report.
> The other option that you could display name/address at the same time ( I
> assume it is 1:1 relationship) is that you create a new column on dimension
> source table, and merge (name, address) column to a new column such as
> name-address. You could use this new column as a attribute directly in the
> dimension attribute.
> If you have further questions or concerns on the issue, please feel free to
> let's know. Than you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscripti...ult.aspx#notif
> ications
> <http://msdn.microsoft.com/subscripti...s/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscripti...t/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
You can add address as property for name attribute and can create
calculated measure on this property.
Regards
Amish Shah
http://shahamishm.tripod.com
|||Peter Yang [MSFT] wrote:
> Hello Alessandro,
> I understand that you'd like to specify an dimension attribute as a
> property not to be aggregated. If I'm off-base, please let me know.
> You may want to consider define attribute relationship bewteen attribute
> name and address, thus you could display address as member property of name
> and do not necessary to drag name attribute to the browser which cause more
> calculations and overhead even if they are 1:1 relationship. When you drag
> a dimension attribute into the browser it is used as normal attribute
> anyway though at running time, it will gain performance improvement when
> engine may find it has 1:1 relationship with another attribute.
> By default, dimension attribute are related to key dimension attribute by a
> attribute relationship. In VS 2005, you could open the dimension in VS
> project, and check the attribute relationships defined on the key attribute
> ( I assume it is "id" in the dimension).
> You may want to create a attribute relationship directly on name attribute
> and define the relationship bweteen name and address. You will be able to
> see address as the member property of the name attribute in browser. You
> could right click the a name cell->Show properties in report->Show All
> properties in report.
> The other option that you could display name/address at the same time ( I
> assume it is 1:1 relationship) is that you create a new column on dimension
> source table, and merge (name, address) column to a new column such as
> name-address. You could use this new column as a attribute directly in the
> dimension attribute.
> If you have further questions or concerns on the issue, please feel free to
> let's know. Than you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscripti...ult.aspx#notif
> ications
> <http://msdn.microsoft.com/subscripti...s/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscripti...t/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
You can add address as property for name attribute and can create
calculated measure on this property.
Regards
Amish Shah
http://shahamishm.tripod.com
|||Thank you for you suggestion, but is not clear to me how to make a
relationship between name and address.
Is enought to set address.keycolumn= customers.name and
addess.namecolumn=address?
Or what I have to do to make the realtionship?
The key of the dimension is a field named "code". Do I also have to set
name.keycolumn=customers.code?
After this when I browse the cube and I right click the name cell->Show
properties in report->Show All
> properties in report the option is grayed.
Thank's
Alessandro
"Peter Yang [MSFT]" <petery@.online.microsoft.com> ha scritto nel messaggio
news:gdsQ4cR4GHA.2336@.TK2MSFTNGXA01.phx.gbl...
> Hello Alessandro,
> I understand that you'd like to specify an dimension attribute as a
> property not to be aggregated. If I'm off-base, please let me know.
> You may want to consider define attribute relationship bewteen attribute
> name and address, thus you could display address as member property of
> name
> and do not necessary to drag name attribute to the browser which cause
> more
> calculations and overhead even if they are 1:1 relationship. When you drag
> a dimension attribute into the browser it is used as normal attribute
> anyway though at running time, it will gain performance improvement when
> engine may find it has 1:1 relationship with another attribute.
> By default, dimension attribute are related to key dimension attribute by
> a
> attribute relationship. In VS 2005, you could open the dimension in VS
> project, and check the attribute relationships defined on the key
> attribute
> ( I assume it is "id" in the dimension).
> You may want to create a attribute relationship directly on name attribute
> and define the relationship bweteen name and address. You will be able to
> see address as the member property of the name attribute in browser. You
> could right click the a name cell->Show properties in report->Show All
> properties in report.
> The other option that you could display name/address at the same time ( I
> assume it is 1:1 relationship) is that you create a new column on
> dimension
> source table, and merge (name, address) column to a new column such as
> name-address. You could use this new column as a attribute directly in the
> dimension attribute.
> If you have further questions or concerns on the issue, please feel free
> to
> let's know. Than you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscripti...ult.aspx#notif
> ications
> <http://msdn.microsoft.com/subscripti...s/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscripti...t/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
|||Hello Alessandro,
You could try the following steps to add attribute relationship between
name and address attribute.
1. Open customer dimension by double click the dimension on the right panel
2. Drag Address column from the source table in Data Source View to the
Name Attribute on the left panel, and you shall see a new Attribute
relationship under attribute Name.
3. Process the dimension and cube and you shall see member property Address
under Name Attribute
Please see if this could meet your requirement. If you have any concerns or
questions, please let me know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
how to set a dimension attribute as a simple "note" field?
I have a simple cube,
dimensions are time and customers (id, name, address, contry, etc), fact are
quantity
On Y axes I have to show the customer name AND the address.
if I drag and drop only the id and name, the query is fast, and it works
fine, If after the name I also add the address, the query becames very slow
I belive this is because of aggregation on the address attribute, that I
really don't need, the address is specific to every customer and it does not
make any sense to do calculation on this.
I only need to show che address near the name, without any aggregation
How can I do it?
Is there any property I have to set?
Thank you
Alessandro BelliHello Alessandro,
I understand that you'd like to specify an dimension attribute as a
property not to be aggregated. If I'm off-base, please let me know.
You may want to consider define attribute relationship bewteen attribute
name and address, thus you could display address as member property of name
and do not necessary to drag name attribute to the browser which cause more
calculations and overhead even if they are 1:1 relationship. When you drag
a dimension attribute into the browser it is used as normal attribute
anyway though at running time, it will gain performance improvement when
engine may find it has 1:1 relationship with another attribute.
By default, dimension attribute are related to key dimension attribute by a
attribute relationship. In VS 2005, you could open the dimension in VS
project, and check the attribute relationships defined on the key attribute
( I assume it is "id" in the dimension).
You may want to create a attribute relationship directly on name attribute
and define the relationship bweteen name and address. You will be able to
see address as the member property of the name attribute in browser. You
could right click the a name cell->Show properties in report->Show All
properties in report.
The other option that you could display name/address at the same time ( I
assume it is 1:1 relationship) is that you create a new column on dimension
source table, and merge (name, address) column to a new column such as
name-address. You could use this new column as a attribute directly in the
dimension attribute.
If you have further questions or concerns on the issue, please feel free to
let's know. Than you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Peter Yang [MSFT] wrote:
[vbcol=seagreen]
> Hello Alessandro,
> I understand that you'd like to specify an dimension attribute as a
> property not to be aggregated. If I'm off-base, please let me know.
> You may want to consider define attribute relationship bewteen attribute
> name and address, thus you could display address as member property of nam
e
> and do not necessary to drag name attribute to the browser which cause mor
e
> calculations and overhead even if they are 1:1 relationship. When you drag
> a dimension attribute into the browser it is used as normal attribute
> anyway though at running time, it will gain performance improvement when
> engine may find it has 1:1 relationship with another attribute.
> By default, dimension attribute are related to key dimension attribute by
a
> attribute relationship. In VS 2005, you could open the dimension in VS
> project, and check the attribute relationships defined on the key attribut
e
> ( I assume it is "id" in the dimension).
> You may want to create a attribute relationship directly on name attribute
> and define the relationship bweteen name and address. You will be able to
> see address as the member property of the name attribute in browser. You
> could right click the a name cell->Show properties in report->Show All
> properties in report.
> The other option that you could display name/address at the same time ( I
> assume it is 1:1 relationship) is that you create a new column on dimensio
n
> source table, and merge (name, address) column to a new column such as
> name-address. You could use this new column as a attribute directly in the
> dimension attribute.
> If you have further questions or concerns on the issue, please feel free t
o
> let's know. Than you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ========================================
==========
> Get notification to my posts through email? Please refer to
> l]
> ications
> <[url]http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx" target="_blank">http://msdn.microsoft.com/subscript...ps/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscript...rt/default.aspx>.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no rights.[/vbcol
]
You can add address as property for name attribute and can create
calculated measure on this property.
Regards
Amish Shah
http://shahamishm.tripod.com|||Peter Yang [MSFT] wrote:
[vbcol=seagreen]
> Hello Alessandro,
> I understand that you'd like to specify an dimension attribute as a
> property not to be aggregated. If I'm off-base, please let me know.
> You may want to consider define attribute relationship bewteen attribute
> name and address, thus you could display address as member property of nam
e
> and do not necessary to drag name attribute to the browser which cause mor
e
> calculations and overhead even if they are 1:1 relationship. When you drag
> a dimension attribute into the browser it is used as normal attribute
> anyway though at running time, it will gain performance improvement when
> engine may find it has 1:1 relationship with another attribute.
> By default, dimension attribute are related to key dimension attribute by
a
> attribute relationship. In VS 2005, you could open the dimension in VS
> project, and check the attribute relationships defined on the key attribut
e
> ( I assume it is "id" in the dimension).
> You may want to create a attribute relationship directly on name attribute
> and define the relationship bweteen name and address. You will be able to
> see address as the member property of the name attribute in browser. You
> could right click the a name cell->Show properties in report->Show All
> properties in report.
> The other option that you could display name/address at the same time ( I
> assume it is 1:1 relationship) is that you create a new column on dimensio
n
> source table, and merge (name, address) column to a new column such as
> name-address. You could use this new column as a attribute directly in the
> dimension attribute.
> If you have further questions or concerns on the issue, please feel free t
o
> let's know. Than you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ========================================
==========
> Get notification to my posts through email? Please refer to
> l]
> ications
> <[url]http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx" target="_blank">http://msdn.microsoft.com/subscript...ps/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscript...rt/default.aspx>.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no rights.[/vbcol
]
You can add address as property for name attribute and can create
calculated measure on this property.
Regards
Amish Shah
http://shahamishm.tripod.com|||Thank you for you suggestion, but is not clear to me how to make a
relationship between name and address.
Is enought to set address.keycolumn= customers.name and
addess.namecolumn=address?
Or what I have to do to make the realtionship?
The key of the dimension is a field named "code". Do I also have to set
name.keycolumn=customers.code?
After this when I browse the cube and I right click the name cell->Show
properties in report->Show All
> properties in report the option is grayed.
Thank's
Alessandro
"Peter Yang [MSFT]" <petery@.online.microsoft.com> ha scritto nel messagg
io
news:gdsQ4cR4GHA.2336@.TK2MSFTNGXA01.phx.gbl...
> Hello Alessandro,
> I understand that you'd like to specify an dimension attribute as a
> property not to be aggregated. If I'm off-base, please let me know.
> You may want to consider define attribute relationship bewteen attribute
> name and address, thus you could display address as member property of
> name
> and do not necessary to drag name attribute to the browser which cause
> more
> calculations and overhead even if they are 1:1 relationship. When you drag
> a dimension attribute into the browser it is used as normal attribute
> anyway though at running time, it will gain performance improvement when
> engine may find it has 1:1 relationship with another attribute.
> By default, dimension attribute are related to key dimension attribute by
> a
> attribute relationship. In VS 2005, you could open the dimension in VS
> project, and check the attribute relationships defined on the key
> attribute
> ( I assume it is "id" in the dimension).
> You may want to create a attribute relationship directly on name attribute
> and define the relationship bweteen name and address. You will be able to
> see address as the member property of the name attribute in browser. You
> could right click the a name cell->Show properties in report->Show All
> properties in report.
> The other option that you could display name/address at the same time ( I
> assume it is 1:1 relationship) is that you create a new column on
> dimension
> source table, and merge (name, address) column to a new column such as
> name-address. You could use this new column as a attribute directly in the
> dimension attribute.
> If you have further questions or concerns on the issue, please feel free
> to
> let's know. Than you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ========================================
==========
> Get notification to my posts through email? Please refer to
> l]
> ications
> <[url]http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx" target="_blank">http://msdn.microsoft.com/subscript...ps/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscript...rt/default.aspx>.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Alessandro,
You could try the following steps to add attribute relationship between
name and address attribute.
1. Open customer dimension by double click the dimension on the right panel
2. Drag Address column from the source table in Data Source View to the
Name Attribute on the left panel, and you shall see a new Attribute
relationship under attribute Name.
3. Process the dimension and cube and you shall see member property Address
under Name Attribute
Please see if this could meet your requirement. If you have any concerns or
questions, please let me know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============
dimensions are time and customers (id, name, address, contry, etc), fact are
quantity
On Y axes I have to show the customer name AND the address.
if I drag and drop only the id and name, the query is fast, and it works
fine, If after the name I also add the address, the query becames very slow
I belive this is because of aggregation on the address attribute, that I
really don't need, the address is specific to every customer and it does not
make any sense to do calculation on this.
I only need to show che address near the name, without any aggregation
How can I do it?
Is there any property I have to set?
Thank you
Alessandro BelliHello Alessandro,
I understand that you'd like to specify an dimension attribute as a
property not to be aggregated. If I'm off-base, please let me know.
You may want to consider define attribute relationship bewteen attribute
name and address, thus you could display address as member property of name
and do not necessary to drag name attribute to the browser which cause more
calculations and overhead even if they are 1:1 relationship. When you drag
a dimension attribute into the browser it is used as normal attribute
anyway though at running time, it will gain performance improvement when
engine may find it has 1:1 relationship with another attribute.
By default, dimension attribute are related to key dimension attribute by a
attribute relationship. In VS 2005, you could open the dimension in VS
project, and check the attribute relationships defined on the key attribute
( I assume it is "id" in the dimension).
You may want to create a attribute relationship directly on name attribute
and define the relationship bweteen name and address. You will be able to
see address as the member property of the name attribute in browser. You
could right click the a name cell->Show properties in report->Show All
properties in report.
The other option that you could display name/address at the same time ( I
assume it is 1:1 relationship) is that you create a new column on dimension
source table, and merge (name, address) column to a new column such as
name-address. You could use this new column as a attribute directly in the
dimension attribute.
If you have further questions or concerns on the issue, please feel free to
let's know. Than you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Peter Yang [MSFT] wrote:
[vbcol=seagreen]
> Hello Alessandro,
> I understand that you'd like to specify an dimension attribute as a
> property not to be aggregated. If I'm off-base, please let me know.
> You may want to consider define attribute relationship bewteen attribute
> name and address, thus you could display address as member property of nam
e
> and do not necessary to drag name attribute to the browser which cause mor
e
> calculations and overhead even if they are 1:1 relationship. When you drag
> a dimension attribute into the browser it is used as normal attribute
> anyway though at running time, it will gain performance improvement when
> engine may find it has 1:1 relationship with another attribute.
> By default, dimension attribute are related to key dimension attribute by
a
> attribute relationship. In VS 2005, you could open the dimension in VS
> project, and check the attribute relationships defined on the key attribut
e
> ( I assume it is "id" in the dimension).
> You may want to create a attribute relationship directly on name attribute
> and define the relationship bweteen name and address. You will be able to
> see address as the member property of the name attribute in browser. You
> could right click the a name cell->Show properties in report->Show All
> properties in report.
> The other option that you could display name/address at the same time ( I
> assume it is 1:1 relationship) is that you create a new column on dimensio
n
> source table, and merge (name, address) column to a new column such as
> name-address. You could use this new column as a attribute directly in the
> dimension attribute.
> If you have further questions or concerns on the issue, please feel free t
o
> let's know. Than you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ========================================
==========
> Get notification to my posts through email? Please refer to
> l]
> ications
> <[url]http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx" target="_blank">http://msdn.microsoft.com/subscript...ps/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscript...rt/default.aspx>.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no rights.[/vbcol
]
You can add address as property for name attribute and can create
calculated measure on this property.
Regards
Amish Shah
http://shahamishm.tripod.com|||Peter Yang [MSFT] wrote:
[vbcol=seagreen]
> Hello Alessandro,
> I understand that you'd like to specify an dimension attribute as a
> property not to be aggregated. If I'm off-base, please let me know.
> You may want to consider define attribute relationship bewteen attribute
> name and address, thus you could display address as member property of nam
e
> and do not necessary to drag name attribute to the browser which cause mor
e
> calculations and overhead even if they are 1:1 relationship. When you drag
> a dimension attribute into the browser it is used as normal attribute
> anyway though at running time, it will gain performance improvement when
> engine may find it has 1:1 relationship with another attribute.
> By default, dimension attribute are related to key dimension attribute by
a
> attribute relationship. In VS 2005, you could open the dimension in VS
> project, and check the attribute relationships defined on the key attribut
e
> ( I assume it is "id" in the dimension).
> You may want to create a attribute relationship directly on name attribute
> and define the relationship bweteen name and address. You will be able to
> see address as the member property of the name attribute in browser. You
> could right click the a name cell->Show properties in report->Show All
> properties in report.
> The other option that you could display name/address at the same time ( I
> assume it is 1:1 relationship) is that you create a new column on dimensio
n
> source table, and merge (name, address) column to a new column such as
> name-address. You could use this new column as a attribute directly in the
> dimension attribute.
> If you have further questions or concerns on the issue, please feel free t
o
> let's know. Than you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ========================================
==========
> Get notification to my posts through email? Please refer to
> l]
> ications
> <[url]http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx" target="_blank">http://msdn.microsoft.com/subscript...ps/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscript...rt/default.aspx>.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no rights.[/vbcol
]
You can add address as property for name attribute and can create
calculated measure on this property.
Regards
Amish Shah
http://shahamishm.tripod.com|||Thank you for you suggestion, but is not clear to me how to make a
relationship between name and address.
Is enought to set address.keycolumn= customers.name and
addess.namecolumn=address?
Or what I have to do to make the realtionship?
The key of the dimension is a field named "code". Do I also have to set
name.keycolumn=customers.code?
After this when I browse the cube and I right click the name cell->Show
properties in report->Show All
> properties in report the option is grayed.
Thank's
Alessandro
"Peter Yang [MSFT]" <petery@.online.microsoft.com> ha scritto nel messagg
io
news:gdsQ4cR4GHA.2336@.TK2MSFTNGXA01.phx.gbl...
> Hello Alessandro,
> I understand that you'd like to specify an dimension attribute as a
> property not to be aggregated. If I'm off-base, please let me know.
> You may want to consider define attribute relationship bewteen attribute
> name and address, thus you could display address as member property of
> name
> and do not necessary to drag name attribute to the browser which cause
> more
> calculations and overhead even if they are 1:1 relationship. When you drag
> a dimension attribute into the browser it is used as normal attribute
> anyway though at running time, it will gain performance improvement when
> engine may find it has 1:1 relationship with another attribute.
> By default, dimension attribute are related to key dimension attribute by
> a
> attribute relationship. In VS 2005, you could open the dimension in VS
> project, and check the attribute relationships defined on the key
> attribute
> ( I assume it is "id" in the dimension).
> You may want to create a attribute relationship directly on name attribute
> and define the relationship bweteen name and address. You will be able to
> see address as the member property of the name attribute in browser. You
> could right click the a name cell->Show properties in report->Show All
> properties in report.
> The other option that you could display name/address at the same time ( I
> assume it is 1:1 relationship) is that you create a new column on
> dimension
> source table, and merge (name, address) column to a new column such as
> name-address. You could use this new column as a attribute directly in the
> dimension attribute.
> If you have further questions or concerns on the issue, please feel free
> to
> let's know. Than you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ========================================
==========
> Get notification to my posts through email? Please refer to
> l]
> ications
> <[url]http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx" target="_blank">http://msdn.microsoft.com/subscript...ps/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscript...rt/default.aspx>.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Alessandro,
You could try the following steps to add attribute relationship between
name and address attribute.
1. Open customer dimension by double click the dimension on the right panel
2. Drag Address column from the source table in Data Source View to the
Name Attribute on the left panel, and you shall see a new Attribute
relationship under attribute Name.
3. Process the dimension and cube and you shall see member property Address
under Name Attribute
Please see if this could meet your requirement. If you have any concerns or
questions, please let me know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============
Subscribe to:
Posts (Atom)