Do We Need Extra Server To Run Web Applications?

Feb 5, 2002

Our company wants to run web based application
in folowing way.

Browser --> WebServer -->Sql Server

Sql server is part part of corporation domain and has about 25 more databases

Should we dedicate extra SQL server to run Web apps , or it would be safe to run web apps on corporation Sql Server?
or
If any one can point on links on this subject?.
Thank you

View 1 Replies


ADVERTISEMENT

2 Web Applications To Same Sql Server

Nov 2, 2000

If there are 2 different web application connecting to a sql server database through ODBC connection, both of them have full privilege to update , create , add column etc. Would there any issues of SQL server impacts when actually on live.

View 2 Replies View Related

Web Applications And SQL Server

Jan 11, 2008

Hi all,

Can anyone tell about impact of SQL server in web applications


Thanks in advance

View 2 Replies View Related

Why Can't Applications See My SQL Server?

Jul 6, 2006

I am running SQL Server 2005 Dev x86 with SSRS SP1 on Windows2003 Svr SP1.

My SQL Server is running and SSRS is working. When I come to run certain installs though, my Server name is not present in the dropdowns or in the browse for installed server lists.

I entered the name of my SQL server manually, but when I ran the application, it gave me an error: 00250 unable to run dtabase locator service.

Any ideas?

View 2 Replies View Related

SQL Server Backup Applications

Jul 23, 2005

Hi All,During the past couple of years I have been maintaining the company'sAccess databases, in the coming weeks I will be migrating data to SQLserver, I will be using the Access forms as a frontend to access datawhile we developed a new front end through VB.Net.I was wondering if anyone will recommend an application that makes anexact replica or backup of the SQL server in the case the SQL serverfails. With MS Access, if a record is corrupted we needed to go backto the previous day backup of the database, we cant afford to havethis issue any longer.Regards,John

View 3 Replies View Related

Is Sql Server Express Edition Enough For My Web-applications?

Apr 28, 2008

Good morning,After long hours of search on the subject, I could not find a clear answer to my question.I understand what are ths physical limit fo the express version (1Gb or Ram, 4Gb database, 64 bit WOW).My configuration is as follow, windows webserver 64bit, I have 4 database of 10Mb each for 4 web-application. The maximum concurent connection  is a total fo about 8 for all the web-application together.Therefore due to the cost of buying a workgroup of standard license, I was hoping to be able to  use the express edition.Please let me know your thought.ThanksArno

View 6 Replies View Related

Find All Applications That Are Calling DB Server

Jun 10, 2015

I need to get the application lists calling our DB. I need both dormant and current. I thought profiler can give only active ones.

View 7 Replies View Related

Two Different Database Belong To Two Different Applications Stay In The Same Server

Aug 17, 2000

Hello....

Does anyone know if two different database belong to two different applications stay in the same physical SQL server 7.0 with one server license would affect their performance?

Would the performance be better off if each database stored in different physical SQL Server 7.0 with different server license?

Thank you in advance!

View 1 Replies View Related

Using SQL Server 2005 CE Embedded In Desktop Applications

Jan 3, 2007

Is it ok to use SQL Server 2005 CE as an embedded DBMS inside a desktop (Windows XP / w2k3 / Vista) application?

The whitepaper available here: http://download.microsoft.com/download/A/4/7/A47B7B0E-976D-4F49-B15D-F02ADE638EBE/Compact_Express_Comparison.doc describes this as one of the primary usages of the product. However, I've seen information elsewhere on this forum that seems to imply that SQL Server 2005 CE is not allowed in desktop applications.

Can you please clarify this, and specify any limitations of this usage?

Also, the whitepaper refers to an online redistribution agreement that needs to be signed in order to freely redistribute SQL Server 2005 CE inside a commercial application. Can you please point to this agreement?

Thanks,

IonWarp

View 7 Replies View Related

Develop Multiusers Applications With SQL Server Express

Feb 3, 2006

Can I develop applications with SQL Server Express that I have more than one user in several computers working with the same database on a server, or I can only develop applications with only one user with a local database with SQL Server Express?

