I had some problems with them: SSRS (SQL Server Reporting Services) account expired several times and the reports stopped working and that is bad for business. SSRS is not a common need for websites but the point is how much can you trust them to support your client's business. Also I had some problems with server upgrades that did not keep compatible configurations. Also 2 years ago or so, support was much better.
Hesham A. Amin My blog twitter: @HeshamAmin
User accounts were lost from your post, but you can configure IIS App pool to run using any windows account. as mentioned here[^]. But select "Custom Account"
Hesham A. Amin My blog twitter: @HeshamAmin
Try to add
Initial Catalog=STAYATWORK;
to the connection string.
Hesham A. Amin My blog twitter: @HeshamAmin
Can you try to change the EF connection to:
The difference between the connection strings is that the ENTLib connection connects to a named instance (LNIDDBTUMSQL24\STAYATWORK) while the EF connection connects to the default instance on LNIDDBTUMSQL24.
Hesham A. Amin My blog twitter: @HeshamAmin
Alikom AlSalam, Eid Mubarak :) Can you post the connection strings used in both cases? Does the DB admin allow public users on the database?
Hesham A. Amin My blog twitter: @HeshamAmin
Since the application pool user is not on the same domain, windows authentication won't work. How will SQL server know about your app pool user? It does not exist in Active Directory. You need to enable SQL authentication or make your machine join the domain which has the SQL server.
Hesham A. Amin My blog twitter: @HeshamAmin
Are the development machine and the DB server on the same domain?
Hesham A. Amin My blog twitter: @HeshamAmin
You can start with the built-in asp.net Membership management[^].
Hesham A. Amin My blog twitter: @HeshamAmin
If you're talking about just the content, not the system code, I think you should update directly on production server and have a good review workflow. the other option will be a bit hard to manage if you allow site users (not editors) to post comments for example. How will you manage the data then?
Hesham A. Amin My blog twitter: @HeshamAmin
Our team used both cruise control[^] and TFS. We also used PowerShell to automate some tasks within the build scripts. There is a great value in implementing build automation and CI in general. Start simple and add more features to your build steps later. Generally, automation is never a waste of time especially when it comes to repetitive tasks like builds. Hesham A. Amin My blog twitter: @HeshamAmin
In my opinion, the major WCF advantage is extensibility and flexibility. It isolates different aspects from the interface (Contract) that the service implements. Examples are: -How data is transfered: SOAP, TCP, JSON, MSMQ) -Security (authorization, authentication) -Performance tuning The framework had many implementations for the above aspects and you can implement your own, for example is an open source project that provide binding for transfer over SMTP (email). You can intercept the WCF pipeline to add some required behaviors or choose from already implemented one. That's why I'm a big fan of WCF :)
Hesham A. Amin My blog twitter: @HeshamAmin
We have solved the issue long time ago, so I don't remember the issue accurately. But as I remember, it was related to replication. There were multiple domain controllers serving the domain. If first CommitChanges saves data to dc1, the second may go to dc2. The solution is to add users in batch and replicate the domain controllers then update the password in another cycle.
Hesham A. Amin My blog twitter: @HeshamAmin
You just create the list and it should be available in the gallery. check List View Web Part[^]
Hesham A. Amin My blog twitter: @HeshamAmin
You need to read image names from database instead of scanning the directory, using a query like:
SELECT * FROM tbl_image WHERE im_album_id = XXX
Reading a basic PHP/MySQL Tutorial[^] will help.
Hesham A. Amin My blog twitter: @HeshamAmin
shankbond wrote:
also when I uploaded a file to the database it was of 18041 bytes, but when I retrieved it after saving on desktop the size was 19,756 bytes which is increased?
I think you need to clear the response using Response.Clear() It's very important not to use string concatenation to make sql statements. Use parameterized queries instead.
Hesham A. Amin My blog twitter: @HeshamAmin
I think you need URL rewriting. check these links: URL Rewriting in ASP.NET[^] URL Rewriting with ASP.NET[^]
Hesham A. Amin My blog twitter: @HeshamAmin
Sure, it's a POST request after all. And you can use Fiddler [] to trace existing service calls. But why do you need to do it that way?
Hesham A. Amin My blog twitter: @HeshamAmin
Your application should work fine with .net 2.0 sp1. unless you need to simulate a client environment where the client did not install the service pack. In this case you should encourage him to update.
Hesham A. Amin My blog twitter: @HeshamAmin
I agree to WoutL's post. But I want to clarify that null comparisons fail. unless you have ANSI_NULLS set to OFF. So take care of nulls in your queries. Also check: Another place when NULL gets tricky[^]
Hesham A. Amin My blog twitter: @HeshamAmin