错误:ASP应用程序中不存在SQL Server或拒绝访问 [英] Error: SQL Server does not exist or access denied in ASP Application
问题描述
嗨!
我是一个意大利男孩,
对不起,我的语言不正确。
我有一台Windows服务器Server 2003 Enterprise Architect和SQL Server
2000 Enterprise。
我正在开发一个ASP Web应用程序,但是当我尝试连接到我的SQL
此连接字符串的服务器数据库
"数据源= MYSERVER;初始目录= MYDATABASE;密码= MYPWD;用户ID = Sa"
我收到错误:''SQL Server不存在或访问被拒绝''。
我已经检查了这个Kb的条件:
http:// support.microsoft.com/default...b;en-us;328306
和这个Kb
http://support.microsoft.com/default...Prod uct = aspnet
但我无法解决我的问题。
谢谢!
Simone
Hi!
I''m an Italian Boy,
Excuse Me for my incorrect language.
I have a Server with Windows Server 2003 Enterprise Architect and SQL Server
2000 Enterprise.
I''m developing an ASP Web Application, but when i try to connect to my SQL
Server Database by this connectionstring
"data source=MYSERVER;initial catalog=MYDATABASE;password=MYPWD;user id=Sa"
I receive th error : ''SQL Server does not exist or access denied''.
I'' have checked the condition in this Kb :
http://support.microsoft.com/default...b;en-us;328306
and this Kb
http://support.microsoft.com/default...Product=aspnet
but i cannot resolve my problem.
Thanks!
Simone
推荐答案
" Simone" < OV ********* @ hotmail.com>在留言中写道
news:uP **************** @ TK2MSFTNGP12.phx.gbl ...
"Simone" <ov*********@hotmail.com> wrote in message
news:uP****************@TK2MSFTNGP12.phx.gbl...
嗨!<我是一个意大利男孩,
对不起,我的语言不正确。
我有一台带有Windows Server 2003 Enterprise Architect和SQL服务器的服务器企业版。
我正在开发一个ASP Web应用程序,但当我尝试通过这个连接字符串连接到我的SQL服务器数据库时
数据源= MYSERVER ;初始目录= MYDATABASE;密码= MYPWD;用户
id = Sa"
我收到错误:''SQL Server不存在或访问被拒绝''。
我不是这些东西的专家,但我会使用server = MYSERVER。或者,如果数据库位于同一台机器上,则完全忽略这一点
确保SQL服务器正在运行并侦听端口1433和
我已经检查了这个Kb中的情况:
http://support.microsoft.com/default...b;en-us;328306
Kb
http ://support.microsoft.com/default...Product=aspnet
但我无法解决我的问题。
谢谢!
Simone
Hi!
I''m an Italian Boy,
Excuse Me for my incorrect language.
I have a Server with Windows Server 2003 Enterprise Architect and SQL
Server
2000 Enterprise.
I''m developing an ASP Web Application, but when i try to connect to my SQL
Server Database by this connectionstring
"data source=MYSERVER;initial catalog=MYDATABASE;password=MYPWD;user
id=Sa"
I receive th error : ''SQL Server does not exist or access denied''.
I''m not an expert on these things but I would use "server=MYSERVER" or, if
the database is on the same machine, leave out that bit altogether
make sure SQL server is running and listening on port 1433 and
I'' have checked the condition in this Kb :
http://support.microsoft.com/default...b;en-us;328306
and this Kb
http://support.microsoft.com/default...Product=aspnet
but i cannot resolve my problem.
Thanks!
Simone
我在远程机器上开发,
SQL服务器正在运行并在端口1433上侦听。 />
有什么想法吗?
谢谢。
西蒙娜
I develope in a Remote Machine,
SQL server is running and listening on port 1433.
Any ideas?
thanks.
Simone
试试这个Kb:
http://www.connectionstrings.com/
-
HTH,
Kevin Spencer
Microsoft MVP
..Net开发人员
跟随者和贷款人都不是。
Simone < OV ********* @ hotmail.com>在留言中写道
news:uP **************** @ TK2MSFTNGP12.phx.gbl ...
Try this Kb:
http://www.connectionstrings.com/
--
HTH,
Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.
"Simone" <ov*********@hotmail.com> wrote in message
news:uP****************@TK2MSFTNGP12.phx.gbl...
嗨!<我是一个意大利男孩,
对不起,我的语言不正确。
我有一台带有Windows Server 2003 Enterprise Architect和SQL服务器的服务器企业版。
我正在开发一个ASP Web应用程序,但当我尝试通过这个连接字符串连接到我的SQL服务器数据库时
数据源= MYSERVER ;初始目录= MYDATABASE;密码= MYPWD;用户
id = Sa"
我收到错误:''SQL Server不存在或访问被拒绝''。
<我已经检查了这个Kb中的情况:
http://support.microsoft.com/default...b;en-us;328306
和这个Kb
http://support.microsoft.com/default...Product=aspnet
但我无法解决我的问题。
>谢谢!
Simone
Hi!
I''m an Italian Boy,
Excuse Me for my incorrect language.
I have a Server with Windows Server 2003 Enterprise Architect and SQL
Server
2000 Enterprise.
I''m developing an ASP Web Application, but when i try to connect to my SQL
Server Database by this connectionstring
"data source=MYSERVER;initial catalog=MYDATABASE;password=MYPWD;user
id=Sa"
I receive th error : ''SQL Server does not exist or access denied''.
I'' have checked the condition in this Kb :
http://support.microsoft.com/default...b;en-us;328306
and this Kb
http://support.microsoft.com/default...Product=aspnet
but i cannot resolve my problem.
Thanks!
Simone
这篇关于错误:ASP应用程序中不存在SQL Server或拒绝访问的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!