View 3 Replies View Related

SQL Server Express Starter Kits (Sample Applications)

Aug 30, 2007

When I registered SQL Server Express I received an e-mail back showing all of the resources available to get started. There were 6 Starter Kits available, Teacher, Colection Manager, Amazon Enabled Movie Collection, and three others. When I click on the links to download the Starter Kits, the link comes back as invalid. Can you provide the correct links to use to get the Starter Applications, or can you e-mail me code? Thanks for you attention to this matter.
Charlie Cappello
CIGNA

View 5 Replies View Related

Is It Possible To Send Message From SQL Server Express To Applications Using It On Different Machines ?

Mar 8, 2008

Hello,

Is it possible to send message from SQL Server Express to Applications using it on different machines ?

For example When an important record is inserted or updated, a message appears on Application user's screen.

If yes then how ?

Thanks

View 3 Replies View Related

What's The Difference Between The Application Developer Tools And Server Applications CD

Apr 19, 2007

I have 2 questions about Sql Server 2005.





1. I have 2 sets of CDs, one is called Sql Server 2005 Developer Edition, Applications Developer Tools, and another one called Sql Server 2005 Developer Edition Servers Server Applications.


I installed the Applications Developer Tools on my development pc, and I was able to use create and populate a database, and use Sql Server Management Studio fine. I wonders what 's the Servers Server Applications set of cds for.





2. I just like to install Sql Server 2005 on a test pc also. Can I use my Developer Edition Applications Developer Tools to install it ?





Thanks.

View 1 Replies View Related

SQL Server 2005 For Two Applications With Different Collation Setting On Same Platform?

Nov 13, 2007

Hi ,

We want to install 2 applications that run on SQL server 2005 but the requirement of database installation are different Collation setting ( One require Dictionary order, case-insensitive, for use with 1252 Character Set and other require Dictionary order, case-sensitive, for use with the 437 (US English) Character set).
So the question here could I install both two applications successfully on same platform ? and if yes how?

Thanks and regards,

Quinh

View 5 Replies View Related

SQL Server Full-text Search Option On ASP.NET Live Applications.

May 29, 2007

Hi, 
Is it advisable to use full text search on asp.net live applications? Will live database servers allow full text search?. If so what are the problems we could face in future.
My DB server is SQL Server2000 and ASP version is 1.1. 
Thanks in advance 
Hamlin Stephen 
 

View 4 Replies View Related

SQL Server 2008 :: Cleanup History Has Extra Output Message

Apr 16, 2015

Oldest Day till I want to Purge[30 days of Old Data] : 03-17-2015

Running Cleanuphistory Procedure On Server:

NO of records are qualifying for deletion:0

Deleted Sysmail MAil Items, Old history: 1
Deleted Sysmail Log Old history: 1
0 history entries purged. <<<<<<< ----------------------- [HOW IT IS COMING ?? ??]
Deleted SQL JOB Old HISTORY: 1

*** END OF PROCEDURE. ***

[Code] .....

View 6 Replies View Related

Reports Are When Printed SQL Server Report Is Printing Extra Pages

Apr 5, 2008



Hi ,

I have developed some report in Sql Server Reporting services my Page orientation is portrait that is report height and width are 8.5 and 11 respectively and margins are set to 0.3 in when it is printed the pages are printed more that actually viewed Pages.

I need help from someone.

Thanks,

Nikhil
response2nikhil@hotmail.com

View 7 Replies View Related

SQL Server Express Starter Kits And Sample Applications Downloads Links Are Bad

Sep 22, 2007



1. The download links shown below for the Starter Kits found at this URL do not work:

http://msdn2.microsoft.com/en-us/express/aa718396.aspx


Teacher Starter Kit
VB http://msdn.microsoft.com/vstudio/eula.aspx?id=4d31bb50-22da-411f-b747-a7b2288fc720
C# http://msdn.microsoft.com/vstudio/eula.aspx?id=06b20449-cbba-4f2f-ab8c-b99c1266cc7e
Collection Manager Starter Kit
http://msdn.microsoft.com/vstudio/eula.aspx?id=98c8074d-d28e-49e1-be44-94f0114f372a
Club Web Site EventCalendar control source code
http://www.asp.net/starterkits/downloads/eventcalendar.zip

