'integrated security' error
-
Hi Dear I registered as ASPSpider.com member. I uploaded my Database and ASP.NET 2005 files in my space, but when i connected to the address http://aspspider.info/sasannaderi/ (you can see it online) this error occured : Keyword not supported: 'integrated security'. My connectionStrings is this : <connectionStrings> <add name=sasannaderi_maskan Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=sasannaderi_maskan providerName=System.Data.SqlClient/> </connectionStrings> Can anyone help me to solve the problem?
-
Hi Dear I registered as ASPSpider.com member. I uploaded my Database and ASP.NET 2005 files in my space, but when i connected to the address http://aspspider.info/sasannaderi/ (you can see it online) this error occured : Keyword not supported: 'integrated security'. My connectionStrings is this : <connectionStrings> <add name=sasannaderi_maskan Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=sasannaderi_maskan providerName=System.Data.SqlClient/> </connectionStrings> Can anyone help me to solve the problem?
-
Integrated Security=SSPI means using Windows Authentication. Does that give you a clue?
Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP
-
Windows authetication works well in local environment. But not in deployed environment. Thats whay you are getting this problem. You have to use Sql Server authentication with proper userid and password.
Thanks, Arindam D Tewary
-
Windows authetication works well in local environment. But not in deployed environment. Thats whay you are getting this problem. You have to use Sql Server authentication with proper userid and password.
Thanks, Arindam D Tewary
In ASPSpider.com (Free Learning & Training Hosting)you can add only SQL Express database and in the guide, tell you that chang your connectionstring to this : "Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=YourUserId_DatabaseName" i change my connectionstring to above format, but it don't work yet!
-
Windows authetication works well in local environment. But not in deployed environment. Thats whay you are getting this problem. You have to use Sql Server authentication with proper userid and password.
Thanks, Arindam D Tewary
Arindam Tewary wrote:
Windows authetication works well in local environment. But not in deployed environment. Thats whay you are getting this problem. You have to use Sql Server authentication with proper userid and password.
That is utter tripe! That statement tells me that you have little idea of how it works rather than it being a deficiency on the part of SQL Server.
*Developer Day Scotland - Free community conference Delegate Registration Open
-
Windows authetication works well in local environment. But not in deployed environment. Thats whay you are getting this problem. You have to use Sql Server authentication with proper userid and password.
Thanks, Arindam D Tewary
Arindam Tewary wrote:
Windows authetication works well in local environment. But not in deployed environment.
:omg: Why ?
cheers, Abhijit CodeProject MVP
-
In ASPSpider.com (Free Learning & Training Hosting)you can add only SQL Express database and in the guide, tell you that chang your connectionstring to this : "Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=YourUserId_DatabaseName" i change my connectionstring to above format, but it don't work yet!
I am sure that they have advised that considering that indevidual would be working ( rather practising ) in their local system when you have SQL Express and application(which is accessed) is in the same COMPUTER. But if you have your code(application) which you try to see using HTTP , then you have to go for SQL Server authentication unless you have the ACCESS TO DATABASE AND YOU CAN CONFIGURE THE SAME DATABASE TO ALLOW WINDOWS AUTHETICATION FOR DEPLOYED APPLICATION. BUT IN MOST CASES, database never allows WINDOWS AUTHENTCATION for deployed application, i.e application which are accessed using HTTP.
Thanks, Arindam D Tewary
-
sasan56 wrote:
the project on my local system work as well.
This is because in your local environment you were using a different windows account to the one being used in the hosted environment. When an ASP.NET application is run inside IIS it will use the ASPNET user (typically) and that user is the one used to connect to the database. In your local environment you probably used Visual Studio's built in web server which would use your own personal credentials to authenticate against the database. You have to modify the database to permit logon from the user that the ASP.NET application is connecting as.
*Developer Day Scotland - Free community conference Delegate Registration Open
-
I am sure that they have advised that considering that indevidual would be working ( rather practising ) in their local system when you have SQL Express and application(which is accessed) is in the same COMPUTER. But if you have your code(application) which you try to see using HTTP , then you have to go for SQL Server authentication unless you have the ACCESS TO DATABASE AND YOU CAN CONFIGURE THE SAME DATABASE TO ALLOW WINDOWS AUTHETICATION FOR DEPLOYED APPLICATION. BUT IN MOST CASES, database never allows WINDOWS AUTHENTCATION for deployed application, i.e application which are accessed using HTTP.
Thanks, Arindam D Tewary
Arindam Tewary wrote:
BUT IN MOST CASES, database never allows WINDOWS AUTHENTCATION for deployed application, i.e application which are accessed using HTTP.
Arindam, I don't understand why it will not work. If you have the access right to that database then what would be the problem ?
cheers, Abhijit CodeProject MVP
-
Arindam Tewary wrote:
BUT IN MOST CASES, database never allows WINDOWS AUTHENTCATION for deployed application, i.e application which are accessed using HTTP.
Arindam, I don't understand why it will not work. If you have the access right to that database then what would be the problem ?
cheers, Abhijit CodeProject MVP
Abhijit, I just told that IN MOST CASES, but NOT for ALL CASES, and that I have seen from my experience. But surley I will try to find out some more of windows authentication in deployed server and that will help me getting much fair idea as well. Windows Authentication is also possible. Why not? :-D
Thanks, Arindam D Tewary
-
Hi Dear I registered as ASPSpider.com member. I uploaded my Database and ASP.NET 2005 files in my space, but when i connected to the address http://aspspider.info/sasannaderi/ (you can see it online) this error occured : Keyword not supported: 'integrated security'. My connectionStrings is this : <connectionStrings> <add name=sasannaderi_maskan Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=sasannaderi_maskan providerName=System.Data.SqlClient/> </connectionStrings> Can anyone help me to solve the problem?
write conn. string like this : <pre> <add name="sasannaderi_maskan" connectionString="Data Source=.\SQLExpress;Initial Catalog=sasannaderi_maskan" providerName="System.Data.SqlClient" /> may be this work for you. But when u upload it on server a proper data source is required. As "." is ok for local but i dont think for server.
-
Abhijit, I just told that IN MOST CASES, but NOT for ALL CASES, and that I have seen from my experience. But surley I will try to find out some more of windows authentication in deployed server and that will help me getting much fair idea as well. Windows Authentication is also possible. Why not? :-D
Thanks, Arindam D Tewary
Arindam Tewary wrote:
IN MOST CASES, but NOT for ALL CASES
Stop shouting. It is rude.
*Developer Day Scotland - Free community conference Delegate Registration Open