Login Failure For OLE DB Data Connection

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


ADVERTISEMENT

Problems With Connection String, Login Failure

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

DB Engine :: Client Unable To Establish Connection Due To Pre-login Failure

Oct 28, 2015

I unable to setup a linked server on sql server 2012. The destination server is on sql server 7.0. I can able to setup the same linked server on sql 2005 sp4 and sql 2008 r2 but unable to setup on 2012. I am getting the below error message. OLE DB provider "SQLNCLI11" for linked server "" returned message "Client unable to establish connection due to prelogin failure".

View 3 Replies View Related

Sql Connection Failed Because Of Connection Failure Login Failed For User 'SW8/Guest

May 16, 2007

Sir i am trying to connect sql from my LAN to my networked computers but whenever i tried to register it through Enterprise manager i get following "SQL Server registration failed because of the conection failure displayed below.Do you wish to Register anyway? Login failed for user 'SW17/Guest'

where SW17/ is my another computer name...
i have checked tcp and named pipes
and confirm username for sql authentication too
please help me as i being late submit my project

View 3 Replies View Related

Connection Failure - Data Corruption?

Jan 18, 2006

Hi,

Yesterday, one of the computers on the network of our SQL server experienced a connection failure while using two specific jobs in a table containing assignments for jobs. The data interaction occurs from a Data Access Page, and from what I've learned, the nature of a DAP is such that the client not only connects to the web server but actually also establishes a direct connection to the SQL Server (we use a backend of MS SQL Server 2003). The data is still inside the tables, but on the Data Access Page, any data that was opened during the connection failure does not show up anymore from any computer.

My guess is that there was corruption of some sort on another layer beneath the actual data layer that cannot be accessed directly or viewed. To remedy this problem, I am going to try to recreate all affected records and rebuild all table ID ties manually with append and update queries. Does anyone know the actual problem or corruption that occurs during a connection failure? Is there a way to access the affected layer(s) and undo the corruption or remedy the affect so the records can be used? Is the problem with the SQL Data itself or on a layer with MS Access/MS DAP?

This data is very important and needs to be used today and was supposed to be used yesterday. If anyone could help me in this matter or provide a better way to undo the supposed corruption, it would be greatly appreciated :)!

thanks in advance,
mellamokb

PS - I don't know if this makes a difference, but other data has been changed in the same database/tables since the connection failure, so a complete reversion back to the system at that point in time would mean loss of other updated data.

View 4 Replies View Related

Microsoft Data Link Error - Connection Failure

Apr 21, 2008

Hi!

I've a computer with W2K SP4 installed. Previously SQL Express 2005 worked but according to the user it "just stopped working".

When selecting database on the server in the "Data Link Properties"-window he is given the following error message:

"Microsoft Data Link" "Login failed. Catalog information cannot be retrieved"
followed by
"Microsoft Data Link Error" "Connection failure"
Note: He is not given the error message "Server does not exist or access denied!"

- The SQL service is started (can be stopped and restarted without problem)
- I've re-installed SQL Express.
- I've checked and is certain the server name is correct (i.e. computernameSQLEXPRESS)

Any ideas here because I'm getting desperate?

Thanks in advance,

Peter Hartlén

View 7 Replies View Related

SQL 2012 :: SSRS Data Shared Data Source Connection Login

Jan 12, 2015

Was wondering if there was a best practice minimum permissions for creating a SQL login to use when setting up a new shared Data source for SSRS report manager?

Something along the lines of them being a data read for the DB and permissions to update tempdb?

Would have thought it not advisable to have the login be able to update the main db...

View 1 Replies View Related

Login Failure

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

Login Failure

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

Login Failure

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

Login Failure. . .

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

SA Login Failure

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

Login Failure

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

Login Failure

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

Vista Remote Connection Problem - Login Failed For User 'xxxxxxx. (.Net SqlClient Data Provider)

May 26, 2007

trying to connect to sql server 2005 over the internet. (its a third paty hosting company i'm using)

so i have to connect via tcp/ip using sql server authentication.

my laptop is running vista.



the version of sql server 2005 on my laptopis developer edition with service pack 2.

it worked fine from windows xp and the connection details are valid as it runa fine from .net on the hosting website.



i have added sql serer managemnt studio to the exceptions list in the firewall.

ihave made sure tcpip is enabled in the sql server connection management console.

i have also enabled it in the cliconfg tool



firewall on/off seems to make no difference.



its almost enough to make you turn to oracle and thats saying something considering how long i've been in the microsoft camp...



the error returned is:
Login failed for user 'SQL2005_152092_garethbowen'. (.Net SqlClient Data Provider)


------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

------------------------------
Server Name: 'xxxx',1433
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536


View 3 Replies View Related

Login Failed Using SQL Server Login For Assigned Script Componet Connection String

Oct 14, 2007



Hi,

I have a script component. What it does, it queries the a table using a connectionstring assigned to it in the Connection Managers Editor (which is an ado.net adapter). this works fine when i'm using a windows login in the ado.net connection manager. But when i changed my connection to use SQL server login, I encounter this error:



OnError,,,Add new records to Dim_T_Status (Case),,,10/14/2007 5:54:47 PM,10/14/2007 5:54:47 PM,-1073450910,0x,System.Data.SqlClient.SqlException: Login failed for user 'CS_REPORT'.
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper90 wrapper, Int32 inputID, IDTSBuffer90 pDTSBuffer, IntPtr bufferWirePacket)
OnError,,,LOAD AND UPDATE OCEAN Dimension Tables,,,10/14/2007 5:54:47 PM,10/14/2007 5:54:47 PM,-1073450910,0x,System.Data.SqlClient.SqlException: Login failed for user 'CS_REPORT'.
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper90 wrapper, Int32 inputID, IDTSBuffer90 pDTSBuffer, IntPtr bufferWirePacket)
OnError,,,LoadOCEANDimensions,,,10/14/2007 5:54:47 PM,10/14/2007 5:54:47 PM,-1073450910,0x,System.Data.SqlClient.SqlException: Login failed for user 'CS_REPORT'.
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper90 wrapper, Int32 inputID, IDTSBuffer90 pDTSBuffer, IntPtr bufferWirePacket)

How to go about this?

cherriesh

View 3 Replies View Related

Login Failure For Guest

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

Login Failure In SQL Server

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

Login Failure After Restore

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

Dts And Mapi Login Failure

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

MAPI Login Failure

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

SQL Mail Login Failure

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

Login Failure For User MachineASPNET

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

Application Login Failure After SQL 6.5 To 6.5 Migration

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

SQL 2012 :: Login Failure For SSMS

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

Login Failure On A Linked Server

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

SQL Server Express Login Failure

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

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 View Related

Restore SQL Server, Login Failure

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

Server Could Not Start Due To Login Failure - URGENT

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

Maintenance Plan Fails Due To Login Failure

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

Login Failure - May Have Resulted From A Corrupted Restore

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

Strange: Continuous Login Failure Errors

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







Copyrights 2005-15 www.BigResource.com, All rights reserved