I am running Windows Vista 64bit - VS2005 - SQL2005
In my app my connection string is
everything works great when I run it in Visual Studio, yet if I run it from IE as localhost My connection string gave all kinds of errors. I looked around and found alot of info and came down to this:
Now I am getting login failure. Invalid credentials. I am not using any password for this db or SQL at all for that matter. I have set the login type to SQL Server and Windows Authentication. What the heck, IIS 7 is frustrating. What am I missing. Thanks in advance.
In my app my connection string is
Code:
Driver=SQL Server;Server=ComputerName\SQLExpress;Database=Mydbeverything works great when I run it in Visual Studio, yet if I run it from IE as localhost My connection string gave all kinds of errors. I looked around and found alot of info and came down to this:
Code:
"Provider=SQLOLEDB;User ID=ComputerName\Username;Password=SQLPassword;Initial Catalog=Mydb;Data Source=ComputerName\SQLExpress;"Now I am getting login failure. Invalid credentials. I am not using any password for this db or SQL at all for that matter. I have set the login type to SQL Server and Windows Authentication. What the heck, IIS 7 is frustrating. What am I missing. Thanks in advance.