Want to upload ASP.NET website on IIS.

Mufid Bagdadi

10y1.1k.NET

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

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vincent Maverick Durano10y ago
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 Bagdadi10y ago
Mufid Bagdadi10y ago
Here is my connection string...
connectionString="Data Source=.\SQLEXPRESS;AttachDbFileName=|DataDirectory|\umangDatabase.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True"
Vincent Maverick Durano10y ago
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 Bagdadi10y ago
Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
Rahul Chavan10y ago
Create a connection string and provide userid and password in it so website can have access to your database.
Vincent Maverick Durano10y ago
Please provide us the error that you are getting. It's hard to guess the "it doesn't accesses the sql database".
Vipan Sharma10y ago
can you please share error with me ?
Mufid Bagdadi10y ago
Its on same machine bro.
Vipan Sharma10y ago
where is your database ? is it on same system or other system ?