.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Running IIS on the the same machine as SQL Server

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

Hello everyone,

We're running IIS and SQL Server on the same machine, so our website and database sit next to each other. Someone mentioned that there are security issues with a set up of this nature.

Is it preferable to run them separately, on a web and database server?

Many thanks

View Complete Post

More Related Resource Links

Windows 7 Home accessing SQL Server running on a WindowsXP Pro machine

I have a client running a program that uses SQL Server 2005 Express running on a WindowsXP Pro machine.  It runs just fine on the WindowsXP machine, even under several different Windows logins that SQL Server has been told are permitted.  Using a Windows 7 Home Premium machine, in trying to set up the ODBC driver to point the program to the SQL Server database on the WindowsXP machine, an error is returned indicating that it is not permitting a connection for the client machinename\Guest.  Of course, the Windows 7 machine is logged on with the same login name and password as is permitted on the WindowsXP machine, but apparently the Win 7 Home machine is not transmitting that login and password allowing the login to SQL Server to be validated through the use of Windows NT 2000 authentication.  This always works with a WindowsXP Pro workstation.  Is my problem that their workstation machine is running a HOME version, or is there some other solution to make the Win7 machine transmit the real login and password instead of trying to log in as Guest?  Networking is letting the Win 7 machine explore shared files and folders in the XP machine since those are not requiring a valid ID and password.

Virtual Server 2005: Program Customized Testing Environments Without Trashing Your Machine


Efficient testing can require many different machine and server configurations but the effort needed to manage these test environments can take a toll. Microsoft Virtual Server 2005 simplifies the provisioning and management of testing environments. This article demonstrates how the extensive Virtual Server COM API can be used to create an automated application testing environment to make your testing chores a whole lot easier.

Ben Waldron

MSDN Magazine August 2004

How can Install Office 2007 on Windows server 2008 R2 64 bit machine in WSS 3.0

I have  64 bit machine  and Windows server 2008 R2 has installed. i have successfully install WSS 3.0  , but  when i tried to install  office 2007 ,  one  error  has  come  "OS is not compatible "  i thought  it was asking  for 64 bit office  2007   and i go through the  google and R&d find no 64 bit office is available ,  i have used   excel .dll in my custom code  so my problem is that   how can  install office 2007  on 64 bot OS 2008 r2  machine .  if anyone can help   me  , please let me know . thanks in advance

Video: Coding a Long-Running Operation Page in SharePoint Server 2007 or Windows SharePoint Services

Watch this visual how-to video as you learn to write code to mimic the default long-running operations page (the "spinning wheel") in SharePoint Server 2007 or Windows SharePoint Services 3.0. (Length: 7:56)

Coding a Long-Running Operation Page in SharePoint Server 2007 or Windows SharePoint Services 3.0 (V

Watch the video and explore code as you learn how to write code to mimic the default long-running operations page (the "spinning wheel") in SharePoint Server 2007 or Windows SharePoint Services 3.0.

Detect if code is running inside SQL Server.

Can managed code "detect" if it is running in the normal .Net CLR or the special SQL Server CLR? Is there some environment flag or field we can look at at runtime? Thanks Cap'n  

Facing MSDTC related issues while archiving data from one database server machine to another databas

I have a question with respect to distributed transactions when carried out between two database server machines on the same network.   Consider there are two database server machines \SOURCE_DATABASE_SERVER\ and \DESTINATION_DATABASE_SERVER\. Now we have to archive the data from one database server to other database server.   Let us suppose the database server \SOURCE_DATABASE_SERVER\ is the live production database server and \DESTINATION_DATABASE_SERVER\ is Long term storage database server. Now data from \SOURCE_DATABASE_SERVER\ needs to be archived into the database server \DESTINATION_DATABASE_SERVER\.   So I have written a dynamic stored procedure which includes distributed transaction (begin Tran, commit Tran, rollback            Tran) coding in it.   Now initially when I executed the procedure, it gave some of the following errors   1) OLE DB provider "SQLNCLI" for linked server "\DESTINATION_DATABASE_SERVER\" returned message "The partner transaction manager has disabled its support for remote/network transactions.". Msg 7391, Level 16, State 2, Line 1 The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "\DESTINATION_DATABASE_SERVER\" was unable to begin a distributed transaction.    

Login Failed for User "XXX" when login from a ETL machine for Sql Server 2005 SP2

Hi Guys, I have a straange issue with Login Failed errors coming intermittently probabaly twice in a week: I have a  production Database on Server A and we have Two ETL servers on Server B and Server C. Sometimes when the ETL's (SSIS) run from SERVER B I do get an error stating login failed for user "XXX" this user is a sql server user. And when I run the same package from Server C it does not give any error and runs smoothly. Both the packages uses the same configuration file to connect to the same database with the same user credentials. Also this error is not a frequent error but comes along once or twice in a weeK. Can anyone shed some light on this and let me know the root cause. Both servers have the same sql client version as well. All servers mentioned above are 64 bit windows 2003 servers. Raju

SQL Server Configuration Manager: Connection to target machine could not be made in a timely fashion

I have a SQL Server 2005 box that was moved from a domain environment to a non-domain environment and was never dropped from its original domain before moving over.  Subsequently a new domain was created at the data center this SQL Server box now resides in.  The machine was dropped from its old domain and joined to the new one.   All the while the service accounts were set to the local admin account.  When I tried to start the Configuration Manager I got the message "Connection to target machine could not be made in a timely fashion.".  I read some blog entries and tried changing all the service accounts to Local System and the error message still came up.   All of the SQL Server services run fine.  It is just this management console that I cannot open.  I wasn't with this employer when this box was moved to the data center so I do not know if it worked prior and there isn't anyone here that could give me its history.   Any help would be appreciated.

