Want to upload ASP.NET website on IIS.

Question

Hi friends I have developed a web application on visual studio 2010 using c# & sql server 2008 i want to publish that website on my vmware's IIS which is running Windows Server 2012 R2 I uploaded the website on iis using ADD SITE its running but it doesn't accesses the sql database . Please help me its too urgent if possible u can take my remote access through Team Viewer. Kind Regards Mufid Bagdadi

Vipan Sharma · Answer

where is your database ? is it on same system or other system ?

Vincent Maverick Durano · Answer

Try the following steps: Login to SqlExpress via SQL Server Management Studio Go to the Security directory of the database Right-click the Users directory Select New User... Add 'NT AUTHORITY\NETWORK SERVICE' as a new user In the Data Role Membership area select db_owner Click OK

Mufid Bagdadi · Answer

Mufid Bagdadi · Answer

Here is my connection string... connectionString=Data Source=.\SQLEXPRESS;AttachDbFileName=|DataDirectory|\umangDatabase.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True

Vincent Maverick Durano · Answer

Can you show us your connection string? Also please give this discussion a read regarding your error: http://stackoverflow.com/questions/2251839/login-failed-for-user-nt-authority-network-service

Mufid Bagdadi · Answer

Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Rahul Chavan · Answer

Create a connection string and provide userid and password in it so website can have access to your database.

Vincent Maverick Durano · Answer

Please provide us the error that you are getting. It's hard to guess the i t doesn't accesses the sql database .

Vipan Sharma · Answer

can you please share error with me ?

Mufid Bagdadi · Answer

Its on same machine bro.