I restored a DB to another server and then i used the stored procedures
exec sp_addlogin on the master DB and the exec sp_change_users_login on the DB that I have restored. When i try to run a sproc I am getting
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.
I have used windows authentication to login to connect to the server using sql management studio
Am i missing something. Thankyou for the help
hi,
My requirement is as follows:
1. I Dump my Database into a dump device
2. I Rebuild my mater Database
3. I Restore my User Database.
4. At the end of the above exercise I find my relationship between sysusers (User Database) and syslogins (master) is totally screwed up. This has been causing logon problems to my User Database…
5. I tried using sp_change_users_login …but it does not seem to work.
Thanking you in advance for your help rendered
Hallo
I have a bit of a problem I haven't come across before. I was testing some restore code using smo, when the restore process got corrupted. Now I cannot log into that database file. Whenever I try and connect to it, I get a login error. Connections to this database file previoulsy worked very well.
I do not get login errors for databases with different names, or when using the same database file on another computer. There must be some data stored somewhere that is causing this. I have removed the database file and reloaded it, but to no avail. Any insight into this would be appreciated
HelloI have just completed the first part of my first intranet project, using MS Access. Next step is to transfer it to SQL Server 2000 on a Windows 2003 Server.The ASP.NET code resides on an XP workstation.I get this error: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.".The connection string:Dim DbConn As New SQLConnection("Server=RDDSRV1; DataBase=Serialnrs; Integrated Security=SSPI").I have also tried the same string, with user id and password for a domain adminstrator. No difference.The database has Windows security with among others ASPNET as user (login?)I have searched throu the my own litterature and this Forum, but can´t find any answer to my problems.Hope I can get a quick anwer.Rolf Dahlström
View 2 Replies View RelatedHi,
I have a SQL Server 2005 Database that I would like to export to SQL Server Express.
How do I go about this?
I've tried backing it up, creating a new (blank) SQL Server Express Database and trying to restore it, but get the following message
------------------------------
Restore failed for Server 'PRODSOL-LAPTOP1SQLEXPRESS'. (Microsoft.SqlServer.Smo).
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'test' database. (Microsoft.SqlServer.Smo)
please help
Regrds
T.Anantha Krishnan
I have a stored procedure that retrieves data via a linked server that is running on a local instance of SQL Express 2005. This has been working without problems for some time.
We are now trying to move the database with the links to either SQL Express 2005 running on a server, or an instance of SQL Server 2005. In both cases I can successfully link the servers but when the stored procedure executes it fails on the select statement from the linked server with the following message:
OLE DB provider "SQLNCLI" for linked server "mosier" returned message "Communication link failure".
Msg 10054, Level 16, State 1, Line 0
TCP Provider: An existing connection was forcibly closed by the remote host.
Msg 18452, Level 14, State 1, Line 0
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Why is the user name null? I've tried explicitly setting login information by running the sp_addlinkedsrvlogin procedure but get the same results. In all cases logins should be using windows authentication and all the servers are inside the corporate firewalls.
I presume there is some property somewhere that is different between the SQL instances that work and the ones that don't but I haven't been able to find anything.
I am using and learning Visual Basic 2005 Express edtion
I have created a project and wriiten/adapted code, as below, to connect to sql server 2005 express edition, that works well.
=============================================================
Dim ConnectionString As String = "Integrated Security=SSPI;" + "Initial Catalog=JIMDbase2;" + "Data Source=.SQLEXPRESS;"
conn = New SqlConnection(ConnectionString)
' Open the connection
If conn.State <> ConnectionState.Open Then
Try
conn.Open()
Catch ae As SqlException
MsgBox(ae.Message.ToString())
End Try
End If
=============================================================
Later and in the same Project, via Database explorer I 'Add connection' to the same sql database to review tables etc.
After this when I run the same code, as above, I get an error that the database is in use
If I then 'Close Connection' or even Delete the connection via Database explorer I receive the error
"Cannot open Database, "JimDbase2" requested by the login. The login failed.
Login failed for User "..".
Can anyone help on this matter?
Thanks and regards,
Jim
Hi Everyone,
We have an Analysis Services database which has 9 cubes. Whenever I do an Archive/Restore it fails giving the following error:
* Unexpected error encountered while updating repository item cannot be found in the collection corresponding to the requested name or ordinal.
* Restoration Cancelled
* DSO function failed
Please advise.
Regards,
Kalyan
We used Named Pipes network library when running SQL Server 2000. The firewall and ip address on the box were changed and reconfigured. We rebooted the server. We cannot start the SQL Server now.
Any suggestions?
Thank you very much,
Nastya
I am using an unattended install script to install the database on the client machine. All the settings look correct. But my application cannot access the db -
Error: Cannot open database requested by the login.
Now when I install SQL Server Express manually, it works fine. I have the service running under local system and enabled user instances is true. I cannot figure out the problem(been working on it for 2 days).
Any ideas?
I'm trying to figure out why this SQL Agent job keeps failing.
We used management studio, and connected as mydomainmyuser, and developed a script to take a backup file from a network share and restore it. It worked fine in SSMS under that login.
After we got it working , we created a SQL Agent job on the same server to run the script, and set the agent job to run under that account that we tested with.
This is the error message we got:
"Executed as user: mydomainmyuser. Create Database permission denied in database master'.
So, I gave that login the rights to Create Database and Create Any Database. Then the error message changed to:
"Executed as user: mydomainmyuser. User does not have permission to RESTORE database 'mydatabase'. [SQLSTATE 42000][ERROR 3013] RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed. "
* I can't use SA for the job account, because the SA account doesn't have rights to see the network folder where the backup file sits, so it has to run under the domain account.
* The user is a member of the dbcreator role - and the serveradmin and sysadmin roles
* The user is a member of dbowner on the database I am trying to overwrite with the restore
* I have given the user the rights CREATE DATABASE and CREATE ANY DATABASE
The only suspicious thing I found was that it appears the server was renamed at one time. When I looked at the login in management studio, I was not able to change some of the rights. On the Securables page, it shows the server name as "MyServer-New", but the server name is "MyServer". It is a replacement, and I suspect that when they did the replacement they named it "MyServer-New", set everything up, then renamed it.
I found this post listed below, and ran the script (shown below), and it showed that the server name was MyServer and the ServerInstanceName is MyServer-New
[URL] .....
SELECT HOST_NAME() AS 'host_name()',
@@servername AS 'ServerNameInstanceName',
SERVERPROPERTY('servername') AS 'ServerName',
SERVERPROPERTY('machinename') AS 'Windows_Name',
SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS 'NetBIOS_Name',
SERVERPROPERTY('instanceName') AS 'InstanceName',
SERVERPROPERTY('IsClustered') AS 'IsClustered'
I can't reset SQL until the next maintenance window to test changing the server name as outlined in the post.
Am I on the right track with the name change messing up permissions, or is there something else I need to check?
We have see login failures for windows accounts. Below is the error message.
Description: In our env most logins are windows accounts. Initially we thought it is an UAC issue and we tried to launch the SSMS using "Run as Administrator". However, we are seeing login failures.
Enviroment:
Microsoft SQL Server 2014 - 12.0.2402.0 (X64)
RTM Enterprise Edition (HyperVisor)
Error Message in Error Log :
2015-08-10 22:36:45.290 Logon Error: 18456, Severity: 14, State: 11.
2015-08-10 22:36:45.290 Logon Login failed for user 'domainloginname'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 10.xxx.xxx.xxx]
[code]....
We tried dropping this account and re-creating the windows account with same permissions but still result is same. It throws same error message. Login failure message !!!
Hi All,
My application uses "crystal reports" control to integrate some reports that can be viewed from within the application.
I'm getting a login failed (due to bad password SQL State 8) error when I bring up the report from within the application. The report runs fine outside the application with the same username password.
- I've checked several times to make sure that I'm passing the correct username/password from the application.
- All letters in the password are lower case. There is not case-sensitive issue.
- I printed the username and password on a pop-up to see what values are passed , and they are correct.
- A single test page that uses the same version of "Crystal Reports" control , using the same username/password, brings up the same report works fine.
I guess , my question is:
Is there a way to trace the login failure event on the SQL Server side to see what is the value of the password that is being sent by crystal reports control?
I'm using Crystal Reports XI with sp2.
SQL Server 2005.
I appreciate the help.
Thanks,
Satish
Hi
I am new to SQL server and I have been trying hard to make a client computer to remote connect to a SQL express database on host computer
I have a VB6 application that can connect to SQL server database LOCALLY without problem:
Connection String is:
my_connection.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyMushroom;Data Source=LAPTOPSQLEXPRESS"
I have followed instruction on enabling remote connection function from this blog:
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
I then try to run the same app from the client computer, it gives me:
Login failed for user 'LAPTOPGuest'.
After looking up the web for solution, I found that I can test the connection from the HOST computer in this way:
C:Documents and Settingskit>sqlcmd -E -S laptopsqlexpress
1>
2>
The test is successful
Now I run the same command on the CLIENT computer
C:Documents and SettingsKit>sqlcmd -E -S laptopsqlexpress
Msg 18456, Level 14, State 1, Server LAPTOPSQLEXPRESS, Line 1
Login failed for user 'LAPTOPGuest'.
Now I can sure that from the client computer it cannot make a connection to it, then I look at the errorLog from my host computer
2006-08-13 21:41:00.34 Logon Error: 18456, Severity: 14, State: 11.
2006-08-13 21:41:00.34 Logon Login failed for user 'LAPTOPGuest'. [CLIENT: 192.168.0.5]
2006-08-13 21:45:10.64 Logon Error: 18456, Severity: 14, State: 11.
2006-08-13 21:45:10.64 Logon Login failed for user 'LAPTOPGuest'. [CLIENT: 192.168.0.5]
2006-08-13 21:48:41.80 Logon Error: 18456, Severity: 14, State: 11.
2006-08-13 21:48:41.80 Logon Login failed for user 'LAPTOPGuest'. [CLIENT: 192.168.0.5]
Now I know it is actually Error: 18456, Severity: 14, State: 11.
From this site : http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx
11 and 12
Valid login but server access failure
It tells the connection string and SQL Express seem to be set up properly but the server access failed the remote connection
I have previously had SQL Server 2000 installed. I uninstalled SQL 2000 before I install SQL express but somehow the SQL Server Service Manager is still running at startup, and C:Program FilesMicrosoft SQL Server80 and its files are still exist after uninstallation..... Could this be a problem?
The Knowledge base suggestion on "enabling remote connection" is very simple and I do not understand why it is so difficult to me just to make a remote connection test work..... please, I need your help.
Recently, one of my clients began receiving this error. My team gave them sysadmin permissions, but this is terrible practice. I have read into disablying simple file sharing, but I don't even think I have the option to do it. I look in mycomputer > tools > view and don't see any option for this. Besides, the problem just started occuring recently, within the last week. The server is a cluster with veritas clustering and the edition is sql server 2000. Has anybody ever had a problem like this and have a good fix?
Thanks for any help in advance...
-Kyle
I have an sql server DB which I populate on a local machine, using enterprise manager I backup the DB and zip it up and upload it to my server where I restore it. Every time I restore it I have to add a new login, which is rather annoying, and it wont let me delete the old login - so I have a list of redundent logins.
View 1 Replies View RelatedTry to restore a disk backup from serverA to serverB, get following error:
Server: Msg 3242, Level 16, State 2, Line 1
The file on device 'backup_ABC_Database' is not a valid Microsoft Tape Format backup set.
But there is no Tape Format at all,
attached is the return info of this backup file
Restore headeronly from backup_ABC_database
-----------------------------------
the database is in "Loading" status with gray shadow....
-D
I am new to asp.net 2.0, although I have some experience with asp.net 1.1. In my new machine I have VS 2005, SQL Server 2000 and Sql Server 2005 installed. I wanted to connect to a database in SqlServer 2000 from a simple asp.net 2.0 project. I used the following connection string:
string strConn = "Data Source=xyz/abc;Initial Catalog=dbname;UID=abc;PWD=efg;";
xyz/abc is the name displyed in the enterprise manager, under SQLServer Group. When I run the app, I am getting the following 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)
The error indicates that it is trying to connect to SQL Server 2005, although my xyz/abc is a SqlServer 2000 instance. Not sure how to force the connection to the SqlServer 2000 database.
Thanks
Hello Everyone and thanks for your help in advance. I have set up a new installation of SQL Server 2005 and VS 2005. I am trying to get some web applications up and working, but am experiencing problems with the database connection. I am tring to use the the sa account to connect, but am receiving the error "Login for user 'sa' failed. Not associated with at trusted account...". I am familiar with this error and have made sure that the SQL Server is using SQL Server and Windows Authentication Mode. The connection string I am passing to it is:
server=(local);uid=sa;pwd=password;database=Northwind
which I believe is correct. So I'm confused as to what the problem is. Any help on this topic would be greatly appreciated. Thanks.
Hi
I am running sql server 7, since friday my users are not unable to access their database on the server. NT group authentication is the mode of accessing the data on the server, the temporary soluton I have found so far is to create individual login. Which means creating login for every user on the network. NT4 Group membership that has always worked no longer functions.
Please help.
Hi experts,
my server was having windows as well as sql login authentication. Once i checked the deny access for BUILTAdministrators . . I'am unable to login as
SA and also I'am also unable to change that check as well. . .any solutions
in this regard will be appreciated
Hello , this is my first posting in this group.I am running SQL server 2000 on my windows 2000 server box. I use itfor my Siebel database.When ever I launch Query Analyzer and chose SQL Server AuthenticationI get the error message below:[Microsoft][ODBC SQL Server driver][SQL Server]Login failure "SA" Not associated with a trusted SQL serverconnection.The funny thing is that if I use Windows Authentication the loginworks.I checked Enterprise Manager and the SA account is present.Any help appreciated .SQL newbieThanks.
View 3 Replies View RelatedThere have been other similar posts, but this is my issue: I have set up database mirroring with a witness, and failover works properly. I have also installed the login id's and their original SID's onto the mirror server. When I run a Reporting Services report against the primary database, it runs properly. When I failover to the mirror server and run the report again, I get a "login failed for user" error. As I have already said, the SQL login that the Reporting Services report uses was installed on the mirror server with the original SID. Any ideas as to what else might be wrong?
View 2 Replies View RelatedI have the default instance of sql server (2005 express) installed on my machine. I can log on with no problems using the windows authentication but I had to create a new login account with a username and password.
I have added the new user using the Management Studio under the Security>Logins folder. I have assigned this new user has a server role of sysadmin and I have mapped the user as the db_owner of each current database on the server (default system db's). When I try to connect to this server (keeping in mind it works fine with the windows account) using sql server Authentication and the new username and password, I get an error that says "Login failed for user 'WblsUser'. The user is not associated with a trusted SQL Server connection. (.Net SqlClient Data Provider)"
There seem to be lots of posts regarding this issue but I was surprised that it should happen when you use the management studio as apposed to a connection string in an application (where the connection string could be typed incorrectly).
I have checked that the protocols for TCP/IP, Named Pipes and Shared Memory are all enabled for both the server and the client.
Anyone got any ideas?
I would like a guest to view some items on the application.
And I recently intalled SQL Server 2000 on my machine. Will integrate Access when ready.
I can access or simply read data from a db if I specify User ID and Password.
Such as....
Dim nwindConn As SqlConnection = New SqlConnection("Data Source=localhost;User Id=sa;Password=xxxxx;Initial Catalog=Northwind;")
Yes, testing first, then adjusting all my code for the SQL instead of Access.
If I leave the id and pw out, it won't read - login failure.
I have read so much on authentication and some posts here, even the one on login failure, but that didn't help.
Keep in mind, just installed, only users are the default ones by the installation.
What setting in the SQL Server is there, and I have looked, that if it's a guest, no id or pw, allow read only to items such as datagrids which only read from tables?
Thanks all,
Zath
I have several dts packages that run just fine through a third party scheduler. I then put a mail task on them to tell me if the package succeeded or failed. Every time the scheduler gets to the mail task it fails and logs a mapi login failure error. When I execute the dts package on my local box it sends the email with no problems. is it a problem with the robot login or is it associated to the profile? any help would be greatly appreciated.
Elizabeth
I have a situation where a SQL Maintenance Task is running, and suppose to email a report to the sys admin. Currently I am getting a Microsoft SQL-DMO Error 17903, Mapi Login Failure.
I have tested the Outlook 98 application and the profile is set correctly. I have tried to send an email within SQL and I receive the error above. I have carried all activities suggested by Microsofts Online Books. Can anyone suggest where to go from here. All Service Packs have been applied.
Thanks
Chris Le ROY
Platform SQL Server 7 on NT
I'm getting the following error message from a scheduled job that mails results.
Emailing error log to Personnel [SQLSTATE 01000] (Message 0) MAPI login failure. [SQLSTATE 42000] (Error 17903).
If I stop and start SQLAgent and SQMail the job works fine.
SQLAgent and SQLMail are running under a valid domain account. When I test the MAPI profile(via Enterprise manager) in SQLAgent and SQLMail I get no errors.
I have checked the event log and the SQL error log and have found no errors.
Does anyone have any ideas??
Hi everybody, good morning !!!
Im trying to open a database mounted in SQL Server Express from a code-behind file with the following connection string:
"Data Source=localhostsqlexpress;Initial Catalog=DB_Name;Integrated Security=True"
But I receive the following error: Cannot open database 'DB_Name'. Login failure. Login failure for user 'machine_nameASPNET'
I'd really appreciate any help, suggestion or comment.
Thanks a lot in advance.
Over the weekend, I attempted to move six databases from an older server to a newer one. I have installed SQL 6.5 on both with identical configurations. After migrating the data, bringing down the old server, renaming the new server and configuring the ip address, I ran into a problem. Two applications that access databases on the server were unable to login using any id other than the system administrator id. Each of these applications have been tested on a test server with the same configuration as the new and old production servers. Each installation is on an NT server with SP6 and each SQL install is using SP4. One of the applications gives an OLE DB error. Any suggestions would be appreciated. Thanks in advance.
View 1 Replies View RelatedI am not able to login to the SSMS, while I am logging I got this error, how to troubleshoot..
Cannot connect to LAASYA.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
[URL]
------------------------------
The system cannot find the file specified
------------------------------
BUTTONS:
OK
------------------------------
Hello,
I have encountered a problem with my data source connection. I have a data souce that uses a SQL Login to access a remote server. When I test the connection in the Data Source Designer all works fine. Even when I add the data source as a new data connection in my SSIS package an use it in a OLE DB Source component it works fine, in the preview window.
But when I try to run the package in debug mode i get the following error message,
SSIS package "rXolapform.dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Error: 0xC0202009 at rXolapform, Connection manager "Frango_A_Source": SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "TCP Provider: An existing connection was forcibly closed by the remote host.
".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'sa'.".
Error: 0xC020801C at Data Flow Task, OLE DB Source 1 [1675]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Frango_A_Source" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error: 0xC0047017 at Data Flow Task, DTS.Pipeline: component "OLE DB Source 1" (1675) failed validation and returned error code 0xC020801C.
Error: 0xC004700C at Data Flow Task, DTS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
SSIS package "rXolapform.dtsx" finished: Failure.
The program '[4316] rXolapform.dtsx: DTS' has exited with code 0 (0x0).
Does anyone have any idea of what it could be?
Thanks in advance!
/P
I have a 2000 / 2005 side-by-side installation on our test server.
To login to 2005 with SSMS, the connect string is
hostname/SQL2005, 1434
There's a WiFi network connecting my client PC to the network.
SSMS fails to login frequently. I need to exit SSMS, then login again. It'll work.
A new problem today - after successful login, I can't open a project and login successfully. Error messages states "Failed to Login".
Any tips?
Sam