SSMS on networked machine - can see server but not instance

Hi, We have been running sql server 2008 enterprise on a single networked machine (SBS 2008) which is also runs DHCP and DNS.  We have bought a new server to just run SQL Server 2008 and I cannot manage to connect to it via SSMS from my laptop - I can see the server but not the instance.   Here is roughly what I have done: Installed Windows Server 2008 Enterprise on the box Installed SQL Server 2008 Enterprise on the box Create a named instance Configured instance to listen on TCP 1533 Created a new firewall rule to allow traffic through on TCP 1533 Created a new rule for sqlsrvr.exe on the firewall I have the services loging on with the following accounts: SQL Server Integration Services 10.0 = DOMAIN\dbadmin = running = automatic SQL Server Analysis Services = DOMAIN\dbadmin = running = automatic SQL Server (namedinstance) = DOMAIN\dbadmin = running = automatic SQL Full-text Filter Daemon Launcher = NT AUTHORITY\LocalService = running = manual SQL Server Reporting Services = NT AUTHORITY\LocalService = running = automatic - this is installed but not configured SQL Server Agent = DOMAIN\dbadmin = Stopped = manual SQL Server Browser = LocalSystem = running = automatic When I log onto the new box as a domain user and log into management studio on my laptop I can then suddenly see the instance and connect. It sounds to me that it is a permissions / acc

Adomd.net "A Connection Cannot be Made , Ensure that the server is running"

Hi I am connecting to my local cube from vb.net windows forms application. This form is called several times within my application. While in the application, i close the form and reopen it frequently.  The conAdomd.Open() functions without any error for the first three times . As in , when i launch the windows forms application for the third time, i get an error "A connection cannot be made, Please ensure that the server is running". I have tried installing the patches, but it does'nt help me.  Request help from forum members. Dim conAdomd As New AdomdConnection() conAdomd.ConnectionString = String.Format("Provider=MSOLAP.3;Data Source={0};", filename)     conAdomd.Open()

net.tcp://localhost:80/MyService client/server errors while IIS is running - even though all Net.TCP

Hello, I am trying to create a simple WCF client/server solution in two Windows Forms projects, respectively.  I am using net.tcp binding on port 80 and have enabled the port sharing property.  My NET.TCP Port Sharing service is running.  I am using Windows 7 x64 and logged in as an administrator.  I've added my username to the smvchost configuration files, in both Framework and Framework 64 directories. I also have IIS running on port 80. However, there seems to be a conflict between net.tcp on port 80 and IIS on port 80 simultaneously.  My understanding was that the Net.TCP Port Sharing is supposed to be the solution for this very scenario. Here are the specific issues: 1.  I start the server in debug mode, which works fine.  I then try to connect with the client, and get the error: "You have tried to create a channel to a service that does not support .Net Framing.  It is possible that you are encountering an HTTP endpoint".  This seems to imply that the NET.TCP Port Sharing is not forwarding the request to my WCF server, and instead is encountering IIS.  This is the first problem. 2.  The second issue is that the Server starts fine in Visual Studio in debug mode, however when I try to run it as a compiled EXE (and right-click - run as admin) it errors "The TransportMana

The report server is not responding. Verify that the report server is running and can be accessed fr

When I trying to configure Reposrting services in IIS & XP. It hsows me error  "The report server is not responding. Verify that the report server is running and can be accessed from this computer."   I also configure with reposrting configuration tools which show all confuguration is perfect.   but when I try to open through IE http://localhost/Reports/Pages/Folder.aspx   or http://localhost/Reportserver   It shows error. I try all ways still not works ..Help me out   Thanks.

Another merge agent for the subscription or subscriptions is running, or the server is working on a

Hi All, Using Merge Replication over the web (https). Server is running SQL Server 2008, client using SQL Server Express 2008. I am getting these error messages while trying to synchronize, and it won't let me sync: {call sp_MSensure_single_instance (N'{459D0BBA-53EC-4F65-AF52-E7DA478841DA}', 4)} Another merge agent for the subscription or subscriptions is running, or the server is working on a previous request by the same agent. Can you please advice what can be done to fix. Do I need to kill a process in SQL Server?

Saving Image File in a Folder on Sever from Client Machine using Sql Server

  Hi EveryOne... Can anyone help me Saving an Image file in a Server folder from a client machine using Sql server 2005....   

SSIS Package working on SQL Client Machine but when trying to run on SQL Server machine giving error

Hi We are trying to run SSIS package on sql server machine but sometimes it is giving error for data flow task containing Script Component. Error is - [SSIS.Pipeline] Error: component "SCR DimensionRelation" (1) failed the post-execute phase and returned error code 0x80004002. This error is not coming continuously. And also not for specific DFT. It comes for different DFTs as we rerun the package. Can anybody help me on this? We are using SQL server 2008. We are not getting any error on client machine :(:(

To prevent the server from setting cookie on the client machine

Hi, I have deployed a Web application on IIS 6. I want to prevent my server from setting cookie on the client browser. I am using the following setting on the web.config file. < sessionState mode="InProc" cookieless="false" />  <authentication mode="Forms">   <forms loginUrl="login.aspx">     </forms>  </authentication> However, it looks like its creating a default cookie named ".ASPXAUTH" in the client machine. I dont want my application to create any sort of cookie. Is there anything specific I need to do in web.config? Please help. Thanks in Advance
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend