Connectivity issue
-
Hi, I have a web application on a Windows XP box (IIS 5.1) which connects to SQL Server on a Windows 2003 box. I have Windows integrated security activated in IIS which is local. When I run my web application through browser it gives me the error: Login failed for user(null). Not a valid SQL Server connection. If I run the same Web app through VS 2005 it connects properly to the remote SQL Server database. Incidentally I log into my XP box in a global domain with a user credential who is having administrative privileges. What is going wrong and what corrective action needs to be taken. P.s. - This error has started creeping after I re-registered ASP.NET 2.0 in IIS using the aspnet_regiis utility as my IIS metabase had got corrupted. But I am not getting any clue as to why this should affect my SQL Server connectivity. Thanx in advance
-
Hi, I have a web application on a Windows XP box (IIS 5.1) which connects to SQL Server on a Windows 2003 box. I have Windows integrated security activated in IIS which is local. When I run my web application through browser it gives me the error: Login failed for user(null). Not a valid SQL Server connection. If I run the same Web app through VS 2005 it connects properly to the remote SQL Server database. Incidentally I log into my XP box in a global domain with a user credential who is having administrative privileges. What is going wrong and what corrective action needs to be taken. P.s. - This error has started creeping after I re-registered ASP.NET 2.0 in IIS using the aspnet_regiis utility as my IIS metabase had got corrupted. But I am not getting any clue as to why this should affect my SQL Server connectivity. Thanx in advance
The machine where the sql sever is installed , there u gave the user name and password (unlike the window authentication)for ur sql server, Now check out ur connectionstring.I think , u did not mention the user name and passwod there. and on more thing , I think , the window authentication mode on the machine where the vs.net is installed has nothing to do withe the sql server(on another machine). so write the connectiionstring , keeping in mind the configuration of that machine where the sql server is installed.)
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!