Dear all,
I developed an asp.net application by using .net frame work 1.1 and sql server 2000.
i was using 2 tier arch (database server is different and web server is different).
my problem is , connection to sql server is not stable,some times it works and some times
it raises error that sql server does not exist or access denied.please help me to solve this problem
Hi all
Please help me.
I have an asp.net 1.1 (vb.net) application which accesses data from a sql server 2000. I published this application on http://test.autenmas.co.za and the database I access is on 196.23.156.196. I am getting this error message when I run the application from this site:
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
But it's working fine on my local, development machine. I am using the following connection string in my connections:
"Data source=196.23.56.193; Initial Catalog=Autenmas; User Id=xxxx; password=yyyy"
Is there anything wrong with my code, is there anything that must be done on the web/database server or any other configurations for that matter, what really is the problem??????
Thanks in advance.
Hi,
I'm trying to connect to my local database running on SqlServerExpress. I'm able to connect to it from SQL Server Studio. I'm also able to create a data connection to the database from VS.NET 2005 using server explorer. However, when I try to pull some data from my code, I get the "SQL Server does not exist or access denied." error.
Here's my code:
<asp:GridView ID="GridView1" runat="server" AllowPaging="true" DataSourceID="SqlDatasource1" /><asp:SqlDataSource ID="SqlDatasource1" runat="server" SelectCommand="select * from tStates" ProviderName="System.Data.OleDb" ConnectionString="Provider=SQLOLEDB;Server=.SQLSERVEREXPRESS;database=TestaDB;uid=sa;pwd=SAPassword" />
I'd appreciate some help on this.
Hi guys,
I just installed WebMatrix and MSDE (downloaded from www.asp.net), and I have set MSDE to use SQL authentication. I have granted user ASPNET read/write previlege and added it to the MSDE user's table. When I tried the following code, it gives me this error: "SQL Server does not exist or access denied."
<%@ Page Language="C#" Debug="true" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">
void Page_Load(object sender, EventArgs e) {
// TODO: Update the ConnectionString and CommandText values for your application
string ConnectionString = "server=(local)/BERKELEY;database=emonopoly;Trusted_Connection=yes";
string CommandText = "select * from test";
SqlConnection myConnection = new SqlConnection(ConnectionString);
SqlCommand myCommand = new SqlCommand(CommandText, myConnection);
myConnection.Open();
DataGrid1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
DataGrid1.DataBind();
}
</script>
<html>
<head>
</head>
<body style="FONT-FAMILY: arial">
<h2>Simple Data Report
</h2>
<hr size="1" />
<form runat="server">
<asp:datagrid id="DataGrid1" runat="server" CellSpacing="1" GridLines="None" CellPadding="3" BackColor="White" ForeColor="Black" EnableViewState="False">
<HeaderStyle font-bold="True" forecolor="white" backcolor="#4A3C8C"></HeaderStyle>
<ItemStyle backcolor="#DEDFDE"></ItemStyle>
</asp:datagrid>
</form>
</body>
</html>
I turned on the debug option, and the exact output is this:
Server Error in '/' Application.
--------------------------------------------------------------------------------
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
Source Error:
Line 13: SqlCommand myCommand = new SqlCommand(CommandText, myConnection);
Line 14:
Line 15: myConnection.Open();
Line 16:
Line 17: DataGrid1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
Source File: D:PersonalProjectsMS.NeteMonopolysourcedatareport.aspx Line: 15
Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +311
System.Data.SqlClient.SqlConnection.Open() +383
ASP.datareport_aspx.Page_Load(Object sender, EventArgs e) in D:PersonalProjectsMS.NeteMonopolysourcedatareport.aspx:15
System.Web.UI.Control.OnLoad(EventArgs e) +55
System.Web.UI.Control.LoadRecursive() +27
System.Web.UI.Page.ProcessRequestMain() +731
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
The strange thing is I'm able to connect to the MSDE database from the DATA window on the right hand side of the WebMatrix design window. Will somebody give me a hand?
And yes, I did make sure the MSDE is running.
Thanks alot
Chris
I have re-installed Visual Studio and SQL Server and now i am getting this error for all applications i try to runError:"
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
ResNet2.top_animals.BindGrid() +64
ResNet2.top_animals.Page_Load(Object sender, EventArgs e) +525
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
"any suggestions?
I'm trying to create to set up connection between my web application on the server and
the database on another box and getting "SQL Server does not exist or access denied" error.
Both the web server and the database machine are Windows 2003 Server, there's no firewall
enabled, there's mixed authentication enabled on the sql server. The machines are not on the
same domain so I'm using SQL Server authentication from web.config. Here's my connection string:
<add key="ConnectionString" value="Server=sqlboxip;User id=sqlaccountname;Pwd=sqlpass;Initial catalog=dbname">
I've also got <identity impersonate="true"> set in web.config.
Had it the connection working at some stage but then with more tweaking and app reinstall
back square one... Please help!</identity></add>
Hello!
When I start my .aspx with ASP.NET Web Matrix Server, it work, but when i try to start it with IIS I get error message.
TIA,
Misha
I have built a web application that runs on my local web server against my local SQL server and my development server, but now I'm trying to get it to work on the live server and I'm not getting a connection. Whenever I try to open the connection, I get a.
SQL Server does not exist or access denied.
error.
Here is my connection string...
Public connString as string
Dim SQLServer As String = "xxx.xx.xx.xxx"
connString = "server=" & SQLServer & ";" _
& "database=DBName;Trusted_Connection=No;user id=xxxID;password=xxxPassword;"
myConnection2 = New SqlClient.SqlConnection(connString)
------------------------------------------------------------
I'm starting my connection to run a datareader this way...
Dim strSQL As String
strSQL = "SELECT ClientID, ClientName " & _
"FROM Client; "
' Create a connection to the table in the SQL database located on
' the remote computer.
Dim myCommand2 As New SqlClient.SqlCommand(strSQL, myConnection2)
myCommand2.CommandTimeout = 1200
myConnection2.Open() 'HERE IS WHERE THE ERROR OCCURS
Dim myReader As SqlClient.SqlDataReader = myCommand2.ExecuteReader(CommandBehavior.CloseConnection)
While myReader.Read()
---------------------------------------------------------------
I can communicate with the server with no problem from my local computer. I can ping the server, and I also tested it by creating a system DSN using the login and password in my application, and it finds the database with no problem. I've tried to connect using the SQL Server's server name and the IP address and both return the same result. I've also saw something in another post to set the trusted connection parameter to "yes" and that didn't work either.
I'm developing on a Windows XP Professional and I'm trying to connect to a Windows 2003 Server with SQL Server 2000 installed on the machine.
I did add the database by restoring a backup from my local server onto the live server. I don't think that should matter, but maybe it does. If anyone has any ideas, I would greatly appreciate it.
hello , i'm very new to sql server.
i'm using sql server 200 & winXP. I have a local server called "JO" and a dsn named "LocalServer".
Authentication is sql server authentication & window with username of "cying" and password "admin"
i can ping my server "JO" but cannot telnet it's sql_server_tcp_port.
this is the error code i obtained when try to open the connection:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
my connection string is as below :
set objcon = server.CreateObject("ADODB.Connection")
strConnection = "Provider=MSDASQL;Driver={SQL Server};Server=local;Data Source=LocalServer;User ID=cying;Password=admin;Persist Security Info=False"
objcon.open, strConnection
is there anything wrong with my connection string or setting?
pls help, thanks in advance
My connection string is :
server=localhost;Database=INFOSEC;Integrated Security=true
It works for the login page, but it does not work for the registration page, and give the "SQL Server does not exist or access denied." error.
Any IDEA?
Hello everyone.
I am trying to install Project Server, and i'm having issues with sharepoint, and connecting to SQL:
dataserver is running sbs2003 sql2003 and analsys services.
server2 is running server2003 is to be the application server for project.
ProjectDb is the database that i have setup in sql.
username is the account that can control everything as administrer.
in Sharepoint is asks for the database server: <<dataserver>>
SQL Server database name: <<ProjectDb>>
I'm using windoes authentication and then i click ok, and get the error message.
I've also see the error message can not find the SQL Server, and access denied. Under ODBC i have installed the sql server information under System DSN.
Any help would be great.
Thanks
Everett Buel
Hi!
I understand that this topic is one of the most discussed topics ever. However i could not find the relevant information after going through (almost) all the posts so far. Hence this post. I am getting the 'SQL Server does not exist or access denied' error when I am trying to access SQL Server from a WINDOWS SERVICE. SQL Server and the Windows service are running on two different machines. (When they are on the same machine, it works). All the solutions I found so far are related to web apps. What should I do in the case of a windows service? My connection string uses SQL server authentication. (I tried with windows authentication. Its not working either.). Under what login does windows services run and how can I add it to valid SQL server logins?
hi,
I have an asp.net application which queries an sql server in some other domain and populates a grid with the results.
i am using sql server authentication and my connection string is as follows:-
Dim connectionString As String = "server=emr01; user id='private'; password='private'; database='NGEMRDev'"
i have also used the following tag in web.config:-
<identity impersonate="true" />
This works fine on my development pc i.e windows xp with sp2 .
but when i tried running the same application in windows 2003 the query gives the following exception:-
Server Error in '/TempDel' Application.
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.Source Error:
Line 77: dataAdapter.SelectCommand = dbCommand
Line 78: Dim dataSet As System.Data.DataSet = New System.Data.DataSet
Line 79: dataAdapter.Fill(dataSet)
Line 80:
Line 81: Return dataSetSource File: c:inetpubwwwroot empdelemrtempdel.aspx Line: 79 Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
ASP.EmrTempDel_aspx.MyQueryMethod(String username) in c:inetpubwwwroot empdelemrtempdel.aspx:79
ASP.EmrTempDel_aspx.Button2_Click(Object sender, EventArgs e) in c:inetpubwwwroot empdelemrtempdel.aspx:89
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +58
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032
Please help me as to how do i successfully implement my application in the windows 2003 server. i have given the aspnet user on the win2003 admin rights.
Hello
please assist me I will appreciate it
I have a problem in my scripting I gues,I "ve done the config and server registrations and allow a public permission ,but stil giving me trouble
well this is my coding:::::::
<
<script language="vb" runat="server">
Dim MyConnection As SqlConnection
Sub Page_Load(Sender As Object, E As EventArgs)
MyConnection = New SqlConnection("server=(localHost);Database=CampusLANDB;Trusted_Connection=yes")
If Not (IsPostBack)
Dim DS As DataSet
Dim MyCommand As SqlDataAdapter
MyCommand = New SqlDataAdapter("Select distinct State from Authors",MyConnection)
DS=New DataSet()
MyCommand.Fill(DS,"tStudents") ' This is where the pro underlies
MySelect.DataSource=DS.Tables("Name").DefaultView
MySelect.DataBind()
End if
End Sub
sub GetName_Click(Sender As Object,E As EventArgs)
Dim SelectCmd As String = "Select From tStudents Where Name =@Name "
Dim DS As DataSet
Dim MyCommand As SqlDataAdapter
MyCommand = new sqldataAdapter(SelectCmd, MyConnection)
MyCommand.SelectCommand.Parameters.Add(New SqlParameter("@Name",SqlDbType.VarChar,2))
MyCommand.SelectCommand.Parameters("@Name").Value = MySelect.Value
DS= new DataSet()
MyCommand.Fill(DS,"tStudents")
MyDataGrid.DataSource=DS.Tables("tStudents").DefaultView
MyDataGrid.DataBind()
End sub
</script>
and I will apreciate if anyone vcan help me urgently
PPM
I have two sql server 2000 with mixed mode authetication. I stand at one server and setup a linked server to the other using the same user id and password.
However when I click to the Tables icon of linked server in Enterprise manager, there is an error message:
Error 17 SQL Server does not exist or access denied.
And It does not show any table.
I register remote sql server in Enterprise manager fine.
Could any one help me ?
Thanks.
I installed SQL 2005 including backward compatibility, MSDN libraries and SP2 a new Windows 2003 server (chose mixed mode authentication). Installation was successful and I then installed an off the shelf database with Windows authentication which also installed successfully.
I created a new group in AD, added the database users into the group and gave db-owner rights to the group in SQL as advised by the installation guide. However, when I try to open the database it gives an error message saying "Cannot open database.[DBNETLIB][ConnectionOpen(Connect()).] SQL server does not exist or access denied". I also tested it adding an individual user (myself) as a user to no avail.
When I set up DSN in ODBC on my computer I can successfully test the connection but can't run the application. The connection is via TCP/IP.
Any suggestions?
Hello All,I have a webservice uses a vb.net component that accesses thrid party dll to connect to a sqlserver dbase, username,dbase name ,server and password are passed to the third party dll for login purpose.This works fine in development evironment when pda client calls webservice, A soap error is thrown to the client "sqlserver does not exist or access denied" when the client calls the deployed webservice. I have tried the following 1. Added ASPNet user to the database 2.Added domian user to the database both has public and dbowner rightsCan any one help??[:'(]Thanks Regards
View 1 Replies View RelatedWhen i am trying to start our hospital software based on SQL server 2000, it shows Following Error.Search Condition is not valid, (DBNETLIB) Connection Open (connect()).  SQL server does not exist or excess denied. Due to Fetch data.I run our software in Windows 8.1, while it smothly runs in previous version of Windows XP and 7.
View 2 Replies View RelatedI have recently deployed a web app that I have been developing onto the production server (Windows 2003 SP1 + an SQL Server 2000 SP4 cluster). The web app uses both Enterprise library and another Dotnet based database abstraction layer to query SQL Server. However, on deployment, when requesting data through both abstraction layers, I receive the generic SQL Server does not exist or access denied. However, I have validated the configuration of Enterprise library by creating a simple diagnostics console app that uses the exact enterprise library configuration file and this can connect without a problem. It seems like only web applications are affected though this is fairly standard web app using ASPNET, user , no impersonation etc. Therefore I suspect something similar to permissions on dlls or similar. I have looked around at Windows, WindowsSystem 32, the Dotnet framework but can anyone suggest any other areas to look at?
View 1 Replies View RelatedError: SQL Server does not exist or access denied.string select="select trainerid from trainer where username='"+user+"'";Line 78: comm=new SqlCommand(select,con);Line 79: con.Open();Line 80: dr=comm.ExecuteReader();Line 81: while(dr.Read())where should i set this so that the sqlserver can be access.. 1 private void btnsubmit_Click(object sender, System.EventArgs e)
2 {
3 string user=TextBox1.Text;
4 string password=TextBox2.Text;
5 Session["uname"]=TextBox1.Text;
6 Session["logintime"]=DateTime.Now.ToString("dd MMM, yyyy");
7 string connectionstring=ConfigurationSettings.AppSettings["connstring"].ToString();
9 con=new SqlConnection(connectionstring);
10 string select="select trainerid from trainer where username='"+user+"'";
11 comm=new SqlCommand(select,con);
12 con.Open();
13 dr=comm.ExecuteReader();
14 while(dr.Read())
15 {
16 Session["trainerid"]=dr["trainerid"].ToString();
17 }
18
19 Response.Redirect("tmenu.aspx");
20 if(CheckBox1.Checked=true)
21 {
22
23
24 DateTime dt=DateTime.Now;
25 TimeSpan ts=new TimeSpan(0,0,1,0);
26 HttpCookie cookie2=new HttpCookie("Username1");//creating http cookies
27 cookie2.Values.Add("name",user); //assigning first key value
28 cookie2.Values.Add("pword",password); //assigning second key value
29 cookie2.Expires=dt.Add(ts); //assigning the expires of cookie
30 Response.Cookies.Add(cookie2); //stored cookie to the client machine cookie folder
31
32 }
33
34
35 }
Does the error below look familiar to anybody? I cannot seem to get past it! My connection code is
<sessionState mode="SQLServer" stateConnectionString="tcpip=BRAHMA" sqlConnectionString="data source=epscor;user id=epscorser;password=epsc0r" cookieless="false" timeout="60"/>
Help in solving this appreciated! -Steve
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Web.SessionState.SqlStateConnection..ctor(String sqlconnectionstring) +92
[HttpException (0x80004005): Unable to connect to SQL Server session database.]
System.Web.SessionState.SqlStateConnection..ctor(String sqlconnectionstring) +189
System.Web.SessionState.SqlStateClientManager.GetConnection(Boolean& usePooling) +98
System.Web.SessionState.SqlStateClientManager.SetAsyncWorker(String id, SessionStateItem item, Byte[] buf, Int32 length, Boolean inStorage) +44
System.Web.SessionState.SqlStateClientManager.System.Web.SessionState.IStateClientManager.Set(String id, SessionStateItem item, Boolean inStorage) +147
System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs) +465
System.Web.SessionState.SessionStateModule.OnEndRequest(Object source, EventArgs eventArgs) +44
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87
Hello everyone,
I’m hoping that someone could help explain why I get this error “SQL Server does not exist or access denied.� . I’ve migrated to the web server from my local machine and these are the steps I took:
1.Copied folder to web server.
2. Changed connection string to connect to DB
3. modified web.config
Being the first time I’ve done this I’m also posting the connection string and config file code.
this.sqlConnect.ConnectionString = "Provider=sqloledb;Data Source=serverAddress;Initial Catalog=myDB;User Id=myLogin;Password=myPass";
I changed it from this:
this.sqlConnect.ConnectionString = "workstation id=myComputerName;packet size=4096;integrated security=SSPI;data source=myComputerName;pers" + "ist security info=False;initial catalog=blog";
the config file:
<sessionState
mode="InProc"
stateConnectionString="tcpip=mssql.mySqlSource.com:42424"
sqlConnectionString="data source=mssql.mySqlSource.com;Trusted_Connection=yes"
cookieless="false"
timeout="20"
/>
Question- that port number, does it need to be changed?
I know that the server is running both 1.1 and 2.0 framework. Not sure if that could be an issue or not.
In Advance I want to say thanks for any support I receive.
The Fatthippo.
We have sql server with the name production1 (IPID:100.102.33.33) ,from asp.net iam able to connect properly ,yesterday we changed the ip Id of this system(production1) from that time if iam trying to connect from asp.net code it is giving error sqlserver does not exists access denied.
Iam able to connect in query analyzer by using same userid,password.
Iam able to connect in vb.net with same connection string which iam using in asp.net
Iam unable to connect in asp.net error sqlserver does not exists access denied.
Please help me is there any problem with asp user or what?
Thanks
I think its my server because I cant get it to link up to an Access data base either, heres the error I get.[DBNETLIB]ConnectionOpen (Connect()),]SQL Server does not exist or access denied.Im pretty sure that all the fields that I entered are correct though.What could be the problem? Someone mentioned that the network protocol configuration maybe isnt setup right. Could this be the problem? If so how would I properly configure this?
View 14 Replies View RelatedI've got a SQL2000 named instance on a box that also has SQL 2005. Both database versions have run side by side for some time and I don't USUALLY have a problem (famous last words!).
I'm currently getting the error in the subject line trying to connect to it as "MACHINENAMESQL2000", SQL2000 being the named instances, from another machine. It works fine from the local machine, naturally. I have verified my creditials, i.e. both Windows Authentication and a SQL login work fine from the local machine. The machines are physically on the same subnet (they're actually side by side) and both can talk to each other just fine, i.e. they ping, and can map drives, etc.
Any tips/ideas on how to trouble shoot this? Is there a new security switch that needs to be set to make the db visible to other machines??
-Confused
I' ve wrote the following simple asp.net code to test the connection to my local SQL server:
SqlConnection connection = new SqlConnection ("server=localhost;uid=sa;pwd=;database=pubs");
try
{
connection.Open();
}
catch(SqlException ex){
Label1.Text= ex.Message;}
finally{
connection.Close();}
But each time I got the following errors:
SQL Server does not exist or access denied.
Can anyone help me find out when my problem lies?
BTW, the SQL service in Control Panel has been started, and my local SQL server uses windows and SQL authentication. When I use osql -E -S MyMachineName(This MyMachineName is some kind SQL Server Registration in SQL Server Group of SQL Server Enterprise Manage), everything seems to be fine, but it does not work when I use osql -E -S localhost.
Trying to get Quickstart tuts up and running. I get this error whenever i try to run any examples.
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied
I installed the MSDE (i think) and i see the service MSSQL server running.
I don't see the icon in the system try that shows SQL server is running. I don't even know how to check to see if the MSDE is installed. There is nothing in my Start>>Program Files MSDE related. What am i doing wrong? Thanks!
Trying to get the Quickstarts up and running. When i go to one of the server side data access tutorials i get the error: SQ: server does not exist or access denied. I am using SQL server 2000. Any reason i would be seeing this?
Also, to see the quickstarts i have to browse to httP://localhost/quickstart/.....if i try to go to http://machinename/quickstart/ i get access denied. Any reason for that?
Thanks for any help.
I'm getting the following error when I run my web app:
SQL Server does not exist or access denied.
I created a role in my db and added a user to that role.
I gave the user the appropriate permissions.
I also gave the user the appropriate permissions to my tables.
Thank you,
Tina
Hi,
I get the following error when I try to access SQL Server:
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied
and I also get the following Warning in the System Log
The server was unable to logon the Windows NT account 'ECOM411-BOYSSWGASPNET' due to the following error: Logon failure: unknown user name or bad password. The data is the error code.
I have settup the account 'ECOM411-BOYSSWGASPNET' on the SQL Server and have given it access to the my DB... Could some one tell me what could be wrong??
How can I fix this probelm..
Thanks
I have 2 servers. one is the web server and the other is the sql server. web server(iis) is on windows 2000 and sql server is hosted on windows 2003
i can't connect to the sQL Server hosted on my Windows 2003 machine from an asp.net application. This is the error message i am getting. "SQL Server does not exist or access denied."
The sql server is set for both windows and sql server authentication. I have no problem connecting to it from the Web server using Enterprise Manager or Query Analyser.
The password is correct and username sa has full access.
This is the code i am using. the code is fine. i have used it 100s of time. the code below will work if i change the data source to "localhost" to connect to the sql server that is hosted on the same machine.
Dim strCon As String
strCon = "data source=Data1;initial catalog=MyFriendsNet;password=blah;persist security info=True;user id=sa;workstation id=Web1;packet size=4096"
Dim MyConnection As SqlConnection = New SqlConnection(strCon)
Dim MyCommand As SqlCommand = New SqlCommand("Select * FROM Users", MyConnection)
MyConnection.Open()
Dim MyDr As SqlDataReader = MyCommand.ExecuteReader
While MyDr.Read()
Response.Write(MyDr("FirstName"))
End While
MyDr.Close()
MyConnection.Close()
This probably has to do with some kind of authentication issue. anyone have any ideas.
Hi,
When i am running web server IIS 5.0 and SQL Server 2000 in the same machine, the following connection strings is working well:
server=(local);uid=sa;pwd='';database=databaseName
But, when i try to run Web Server IIS 5.0 on machnine A and SQL Server 2000 on machine B. The connection strings for connecting to the database server is:
server=serverName;uid=sa;pwd='';database=databaseName
The following error occurs:
Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
Source Error:
Line 70: myCommand.CommandType = CommandType.Text
Line 71: ' Execute the command
Line 72: myConnection.Open()
Line 73: Dim result As SqlDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Line 74:
Source File: c:inetpubwwwrootPSRBNetDesktopModulesCirrusMembershipDB.vb Line: 72
Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +484
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
PSRBNet.Cirrus.MembershipDB.GetSingerMemberInfo(String MemberID) in c:inetpubwwwrootPSRBNetDesktopModulesCirrusMembershipDB.vb:72
PSRBNet.Cirrus.Test.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootPSRBNetDesktopModulesCirrusTest.aspx.vb:534
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
Anyone facing this problem before? please help...
Hi All, I'm working from the tutorials section of this site.
The code is below:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<script language="VB" runat="server">
Sub Page_Load(Sender As Object, E As EventArgs)
Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter
MyConnection = New SqlConnection("server=(local)NetSDK;database=pubs;Trusted_Connection=yes")
MyCommand = New SqlDataAdapter("select * from Authors", MyConnection)
DS = new DataSet()
MyCommand.Fill(ds, "Authors")
MyDataGrid.DataSource=ds.Tables("Authors").DefaultView
MyDataGrid.DataBind()
End Sub
</script>
<body>
<h3><font face="Verdana">Simple Select to a DataGrid Control</font></h3>
<ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
/>
</body>
</html>
This is the error:
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
Hope you can help.
Thanks,
Dermot