IIS connecting to LocalDB

sql windows iis localdb
Tom Hruby picture Tom Hruby · Nov 9, 2012 · Viewed 14.5k times · Source

Is there any way so IIS could connect to LocalDB without using the NT SERVICE\NETWORK SERVICE user account.

This account has not suitable permissions. I'm looking use some other default account or is there some way that I can use the NETWORK SERVICE account without changing permissions?

Answer

Krzysztof Kozielczyk picture Krzysztof Kozielczyk · Nov 9, 2012

You should use Shared Instances feature of LocalDB. These two posts on Using LocalDB with Full IIS should give you more information. Especially the second part seems relevant, but the first one contains some context as well.

(note: the original links are no longer available, using archive.org instead)

  1. Part 1: User Profile
  2. Part 2: Instance Ownership

Original (non-working as of March 2019) links:

  1. Part 1: User Profile
  2. Part 2: Instance Ownership

Related questions

Import SQL file into mysql

I have a database called nitm. I haven't created any tables there. But I have a SQL file which contains all the necessary data for the database. The file is nitm.sql which is in C:\ drive. This file has …

Read More
Connecting to Microsoft SQL server using Python

I am trying to connect to SQL through python to run some queries on some SQL databases on Microsoft SQL server. From my research online and on this forum the most promising library seems to be pyodbc. So I have …

Read More
Can't connect to SQL 2012 remotely by IP and named instance

First off, I already know that Windows Firewall is blocking my connection -- I just don't know what to do about it. When I turn WF all the way off, my remote connection works. I already have a Rule to …

Read More