34,593
社区成员
发帖
与我相关
我的任务
分享请问sql为什么登陆不了？
下面是源代码，为什么浏览时会出现“用户 'NT AUTHORITY\NETWORK SERVICE' 登录失
败”
请高手指教
<%@Import Namespace="System.Data.SqlClient" %>
<HTML>
<title>Sample asp.net Page</title>
<body>
<script language="vb" runat="server">
Sub Page_Load(sender As Object, e As EventArgs)
Dim ConnStr as String
ConnStr = "Data Source = localhost;Integrated Security=SSPI;"
ConnStr = ConnStr +"Initial Catalog=pubs"
Dim conn As SqlConnection = New SqlConnection(ConnStr)
Try
conn.Open()
Status.Text = "Connection was successful!"
Catch ex As SqlException
Status.Text = ex.Message
Finally
conn.Close()
End Try
End Sub
</script>
<h1>Connecting to a data source using the Connection object</h1>
<asp:Label ID="Status" Runat="server"></asp:Label>
</body>
</HTML>
败”
请高手指教
<%@Import Namespace="System.Data.SqlClient" %>
<HTML>
<title>Sample asp.net Page</title>
<body>
<script language="vb" runat="server">
Sub Page_Load(sender As Object, e As EventArgs)
Dim ConnStr as String
ConnStr = "Data Source = localhost;Integrated Security=SSPI;"
ConnStr = ConnStr +"Initial Catalog=pubs"
Dim conn As SqlConnection = New SqlConnection(ConnStr)
Try
conn.Open()
Status.Text = "Connection was successful!"
Catch ex As SqlException
Status.Text = ex.Message
Finally
conn.Close()
End Try
End Sub
</script>
<h1>Connecting to a data source using the Connection object</h1>
<asp:Label ID="Status" Runat="server"></asp:Label>
</body>
</HTML>
...全文
请发表友善的回复…
发表回复
Gelim 2003-09-28
- 打赏
- 举报
控制面板--〉管理工具--〉服务--〉选择MSSQLSERVER--〉出现MSSQLSERVER的属性（本地计算机）的窗体--〉选择登录页--〉将登陆身份改为“本地系统账户”
不知道对楼主有没有帮助！
suwait 2003-07-15
- 打赏
- 举报
还是不行：
2、改为sa登陆如：
change localhost to your sql server machine name:
<%
sConn = "Provider=SQLOLEDB;Database=法律sql;Server=localhost;UID=sa;PWD=19791010;"
set conn = Server.CreateObject("ADODB.Nonnection")
conn.Open sConn
set rs = conn.Execute("select * from [l1000]")
do until rs.EOF
for i=0 to rs.fields.count - 1
Response.Write rs.fields(i).name & "=" & rs.fields(i).value & "<BR>"
next
rs.moveNext
loop
rs.close
conn.close
set conn=nothing
%>
、、、、、、、、、、、、、、、、、、、、、、、、
能不能说得更清楚一点啊，谢谢啦？
2、改为sa登陆如：
change localhost to your sql server machine name:
<%
sConn = "Provider=SQLOLEDB;Database=法律sql;Server=localhost;UID=sa;PWD=19791010;"
set conn = Server.CreateObject("ADODB.Nonnection")
conn.Open sConn
set rs = conn.Execute("select * from [l1000]")
do until rs.EOF
for i=0 to rs.fields.count - 1
Response.Write rs.fields(i).name & "=" & rs.fields(i).value & "<BR>"
next
rs.moveNext
loop
rs.close
conn.close
set conn=nothing
%>
、、、、、、、、、、、、、、、、、、、、、、、、
能不能说得更清楚一点啊，谢谢啦？
pengdali 2003-07-15
- 打赏
- 举报
1、企业管理器-->右键你的实例(就是那个有绿色图标的)-->属性-->安全-->改为sql与window混合
2、改为sa登陆如：
change localhost to your sql server machine name:
<%
sConn = "Provider=SQLOLEDB;Database=法律sql;Server=localhost;UID=sa;PWD=19791010;"
set conn = Server.CreateObject("ADODB.Nonnection")
conn.Open sConn
set rs = conn.Execute("select * from [l1000]")
do until rs.EOF
for i=0 to rs.fields.count - 1
Response.Write rs.fields(i).name & "=" & rs.fields(i).value & "<BR>"
next
rs.moveNext
loop
rs.close
conn.close
set conn=nothing
%>
see more connection strings at
http://www.able-consulting.com/ado_conn.htm?f=ado_conn.htm#DSN
2、改为sa登陆如：
change localhost to your sql server machine name:
<%
sConn = "Provider=SQLOLEDB;Database=法律sql;Server=localhost;UID=sa;PWD=19791010;"
set conn = Server.CreateObject("ADODB.Nonnection")
conn.Open sConn
set rs = conn.Execute("select * from [l1000]")
do until rs.EOF
for i=0 to rs.fields.count - 1
Response.Write rs.fields(i).name & "=" & rs.fields(i).value & "<BR>"
next
rs.moveNext
loop
rs.close
conn.close
set conn=nothing
%>
see more connection strings at
http://www.able-consulting.com/ado_conn.htm?f=ado_conn.htm#DSN
