MSDE Problem - SQL Server Not Found Or Access Denied
Nov 10, 2003
I am running the MSDE 2000 Setup off the SQL Server 2000 Developer Edition CD.
After installation is complete, there is a service under the Control Panel -> Services window
called MSSQL$GregInstance. I then start that service.
But now when I try to connect to the database using
osql -E -S GregInstance
I get told that the SQL Server does not exist or access denied. Even though the server is running. I have also tried
osql -E -S localhost
but no luck. Why can it not find the instance of SQL Server?
Note : SQL Server 2000 is not installed on the machine, only this MSDE instance.
Thanks
Greg
View 1 Replies
ADVERTISEMENT
Sep 30, 2004
When making a call to MyList.DataSource = products.GetProductCategories();
I get the "SQL Server not found or Access denied" error. Where should I start looking?
Thanks,
Dion
View 2 Replies
View Related
Aug 7, 2005
Yes I have the dreaded "SQL Server does not exist or access denied." error
when trying to connect to an MSDE database. I've tried many solutions
found across the net. I installed the latest sp3a version of MSDE,
granted the ASPNET worker process access to my database, opened port
1433 in the Windows XP firewall. I'm running Windows XP SP2.
The funny thing is that I can successfully connect using an ODBC DSN connection (OdbcConnection). No problems at all.
This works.
<code>
Dim strDSNString As String = "DSN=mike"
Dim objConn As New OdbcConnection(strDSNString)
Dim objCmd As New OdbcCommand("select * from table1", objConn)
Dim objReader As OdbcDataReader
Try
objConn.Open()
objReader = objCmd.ExecuteReader
While objReader.Read
Response.Write(objReader("column1"))
End While
objConn.Close()
Catch
Response.Write("fail")
End Try
</code>
But no luck when I try an SqlConnection.
This does not work.
<code>
db_connection = New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
db_connection.Open()
</code>
The connectionString = Integrated Security=SSPI;Initial
Catalog=miketest;Data Source=localhost;Network
Library=dbmssocn;Trusted_Connection=True;
So, why does the OdbcConnection work but the SqlConnection does not??
Thank you.
View 4 Replies
View Related
Sep 21, 2006
Hi all,
I'm getting this error message when I try to connect my MSDE database from other machine using enterprise manager application. Both of the machines are WinXP SP2. I found some solution such as using 'SQLServer Network Utility' but didn't work out for me. I even can not connect my database on my computer using TCP/IP. When I connect with name, it worked fine. I already enable both TCP/IP and Named pipe protocol on the MSDE machine.
If someone has solution on that please let me know.
Thanks,
Myo
View 7 Replies
View Related
Jul 26, 2004
I've got a popular problem so i get a message that server acces denied! ..
But that what is different in my error.... When i use same setting same database and connection string (on MSDE server) there is no problem...
On SQL server i have got windwos authentication but i added all accounts as ASPNET and SA.... and when i try to connect by
RETTO - name of my server
server=RETTO;uid=sa;pwd=password;database=db1;
or by
Integrated Security=SSPIserver=RETTO;uid=RETTOASPNET;database=db1;
I CAN BROWSE RECORDS THERE ARE NO PROBLEMS WITH CONNECTION!!! but when i try to update or iinsert or delete something in database there becomame this error that access denied or server does not exist!!!
PLEASE HELP I'm FIGHTING WITH THAT FOR OVER 5 DAYS!!!
I MADE FOR MY ACCOUNTS (SA, ASPNET) ALL THINGS ALLOWED AS EXECUTING stored procedures.. OR ACCESING datatables with insert delete and update query WHERE IS THE PROBLEM!!!??
View 3 Replies
View Related
Jun 10, 2015
I have recently upgraded to SQL2014 on Win2012. The Access front end program works fine.
But, previously created Excel reports with built in MS Queries now fail with the above error for users with MS 2013. The queries still work for users still using MS 2007.Â
I also cannot create any new queries and get the same error message. If I log on as myself on the domain to another PC with 2007 installed it works fine, so I don't think it is anything to do with AD groups or permissions.
View 6 Replies
View Related
Apr 22, 2015
When 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 Related
Oct 28, 2006
Hi folks,
I'm having trouble getting off the ground with the Web application walkthrough "Walkthrough: Creating a Web Application Using Visual C# or Visual Basic" in VS.NET Pro 2002 [Academic] documentation. After a bit of fishing around, and consulting the MS Knowledge Base, I got the pubs database installed. I also got the connection to work well enough that the dataset would fill in the IDE.
The problem is that when I try to run the web form, either from the IDE debug menu, or by accessing the .aspx file on localhost using Firefox, I get the error:
SELECT permission denied on object 'titles', database 'pubs', owner 'dbo'.
showing in the browser.
My understanding is that this page is running as ASPNET, and I did already carry out the recommended commands to enable access:
C:>osql -E -S MY-MACHINE-NAMEVSDOTNET -Q "sp_grantlogin 'MY-MACHINE-NAMEASPNET'"
C:>osql -E -S MY-MACHINE-NAMEVSDOTNET -d Pubs -Q "sp_grantdbaccess 'MY-MACHINE-NAMEASPNET'"
both of which commands returned successfully. Any suggestions as to what else I should do to get the necessary permissions to actually display the data in my browser? Does the IIS user account need permission also?
Thanks for any insight into this vexing problem. I must say that along the way, I have had some fun exploring the osql comand-line tool. Using the -E switch, I have been able to run select and upgrade queries, but this is all pretty much fishing in the dark. I would like to get back to actually working with the walthroughs in the Visual Studio documentation.
Thanks,
Joseph
View 4 Replies
View Related
Apr 3, 2005
Hi
Recently I install XP SP2 (wish I wouldn’t!) , now I cant use MS SQL databases , this is the error :
SQL Server does not exist or access denied
I add to ports 1433 and 1434 to windows firewall , as this article said :
http://www.docs.com/HelpFiles/WindowsXPServicePack2Fix.htm
but I doesn’t work
Do any one know how can I fix it ?
Tanks,
View 8 Replies
View Related
Oct 6, 2006
I 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 Related
Oct 7, 2006
Error: 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 }
View 18 Replies
View Related
Nov 30, 2006
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
View 7 Replies
View Related
Feb 8, 2007
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.
View 8 Replies
View Related
Feb 16, 2007
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
View 17 Replies
View Related
Nov 5, 2007
Hi,
Iam using a connection string to connectin sql server from asp.net (vesion 1.1).
When iam using same connection string in windows form it is connecting to sql server proplery.
Iam using the same connection in asp.net (web based page) but is saying an error "SQL Server does not exists or access denied".
From Query analyzer iam able to connect to sql server.
Please let me know the reason .
Thanks,
ASwani kumar
View 8 Replies
View Related
Jan 6, 2008
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 Related
Jun 17, 2008
I'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
View 1 Replies
View Related
Nov 12, 2003
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.
View 3 Replies
View Related
Nov 14, 2003
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!
View 5 Replies
View Related
Nov 17, 2003
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.
View 1 Replies
View Related
Nov 25, 2003
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
View 11 Replies
View Related
Dec 12, 2003
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
View 6 Replies
View Related
Dec 19, 2003
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.
View 3 Replies
View Related
Feb 11, 2004
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...
View 4 Replies
View Related
Apr 21, 2004
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
View 20 Replies
View Related
Jun 11, 2004
As shown by the post topic, I am trying to connect to a remote sql server through enterprise manager, and have been getting "SQL Server does not exist or access denied".
I have disabled Named Pipes, made sure it's listening on port 1433, triple-checked the user account, etc. Still nothing. The server is behind an ISA server, that has packet filtering turned on for 1433 also, yet I can't help but think the ISA server is to blame....
I am baffled after reading multiple tech docs and forum posts.
ANY HELP would be GREATLY APPRECIATED. (I'm pulling my hair out).
View 4 Replies
View Related
Jun 21, 2004
Hello,
I am walking step y step with this tour:
http://www.asp.net/webmatrix/tour/section2/createnewdb.aspx
But when I came to this step:
http://www.asp.net/webmatrix/tour/section2/image/22_EnterDbName.jpg
I got the fallowing error message:
Could not create the database.
Sql server does not exist or access denied ConnectionOpen (Connect()).
I just installed:
http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1
Your help is greatly appreciated.
View 4 Replies
View Related
Aug 26, 2004
ASP.NET page on dev server and live server both access data on live server.
A couple of days ago I started getting "SQL Server does not exist or access denied" error when running the pages on the Dev server.
Looking at the live server logs I see:
Logon Failure:
Reason:Unknown user name or bad password
User Name:ASPNET
Domain:FS-DEVWEB-2000
Logon Type:3
Logon Process:NtLmSsp
Authentication Package:NTLM
Workstation Name:FS-DEVWEB-2000
What changed? Why can't the ASP.NET on the Dev server get SQL data from the Live Server. All the connection strings are correct. I can get the same SQL connection and queries running in Enterprise Manager and Classic ASP from the Dev server to the Live Server.
Any ideas how to fix this. I'm sure I just have to some how tell the live server to trust the Dev server.
Thanks
View 2 Replies
View Related
Sep 11, 2004
I got this error when try to run dotnet application SQL Server does not exist or access denied .
Here is my connection string. It used to be working. THanks!
<add key="data" value="data source=66.25.45.27;initial catalog=EPLAN_DB_DEV;persist security info=False;user id=eplanuser;workstation id=laptop;packet size=4096;password=qnetuseradd>
View 3 Replies
View Related
Sep 17, 2004
Hello Everyone and thanks for your help in advance. I am having an awful time debugging a SQL Server Connection issue. I have a new installation of a Windows 2003 Server and SQL Server 2000. I have an ASP.Net application that is currently functioning on a Windows 2000 Server. I have donwloaded all of the latest service packs. I have verified that the SQL Server uses both SQL Server and Windows authentication. I have set the connection string in the web.cinfig to:
server=(local);uid=sa;pwd=password;database=Northwind
But nothing seems to get me connected. I have read numerour KB articles, but can't get resolution. I desperately need help. Any insight would be enormously appreciated. Thanks.
View 4 Replies
View Related
Sep 19, 2004
I get this error when trying to run my newly designed page
here is where it occurs
Server Error in '/NewParadoxDotNetConversion' 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 230: 'Put user code to initialize the page here
Line 231: Me.DstUpgradesSQL1.Clear()
Line 232: Me.daUpgradesSQL.Fill(Me.DstUpgradesSQL1) <---------
Line 233:
Line 234:
Source File: e:inetpubwwwrootNewParadoxDotNetConversionamdupgrade.aspx.vb Line: 232
Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
NewParadoxDotNetConversion.amdupgrade.Page_Load(Object sender, EventArgs e) in e:inetpubwwwrootNewParadoxDotNetConversionamdupgrade.aspx.vb:232
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
alright here is the problem though
Using this connection UNALTERED i can go into this data adapter run this query through query analizer and it works great
I can make it fill the dataset in the IDE but when i run the page it gives this error
when creating a connection to this computer i save the password so it should not need the password
when i create this connection I select the server i use my login I select the database click "Test Connection" and it works correctly and as i said earlier i can use this connection in the IDE without any problems what-so-ever
is there anything you can tell from this
in sql server under properties of the server -> under the security tab -> under authentication
i moved the option to "sql server and windows" from "windows only"
so that i could login from a remote server
is there something else i should change also?
The program works correctly on my development computer running sql server 2000 on windows 2000 pro
the other sql server that is giving me the problems is located on a windows 2003 server with sql server 2000
Thanks for any help you can give
View 10 Replies
View Related
Sep 25, 2004
I am getting this message error when executing my first web application. I am using MSDE and executing on the same computer. Here is the code i am using. The name of the local computer is winxp.
<%@ Page Language="VB" Debug="true" %>
<%@ import Namespace="System.data" %>
<%@ import Namespace="System.data.sqlclient" %>
<script runat="server">
' Insert page code here
'
Sub Page_Load(Sender As Object, E as EventArgs)
Dim con as new sqlconnection("data source=winxp.contactos;integrated security=SSPI;Database=Contactos")
Dim da as new sqldataadapter ("select * from contactos",con)
Dim ds as new dataset()
da.fill(ds,"contactos")
ListBox1.DataSource = ds
ListBox1.DataTextField = ds.tables("Contactos").Columns("Cedula").ToString
ListBox1.DataBind()
end Sub
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<asp:ListBox id="ListBox1" runat="server" Width="275px"></asp:ListBox>
<!-- Insert content here -->
</form>
</body>
</html>
View 1 Replies
View Related
Nov 25, 2004
Hi,
I have problem in connecting SQL Server 2000.
The Operating System I am Using is MS 2000 Proffesional, I have Installed SQL Server 2000 Client.
I have Installed the SQL Server(Standard Edition) on MS Server 2003 and also the Sql Server 2000. This is my Domain Server.
Through ASP.NET when i am trying to connect through the Connection String it says "SQL Server does not exist or access denied"
I have no problem in connecting through SQL Server Manager & Query Analyzer.
Could Any one tell me the right way to connect to Remote Server.
Thanking You,
Regards,
M.Upendra Nath
View 1 Replies
View Related