2. None of the download links shown below for the Sample Applications found at this URL work:

http://msdn2.microsoft.com/en-us/express/bb403187.aspx


Internet Explorer Favorites Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=3bdccf1b-88c6-45a6-9dcf-7499ad664dab
Skills Manager Sample

http://msdn.microsoft.com/vstudio/eula.aspx?id=09305c92-890f-4dc7-a20d-f58b611d23c7
Survey Manager Sample

http://msdn.microsoft.com/vstudio/eula.aspx?id=98171070-e0f6-4fcd-948e-9c5af497ab4f
Help Desk Sample

http://msdn.microsoft.com/vstudio/eula.aspx?id=009e3b2d-98b1-46dc-8476-676a2519eafa
Reports for Web Sample

http://msdn.microsoft.com/vstudio/eula.aspx?id=79610b4f-fc7e-4ca8-9ae2-8ca8a5a6de0d
Reports for Windows Sample

http://msdn.microsoft.com/vstudio/eula.aspx?id=9c9a8d75-58b1-4be7-91be-50fefbe5d28c

View 2 Replies View Related

SQL Server 2008 :: Send Emails To Individuals In Query Results And Extra?

Jul 15, 2015

I have a set of results based on a query that displays a learner, their workplace assessor and both their email addresses.

I want to send a standard request email (using db_mail) to each learner's email address which specifies who their individual assessor is and their current employer. One per learner.
I then want to email each assessor and in this email detail their learners (and their employer details) that I have emailed the request too.

View 1 Replies View Related

How Can I Connect To .MDF Through 2 Applications?

Dec 2, 2006

Here is the big problem:

I am using ASP.NET 2.0 login control. this control connect to ASPNET.MDF database.
I built another application using windows service, and this application also connects to ASPNET.MDF database.
problem is that the first application that connects to the database, locks the database, and so the other application cannot use the database untill the other application is closed.
I am going on circles about this, and just don't know what to do.
Please please please. love me do.
 
 

View 1 Replies View Related

MSDE For Web Applications

Dec 10, 2003

Hi, I am needing help on which MSDE version support 25 concurrent users. Can anyone help?

Creating an intranet that I would like to run on msde. My problem is that it wont allow more than one person to access the intranet at a time.

MSDE is running on windows 2000 with IIS.

View 1 Replies View Related

SQL Express Db With Both Win / Web Applications

May 17, 2006

I have a SQLexpress db that i would like to be able to access from both a windows app and web app (both running on the same machine) at the same time.  Is this possible. I've been able to connect either one or the other, but not both at the same time.
Thanks   

View 1 Replies View Related

Accounting Applications

Dec 11, 2001

Hi to all..
Does anyone know about some useful resources of programming Accounting and General Ledger applications..SQL scripts,books..etc.
Thanks to all..

View 7 Replies View Related

Find Out Applications

Aug 3, 2007

how do i find out what application is using certain DB?.


=============================
http://www.sqlserverstudy.com

View 3 Replies View Related

Deployment Of Applications

May 23, 2007

Hi,



I have developed several PPC apps in VS2003, which i have deployed to other PPCs using sqlce.wce4.armv4.CAB for the database runtime.



Now I developed a new app. version in Visual Studio 2005, using the free SQL server express database that came with it.



I can create a .cab file for the app using a setup project, but it eludes me what to install on the PPC of the customer, database wise.



Is there some kind of installable runtime for sql server express ?

(Or what is it called today ?)



thx in advance,

Paul.

View 1 Replies View Related

Restoring Db From Web Applications..

May 17, 2007



i am a computer sciences engineering student and and we have an assignment to create a web project with a database.



Our lecturers will store our submissions on a db server but they want our projects enable the restoring our own databases..



that is, they wanna be able to have a copy of our databases to a new db that they have just created.. and they want us to enable this feature in an install.aspx page in our project.. the new db is guaranteed that will have the same name as ours..

