Authentication Newbie help  
Author Message
Jedi_Dave





PostPosted: Installing and Registering Visual Studio Express Editions, Authentication Newbie help Top

Hey All

I can't seem to crack authentication, i've followed tutorials got everything working fine when i press F5, but when it's uploaded all i get is this

------------------------------------------------

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

--------------------------------------------------

Is this saying that The host should be running sql 2005 server, or can sql express exsit without a server installation.

I'd like to have all the authentication tables in a hosted Sql 2000 database i have, but i can't run the sql registation tool, so i always end up with a sql express databse.

So in a nutshell :

Why do i get the above error

and

Can i setup up asp.net 2.0 authentication with sql 2000 without the command line tool

I'm really in a mess here

cheers

DAve



Visual Studio Express Editions17  
 
 
ahmedilyas





PostPosted: Installing and Registering Visual Studio Express Editions, Authentication Newbie help Top

ASP.NET questions should be posted over at the ASP.NET forums:

http://forums.asp.net

as for the SQL Express problem, its exactly as it states - you need to enable remote connections. There are many topics about this on these forums, I have taken a couple of minutes to give you links to the topics to which I hope helps you:

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=11804&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=238688&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=333279&SiteID=1

http://support.microsoft.com/default.aspx scid=kb;EN-US;914277

I hope this helps



 
 
Glenn Wilson





PostPosted: Installing and Registering Visual Studio Express Editions, Authentication Newbie help Top

Looking at the example and text you have posted it looks like you are using the default settings for the membership system in asp.net, for this you should really post your questions in the Membership and security groups on http://forums.asp.net ...

But For starters using the default settings will create a user instance in the sql express database installed on the machine... Generally it will create it in the app_data directory. What you need to do is re point the memeber ship system to look for the tables and such in your sql 2000 database this can be done by running a command line tool to set up the tables and procedures inside your sql server 2000 machine. When this is done you will need to point your member ship provider to the new datastore. The command tool in question is 'aspnet_regsql' run with the following command line to see the help flags for it 'aspnet_regsql / '...