替换VS .NET的SQL Server Express Edition集成 [英] Replacing VS .NET's SQL Server Express Edition Integration

问题描述

我已经看到很多帖子和准备文章讨论如何更改

会员资格&角色提供者在VS .NET中很容易，但还没有看到如何执行它的说明。


如果我已经在一台机器上安装了SQL Server 2000没有安装SQL Server

2005 Express我的VS .NET安装，如何设置我现有的SQL

2000服务器作为会员资格& ASP .NET的角色提供程序？

解决方案

您好Scott，


至于配置ASP.NET 2.0会员连接SQL Server 2000，你需要做b / b
需要做以下事情：


**使用aspnet_regsql.exe工具设置数据库在sqlserver 2000 db


**在ASP.NET 2.0应用程序中添加一个新的成员资格提供程序，它使用

a连接字符串指向您的SQL Server 2000数据库


这里有两篇网页文章提供了详细的步骤：


#Configuration ASP.NET 2.0 Application Services使用SQL Server 2000或SQL

Server 2005
http://weblogs.asp.net/scottgu/archi...25/423703.aspx

＃使用带有SQL Server 2000的ASP.NET 2.0 Membership API
http://www.vikramlakhotia.com/Using_...ith_SQL_Server

_2000.aspx

此致，


Steven Cheng


Microsoft MSDN在线支持主管


========= =========================================


通过电子邮件收到我的帖子通知？请参阅
http://msdn.microsoft .com / subscripti ... ult.aspx＃notif

ications。


注意：MSDN托管新闻组支持服务是针对非紧急问题

如果社区或微软支持人员在1个工作日内做出初步回复是可以接受的。请注意，每个跟随

的响应可能需要大约2个工作日作为支持

专业人士与您合作可能需要进一步调查才能达到

最有效的分辨率。该产品不适用于需要紧急，实时或基于电话的交互或复杂的b $ b项目分析和转储分析问题的情况。这种性质的问题最好通过联系

Microsoft客户支持服务（CSS）处理
href =http://msdn.microsoft.com/subscriptions/support/default.aspx\"target =_ blank> http://msdn.microsoft.com/subscripti...t/default.aspx 。


==================================== ==============

此帖子按原样提供。没有保证，也没有赋予任何权利。


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

>回复：Scott M. < sm ** @ nospam.nospam>
来自：" Scott M." < sm ** @ nospam.nospam>
主题：替换VS .NET的SQL Server Express Edition集成
日期：2007年11月29日星期四00:15:44 -0500

我已经看到很多帖子和准备文章讨论如何改变
会员资格&角色提供者在VS .NET中很简单，但还没有看到如何操作的说明。

如果我已经在一台机器上安装了SQL Server 2000并且没有安装SQL

Server

> 2005 Express安装我的VS .NET，如何设置现有的SQL
2000服务器是会员资格& ASP .NET的角色提供者？

你打败了我，史蒂文...... ;-)

第二个链接重新发布，修复它，因为它被分成2行。


！＃使用SQL Server 2000的ASP.NET 2.0 Membership API

！ http://www.vikramlakhotia.com/Using_...rver_2000 .aspx


要记住的一点是，SQL Server 2000和SQL Server 2005 Express可以共存。

我有它们两者同时在同一个测试盒上运行。


这样，您就不必处理可能需要旧语法的自定义实现。


Juan T. Llibre，asp.net MVP

asp.net faq： http://asp.net.do/faq/

foros de asp.net，en espa？ol： http://asp.net.do/foros/

== ====================================

" Steven Cheng [MSFT ]" < st ***** @ online.microsoft.com在消息新闻中写道：n7 ************** @ TK2MSFTNGHUB02.phx.gbl ...

嗨Scott，


至于配置ASP.NET 2.0成员资格以连接SQL Server 2000，你需要做b
$ b以下内容：


**使用aspnet_regsql.exe工具在sqlserver 2000中设置数据库db


**添加一个新的成员资格提供者你的ASP.NET 2.0应用程序使用

a connectionstring指向你的SQL Server 2000数据库


这里有两篇网页文章提供了详细的步骤：


＃配置ASP.NET 2.0应用程序服务以使用SQL Server 2000或SQL

Server 2005
http://weblogs.asp.net/scottgu/archi...25/423703.aspx


＃使用SQL Server 2000的ASP.NET 2.0 Membership API
http://www.vikramlakhotia.com/Using_...ith_SQL_Server

_2000.aspx


此致，


Steven Cheng


Microsoft MSDN在线支持主管


=============================================== ===


通过电子邮件收到我的帖子通知？请参阅
http://msdn.microsoft .com / subscripti ... ult.aspx＃notif

ications。


注意：MSDN托管新闻组支持服务是针对非紧急问题

如果社区或微软支持人员在1个工作日内做出初步回复是可以接受的。请注意，每个跟随