so now what i am supposed to include in install.aspx?

View 6 Replies View Related

Extra Row

Jan 18, 2007

hi all,

i wonder if i could break one row to multiple row base on this case :-

status=A OriginQty=10 HoldQty=3

i want to print the status=H for the remaining originqty-holdqty
isit possible to digest this data in my SP to:-

status=A BalQty=7
status=H BalQty=3



~~~Focus on problem, not solution~~~

View 2 Replies View Related

Sql Transactions Tiers Applications

Aug 3, 2006

Hi All.. I have an 3 tier web applications and I want to use sql transactions but not in each class.
Example :
I have 3 clases who need to update each table in one transaction how I do use sql transactions. I try to do in this way but not work:
sub cmdupdate_click   dim a as new class1   dim b as new class2   dim c as new class3   dim cn as new sqlconnection......   cn.open   .....transactions.... scripts   a.cn =cn ...I pass the same connection via property to each class   a.update   b.cn=cn....   b.update   c.cn=cn.....   c.update
   Transaction...scripts to commit   cn.closeend sub
maybe that logic is incorrect.  I dont now is my explain is clear.
 
 
 
 

View 3 Replies View Related

Unique Database For Various Applications?

Oct 18, 2007

There is a possibility of a unique database for various applications. Example users of a table that has the name, email, registro.Uma application included in a user table and other application also included in this table.

View 2 Replies View Related

Correct Way To Move Applications

Dec 10, 2007

What is the correct way to move applications from one server (2000) to another server(SQL 2005). I have to move all the databases as well as applications from one server to another.Here is my procedure:
1) Backup all 65 databases in first server(600GB total)
2)copy all the backup files from one server to another(destination)
3)Make all database(single user)and take transaction Log backup
4) Restore all database to destination server in norecovery mode and restore all transaction log in Recovery mode)
5)stop server 1 and point the application to another server

So how much downtime i have to face since it is 24/7 production server. and
Can you please give the correct details so i can apply.

View 10 Replies View Related

Monitoring Applications Querys

Feb 1, 2007

Hi there!I'm programming in delphi and new to querieng MS SQL Server. Is there a wayto monitor the queries sent to the server and something of the returns. Atleast execution time would be interesting ...Thx in advance,Fritz

View 2 Replies View Related

Looking For Tools To Monitor Sql And Applications

Jul 20, 2005

I am looking for the right tools to do application monitoring.I'm hoping to find one single tool that can do the entire job but ifit does not exist then a few monitoring apps would do as well.I need the ability to do the standard things like testing for ping,checking for windows services running and restarting them after somethreshold is met, and wmi.Some of the more tricky things I need it to do are:* Parse log files looking for specific error codes, and the ability toset an alert only if it sees that error X times over some period oftime.* Run custom slq queries like row counts and max values returned froma query and if that condition is met X times over some period oftime.* Run an external app that does its own custom testing and act on itsresults, which could be to parse the result file from the app.Keep in mind cost is not the isssue right now - so this can befreeware to some type of enterprise solution that our company can use.Does anyone know of any tools that you can point me towards?Thanks...

View 1 Replies View Related

Problem Conecting To The Same DB From Two Applications

Apr 7, 2006

Hello,

I'm new to VB and SQL server. I have a windows forms application and a Web application that need to connect to the same database (Named WebCenter). But when I try to connect to it from the Web app while running the windows forms app this error message apears:

Unable to open the physical file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataWebCenter_Data.MDF". Operating system error 32: "32(The process has no access to the file because is being used by another process).
Unable to open the physical file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataWebCenter_Log.LDF". Operating system error 32: "32(The process has no access to the file because is being used by another process.)".
Cannot open database "WebCenter" requested by the login. The login failed.
Login failed for user 'CARLOS-PCASPNET'.
File activation failure. The physical file name "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataWebCenter_Log.LDF" may be incorrect.

Can anyone give me hand or point me in the right direction.

Thanks,

Carlos.

Pd. Please excuse my english.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved