SSMS - Intermittent Login Failure
Mar 31, 2006
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
View 1 Replies
ADVERTISEMENT
Jun 24, 2014
I 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
------------------------------
View 6 Replies
View Related
Apr 5, 2006
In an SSB test project created from the T-SQL batch in Stuart Padley's Weblog (subtitled "SQL Server 2005 stuff I couldn't find anywhere else", http://blogs.msdn.com/stuartpa/archive/2005/07/25/443229.aspx) I found strange inconsistencies with enquing messages between two databases on the same SQL Server 2005 Standard Edition SP-1 CTP March instance running under Windows Server 2003 SE SP-1:
Sending a simple message from the Initiator to the Target database with either the SendMessageProc stored procedure or its code as a batch fails for about 50% of all tries, with varying failure patters (up to 10 sequential attempts fail). Messages for failed tries remained in the transmission_queue, but didn't appear in the InitiatorQueue or TargetQueue.
I made the following changes to Stuart's code in the SendMessageProc procedure and my SendInitiatorToTarget.sql messaging script:
1. Split out EXEC SendMessageProc from Stage 4 and all of Stage 5 into a separate batch to enable sending multiple messages without recreating all objects.
2. Changed BEGIN DIALOG to BEGIN DIALOG CONVERSATION
3. Added a missing END CONVERSATION statement
A simple intradatabase service based on the "Hello World" DB Engine sample run in the Northwind or AdventureWorks database behaves as expected.
The partition with SQLS 2005 SP-1 also has SSX SP-1 with Advanced Services installed. Some minor problems occured when installing SSX SP-1, so I removed the original SSX instance and reinstalled SSX SP-1. See http://oakleafblog.blogspot.com/2006/03/sql-server-2005-sp1-ctp-available-for.html.
The same SSMS project runs fine on a fresh install of SQLS 2005 RTM under WS 2003 SP-1 on another machine partition. (This machine isn't running VS.) No messages fail to reach the Target database, as would be expected.
Has anyone else encountered similar anomalous behavior with SSB under SP-1 CTP? This problem ran me nuts for an entire day until I finally gave up and created a new SQLS 2005 RTM test instance.
If anyone (especially Remus) wants a copy of the scrpt, send your e-mail address to roger_jennings(nospam_at)compuserve(nospam_dot)com.
--rj
View 7 Replies
View Related
May 18, 2006
This is very strange...
After installing the Advanced Services package, I started getting errors connecting to a database (.MDF) that I've been using for weeks/months.
The error was something like "login failed for machineuser". After twiddling with the connection string and starting and stopping the SQLEXPRESS service it started working again. Did some more work, everything was fine, shutdown and went to bed.
This morning, I am unable to connect to the database - nor any other database, it seems. This time I'm getting "cannot find the physical file" type errors.
Any leads on solving this would be much appreciated. I've search using the error codes and I'm not turning anything up that seems quite like the problem I'm having.
- porko
View 7 Replies
View Related
Mar 27, 2008
Greetings,
I have a VB 2003 .NET application that I wrote for a customer that connects to a named instance of SQL 2000. Until recently it has been working fine. Lately the program either pops a timeout failure within a few seconds or a general network error. I've increased the connection timeout settings to 90 seconds but the error still pops within a few seconds. I'm thinking something has changed in the environment that prevents a clean connection to the named instance of SQL server.
How should this issue be troubleshoot to determine the problem and what areas need to be looked at?
Thanks
View 3 Replies
View Related
May 25, 2007
I have installed a SQL Server 2005 Standard Edition instance with SSIS on Window Server 2003 x64. From my PC, I am able to connect to the Integration Services on the server using Windows Authentication but not with a local SQL login - and the option to change authentication methods is greyed out.
Is it possible to remotely connect to SSIS using a SQL login rather than a Windows login? If so, any ideas or references for configuring it as such?
Thanks.
- Lance
View 1 Replies
View Related
Jun 9, 2015
we have an application which lets users connect to production database with windows credentials, They are able access the sql tables too with windows login. I want to restrict them from accessing the sql tables. How do I do that.?I tried a db_deny but that prevented them from accessing the application too.
View 10 Replies
View Related
Sep 9, 2015
When I try to connect to "Integration services" in "SSMS" with my window authentication, for some servers can able to connect. But for some server i am getting error like "Access denied".
To fix these Access Denied, as per instruction from google, i have configured the Administrative Tools-->Component Services->Component Services-->Computer-->My Computer-->DCOM Config-> Microsoft SQL Server Integration Services 11.0--> Right
Click-->Properties-->navigate to “Security”--> then adding the Active direcotry login in the "Launch and Activation Permissions", "Access Permissions" and "Configuration Permissions".
Then this issue was fixed. I want to know why this was happening to some servers only, what is the reason behind this.
View 5 Replies
View Related
Mar 21, 2014
I have a windows 2008 with SQL Server 2008 R2 VM on Azure. I am trying to connect to the SQL server for the first time using SSMS, but have not been able it. I have a VPN tunnel, so I am connecting using Windows authentication. The error I get back from SSMS is:
Login failed for user 'domainusername'. (Microsoft SQL Server, Error: 18456).In the event viewer I see this error message: Login failed for user 'domainusername'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]
I have done the following:
- created an endpoint for port 1433
- opened port 1433 in the firewall
- Ran the MSSQLSERVER service as the build-in users Network Services, Local System, and Local Service, and as a local and domain administrator, with the same exact result each time.
- I get the same result trying to connect locally or remotely.
- I get the same result trying to connect using sqlcmd.
View 4 Replies
View Related
Jul 1, 2006
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
View 1 Replies
View Related
Aug 11, 2006
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.
View 2 Replies
View Related
Mar 18, 2002
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.
View 4 Replies
View Related
Jul 10, 2002
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
View 1 Replies
View Related
Jul 20, 2005
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 Related
Jan 16, 2007
There 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 Related
Nov 17, 2006
I 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?
View 1 Replies
View Related
May 11, 2004
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
View 4 Replies
View Related
Nov 22, 2005
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 Related
Jun 26, 2000
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
View 1 Replies
View Related
Jan 8, 2002
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
View 1 Replies
View Related
Jun 1, 1999
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
View 2 Replies
View Related
Nov 20, 2001
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??
View 1 Replies
View Related
Jul 6, 2007
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.
View 9 Replies
View Related
Jan 16, 2001
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 Related
Jan 31, 2008
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.
View 5 Replies
View Related
Aug 13, 2007
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
View 2 Replies
View Related
Nov 21, 2007
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
View 7 Replies
View Related
Oct 12, 2006
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
View 1 Replies
View Related
Jun 6, 2008
I recently moved my web app off of my development machine which hosted the db. Now the db is hosted on a SQL 2005 server and when i try to use the web app there is something wrong with the connection string i get a login failure. there was an account created on the domain called bookservice the domain name is thc. this user was given dbowner privlidges to the BookSchedule db on the CORESQLDEV01 server. Here is my original connection string from my web.config <connectionStrings><add name="BookScheduleConnectionString" connectionString="Data Source=SQLSERVERSQLEXPRESS;Initial Catalog=BookSchedule;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>Here is the new connection string after i moved the db to the SQL server <connectionStrings>
<add name="BookScheduleConnectionString" connectionString="Data Source=CORESQLDEV01;Initial Catalog=BookSchedule;User Id=THCookservice;Password=*********"
providerName="System.Data.SqlClient" />
</connectionStrings> Here is some of the error output from the webapp when it tries to load the pageSqlException (0x80131904): Login failed for user 'THCookservice'.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.GridView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69 System.Web.UI.Control.EnsureChildControls() +87 Any help is greatly appreciated. If more information is needed please let me know
View 5 Replies
View Related
Aug 23, 2001
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
View 1 Replies
View Related
Nov 14, 2007
W2k3SP2 running SQL2k5SP2 in mixed mode. Trying to run a daily maintenance plan with a domain admin service account [domainsqlsvc]. This account is having login failure when I try to run the maintenance job. Would like to figure out why this account cannot authenticate with SQL. I believe I have local login denied, but login as a svc and login as a batch job are both enabled in Domain Policy.
What am I missing?
TIA for your help!
-Nick
EDIT: Here is the error data.
Date 11/14/2007 9:36:16 AM
Log SQL Server (Current - 11/14/2007 9:36:00 AM)
Source Logon
Message
Login failed for user 'domainsqlsvc'. [CLIENT: <local machine>]
Error:18456, Severity: 14, State: 16
View 2 Replies
View Related
Jan 28, 2007
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
View 2 Replies
View Related
Jun 5, 2007
I have SQL 2000 Server that had a database called ABC and it has been moved to another server on 5-15-2007
I kept ABC database in Read_only mode for few days (just in case) on old server and finally dropped it on 5-20-2007 and I think I forgot to drop the associated logins. I started seeing login failure for user 'xyz' in error logs
When I first noticed the login failure error in SQL Server log for login xyz, I deleted xyz login but it did not stop the errors.
I have been trying from then and no luck in identifying the cause/ resolving this issue.
I have ran SQL profiler trace and caught the user hostnames, NTusername in few cases and Application Name and contacted the Application owner & user (who are in the trace) to stop windows service/ schedule jobs..anything that is pointing to old server but the bad luck is they are not aware of anything running or pointing to old server. The worst part is the user whose hostnames are shown in the trace have never used ABC database and do not have any idea.
Here is what I found in the profiler trace:
TextData LoginName NTUserName HostName ApplicationName
Login failed for user 'xyz' xyz AB00007 WAB000007 Microsoft (r) Windows Script Host
Today I have created the xyz login in the server and assigned model database with reader permission to see if log some different error but nothing new (the same login failure error)
Finally, I had no solution other than restoring the ABC database back to my old server and set it in to Read_Only mode to stop these errors and Now I see the login 'xyz' firing the query against the database
* Any hint or pointers why this is happening and any possible solution on this?
View 1 Replies
View Related
