Lab Sql

When my IIS MVC4 Web App (running as my user) tries to connect to a named LocalDb Instance it fails… Read more Sqllocaldb Info Lists Two Instances With The Same Name

title speaks for itself, db.ExecuteCommand('INSERT INTO tCSVFile(fileName, fileContent, mimetyp… Read more Linq To Sql Insert Not Working On Deployed Server(iis)

I have the following error with my ASP.NET web site. I have just moved it to another PC. Got IIS ru… Read more How To Resolve Asp.net Datacontext Connection Error

Using SQLite in PHP (thus using PDO), I have this code: try { $db = new PDO('sqlite:C:\Program … Read more How To Show Sql Errors In Sqlite?

We have an application running where IIS and SQL are on the same machine. It's a windows2003sta… Read more Best Way To Improve Performance (and Include Somehow Failover)

I'm working on an application using ASP.NET MVC5 and connecting to my SQL Server database with … Read more Can't Connect To Sql Server Database From Local Iis Over Https

Is there any way so IIS could connect to LocalDB without using the NT SERVICE\NETWORK SERVICE user … Read more Iis Connecting To Localdb

I have a web site running on IIS on my localhost. This web site has directory security set to only … Read more Integrated Windows Authentication With Iis, Firefox And Sql Server

I ran a web app on IIS and I got a System.Data.SqlClient.SqlException: 'Login failed for user&… Read more How To Fix System.data.sqlclient.sqlexception : "login Failed For User "xx\xxxx$""

We've just started using LINQ to SQL at work for our DAL & we haven't really come up wi… Read more How Do You Implement Caching In Linq To Sql?

We have a 3rd party product that allows some of our users to manipulate data in a database (on what… Read more Iis To Sql Server Kerberos Auth Issues

I am using SQLServer2005 and VS2008. My connection string in web.config is: add name='library&… Read more Web.config Authentication Error

I have a connection string that looks like this: Server=.;Database=mydbname;Trusted_Connection=True… Read more Application Cannot Open SQL Connection When On IIS

I recently disabled TLS 1.0 & TLS 1.1 on a web server, but it seems to have caused some issues … Read more SSL/TLS 1.2 Connection Issues - PHP/SQLSRV

When I run web application via VS 2008, the application is able to log onto Sql server and check cr… Read more SqlException: Login Failed For User 'NT AUTHORITY\NETWORK SERVICE

We have a 3rd party product that allows some of our users to manipulate data in a database (on what… Read more IIS To SQL Server Kerberos Auth Issues

We have an application running where IIS and SQL are on the same machine. It's a windows2003sta… Read more Best Way To Improve Performance (and Include Somehow Failover)

Using SQLite in PHP (thus using PDO), I have this code: try { $db = new PDO('sqlite:C:\Program … Read more How To Show SQL Errors In SQLite?

I have a connection string that looks like this: Server=.;Database=mydbname;Trusted_Connection=True… Read more Application Cannot Open SQL Connection When On IIS