Login failed for user ''.
Hi Everyone,
I have this problem. I am done with the coding, and I want to access it using a url. The program is working perfectly in my local computer, but when I try to go to IIS, add a new website, assign port, like what I did in my past programs. The problem is when I try to go to the url, it is giving me the error: Login failed for user 'test1\Test2$'.
Here are some useful info:
Test1 is the network,
Test2 is the server and the IIS that I have located the development file
I developed the system using my computer but IIS is in the server
Is this an sql server security issue?
I searched the internet already and havent found the solution to my problem, I hope someone can help me out on this.
Thank you very much in advance.
Re: Login failed for user ''.
Sound's Like a SQL Security thing...
Dbl check all your SQL Connection strings, and test them on the IIS server..
Re: Login failed for user ''.
Hi GremlinSA,
Can you tell me how to do that?
Re: Login failed for user ''.
RDP to the IIS server (Remote Desktop if you cant access it physically) Fire up SSMS (Sql Server Management Studio) and test the SQL login ... and check this login to the one you have in your Web.config file...