Login failed for user 'HNT1PC0281ASPNET'. 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: Login failed for user 'HNT1PC0281ASPNET'.
This String work in a C# application, but not ASP using VB.
Source Error:
This occurs on the con.Open() statement
When using a loginname/password I recieve
con = New SqlConnection("Server=HNT1PC0281;uid=sa;pwd=something;database=test")
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. 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: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
<script language="VB" runat="server"> Sub Page_Load() Dim strConnection as String = "user id=sa;password=;" strConnection += "database=northwind;server=solo822;" strConnection += "Connect Timeout=30" data_src.text = strConnection
Dim objConnection as New SqlConnection(strConnection)
'now we attempt to open the connection try objConnection.Open() con_open.text="Connection opened successfully.<br />" objConnection.Close() con_close.text="Connection closed.<br />" catch e as Exception con_open.text="Connection failed to open.<br />" con_close.text=e.ToString() end try end Sub </script>
<html> <body> <h4>Testing the data connection <asp:label id="data_src" runat="server"/></h4> <asp:label id="con_open" runat="server"/><br /> <asp:label id="con_close" runat="server"/><br /> </body> </html>
the displayed error: Testing the data connection user id=sa;password=;database=northwind;server=solo822;Connect Timeout=30 Connection failed to open.
System.Data.SqlClient.SqlException: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at ASP.sql_connection_aspx.Page_Load()
I have instal VS Studio and MSDE. For experimental purposes I have not instal office and SQL. I wanted to see if I could connect to the MSDE. But each time I try to connect I receive the error message Access Denied or SQL Server does not exist.
I have installed the MSDE that comes with VS NET 2002. For experimental reason's I have decided not to instal SQL and Office XP.
But the problem I have is that anytime I try to connect I receive an exception. The exception message is "No SQL server or Access Denied". I am not too sure if I am not doing something right or I have to instal office or SQL. I have created my database using the visual tools in the VS NET 2002.
I've just started to learn ASP.net using Scott Mitchell's book:ASP.NET in 24 hours. But i've got a little problem in the database section. I couldn't connect with a MSDE from webmatrix using sql server authentication even the username and password are correct. The error message : "unable to connect to the database server:Login failed for user 'sa'. Reason:not associated with a trusted SQL server connection". What does it mean? Have any of you ever had this kind of problem? Thank you for helping me.
I am trying to connect to a remote MSDE SQL database. When I set up the odbc connection I get a connection denied error. The SQL server is on a windows 2003 server. Any ideas are greatly appreciated.
When i developed my application, i used sql 2000 as a server side DB. Now my client want to install MSDE instead of SQL 2000.
so i uninstall SQL2000 and installed MSDE .
AS we all know, MSDE doesn't have GUI. So i installed Microsoft SQL Server Management Studio Express - Community Technology Preview (CTP) (includeing xmlparser,windows installer,.net 2.0).
now i could able to view tables and everything. but i couldn't make the connection. Getting error like "SQL server not found. CMPNAMEMSDERELA" I used same kind of connection string for SQL 2000. Worked well.here what happened?
Connection String : "Data Source = CMPNAMEMSDERELA;Database =TEST; User id ="xxx; Password =xxxx;"
OS: Windows server 2003. i used VB.NET to develop the apps. (VS2003). Connecting from Pocket PC.
kindly help me to solve this problem.
(Already i posted this in SQL tools forum. i hope this is the right place to post this question. so posting again.)
Where <IPADDRESS> is the Ip address of the remote machine and <INSTANCENAME> is the MSDE instance name. Is this correct? If not, what am I doing wrong?
REBOOTED AND sql SERVER iCON APPEARS on the lower desktop Icon bar, open it and it says: Server: JOHN Servises: SQL Server Running \JOHN - MSSQLServer
opened a command prompt at c: and entered osql -S JOHN -U sa -P password and got the 1> reply on the next line
I typed EXIT
I had downloaded two scripts that create Pubs and Northwind SQL databases. I put them in the C: folder
I Typed at c:osql -E -i instpubs.sql
It created the pubs SQL database for me
I Typed at c:osql -E -i instnwinds.sql
It created the nwinds SQL database for me
I closed the command prompt and went to the Administrator Tools in the Control Panel I selected Data OLEDB Selected ADD entered Pubs and used default values for Pubs to create a connection Tested it OK
Then went and ran Visual Studio Net 2003 Checked to see if the pubs and northwind SQL databases where present in the Server Explorer drop down window. I seleced the connect to database Icon and in it's Data Link Properties I entered JOHN for server name pubs for selected database on the server with Provider as MS OLEDB for SQL Service the Icon changed to connected.
I entered this in the code for page_load
Dim MyDS As New DataSet Dim ConnStr As String Dim SQL As String ConnStr = "server=(local)C:Program FilesMicrosoft SQL ServerMSSQLData;database=pubs;Trusted_Connection=yes"
SQL = "SELECT * FROM Titles " & _ "SELECT * FROM Publishers" Dim MySqlConn As New SqlConnection(ConnStr) Dim MySqlAdapter As New SqlDataAdapter(SQL, ConnStr)
'The SqlDataAdapter will automatically open and 'close the SqlConnection MySqlAdapter.Fill(MyDS)
But I can not get this to work it errors out on line:
and get this error: [SqlException (0x80131904): Shared Memory Provider: The system cannot find the file specified. ] System.Data.ProviderBase.DbConnectionPool.GetConnection(Object owningObject) +317
I've tried so many combination with and without user and password, I just don't get it, spent three long days stuck here, can someone help me out.
Note: C:Program FilesMicrosoft SQL ServerMSSQLData Is the accual location on my machine that pubs database is located.
I can use the pubs SQL database in Web Matrix OK. Thanks pdqjohnny@hotmail.com
The connection string I'm currently using for SQL Server is Provider=SQLOLEDB;Server=SERVERVSDOTNET;Database= CCDDbase;Integrated Security=SSPI
would this be the same query string for MSDE database? I'm quite new in MSDE but I know that except for the tools that comes with SQL Server and its size, they are practically the same...
I installed a MSDE on a Windows XP SP2 and configured it for accepting remote connections. But It shows the "SQL Server doesnot exist or connection denied" message whenever I try to connect to this server. For more information I am adding more facts
* It is an MSDE and not a WMSDE * Firewall is turned off * Server process is listening on 0.0.0.0:1433 * TCP/IP and Named Pipes are enabled using server network utility * LoginMode=2 is set for mixed mode authentication in the registry * Tried restaring the Process and even windows after the changes.
I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.
Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.
Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.
i have msde 2000 running on a server i am able to create an odbc connection to my db on that pc. when i try to create anpther odbc connection on another pc on that network i get the following error:
sql state '01000' server error 2 [microsoft][odbc sql server driver][named pipes] connectionopen (connect()). connection failed sql state '08001' server error 17 [microsoft][odbc sql server driver][named pipes]server does not exist or access denied.
what do i have to do to get this odbc connection on this pc working?
I have just done an in-place upgrade from MSDE to SQL Express with Advance Services for my customer. After upgrading, the program was not enable to connect to SQL Express and threw an error (the program connect to the server through OLEDB provider)
Code -2147217843 (80040e4d) - IDispatch error #3149 - Source : Microsoft OLE DB Provider for SQL Server
It only works if I replace the string "Provider=SQLOLEDB.1" with "Provider=SQLNCLI.1". I wonder why I have to do that because in my working PC and other customers, I don't get this.
The customer's PC use Windows 2003 Server for Small Business Server SP1
1. .NET Framework Version 1.1 Redistributable 2. .NET Framework Version 1.1 Software Development Kit (SDK) 3. MSDE 2000 Rel A
In the command window I changed to the directory where MSDE 2000 Rel A was installed and typed in this:
setup.exe INSTANCENAME=MyDb DISABLENETWORKPROTOCOLS=1 SAPWD=<My SA PASSWORD>
MSDE installed successfully and the little icon appeared in the system tray, next to the clock. However, there was no little green arrow/triangle showing on the icon to show connection status as Connected.
4. ASP.NET Commerce Starter Kit
During the Starter Kit install a Connect to Database window opened - Connect to SQL or MSDE.
In the 'Server' field the following was automatically displayed:
STEVE-HOME/MyDb
Where STEVE-HOME is the name of my computer (changed from 'localhost') and MyDb is the instance name.
Thw 'Windows Authentication' radio button was selected by default. I left this unchanged, then clicked OK.
A window opened asking to test the connection. I clicked OK and the connection was successful.
(I didn't select the SQL Server authentication or enter a username, password or select a Database.)
The Starter Kit installed successfully and works fine. However, the SQL Server Service Manager icon states it is not connected when I mouse over it.
I opened the SQL Server Service Manager window and the Server and Services fields are blank.
Surely the Starter Kit wouldn't work if MSDE wasn't connected.
Can anyone advise on how to get the icon to show it is connected
I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which I have heard works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.
Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get the following error:
Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
Of course, some of the entries will be read only, since doctors have to sign off the charts and are not allowed to subsequently change them. But I should still be able to switch over to sql 2005?!?!?!?
Or... is there a way to attach the databases to SQLExpress manually?
Hi all,Here is my situation.I have an application that uses SQL 2000. The client has a programthat uses MSDE. The client MUST have the MSDE version of the Database.What I have done is to create a SQL 2000 Database that is exactly likethe MSDE version. What I wish to do, is at regularly scheduledintervals, update the SQL 2000 Data with the newest MSDE Data.On my clients server, they have both MSDE and SQL 2000 installedthe msde has a user name and password to access it, whereas the SQL2000 uses authenticated mode to access it.What I'm trying to do is to write a bunch of SQL Queries, that I canrun that will copy over the new Data, but I'm having problems accessingthe msde database in query analyzer from the SQL DatabaseCan anyone give me hints on the best way to try thisThanksScott
I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which the company says works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.
Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get an error:
Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
Or... is there a way to attach the databases to SQLExpress manually?
Downloaded and installed MSDE and just finished creating a website using the Community Starter Kit. I'm used to working with Access Databases and this is my first experience with anything SQL. Can someone provide my with some guidance as to what I need to do to upload the MSDE Database to a server. Can I just upload the files like an Access Database or is this more involved. Thanks for you help.
I'm using Visual Studio.Net enviroment, i have SQL desktop Engine installed and everything is working great. I have a problem that whenever i create a new database connections i can NOT delete it. I know that i have to select the node containing the connection and then press the DEL Key, but it seems that the delete option is not valid!
Hi, I am new to .net, I installed .net sdk and framework. now I downloaded MSDE and installed it, I got this directory : C:MSDERelA but when I double click in the setup file nothing happened, please help me on what should I do . thanks
I'm running Windows 2003 .NET server (1 year trial) and I have the latest version of MSDE installed. I have WebMatriX II installed. I want to create an MSDE database I can use with a DSN so can use in .ASP or APS.NET. I've successfully created a test database (in Webmatrix II) via Windows Authentication security and have created a DSN via ODBC/Windows Authentication security but don't know how to access in ASP or ASP.NET web page. All the SQL databases I use in .ASP have a DSN, User, Password as connection parameters. I want to continue this process. I ran the command list: setup SAPWD=**secret** SecurityMode=SQL after setting up MSDE SP3. I log into the server as "Administrator" with a password. Question: 1. What am I supposed to use as a ID and Pass if I want to setup a MSDE database in WebMatrix II using SQL Server authentication? Everything I try fails. I was never asked to provide a beginning ID and Pass for SQL(MSDE) Server. 2. What does the connection string look like to access the database in ASP.NET for Windows Authentication security? Like this: ConnectionString= "server='localhost'; trusted_connection=true; database='ichapter_test'". 3. What would it look like in .ASP? Thanks in advance! JurekWorks
HiI am just starting my first .NET project using the web matrix and an MSDE database. I am pretty much at the limit of my knowledge - all very interesting. I have some data in an Access spreadsheet (6 columns and 365 rows) which in the past I have copied and pasted into an Access database table. How do I get it into a MSDE database table? This process does not need to be automated/programmed as I will only have to do it once a year. Any ideas on the easiest way forward would be much appreciated.Thanks in advance.Mike
I'm trying to build a record update form and I'm going off the "Build Your Own ASP.NET Website" book. I'm not getting any compilation errors; the database just doesn't update.
I have installed the MSDE from Office 2002 CD and MSDE is running. I can see the SQL Server Icon in tray with green arrow. CAn ne body help me how to create database in the MSDE. I am new to this. Is there any query manager or entrprise tool by which I can create database and table in it. Also I am not able ro install the Starter Kit .Please help me in this.
I have MSDE installed on my machine to support off-line use of a web application.
The database (MDF) file in question is stored on an encrypted area of my hard drive, which must be unlocked each time the machine starts up by the user entering a password.
Unfortunately, by this time the SQL Server service has already started, and although it still lists the database along with master, etc, it cannot access it. I believe the error mentions that some files are unavailable.
Stopping and restarting SQL Server using Service Manager fixes this problem. However, this can only be done when logged in as Administrator. I need to find a solution for normal users without Admin privileges.
Is there any other way of making the now-unlocked MDF file available to SQL Server? I thought about using SQLDMO to Refresh databases, but no joy.
This is a real show stopper for my application, which I've spent three years developing! It goes without saying that I'm writing this message with a long face. If anybody has any suggestions I would be very happy to hear from you!
I installed MSDE on a pc with no problems, but now I realise I want to create another instance and set DISABLENETWORKPROTOCOLS=1 so I can use Enterprise Manager over the network from another PC.
If I create another instance of MSDE on the PC, can I remove / uninstall the first instance?
Is it any big deal if I leave the first instance?
and last but not least...
If I create a new instance will it see the database I created on the first instance?
told you so...
Can anyone recomend some good literature to explain about instances please :D
We can install the enterprise manager, but cant get the maintenance plans to work. (fields stay empty and setting dont get saved) I've searched a bit, but couldn't fix it.
No problem, i created a job, with 12 T-SQL commands, and the backups are working perfect.
Now we wanne backup with a history (we take a backup every 4 hours of the day), because now they always get overwritten.
So im trying to change my transactSQL to create dynamic files.
The code i'm using right now :
BACKUP DATABASE PW0001A00 TO DISK = 'C:SQLBACKUPPW0001A00.BAK' WITH INIT, NOUNLOAD, NOSKIP, STATS=10, NOFORMAT
I've tried different things like
BACKUP DATABASE PW0001A00 TO DISK = 'C:SQLBACKUPPW0001A00' + DATEPART(month, GETDATE()) + '.BAK' WITH INIT, NOUNLOAD, NOSKIP, STATS=10, NOFORMAT
but nothing worked.
so basically I wanne be able to create dynamic filenames in the above command.
I have installed MSDE into my system, in which SQL Server is not installed. I have followed the installation instructions and installed MSDE. How can i connect to the database? I have the .MDF file of the database (already created in sqlserver) in the Data Folder. How can i connect to the database from Visual Basic 6?
I have a vb application that uses sql server database , I want to move from sql server to msde file , wanna be able to attach msde file with vb app ,and run setup program It looks like there is not much good info how to start with it can anyone guide me ? Thanks
