Click here to Skip to main content
14,422,431 members
Rate this:
Please Sign up or sign in to vote.
See more:
HI i design website in code. I using sql server database for my website. When i run website from vb its run ok but when i host my website on iis server website not reading and writing data. I add also appPool and firewall setting. but not working
here is my connection string which i using in vb
strProvider = ("server=DESKTOP-18J50OK\RSSSQLSERVER;AttachDbFilename=" & DbPath & "\RSS.mdf;User Instance=True;Integrated Security=True")

What I have tried:

I want host my website on iis server and run in lan (Local network)
Updated 5 days ago
F-ES Sitecore 5 days ago
You've either not set the site up correctly (we don't know how you've set it up, we can't access your system so can't tell you), or the IIS server can't connect to "desktop-18j50ok" (again we don't know your network, where your IIS is, what your firewall settings are etc so we can't help you with this either).

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Attaching a database file should only be done on a development machine, but avoided for any production purpose.
Please see SQL Server connection strings[^] to know how to build your connection string. Use the service provided by the SQL instance rather than relying on attaching a .mdf file.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100