Re: 'integrated security' error - ASP.NET Discussion Boards

sasan5617-Apr-09 1:17

17-Apr-09 1:17

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?

Re: 'integrated security' error

Ashfield17-Apr-09 2:03

Ashfield

17-Apr-09 2:03

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

Re: 'integrated security' error

sasan5617-Apr-09 2:32

sasan56

17-Apr-09 2:32

I set it to True, but it don't work!
the project on my local system work as well.

Re: 'integrated security' error

Arindam Tewary17-Apr-09 2:37

Arindam Tewary

17-Apr-09 2:37

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

Re: 'integrated security' error

sasan5617-Apr-09 2:47

sasan56

17-Apr-09 2:47

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!

Re: 'integrated security' error

Arindam Tewary17-Apr-09 3:04

Arindam Tewary

17-Apr-09 3:04

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

Re: 'integrated security' error

Abhijit Jana17-Apr-09 3:24

Abhijit Jana

17-Apr-09 3:24

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

Re: 'integrated security' error

Arindam Tewary17-Apr-09 3:45

Arindam Tewary

17-Apr-09 3:45

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? Big Grin | :-D

Thanks,
Arindam D Tewary

Re: 'integrated security' error

Colin Angus Mackay17-Apr-09 5:24

Colin Angus Mackay

17-Apr-09 5:24

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

Re: 'integrated security' error

Colin Angus Mackay17-Apr-09 3:00

Colin Angus Mackay

17-Apr-09 3:00

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

Re: 'integrated security' error

Abhijit Jana17-Apr-09 3:03

Abhijit Jana

17-Apr-09 3:03

Arindam Tewary wrote:
Windows authetication works well in local environment. But not in deployed environment.

Why ?

cheers,
Abhijit
CodeProject MVP

Re: 'integrated security' error

Colin Angus Mackay17-Apr-09 3:06

Colin Angus Mackay

17-Apr-09 3:06

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

Re: 'integrated security' error

Ashfield17-Apr-09 9:04

Ashfield

17-Apr-09 9:04

Of course it didn't. You have to be in a trusted domain for it to work, thats why its called WINDOWS AUTHENTICATION

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: 'integrated security' error

Dev S17-Apr-09 4:01

Dev S

17-Apr-09 4:01

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.

how to display date in gridview header

rahul.net1117-Apr-09 0:15

rahul.net11

17-Apr-09 0:15

Hello All,
I want to display dates in gridview header for eg:
If the week start on 12 (Sunday) then i want to display all the week dates in its header as follows.

S(12) M(13) T(14) W(15) T(16) F(17) S18

how can i do this?

Thanks
Rahul

People Laugh on me Because i am Different but i Laugh on them
Because they all are same.

Re: how to display date in gridview header

Ashfield17-Apr-09 2:04

Ashfield

17-Apr-09 2:04

I can't see what your problem is, if you have a start date to use then just add 1 to it to get the next date - simple with the datetime class.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: how to display date in gridview header

wasifahmad17-Apr-09 3:36

wasifahmad

17-Apr-09 3:36

If you have a data table and you are binding your grid with datatable then gridview header caption will be made by datatable.Columns(0).ColumnName property. Whatever you will assign in ColumnName property of column will become grid view header caption.

Let me know this solves your issue or not?

Regards,
Wasif Ahmad

difference between DataReader and DataAdapter??

Pradeep Shet16-Apr-09 23:28

Pradeep Shet

16-Apr-09 23:28

what is the major difference between DataReader and DataAdapter??

Re: difference between DataReader and DataAdapter??

Abhijit Jana16-Apr-09 23:33

Abhijit Jana

16-Apr-09 23:33

pradeep.shet wrote:
what is the major difference between DataReader and DataAdapter??

DataReader Vs DataAdapter

cheers,
Abhijit
CodeProject MVP

Message Removed

16-Apr-09 23:26

gunasundari

16-Apr-09 23:26

Message Removed

Re: adobe flex in asp.net

Abhijit Jana16-Apr-09 23:35

Abhijit Jana

16-Apr-09 23:35

gunasundari wrote:
How to integrate the adobe flex file in asp.net web application?

Did you gone through the Flex Online help. That is one if the based resource from where you can learn.

cheers,
Abhijit
CodeProject MVP

How to customize t Shirt..

KiranKumar Roy16-Apr-09 23:03

KiranKumar Roy

16-Apr-09 23:03

i want to customize t shirt with asp.net.

please refer blow site and please give me some idea how it is possible with the asp.net.

http://en.tailor4less.com/tailormade/shirts/configure[^]

Kindly Check it and give me right way to do this..

thanks in advance.

KIRANKUMAR ROY
http://www.misc-story.blogspot.com

Re: How to customize t Shirt..

Abhijit Jana16-Apr-09 23:26

Abhijit Jana

16-Apr-09 23:26

KiranKumar Roy wrote:
i want to customize t shirt with asp.net.

I didn't get you!

cheers,
Abhijit
CodeProject MVP

Re: How to customize t Shirt..

KiranKumar Roy17-Apr-09 1:40

KiranKumar Roy

17-Apr-09 1:40

have you visited site which i have given on my post...
it will explain you all the things....
I need a site which dynamically generate image of T shirts in which i can
select the t shirt color, T shirt size text on the T Shirt...
Kindly visit the below site..

http://en.tailor4less.com/tailormade/shirts/configure[^]

Thans for you reply..

KIRANKUMAR ROY
http://www.misc-story.blogspot.com

Re: How to customize t Shirt..

SeMartens17-Apr-09 1:38

SeMartens

17-Apr-09 1:38

Well write a webapp... You could use silverlight to make it look fency...

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Last Visit: 31-Dec-99 18:00 Last Update: 28-Apr-24 12:22

Refresh

ᐊ Prev 1...2078 2079 2080 208120822083 2084 2085 2086 2087 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.