My IIS7x server is logging all fields to W3C format. I'm using LogParser and sending each row out to SQL for further analysis. After a few months worth of logging, each row finds a null value in sUserTime.
Under what conditions would some component within IIS or Windows write a value into sUserTime? I'd like to be sure it's always null so I can merge the currently separate 'Date' & 'Time' fields into it using an update statement that depends on 'is null' condition.
thx
Working in IIS7x and a handful of MVC3 sites. I'm trying to make the contents single folder (.wvm files) accessible to a number of different websites (each resolving to a different domain).
How do I configure the server so that links resolve to a physical path on the server's drive instead of a relative path within a given site's folder structure?
e.g. the same physical file should serve both these requests
http://www.mySite1.com/media/aCommonVideo.wmv
http://www.myOtherSite.com/media/aCommonVideo.wmv
thx
For an asp.net webapp, is there a functional difference between a connection string (in Web.config) that uses:
Data Source=[WIN-MachineName]\SQLEXPRESS
vs
Server=[WIN-MachineName]\SQLEXPRESS
Since both refer to the instance of SQLServer one wants to think they'd be interchangeable.
My remote server running 08 R2 can connect to it's SQLExpress instance via SSMS. db Properties has 'Permit remote connections ticked'. Firewall off doesn't help. Another thread here shows 'sqlcmd -e -s ip\instance' as a suggestion - i'm not familiar with that way in - only use SSMS - but if that's _supposed to work locally, it's not in my case.
What's the next step to implementing remote access? Is the 64 bit coming into play? 64 bit version is installed but the configuration manager has a couple nodes with reference to '(32-bit)'
thx
I've just installed SQL Express 08 R2 using default choices. I notice that the 'Log on as:' property is 'Network Service'. Is that correct?
fwiw, This instance lives only to serve IIS (runs on the same box) and only needs to respond to remote admin access via our VPN.
thx
Is there an interface separate from the regular IIS manager?
When I search on IISExpress I find only a link to a folder full of logs related to IISExpress sites that had been spawned by Visual Studio.
Is there a difference between installable IIS features (specifically Smooth Streaming) depending on which WindowsServer 08 R2 edition is installed?
thx
I'm using WinServer to generate and send emails via my Goggle Apps-hosted domain (my SMTP server is smtp.gmail.com) . My registrar (Network Solutions) supports Text records - so I should be able to sign outgoing mail. Where do I go to generate those keys? Do I need anything running on my server - is there some other entity involved beyond inserting a text record in my registrar's DNS?
thx
I'm trying to implmenet a scenerio where my website's images are stored in an Amazon S3 bucket. So far, i've setup the bucket and the CNAME record so that images are correctly served from S3 via the URI pattern: 'http://images/myDomain.com/[image files]'
Now I want to convince IIS to rewrite incoming requests to point to S3. The site's images are currently stored as:
http://testing.myDomain.com/content/images/logo.jpg.
Working off several samples for IIS's URL Rewrite module, this is the rule that I'm thinking should work but obviously isn't. Since I'm testing this, I literally am working in the subdomain named testing. The above URL really _does resolve to my logo.jpg.
<rule name="Redirect Images" stopProcessing="true">
<match url="http://testing.myDomain.com/content/images/(.*)" />
<action type="Redirect" url="http://images.myDomain.com/{R:0}" />
</rule>
mny thx
When i installed windows i had a typo in the machine name that i corrected from the system's 'Computer Name/Domain Changes' - the workstation is a member of a workgroup not a domain. From everything i can see the renamed machine name is correct.
Shift gears.... I'm importing SQL logins from my remote server to this, my development workstation and have used the script presented here - a script that generates a CREATE statement for each login found. While I was preparing to run this script's output (from the remote box) i needed to change the domain name from the remote to my local's name - so i ran the same script locally (in order to see what SQL things my domain name is.
SQL has the original machine name - the one with the typo. However, the scripts are tossing errors if i try to create logins with that identifier.
CREATE LOGIN [Setve\Admin] FROM WINDOWS WITH DEFAULT_DATABASE = [master]
But works correctly if i use the updated machine name: CREATE LOGIN [Steve\Admin] FROM WINDOWS WITH DEFAULT_DATABASE = [master]
So the problem is: do i have a problem i need to solve? Somewhere, deep in the guts of SQL Server, it has record of a Domain name that does not exist. Should i find and fix that discrepancy?
thx
Windows 2008 with native Windows Firewal w/Adv Sec. Using GRC.com's Shield'sUP to probe my system I find 25 to be open. Since I only use it to send mail from SQL Server (internally) i'd like to close the port to any outside access. I have a firewall rule set to block all local and remote 'Port 25' on all profiles but shieldsup insists it can see 25.
where do i look next?
thx
I have a VPN connection to my remote Win08 server running Windows Firewall w/ Adv. Sec. I open all ports to a handful of specific IPs which gives me ability to connect with Remote Desktop Connection as well as access to the file system (mapping network drives).
Now i'm trying to configure access to the sql server. Working from my local MSSMS I can see the remote Database Engine in the 'Browse for Servers | Network Servers' dialog. But I can't actually establish a connection (the standard 'cannot connect to...' error dialog pasted below) until i turn off the 'Private Profile' of the firewall.
So the firewall rule that grants access to File Sharing and Remote Desktop Connection is not granting access to the SQL Server. Where do I look for additional config options?
TITLE: Connect to Server
Cannot connect to myBoxName.
------------------------------ ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)
Logged on as 'Administrator' (and a member of just one Group - Administrators) i am seen as God (ok ... god) to the SQL install.
Where do I bestow the same level of permission to all members of the Administrators group?
EDIT: The server's configured to accept Mix Login Mode in case that matters.
thx
I'm working with a newly hired dev on a server08 box - he'll be working both SQL and IIS7. In the past I've just bestowed Admin on devs (and if he's reading this - nothing personal - i'm sure you are a fine upstanding whatever yadayada).
The box has VS10 and sql08 but none of the existing groups are pointing at those specific packages. How do i go about assigning appropriate permissions?
thx
My sql error log is full of messages telling me one or another of my dbs is starting up - sometimes the time spacing is only fractions of a sec apart:
2010-08-27 10:07:00.98 spid59 Starting up database 'myDb'.
2010-08-27 10:07:03.11 spid59 Starting up database 'myDb'.
2010-08-27 10:07:03.44 spid59 Starting up database 'myDb'.
I'm seeing this on several db that have very low activity and on seeing any on thoes dbs that are more active. No intervening messages saying anything about an error condition - is this normal?
I'm working with a Server08 box (Web Edition) where the Task Scheduler had run a set of unchanged housekeeping scripts for months. Over the last week, Scheduler has failed to start scripts twice.
TS's UI is not reporting any error condition - just doesn't run the scripts. I'd like to run a query (either PowerShell or Log Parser) to pull any TS-based events for the last week but i'm not sure of the best approach, syntax, or process names to look for.
thx
I'm running a web-based store where order confirmations are sometimes blocked and don't reach the intended user. The structure of the business model is such that our product is marketed to the end-user by a 3rd parities - affiliates how are known entities to the end-users and email is freely exchanged between end-users and our affiliates.
Our confirmations being blocked is becoming a big enough problem that we are considering implementing a system where a 'confirmations' address is created within the affiliates domain, then we'd have our app send via the affiliate's mail server instead of our own. But that'd be lots of work.
The idea has been raised to have our app use our affiliates' email in the FROM field but still send from our server. My thinking is that would be detected at the end-users side and blocked just as often - we dealing with institutions large enough at least some checks up at the perimeter.
Is this assumption correct (more likely to be blocked) or is there a less round about way to send messages under the auspices of 3rd parties?
thx
Looking for examples of integrating LP into this workflow:
So i think the question boils down to:
How do i hook LP upto IIS7?
EDIT: Ok...re-boiling the question. When an IIS exception is triggered I want to see all the other log rows where the session cookie is the same as the session cookie found in the error event. Yes, I could live with polling IIS logs via a scheduled task - that takes ELMAH/SQL out of the equation.
But now the question becomes: Find all log rows where session cookie = the session cookie found in a row that had an error
Probably in than email is outgoing means servers have to reply but beyond that, what's the bare minimum portlist that a public-facing webserver (iis7 with same-box sql) have to admit?
I've been managing our company's server-farmed webserver from my workstation via internet for long enough that it will be easy to miss out on the new capabilities offered by combining Win7 and Server08 simply because I've got a system that works.
But it's always nice to make stuff work better.
I've been reading about major advances in VPNing when a Win7 client connects to a WinServer08 box. I'm not clear if all improvements are contained within the product called 'DirectAccess' which is intra-net oriented or not. Since I'm _not dealing with an intranet i'm not sure where to look for possible enhancements I can actually take advantage of.
My host is not actively supporting 08 (tho they've let me image my server from it) so I can't count on them for helping me explore what's possible. Here's their reply to my initial question asking them to review MS's prerequisites for DirectAccess (http://technet.microsoft.com/en-us/library/dd637808%28WS.10%29.aspx).
The question boils down to which rabbit holes should I be looking to for enhanced connectivity features that avoid the complexity of conventional (MS-based) VPN configurations?
The requirements suggest the need for two physical interfaces, from what I can tell, one being publicly facing and another facing a private or intranet, which is not something your server is really associated with, so I don't see how this feature would be usable. There would be no IPv6 support on the standard internal networking feature we offer to you, and you'd need multiple systems on that internal network system to make use of it.
Additionally, all servers are assigned 1 single IP by default, and we cannot offer a consecutive IP address for the public-facing network interface, unless you use a private VLAN or if this system will properly work with the secondary IP allocation method we typically use.
We also do not offer support for Active Directory and the network configuration is not designed with operating an AD forest at this time.
Many thx