的响应可能需要大约2个工作日作为支持

专业人士与您合作可能需要进一步调查才能达到

最有效的分辨率。该产品不适用于需要紧急，实时或基于电话的交互或复杂的b $ b项目分析和转储分析问题的情况。这种性质的问题最好通过联系

Microsoft客户支持服务（CSS）处理
href =http://msdn.microsoft.com/subscriptions/support/default.aspx\"target =_ blank> http://msdn.microsoft.com/subscripti...t/default.aspx 。


==================================== ==============


此帖子按原样提供。没有保证，也没有赋予任何权利。



--------------------
< blockquote class =post_quotes>
>>回复：Scott M. < sm ** @ nospam.nospam>
来自：" Scott M." < sm ** @ nospam.nospam>
主题：替换VS .NET的SQL Server Express Edition集成
日期：2007年11月29日星期四00:15:44 -0500

我已经看到很多帖子和准备文章讨论如何改变
会员资格&角色提供者在VS .NET中很简单，但还没有看到如何操作的说明。

如果我已经在一台机器上安装了SQL Server 2000并且没有安装SQL

服务器

>> 2005 Express安装我的VS .NET，如何设置我的现有SQL
2000服务器是会员资格& ASP .NET的角色提供者？

好的，ScottGu的博客是一个很好的链接回答我的问题。


所以，现在我有一个跟进问题，这个问题出现在Scott的博客中，但是

没有回答：


如果我的现有数据库中有我自己的用户/密码数据已经存在于

表中，我该如何配置ASP .NET来使用该数据？

提供商如何知道使用我的表格以及哪个字段代表什么数据？


Steven Cheng [MSFT]" < st ***** @ online.microsoft.com写信息

新闻：n7 ************** @ TK2MSFTNGHUB02.phx.gbl ...

嗨斯科特，


需要做以下事情：


**使用aspnet_regsql.exe工具在sqlserver 2000 db中设置数据库


**在ASP.NET 2.0应用程序中添加一个新的成员资格提供程序，它使用

a连接字符串指向您的SQL Server 2000数据库


这里有两篇提供的Web文章详细步骤：


＃配置ASP.NET 2.0应用程序服务以使用SQL Server 2000或

SQL

Server 2005
http：//weblogs.asp。 net / scottgu / archi ... 25 / 423703.aspx

http://www.vikramlakhotia.com/Using_...ith_SQL_Server

_2000.aspx


此致，

Steven Cheng


Microsoft MSDN在线支持主管


======================================= ===========


通过电子邮件收到我的帖子通知？请参阅
http://msdn.microsoft .com / subscripti ... ult.aspx＃notif

ications。


注意：MSDN托管新闻组支持服务是针对非紧急问题

如果社区或微软支持人员在1个工作日内做出初步回复是可以接受的。请注意，每个跟随

的响应可能需要大约2个工作日作为支持

专业人士与您合作可能需要进一步调查才能达到

最有效的分辨率。该产品不适用于需要紧急，实时或基于电话的交互或复杂的b $ b项目分析和转储分析问题的情况。这种性质的问题最好通过联系

Microsoft客户支持服务（CSS）处理
href =http://msdn.microsoft.com/subscriptions/support/default.aspx\"target =_ blank> http://msdn.microsoft.com/subscripti...t/default.aspx 。


==================================== ==============


此帖子按原样提供。没有保证，也没有赋予

权利。



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

>>回复：Scott M. < sm ** @ nospam.nospam>
来自：" Scott M." < sm ** @ nospam.nospam>
主题：替换VS .NET的SQL Server Express Edition集成
日期：2007年11月29日星期四00:15:44 -0500

我已经看到很多帖子和准备文章讨论如何改变
会员资格&角色提供者在VS .NET中很简单，但还没有看到如何操作的说明。

如果我已经在一台机器上安装了SQL Server 2000并且没有安装SQL

服务器

>> 2005 Express安装我的VS .NET，如何设置我的现有SQL
2000服务器是会员资格& ASP .NET的角色提供程序？

I''ve seen many posts and ready articles discussing how changing the
membership & roles "provider" in VS .NET is easy, but have yet to see
instructions on how to do it.

If I already have SQL Server 2000 on a machine and didn''t install SQL Server
2005 Express with my VS .NET installation, how do I set up my existing SQL
2000 server to be the membership & roles provider for ASP .NET?

解决方案

Hi Scott,

As for configuring ASP.NET 2.0 membership to connect SQL Server 2000, you
need to do the following things:

** use aspnet_regsql.exe tool to setup a database in sqlserver 2000 db

** add a new membership provider in your ASP.NET 2.0 application which use
a connectionstring pointed to your SQL Server 2000 database

Here are two web articles provided detailed steps:

