Groups > Asp .Net > ASP dotNET Security > Re: creating login database on server




creating login database on server

creating login database on server
Wed, 2 Apr 2008 11:13:23 +0000
I am trying to create a login database on GoDaddy to allow access to a password
protected folder.

I created the database on my local computer with the online asp.net
configuration website and tested it locally and it worked fine.

I selected publish to provider and scripted the db to a .sql file. 

I created the database on GoDaddy and using their online manager I executed the
.sql file. At the end of the equecution it had the following errors

"Cannot resolve the collation conflict between "Hebrew_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation. Cannot
resolve the collation conflict between "Hebrew_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation. Cannot
resolve the collation conflict between "Hebrew_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation. Cannot
resolve the collation conflict between "Hebrew_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation. Cannot
resolve the collation conflict between "Hebrew_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation. " 

 I have hebrew installed on my computer but I am not using hebrew in this
database so I dont know where it got it from.

When I try to login I get the server error "Could not find stored procedure
'dbo.aspnet_CheckSchemaVersion'. "

What should I do? GoDaddy does not support remote connectivity which makes
everything more complicated.

 

Thanks in advance
Post Reply
Re: creating login database on server
Wed, 2 Apr 2008 12:05:42 +0000
how else can I setup a login database that is simpler and understandable that I
can do by hand?
Post Reply
about | contact