set affinity for SqlExpress: iis

Showing posts with label iis. Show all posts

Wednesday, March 21, 2012

How to setup iis virtial directory management for SQLXML

I need to setup iis virtial directory management for SQLXML
on our web server SERVER1 to talk to our SQL server SERVER2
however I can not get the snapin to load on SERVER1.
Where do I get the snapin, or what should I be doing?
Thank you
Steven AndersonCould you elobarate your problem a little bit more? Where do you actually
have the problem in the Virtual Directory Management for SqlXml 3.0?
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Steven Anderson" <StevenAnderson@.discussions.microsoft.com> wrote in
message news:3BB9821D-07A8-45D1-9243-DE2065FE4503@.microsoft.com...
>I need to setup iis virtial directory management for SQLXML
> on our web server SERVER1 to talk to our SQL server SERVER2
> however I can not get the snapin to load on SERVER1.
> Where do I get the snapin, or what should I be doing?
> Thank you
> Steven Anderson

How to setup iis virtial directory management for SQLXML

I need to setup iis virtial directory management for SQLXML
on our web server SERVER1 to talk to our SQL server SERVER2
however I can not get the snapin to load on SERVER1.
Where do I get the snapin, or what should I be doing?
Thank you
Steven Anderson
Could you elobarate your problem a little bit more? Where do you actually
have the problem in the Virtual Directory Management for SqlXml 3.0?
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Steven Anderson" <StevenAnderson@.discussions.microsoft.com> wrote in
message news:3BB9821D-07A8-45D1-9243-DE2065FE4503@.microsoft.com...
>I need to setup iis virtial directory management for SQLXML
> on our web server SERVER1 to talk to our SQL server SERVER2
> however I can not get the snapin to load on SERVER1.
> Where do I get the snapin, or what should I be doing?
> Thank you
> Steven Anderson

How to setup front-end IIS and back-end SQL server?

Hi,

I need some help in setting up a front end IIS box and back end SQL 2005 box. I will be using merge replication.

Front end server will be a 32 bit.

How exactly do you do this? Anyone have any links to articles that walks through the setup?

Thanks,

Hi Pintu, see this link:

http://www.databasejournal.com/features/mssql/article.php/1438231

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 (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
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>

How to setup a SQL Database for a shared web hosting?

"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?

"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:
>

Friday, March 9, 2012

How to set NT Authority in sql 2000?

We have an application store in a web server using IIS 6.0, however the application is communicating to sql 2000 that is stored in a 2000 server.

In IIS 6.0 the application pool is set to Network Services, therefore sql 2000 is looking for a user called 'NT AUTHORITY\ANONYMOUS LOGON'.

But the login failed, and I don't see how to add NT Authority as a user in a 2000 server like you can in a 2003 server.

In all, we are trying to set permissions to certain users only by using the identity impersonate='true' in the web config file, but even with this setting set to true, and our network information set as a user in sql 2000, we still are denied access to the data.

What are some things we need to look for and what configuration do we need to set?

Thanks,

xyz789

P.S.
We also have all the permissions check to have access to all the tables and store procedures for each user.

Hi,

Are you trying integrated security and impersonating the current asp.net user?

Remove the anonymous access from IIS. Make sure in the authentication, only 'Integrated Windows
authentication' is checked.

You may need kerberos authentication.

http://msdn.microsoft.com/msdnmag/issues/05/09/SecurityBriefs/

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||

Thank you!

Wednesday, March 21, 2012

How to setup iis virtial directory management for SQLXML

How to setup iis virtial directory management for SQLXML

How to setup front-end IIS and back-end SQL server?

How to setup a SQL Database for a shared web hosting?

How to setup a SQL Database for a shared web hosting?

How to setup a SQL Database for a shared web hosting?

Friday, March 9, 2012

How to set NT Authority in sql 2000?

set affinity for SqlExpress

Blog Archive

About Me