My question is, is it possible to connect to an SQL database using the MSDE 2000 SP3a edition over the internet? And if so, how do I set it up? Thank you in advance.
3 of 100 MSDE servers' sql agent stop working with 'sqlAgent servise has marked as deleted'.
1. is there a way to fix this service could not start issue? 2. probably not. before moving all DBs to a new MSDE server, I run scripts on daily via isql to these 3 MSDE to run the daily backup and dbcc jobs. The problem is I could forget to run.
I tried to run following: backup database remote1.db1 to Backup_db1 with init so that I could run a job from my server on scheduling time. but it did not work. Any idea to turn manual process to semi-weapon? thanks -D
I've been using NT authentication to access my MSDE without any problem, but when I try to login using an account with SQL Server username and password it returns
"Login failed for user 'testuser'. Reason: Not associated with a trusted SQL Server Connection."
I tried with Visual Studio, Query Analyzer and ODBC, they all return the same error.
Is this a limitation of MSDE or are there configurations that I'm not aware of?
Hi all,I have the the problem with logging to MSDE using SQL-DMO interface. On theW2K with LoginSecure=TRUE everything is OK (connect is made without anyparameters)But when LoginSecure=FALSE (on Win 98)connect( 'instance_name', 'sa', 'sa_password' )then it returns error message :Login failed for user 'sa'. Reason : Not associated with a trusted SQLI install MSDE on Win 98 with parameters :INSTANCENAME='instance_name'SECURITYMODE=SQLSAPWD='sa_password'Server runs with given instance name.Who knows why I can not login to MSDE ?TIA,Marek Powichrowski
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?
I have 2 pcs connected each other and one has the MSDE installed, i would like to access PC1 MSDE instance remotly is this possible or MSDE couldn't be used in network environment and just locally?
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.
After installing MSDE 2000 in mixed mode local access worked fine. Accessing through network with enterprice manager at first didn't work. Fixed by activating network protocols "TCP/IP" and "Named pipes" in database properties. But only the first time. After that login by SQL user and password is denied after restart local MSDE machine.
Hi all,I have bought Visual C# .NET 2003 Standard and downloaded the MSDE to usewith it.I did install it with it's default options and now i'd like to administer itwith Web Data Administrator but it keeps telling me that i should enable SQLServer Authentication.So i tried debugging the question creating an .udl file and trying to testvarious authentication methods:- Integrated Windows authentication works fine- SQL Server authentication (when i try logging in using user 'sa' with thepassword i've set keeps telling me that user 'sa' is not associated with atrusted SQL Server connection.How do i solve this puzzle? Tried googling (and reading some faqs) butdidn't come up with anything useful.Unfortunately the Web Data Administrator doesn't allow using integrated NTauthentication. :-(Thank You,Lorenzo
I just want to find out what the difference between a remote login and a remote query is. I'd have thought that a remote query inherently requires a remote login.
We just installed an application, WhatsUpGold, to monitor our servers. Management won't let me host that on my primary SQL box. So, we are using MSDE on the local machine (call that box my_netmon).
I can access the db with very basic functionality using osql while on the my_netmon machine. I've added my domain user account as a System Admin using the following commands.
exec sp_grantlogin @name go
exec sp_addsrvrolemember @name, 'sysadmin'
But when I go to the my_sql machine and try to attach to it with Enterprise Manager I get an error that the server does not exist.
What gives??? Is it just not possible, or am I missing something here?
My goal is to just be able to see the data stored in the MSDE db. Write views, etc...
I've searched all over the web trying to find a goddamn fix for this problem and no one has it right or they have the commands misspelled (!!!), so in spite of all those idiots, in spite of the makers of the Web Matrix guided tour for not pointing out this problem, and in spite of Microsoft who has not posted a solution themselves, here it goes:
* !! Change MYCOMPUTER below to the appropriate name of your computer !! * Open a command prompt * Type: C: * Type: cd "C:Program FilesMicrosoft SQL Server80ToolsBinn" (or the exact location of the file "osql.exe" if different) * Copy/paste the following commands
I have a installation of MSDE MSQLSERVER on my machine, in this server i run a local database. The problem began when I uninstalled the msde sqlserver and reinstalled it. The program tha uses the database not are connecting, they prompt: "login failed"
I have messed around with some remote login stuff and really screwed things up, now all of my jobs that execute prcedures on the remote server all fail saying the login failed for user 'sa'.
I need to get this working again and could really do with some help.
Hi, I have installed SQL Server 2005 and Visual Studio 2005 in my machine. I got an error when I tried an example.
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)" .
I have enable TCP/IP protocol in the sql server configuration manager. Services of SQL Server Browser is on. I have kept on one machine and from another i am trying to connect Firewall services - i have added Sql application in the exception I am using Windows XP service pack 2 as OS With Windows authentication and Sql Authentucation I am able to login in the local machine but when I try to login from another machine it gives me above mentioned error Kindly do help me... Can this be doen with Windows XP Service pack 2 or I need to change theOS
I am new to asp.net programing and am trying to put a basic secured login page on out IIS server to test, etc... Using the wbe matrix tool I was able to sucessfully login, and access avrious database tables without a problem, however on the IIS box I receive the following error when i attempt to access pages that use the database.
Login failed for user 'NT AUTHORITYNETWORK SERVICE'. Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
Source Error:
Line 48: Line 49: Dim ds As New DataSet() Line 50: myCommand.Fill(ds) Line 51: Line 52: MasterGrid.DataSource = ds
-------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032
All asp & aspx pages that do not reference a database work fine. I have ready many articles about simialr problems, and it appears that I either need to cerate a aspnet user or add the nt authority as a database user. Can someone point me in the irght direction, and how to get this working?
I got a problem a system administrator can not log on to sql remote server so he can back up the system tables. Hes doing it through active directory, not sure what the problem is. can anyone help please. reason says not associated with a trusted sql connection?
We have a SQL Server 2005. I am able to remote login into the server using my desktop user/password. But when I am unable to login using sa/password. It says , check the username , domain etc.
what chagnes do I have to make so , that I can remote login into the server from my desktop using the SA/password.
Hi, i've ben trying to login remotely to sql server 2005, everything is set up so i can do this however i can only login with the default "sa" user when i try to login with an account i created in Managemen Studio under security folder i get this message "Login failed for user DOMAINuser" why is this? thanks in advance
Hello guys and girls! I need help for this error. Could anyone be so kind to enlighten me on this? Thanks! When i attempted to login to my local page, this occurred:
I'm about googled out on this one. I did find one post that looked almost like mine but the thread was never finished. I'm sure this problem has been solved and I'm just having trouble finding it. Can someone help me?
I'm running sql server 2000 on a small workgroup network of winxp machines.
If sql server machine is the same as webserver machine, my asp.net app works. If sql server and webserver are different, the app fails because of sql server login failure.
I am able to explore the database remotely through server explorer in VStudio2003. However, when I try to access the database with the asp.net application, the login fails. I have tried several connection strings. Authentication on the server is 'mixed', the server runs in the system account, and the password for sa is "" (blank password).
When "machinename" is the same as the machine on which the app is running. both of those connection strings work, and the application runs correctly.
When "machinename" is different (that is, sql server on a different machine from the webserver), depending on the connection string I get either "Login failed for user 'sa'." or "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
Obviously VStudio is using some mechanism to add the remote server to it's list of servers and then to allow me manually to explore the databases on that server. Why am I too stoopid to figure it out?
I am trying to use a confirmed and valid account over a WAN (US to Europe) to register and access a SQL server database. The protocol being used is TCP/IP and it has been confirmed that port 1433 is open.
The data is going through a frame relay line and pining the remote SQL Server does return a valid response. Unfortunately, I am getting the following error:
Error 18456 Severity Level 14 Message Text Login failed for user 'TestUser'.
Explanation You do not have permission to log in to the server.
Action Contact a member of the sysadmin fixed server role to request login permission.
I moved my web and DB to a new server. I am trying to use a private network between my servers to connect to my DB.
I backed up my DB on the old server, copied it to my new server, then restored it.
I then went into Security > Login and set up a User Name & Password and set the db as the default db, made that user the owner, etc.
I went to my web server, changed my connection string to this:
Code:
sConString = "Driver={SQL Server};" & _ "Server=tcp:MYSERVERNAME;" & _ <!-- The server name --> "Address=xxx.xxx.xxx.xxx,1433;" & _ <!-- The Private IP Address between servers --> "Network=DBMSSOCN;" & _ <!-- Telling it to use TCP --> "Database=DBNAME;" & _ <!-- The name of the DB I am connecting to --> "Uid=UNAME;" & _ <!-- The user name to login with --> "Pwd=UPWD;" <!-- The Users Password -->
(Obviously I changed the critical info above, but this is the format I used)
I cannot seem to login to the DB. I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'UNAME'.
/(file path), line 5
I have read the following article and it appears I have everything right. http://support.microsoft.com/?scid=kb;en-us;827422&spid=2852&sid=332
Somehow I cannot seem to connect/login to get the proper access. Can anyone help? Anyone see anything I am doing wrong? Anyone have any suggestions?
Thanks for the help in advance. I am trying to get this done tonight so it is running in time for the morning.
I'm very new to this so excuse my naiveity...I have connected my desktop and laptop computer at home, on my desktop I have a series of db's under my default named instance <computername>/sqlexpress and I have created access logins using windows auth. When I connect to the desktop from the laptop using tcp:<computername>sqlexpressuserid I can only see the systemdb's...I am trying to view adventure works, just to see how this remote connection stuff works...any ideas?
I have connected my desktop and laptop computer at home, on my desktop I have a series of db's under my default named instance <computername>/sqlexpress and I have created access logins using windows auth. When I connect to the desktop from the laptop using tcp:<computername>sqlexpressuserid I can only see the system db's...I am trying to view adventure works, which I can see on the desktop fine using the same login...any ideas?
I have 2 xp machines one has the SQL EXPRESS Server with all the goodies on it and the other I just install the client stuff. I am using VB 6 to program with using the ADO. It works great on the server machine. The software pulls up great. I can't seem to get it to work on the client machine. I get "Login failed for user 'TIGGERLGuest'. I found the places to set the TCPIP setings on the server SQL Express to allow this even turned on the browser but nothing same error. I am using the same login on both machines and am pointed to the same workgroup. I used window authentication when I set them up. Not sure why it insists on using Guest.
This is a copy of the connection string I am using
Hi, I have an ASP.Net web application running in groupnamewebservername. I am trying to connect it to the remote database server groupnamedatabaseservername using the ASPNET user id. The remote database is SQL Server 2005 and the web server has IIS 6.0 installed. My web.config connection entry has username as "groupnamewebservernameaspnet" and I have a database user in remote database server under the login name groupnamewebservername$. When I try to connect, I keep getting the following error: System.Data.SqlClient.SqlException: Login failed for user 'groupnamewebservernameaspnet'.
Could you please let me know what I am doing wrong here? Thanks. Regards, Gayathri.
but i am able to login to the same remote sql server through SQL server managment studio express using the details i am using in the connection string in the "test.aspx" page. ERROR:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)When this page is run, i want all the user's UserName and Password to be dispalyed.However, i am getting the above mentioned error.what could be the problem? This is the code i am using in my test.aspx page to connect to "Login" table in my database. 1 Imports System.Data2 Imports System.Data.SqlClient3 4 Private Sub GetAllTheComments()5 6 Dim MyConnection As SqlConnection7 8 Dim MyCommand As SqlDataAdapter9 10 MyConnection = New SqlConnection("server=XXX.X.XXX.X;uid=X;pwd=X;database=X")11 12 MyCommand = New SqlDataAdapter("select UserName, Password from Login", MyConnection)13 14 ds = New DataSet15 16 MyCommand.Fill(ds)17 18 DataList1.DataSource = ds19 20 DataList1.DataBind()21 22 End Sub