#Configuring ASP.NET 2.0 Application Services to use SQL Server 2000 or SQL
Server 2005
http://weblogs.asp.net/scottgu/archi...25/423703.aspx

#Using ASP.NET 2.0 Membership API with SQL Server 2000
http://www.vikramlakhotia.com/Using_...ith_SQL_Server
_2000.aspx
Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

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

>Reply-To: "Scott M." <sm**@nospam.nospam>
From: "Scott M." <sm**@nospam.nospam>
Subject: Replacing VS .NET''s SQL Server Express Edition Integration
Date: Thu, 29 Nov 2007 00:15:44 -0500

I''ve seen many posts and ready articles discussing how changing the
membership & roles "provider" in VS .NET is easy, but have yet to see
instructions on how to do it.

If I already have SQL Server 2000 on a machine and didn''t install SQL

Server

>2005 Express with my VS .NET installation, how do I set up my existing SQL
2000 server to be the membership & roles provider for ASP .NET?

You beat me to it, Steven... ;-)

Second link reposted, to fix it, as it was broken into 2 lines.

!#Using ASP.NET 2.0 Membership API with SQL Server 2000
!http://www.vikramlakhotia.com/Using_...rver_2000.aspx

Something to keep in mind, too, is that SQL Server 2000 and SQL Server 2005 Express can coexist.
I have them both running on the same testbox at the same time.

That way, you don''t have to deal with custom implementations which might require old syntax.


Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espa?ol : http://asp.net.do/foros/
======================================
"Steven Cheng[MSFT]" <st*****@online.microsoft.comwrote in message news:n7**************@TK2MSFTNGHUB02.phx.gbl...

Hi Scott,

As for configuring ASP.NET 2.0 membership to connect SQL Server 2000, you
need to do the following things:

** use aspnet_regsql.exe tool to setup a database in sqlserver 2000 db

** add a new membership provider in your ASP.NET 2.0 application which use
a connectionstring pointed to your SQL Server 2000 database

Here are two web articles provided detailed steps:

#Configuring ASP.NET 2.0 Application Services to use SQL Server 2000 or SQL
Server 2005
http://weblogs.asp.net/scottgu/archi...25/423703.aspx

#Using ASP.NET 2.0 Membership API with SQL Server 2000
http://www.vikramlakhotia.com/Using_...ith_SQL_Server
_2000.aspx
Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

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

>>Reply-To: "Scott M." <sm**@nospam.nospam>
From: "Scott M." <sm**@nospam.nospam>
Subject: Replacing VS .NET''s SQL Server Express Edition Integration
Date: Thu, 29 Nov 2007 00:15:44 -0500

I''ve seen many posts and ready articles discussing how changing the
membership & roles "provider" in VS .NET is easy, but have yet to see
instructions on how to do it.

If I already have SQL Server 2000 on a machine and didn''t install SQL

Server

>>2005 Express with my VS .NET installation, how do I set up my existing SQL
2000 server to be the membership & roles provider for ASP .NET?

Ok, ScottGu''s blog was a good link to answer my question.

So, now I have a follow up question, which came up in Scott''s blog, but was
not answered:

If I have an existing database with my own user/password data already in a
table, how can I configure ASP .NET to use that data? How would the
provider know to use my tables and what field represents what data?


"Steven Cheng[MSFT]" <st*****@online.microsoft.comwrote in message
news:n7**************@TK2MSFTNGHUB02.phx.gbl...

Hi Scott,

As for configuring ASP.NET 2.0 membership to connect SQL Server 2000, you
need to do the following things:

** use aspnet_regsql.exe tool to setup a database in sqlserver 2000 db

** add a new membership provider in your ASP.NET 2.0 application which use
a connectionstring pointed to your SQL Server 2000 database

Here are two web articles provided detailed steps:

#Configuring ASP.NET 2.0 Application Services to use SQL Server 2000 or
SQL
Server 2005
http://weblogs.asp.net/scottgu/archi...25/423703.aspx

#Using ASP.NET 2.0 Membership API with SQL Server 2000
http://www.vikramlakhotia.com/Using_...ith_SQL_Server
_2000.aspx
Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.

==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.

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

>>Reply-To: "Scott M." <sm**@nospam.nospam>
From: "Scott M." <sm**@nospam.nospam>
Subject: Replacing VS .NET''s SQL Server Express Edition Integration
Date: Thu, 29 Nov 2007 00:15:44 -0500

I''ve seen many posts and ready articles discussing how changing the
membership & roles "provider" in VS .NET is easy, but have yet to see
instructions on how to do it.

If I already have SQL Server 2000 on a machine and didn''t install SQL

Server

>>2005 Express with my VS .NET installation, how do I set up my existing SQL
2000 server to be the membership & roles provider for ASP .NET?

这篇关于替换VS .NET的SQL Server Express Edition集成的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！