I have been tring to get my local host/reports to work I can to the conculsion I had to remove the iis and reinstall it. I now have the local host working but I get a 403 error when I try to run my site which is located at the ip address http:/xx.xxx.x.xx/default.aspx if I try to run this I get the 403 error can some one help me out I am under a ver y short deadline and need some help.
Are the entries correctly mapped in DNS server?Friday, March 30, 2012
Monday, March 12, 2012
need advise of basic knowledge
I dont know where to put this thread, I just wanna ask a question..actually what is happen when subscription synchronized the publications among IIS process.. (SQLMobile)
could you guys give me a diagram/schema of it?
thanks before
What are you looking for?
If you want a detailed process regarding security and logins that get used using web synchronization, refer to this:
http://msdn2.microsoft.com/en-us/library/ms345212.aspx
If you have any other specific questions, please do post them.
|||thanks for your reply Mahesh :)
I also curious about, when subscriber do data update on SQLMobile, and then use sync process, what is happen with the data on publisher?is it updated like the subscriber did or subscriber will change back the data to origin publisher's?I'm using merge replication
many many thanks..
|||If the subscriber updates data and there are no conflicting publisher updates, the subscribers updates will be propagated to the publisher.
If there are conflicts (publisher and subscriber update the same row or same column -- depending on row or column tracking) there could be conflicts and one of them may lose. Also the winning row is governed by the type of article resolver you choose.
|||thx for ur info
I'll try it
Need advice on obtaining an SQL server
to serve database content. We are currently using IIS and Access.
The price was estimated to be $10,000. It seemed a little steep to me, but
our IT guy said that when you buy SQL for web use they charge more than if
you only needed it for use within a company. We are a non-profit government
appointed agency and are not setting this up for sales, just for serving
data to the public free of charge. And only the web server would be
interacting with the SQL server, we are not trying to set up some kind of
tunneling application for people to access the SQL server directly. The web
administrator and web server would be the only two clients.
Does this sound like the correct price for a basic SQL server? The lowest
tier of service should suit us fine, we just want a boost in speed from the
IIS/Access setup and avoid the odd crashes associated it (once every few
months).
I can only comment on the SQL Server side:
If you expose data through an app server (which IIS is in this aspect), you need to either buy per
processor license or make sure that every user who uses the app server (your web site) has a SQL
Server Client Access License. I assume that the web server is public, so you need to go per
processor. It is *not* enough to have a CAL for only the app server (read about multiplexing in the
licensing doc).
One thing to consider is SQL Server Express.
Another thing is if MS has some special deal for non-profit organizations. Talk to your MS rep about
this.
Licensing FAQ: http://www.microsoft.com/sql/howtobuy/faq.mspx
To speak to someone regarding licensing:
You can call 1-800-426-9400 (select option 4), Monday through Friday, 6:00
A.M. to 6:00 P.M. (PST) to speak directly to a Microsoft licensing
specialist for licensing problem. Worldwide customers can use the Guide to
Worldwide Microsoft Licensing Sites
http://www.microsoft.com/licensing/index/worldwide.asp to find contact
information in their locations.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Matt" <mattmatt32@.notmail.com> wrote in message news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gbl...
> The company I work for is looking into purchasing a server and SQL license to serve database
> content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but our IT guy said that
> when you buy SQL for web use they charge more than if you only needed it for use within a company.
> We are a non-profit government appointed agency and are not setting this up for sales, just for
> serving data to the public free of charge. And only the web server would be interacting with the
> SQL server, we are not trying to set up some kind of tunneling application for people to access
> the SQL server directly. The web administrator and web server would be the only two clients.
> Does this sound like the correct price for a basic SQL server? The lowest tier of service should
> suit us fine, we just want a boost in speed from the IIS/Access setup and avoid the odd crashes
> associated it (once every few months).
>
|||Seems like SQL Express would be ideal for you (and it is free
http://msdn.microsoft.com/sql/express/default.aspx
William Stacey [MVP]
"Matt" <mattmatt32@.notmail.com> wrote in message
news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gbl...
> The company I work for is looking into purchasing a server and SQL license
> to serve database content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but
> our IT guy said that when you buy SQL for web use they charge more than if
> you only needed it for use within a company. We are a non-profit
> government appointed agency and are not setting this up for sales, just
> for serving data to the public free of charge. And only the web server
> would be interacting with the SQL server, we are not trying to set up some
> kind of tunneling application for people to access the SQL server
> directly. The web administrator and web server would be the only two
> clients.
> Does this sound like the correct price for a basic SQL server? The lowest
> tier of service should suit us fine, we just want a boost in speed from
> the IIS/Access setup and avoid the odd crashes associated it (once every
> few months).
>
Need advice on obtaining an SQL server
to serve database content. We are currently using IIS and Access.
The price was estimated to be $10,000. It seemed a little steep to me, but
our IT guy said that when you buy SQL for web use they charge more than if
you only needed it for use within a company. We are a non-profit government
appointed agency and are not setting this up for sales, just for serving
data to the public free of charge. And only the web server would be
interacting with the SQL server, we are not trying to set up some kind of
tunneling application for people to access the SQL server directly. The web
administrator and web server would be the only two clients.
Does this sound like the correct price for a basic SQL server? The lowest
tier of service should suit us fine, we just want a boost in speed from the
IIS/Access setup and avoid the odd crashes associated it (once every few
months).I can only comment on the SQL Server side:
If you expose data through an app server (which IIS is in this aspect), you
need to either buy per
processor license or make sure that every user who uses the app server (your
web site) has a SQL
Server Client Access License. I assume that the web server is public, so you
need to go per
processor. It is *not* enough to have a CAL for only the app server (read ab
out multiplexing in the
licensing doc).
One thing to consider is SQL Server Express.
Another thing is if MS has some special deal for non-profit organizations. T
alk to your MS rep about
this.
Licensing FAQ: http://www.microsoft.com/sql/howtobuy/faq.mspx
To speak to someone regarding licensing:
You can call 1-800-426-9400 (select option 4), Monday through Friday, 6:00
A.M. to 6:00 P.M. (PST) to speak directly to a Microsoft licensing
specialist for licensing problem. Worldwide customers can use the Guide to
Worldwide Microsoft Licensing Sites
http://www.microsoft.com/licensing/index/worldwide.asp to find contact
information in their locations.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Matt" <mattmatt32@.notmail.com> wrote in message news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gb
l...
> The company I work for is looking into purchasing a server and SQL license
to serve database
> content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but
our IT guy said that
> when you buy SQL for web use they charge more than if you only needed it f
or use within a company.
> We are a non-profit government appointed agency and are not setting this u
p for sales, just for
> serving data to the public free of charge. And only the web server would b
e interacting with the
> SQL server, we are not trying to set up some kind of tunneling application
for people to access
> the SQL server directly. The web administrator and web server would be the
only two clients.
> Does this sound like the correct price for a basic SQL server? The lowest
tier of service should
> suit us fine, we just want a boost in speed from the IIS/Access setup and
avoid the odd crashes
> associated it (once every few months).
>|||Seems like SQL Express would be ideal for you (and it is free
http://msdn.microsoft.com/sql/express/default.aspx
William Stacey [MVP]
"Matt" <mattmatt32@.notmail.com> wrote in message
news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gbl...
> The company I work for is looking into purchasing a server and SQL license
> to serve database content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but
> our IT guy said that when you buy SQL for web use they charge more than if
> you only needed it for use within a company. We are a non-profit
> government appointed agency and are not setting this up for sales, just
> for serving data to the public free of charge. And only the web server
> would be interacting with the SQL server, we are not trying to set up some
> kind of tunneling application for people to access the SQL server
> directly. The web administrator and web server would be the only two
> clients.
> Does this sound like the correct price for a basic SQL server? The lowest
> tier of service should suit us fine, we just want a boost in speed from
> the IIS/Access setup and avoid the odd crashes associated it (once every
> few months).
>
Need advice on obtaining an SQL server
to serve database content. We are currently using IIS and Access.
The price was estimated to be $10,000. It seemed a little steep to me, but
our IT guy said that when you buy SQL for web use they charge more than if
you only needed it for use within a company. We are a non-profit government
appointed agency and are not setting this up for sales, just for serving
data to the public free of charge. And only the web server would be
interacting with the SQL server, we are not trying to set up some kind of
tunneling application for people to access the SQL server directly. The web
administrator and web server would be the only two clients.
Does this sound like the correct price for a basic SQL server? The lowest
tier of service should suit us fine, we just want a boost in speed from the
IIS/Access setup and avoid the odd crashes associated it (once every few
months).I can only comment on the SQL Server side:
If you expose data through an app server (which IIS is in this aspect), you need to either buy per
processor license or make sure that every user who uses the app server (your web site) has a SQL
Server Client Access License. I assume that the web server is public, so you need to go per
processor. It is *not* enough to have a CAL for only the app server (read about multiplexing in the
licensing doc).
One thing to consider is SQL Server Express.
Another thing is if MS has some special deal for non-profit organizations. Talk to your MS rep about
this.
Licensing FAQ: http://www.microsoft.com/sql/howtobuy/faq.mspx
To speak to someone regarding licensing:
You can call 1-800-426-9400 (select option 4), Monday through Friday, 6:00
A.M. to 6:00 P.M. (PST) to speak directly to a Microsoft licensing
specialist for licensing problem. Worldwide customers can use the Guide to
Worldwide Microsoft Licensing Sites
http://www.microsoft.com/licensing/index/worldwide.asp to find contact
information in their locations.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Matt" <mattmatt32@.notmail.com> wrote in message news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gbl...
> The company I work for is looking into purchasing a server and SQL license to serve database
> content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but our IT guy said that
> when you buy SQL for web use they charge more than if you only needed it for use within a company.
> We are a non-profit government appointed agency and are not setting this up for sales, just for
> serving data to the public free of charge. And only the web server would be interacting with the
> SQL server, we are not trying to set up some kind of tunneling application for people to access
> the SQL server directly. The web administrator and web server would be the only two clients.
> Does this sound like the correct price for a basic SQL server? The lowest tier of service should
> suit us fine, we just want a boost in speed from the IIS/Access setup and avoid the odd crashes
> associated it (once every few months).
>|||Seems like SQL Express would be ideal for you (and it is free:)
http://msdn.microsoft.com/sql/express/default.aspx
--
William Stacey [MVP]
"Matt" <mattmatt32@.notmail.com> wrote in message
news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gbl...
> The company I work for is looking into purchasing a server and SQL license
> to serve database content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but
> our IT guy said that when you buy SQL for web use they charge more than if
> you only needed it for use within a company. We are a non-profit
> government appointed agency and are not setting this up for sales, just
> for serving data to the public free of charge. And only the web server
> would be interacting with the SQL server, we are not trying to set up some
> kind of tunneling application for people to access the SQL server
> directly. The web administrator and web server would be the only two
> clients.
> Does this sound like the correct price for a basic SQL server? The lowest
> tier of service should suit us fine, we just want a boost in speed from
> the IIS/Access setup and avoid the odd crashes associated it (once every
> few months).
>