Sharepoint Webpart

Question

I have created a webpart which works fantastic on my Virtual Machine where I have developed it.

But When I try to run the same webpart on my physical Machine, I cannot open the SQL Connection as the SQL Server is Seperate box on the network.

My Physical, Virtual and SQL Box are on the Same network but for some reason, It doesn't work on my Physical Machine,

It Come up with the following Message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

What causes this Issue?

Answer 1

You are using Intgrated Security, which means the current User is used for authentication against the database service. On the production server the webpart code is executed, using the anonymous user. And (of course) this user has no right to access any ressources other the web server files.

To avoid this behaviour use a dedicated account using SQL-Server security. See this example Connection string:

connectionString="Data Source=SERVERHOSTNAME;Initial Catalog=YOURDATABASE;Persist Security Info=True;User ID=YOURUSER;Password=YOURPASSWORD";

Be sure to get a valid logon from your production database administrator for your database with appropriate rights (such as db_reader).

Answer 2

You specified User Id and Password and then set Trusted_Connection to True, so I guess that integrated authentication is used - remove the Trusted_Connection=True part.