Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

IIS connecting to LocalDB

Tags:

sql

windows

iis

localdb

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?

like image 240
Tom Hruby Avatar asked Nov 09 '12 13:11

Tom Hruby

People also ask

How do I enable IIS access to SQL Server?

Right-click your application and then click Properties. On the Directory Security tab, click Edit. In the Authentication Methods dialog box, clear the Anonymous Access check box, and then do one of the following: If SQL Server is on the same computer as IIS, select the Integrated Windows authentication check box.

How do I connect to SQL database in IIS 10?

Click the Add Connection button on the Database Manager toolbar. In the Connection name text box, type a connection name. In the Database provider list, select the provider that you would like to use to connect to the database. (For example, to connect to a SQL Server database, select the System.

1 Answers

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
like image 66
Krzysztof Kozielczyk Avatar answered Oct 14 '22 14:10

Krzysztof Kozielczyk
Sign in to Comment

Related questions

The conversion of the varchar value overflowed an int column
When to use separate date and time instead of a single datetime
Django left outer join with filter
Like operator for integer
How to pivot dynamically with date as column
Performance of max() vs ORDER BY DESC + LIMIT 1
What is rowID & rowNum (ROWID vs ROWNUM)
Product Final Price after Many Discount given
How to aggregate (counting distinct items) over a sliding window in SQL Server?
Filtering by relation count in SQLAlchemy
Converting MySQL select to PostgreSQL
Getting rid of Table Spool in SQL Server Execution plan
MYSQL: Display Skipped records after LOAD DATA INFILE?
How to self JOIN recursively in SQL?
To calculate sum() two alias named columns - in sql
SQL - Joining two tables and counting items
How SQL's convert function work when converting datetime to float?
How to add tracing/debug output to stored procedures in Sql Server (2008)
MySQL: how to drop multiple tables using single query?
Why are BOOLEAN type columns problematic in relational database design?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!