Category: Windows 8

13 Dec 2017 11:40

Joined:	11/11/2017
Level:	Bronze
Points:	14

Points:	5

Can't acces SQL Server Express Database in IIS server?

I have an application ASP.net MVC in the neighborhood. I'm working with VisualStudio 2017 and IIS Express and SQL Server Express. I have attempted to put my undertaking on IIS nearby on my PC. My application can be executed on my program yet I can't make some demand with my SQL Server Express since my code is on IIS. I think SQL Server Express needs a few parameters yet I don't discover them.

My association string is :

this.Database.Connection.ConnectionString = "Server=" + NameServer + "; Database=" + NameDatabase + "; Integrated Security = genuine";

I utilize local SQL Server Express I don't know whether it's an issue If you have a few thoughts?

Kosmiktechnologies.com

#769454

01 Jan 2018 15:37

Joined:	13/06/2007
Level:	Gold
Points:	21327

Points:	3

you should attached SQLExpress keyword in your connection string.
see below sample connection string
'provider=sqloledb; datasource=IP\sqlexpress; uid=sa; pwd=test@123; database=test '

if your database server is same then you can use localhost or server name, instead of IP address
Hope it helps

Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]

#769460

02 Jan 2018 20:28

Joined:	12/11/2009
Level:	Gold
Points:	43848

Points:	2

I think your SQL Express is not configured to access remotely. Please refer below article and configure the DB accordingly and try again.

blogs.msdn.microsoft.com/sqlexpress/2005/05/05/how-to-configure-express-to-accept-remote-connections/

Let me know if this doesn't help.

Regards,
Asheej T K

Can't acces SQL Server Express Database in IIS server?

About dotnetspider.com

Quick Links

General

Services