MS SQL Server :: Error 18456 - Cannot Connect

Cannot Connect. Error 18456.

Dec 7, 2007

I finally got SQL Server 2005 installed on my Vista Ultimate computer and now I can't connect in SQL Server Management Studio.

I've got a named instance; use the built-in system account; windows authentication mode. I try to connect to

Server type: Database Engine
Server name: RAYWOERNER-PCRAYWOERNER
Authentication: Windows Authentication

and it fails. Please help.

Thanks,

Ray

Here are the technical details:

===================================
Cannot connect to RAYWOERNER-PCRAYWOERNER.
===================================
Login failed for user 'RayWoerner-PCRay'. (.Net SqlClient Data Provider)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
------------------------------
Server Name: RAYWOERNER-PCRAYWOERNER
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536

------------------------------
Program Location:
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

View 9 Replies View Related

Error 18456 When Trying To Connect To 2005 Using Odbc

Oct 1, 2006

Hi all

I am using Windows XP SP2 with a Sql server 2005 Express installation. I created a test db with a user called test, schema also test. I gave the permission connect, db_datareader and db_datawriter. I can now connect into this user using WinSQL. But if I want to connect using a application which is using ODBC, then I get the error:

[SQLSTATE=28000 - [Microsoft][SQL Native][SQL Server]Login failed for user 'test'.[Native Error=18456]]

Because I connect using ODBC, I think there must be the problem. But I have to connect with ODBC. There is no other possibility.

any ideas ?

Regards, Waff

I found this out:

The server collation is defined to: Latin1_General_CI_AS

If I create a new login id in lowercase, then ODBC will change it to uppercase and then the server refuse the access. But why. CI means case insensitive, so doesn't matter if upper or lower case. should.

How do you use a id in lowercase and connecto via ODBC ?

View 3 Replies View Related

Cannot Connect To Database Engine

Jan 7, 2012

i installed sql server 2005 but cant connect to database engine. i write (computer name)sqlexpress but it failed. error is:

TITLE: Connect to Server
------------------------------
Cannot connect to rezasqlexpress.
------------------------------
ADDITIONAL INFORMATION:

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

View 1 Replies View Related

Cannot Connect To Database Engine

Apr 30, 2008

Hi,

I've just installed a brand new instance of SQL on a new server. It's for our Helpdesk/Inventory software. All I needed to install was the DB Components and the Tools (primarily for Management Studio). I did not install SQL as a default instance, but called it TRACKIT8 (software using this instance). I have subsequently installs SP2 before trying to connect to the DB.

I am unable to conect to the DB Engine via Management Studio. In the Server name: field, there is a blank space, so I try to browse for a server, but I get nothing. I try to manually type the name of the server (NIASSQL2, localhost etc) into the field, but I cannot connect to the engine at all. I can see the services for the Server and Server Agent have started in the SQL Server Configuration Manager and I am able to change certain field in the properties of the Server and Agent (change the path of the error logs).

Is there something I am supposed to configure before I try to connect via the Management Studio? I am looking to change the paths of the Data Files, as I don't want them on my C: partition. Plus I have other instances I want to create and install. Any help would be greatly appreciated.

Cheers.

View 1 Replies View Related

I Cannot Connect To The Database Engine ...

May 4, 2007

I can connect to Analysis Service and Integration Service but I can not connect to the Database Engine. I receive the following error message:

Cannot connect to homebase.

Additional Information:

An error has occurred whlie 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 doesn not allow remote connections. (provider: SQL Network Interfaces, error: 25 - COnnection string is not valid)(Microsoft SQL Server, Error:87)

(Click on OK to continue)

View 4 Replies View Related

Cannot Connect To Database Engine

May 22, 2007

Hi! I have a little problem and I need your help.

I have recently installed SQL Server 2005 Developer Edition. I did not install all the features, just the Database engine and Analysis Services. I also updated everything with SQL Server SP2.

So far, so good. But when I tried to connect to the Database Engine, I get a little window with the following message:

"Cannot connect to Valentin-PC (server name)."

"Login failed for user - User Name - ( Microsoft SQL Server, Error: 18456 )".

I have tried just about everything, but to no avail. What is strange is the fact that I can connect to the other server type that I have installed (Analysis Services). No connection problems there.

Can anyone help?

Mucho gracias!

View 11 Replies View Related

Can't Connect The Database Engine

Sep 21, 2007

I just installed SQL server Enterprise 2005 and connected database engine in SQL server management studio, but it is blank space when choose 'browse for more' at server name field. What's reason to cause this problem?

Questions for this problem:

1. Do I need to open the TCP port 1433 in firewall by hand for connect database engine?

2. I can��t find the sqlbrowser.exe in SQL server/90/ folder, can I copy this file into it.

3. The SQL server mobile is work; I can connect the new created database. What��s different to use SQL server mobile and database engine?

4. I got five discs from Microsoft; I have installed DVD server application and pack 2. Do I need to install the library?

Thanks for any help.

View 7 Replies View Related

DB Engine :: Cannot Connect To Configuration Database

Aug 10, 2015

When trying to open the sharepoint webpage I'm getting this error - cannot connect to the configuration database sharepoint 2010.Database is on SQL server 2008.Tried opening the site on server - got the same error.Googled and tried to start the mssqlserver services (browser and sql server) but they fail to start with error code 17058.

Googled what this error was about and some solutions led me to check the error log in event viewer. For mssqlserver I got following message in the event proverties window - Could not open error log file <path of log file> ''. Operating system error = 5 (access denied).When I tried to login on the sql server management studio, it does not let me login and gives error -

I got to know that this can happen due to unexpected reboot of server. I checked my server and it had actually restarted unexpectedly.URL...

View 13 Replies View Related

Can't Connect To Local Database Engine

Jan 20, 2008

I am trying to run MS SQL Server Management Studio Express. According to what I read, I can connect by selecting Database engine, then on server name, I put my computer name sqlexpress. I am using Windows Authentication. Every time, I get:

TITLE: Connect to Server
------------------------------
Cannot connect to kennethsqlexpress.
------------------------------
ADDITIONAL INFORMATION:
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) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------

What am I doing wrong? Thanks for helping me to stop pulling my hair out.

View 2 Replies View Related

SQL Server 2005 Cannot Connect To Database Engine...!

Sep 24, 2007

Hello
I've just installed 'SQL server 2005' and it installed the components like .Net2.0 and visual studio 2005 . before installing them I had uninstalled sql server2000 . I ran SQL management studio and tried to connect and makin' servers it doesn't allow me to connect or making any new servers...... it gives me this error
Cannot connect to local.
Additional information:
An error has occured while establishing a connection to the server. ......
error:53)

need to solve it....

View 3 Replies View Related

How To Stop The Connect To Database Engine Dialog

Feb 16, 2008

I am working (or trying to work) in Management Studio. I have one database that I use on my one and only machine. ( I am not using any of the default databases.) I have several queries saved as files, which I open as needed. Every time I open a file I get that VERY ANOYING Connect to Database Engine dialog box. OK, it's no big thing. I don't use Server Authentication so all I have to do is hit enter and I get connected. But why should I even have to hit enter once after I'm already connected?

How can I MAKE IT STOP?

Thanks,

Gregory

View 3 Replies View Related

No More Able To Connect To My SQL Server 2005 Database Engine

Mar 12, 2007

Hello,
I have installed SQL Server 2005 in my PC and during the installation I
have created a predefined instance (I have used Windows autentication).
I could use correctly SQL Server till some days ago, when I changed the
password of my PC login profile.
Now, when I open SQL Server, if I click on the "Connect" button,
the following error message appears (I translate it from italian version)

Unable to connect to "CARLO"
Further information:
An error has occurred while you were trying to establish a connection to
the server. When you connect to SQL Server 2005, this error can be generated
because SQL Server doesn't allow remote connections under the predefined
settings. (provider: Provider Named Pipes, error: 40 - Unable to open a
connection to SQL Server) (Micorsoft SQL Server, error:2)

I'm sure that the error raises because I have changed my PC access
password (the program worked correctly before), but in the "Connect to
Server" window the user name and the password text boxes are disabled, so
I can't insert the new password...
Can you suggest what have I to do?

Thank you very much

View 5 Replies View Related

HELP!! Cannot Connect To SQL Server 2005 Developer Database Engine

Oct 19, 2007

OK.

I'm using Microsoft SQL Server 2005 Developer Edition and I installed it under "Local System" on Microsoft Windows Vista Ultimate.

I understand that there are issues of course that occur with this, however I can't seem to understand why what I'm doing isn't working. I'm not using this on any server, just to test out ASP.NET 2.0 applications - nothing more.

I'm getting this error:

TITLE: Connect to Server
------------------------------

Cannot connect to RUSSPC.

------------------------------
ADDITIONAL INFORMATION:

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) (Microsoft SQL Server, Error: 2)

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

------------------------------
BUTTONS:

OK
------------------------------

I've installed this via a mixed authentication (as suggested by www.wrox.com).

I tried enabling the TCP/IP and named pipe connections, just as previous people have done, but it hasn't worked. Nor has enabling the SQL Browser.

I'm really at a loss on what to do.

View 3 Replies View Related

Remeber Password On Connect To Database Engine Dialog

Nov 26, 2007

Is there any description on what the Remember Password check box on this dialog box does? As far as I can tell, it doesn't do anything. Every time I open an item from a project, or create a new Query, I get asked for the password, no matter how many times I have given it for the Server before.

It looks so useful, but is frustrating not knowing how to use it.

Thanks,

-Rob

View 5 Replies View Related

DB Engine :: Error - Failed To Connect To IPC Port - System Cannot Find File Specified

Jun 2, 2008

In Management Studio i highlight my query and then click on 'Analyse query in Database Engine Advisor' but i get the following error message: "Failed to connect to an IPC Port: The system cannot find the file specified". Seems like if I reboot my computer it works one time then get the same error on the second time.I'm running developer edition with service pack 2.

View 8 Replies View Related

SQL 2012 :: Opening Files Result In Connect To Database Engine Prompt?

Feb 24, 2014

When opening .sql files, I get a connect to database engine prompt every single time. how to stop this from prompting vs. just using my current active connection?

View 4 Replies View Related

Unable To Connect To SQL SERVER 2005 Database Engine Using Windows Authentication Under Windows Vista...

Mar 26, 2008

Hallo there,

I just upgraded from Windows XP Pro to Windows Vista Bussiness and tried to reinstall SQL Server 2005 Developers Edition. After the installation i downloaded (using microsoft windows update) and installed all the service packs for sql and vista available.

My problem is when i open sql server management studio and try to connect to my default instance using windows authentication and database engine, an 18456 error occurs.

I enabled all the protocols and all the ports
I disabled windows firewall and antivirus (eset nod32)
I installed all service packs available
I have also installed Visual Studio 2005 without installing sqlexpress

But nothing happens!

Please i am very desperate, any information will be gratefully accepted.

This is my installation Information

Code Snippet

Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.1434
Operating System 6.0.6001

Thank you in advance,
Patonios

View 3 Replies View Related

Database Engine Connection Error.

Mar 6, 2006

I got the sql2005 std edition at the msdn rollout, and the vs2005 studio. I uninstalled sql2000 and now, cannot connect to the database engine.

I get the following error message with a link to an page that offers no info. What's up and how can I get it to work? Please, help.

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) (Microsoft SQL Server, Error: 2)

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

View 3 Replies View Related

Error Connecting To Database Engine

Apr 25, 2006

I have been successfully using SQL Server 2005 developer
edition for a couple of months now. However,
when I started Microsoft SQL Server Management Studio this morning I could not
connect to the ��Database Engine�? (I��m using Windows Authentication). I can still connect with the ��Integration
Services�? and ��Analysis Services�? on the same server. The server running on my local machine, so
there shouldn��t be any problems with the network. I am also able to connect with it through
ODBC, it just seems to be the Server Management Studio which can��t connect, and it only has
problems with the ��Database Engine.�? Any
help would be appreciated.David

The detailed error message says:

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: TCP Provider, error: 0 -
No connection could be made because the target machine actively refused it.)
(.Net SqlClient Data Provider)

------------------------------

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

------------------------------

Error Number: 10061

Severity: 20

State: 0

------------------------------

Program Location:
at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection)

at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)

at
System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner,
Boolean& failoverDemandDone, String host, String failoverPartner, String
protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean
encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection
owningObject, Boolean aliasLookup)

at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)

at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)

at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection, DbConnectionPoolGroup poolGroup)

at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)

at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)

at
System.Data.SqlClient.SqlConnection.Open()

at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo
ci, IServerType server)

at
Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

View 6 Replies View Related

Error 3125 - The Database Engine Can't Find <name>

Mar 20, 2001

I am running SQL 7.0 with Access 97 as a front end. I am having a problem linking one of the tables with an odbc connection. When I try to link the table, it gives me the error :

"The database engine can't find <name of table>. Make sure it is a valid parameter or alias name, that it doesn't include invalid characters or punctuation, and that the name isn't too long."

I have tried renaming the table, and it then will allow the connection, but if I rename it back to the original name, it doesn't work again. The table name is "Invoice_Line_Item". Changing the name permanently is not an option.

Has anyone else run across this problem, or know of a fix for it.

View 1 Replies View Related

Database Engine Tuning Advisor Error

Jul 3, 2006

I have a very irritating error with Database Engine Tuning Advisor. While processing traces from Sql Profiler I keep getting trace log full of syntax error of most of queries - some of them very simple and ALL of them perfectly correct ( I check them separatly in QueryAnaliser ) - program gives recomendtation when I enter queries one by one - in that case the syntax is correct for Database Engine Tuning Advisor, but I just can't imagine why quries given to analysis in the set aren't correct? I dont' want to enter trace query by query (while I have thousends of them) !

It all seem like a Database Engine Tuning Advisor bug, any ideas about this problem?

Joanna

View 1 Replies View Related

DB Engine :: Transaction Log Database Corruption Error

Jul 23, 2015

I am having an issue for transaction log database backup getting failed and throw me a following error. I never seen this corruption error before so Is there any solution for it?This error is from my Log file:-

Failed:(-1073548784) Executing the query "BACKUP LOG [Xe] TO DISK = N'D:XeXeXe_backup_201507230922.trn' WITH NOFORMAT, NOINIT, NAME = N'Xe_backup_20150723092224', SKIP, REWIND, NOUNLOAD, STATS = 10

" failed with the following error: "BACKUP detected corruption in the database log. Check the errorlog for more information. BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.This is from SQL JOB error"-

Executed as user: SqlAdmin. ...ion 9.00.5324.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:22:20 AM Progress: 2015-07-23 09:22:24.08 Source: {297F9C99-05AE-47BD-AA70-3E25DDD78CAB}
Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2015-07-23 09:22:24.91 Source: Back Up Database (Transaction Log)

[code]....

View 10 Replies View Related

DB Engine :: High Availability Database Backup Error

May 19, 2015

Backing up all databases on a sql server that hosts secondary high availability databases as well as other databases. The other databases back up fine, but the high availability secondaries all get the same error:

BackupDiskFile::OpenMedia: Backup device 'F:MSSQLBackupdbnamedbname_backup_2015_MM_DD_tttttt_ttttttt.bak' failed to open. Operating system error 2(The system cannot find the file specified.)

View 11 Replies View Related

Native Error 18456 !!!! Help!!!!

Feb 22, 2008

Hi all,

Ms SQL Server Native Error 18456 !! Login Failed.

Pls help me out.

Thanx in Advance

View 7 Replies View Related

Sql Server Error 18456

Oct 28, 2004

We are facing the error 18456 since we have changed our O.S from Windows 2000 to XP .When we try to check the ODBC connection it works with 2000 but with xp we still hve this error .Some people advise me to check the security options but I dit not find any that could explain this problem.

The user has the administrator rights.

Any help will be appreciated

View 3 Replies View Related

18456 Error With State 38

Jul 31, 2015

Login failed for user ''. Reason: Failed to open the explicitly specified database. [CLIENT:xx.xx.xx.xx]

No missing database & having sysadmin permission.

why this error coming?

View 3 Replies View Related

Error 18456 State 5

Nov 23, 2007

Hi. I have read a lot of info for this problem but I didn't succeed to find error with state 5.
I have this message in my logs:

Code Block
11/23/2007 16:41:53,Logon,Unknown,Login failed for user 'Administrator'. [CLIENT: 127.0.0.1]
11/23/2007 16:41:53,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.

One of my programm tried to establish connection with MS SQL 2005. Login: Administrator. Pleas help!!!

View 6 Replies View Related

Error: 18456, Severity

May 16, 2008

I am not sure if th is is the right place to post this error but I am at my wits end on how resolve this problem
My even viewer and log is logging this every min. This is happening on my MOSS 2007 production database server.
I have been loooking on line and have not been able to find a concrete answer has anyone run into this problem and can you point me in the righ direction. Machine is Sql Server Standard win2003 Server service pack2

2008-05-14 19:46:00.66 Logon Login failed for user 'Domainuseraccount'. [CLIENT: <local machine>]
2008-05-14 19:47:00.66 Logon Error: 18456, Severity: 14, State: 16.

Thanks in advance for any assistance

Neil Palmer

View 1 Replies View Related

Error 18456 State 6

Jul 3, 2007

Hi,

I am trying to connect to a remote SQL server via Management Studio. I am using the windows credentials I use to log into the computer but when I enter the same domainusername and password I get error 18456. I check the logs and see it is a state 6 error. After checking http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx I see that means
Attempt to use a Windows login name with SQL Authentication

Is it possible for me to access a SQL server remotely?

Thanks

View 1 Replies View Related

Microsoft JET Database Engine Hresult: 0x80004005 Description: Unspecified Error.

May 12, 2006

I have ran into the same problem ... Importing from Access into SQL 2005 using SSIS and get the error:

[Connection manager "SourceConnectionOLEDB"] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".

View 3 Replies View Related

Setting Up Replication Gives Error 18456 - Please Help

Feb 29, 2000

I am using the Configure Publishing and Distribution Wizard in the SQL Server Enterprise Manager to configure a server as a Distribution and Publishing server. The security configuration on the server in question for authentication is SQL Server and Windows NT.

When I get to the first page in the wizard I select that I want to use the server as the Distributor. The other option is to use another server for the Distribution server - and this isn't what I want to do. The next page presents the option to use the default settings to configure the distribution databases or to configure the setup. If I select the default options I get the following error message when the arrow is pointing to Configuring Distributor:

----------------------------------------------
SQL Server Enterprise Manager could not configure 'SERVER1' as the Distributor for

'SERVER1'.

Error 18456: Login failed for user 'sa'.
Remote logins for remote server 'repl_distributor' have been dropped.
Server dropped.
Server added.
Server network name set.

----------------------------------------------

Something I have tried to change in order to fix this issue is the 'Replication agents on the Distributor log into the Publisher:' option from its default (By impersontating the SQL Agent account on 'SERVER1' (trusted connection)) to 'Using SQL Server Authentication of this account:', and in those fields I have put in 'sa' (which is a valid admin account to the SQL server) and the correct password.

In all cases I get the message above. Can anyone help me to see what I am doing wrong?

Thanks for your time,
Eric Gross

View 1 Replies View Related

Help Needed On SQLServer , Error 18456

Mar 1, 2004

Hi All,

I have tried accessing a remote database in one of by stored procs using linked servers and also using OpenDataSource method.
In both the cases , I am getting login failed error.

Following is the stored proc :

CREATE PROCEDURE TEST AS

SELECT *
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=blrkec3432s;User ID=xyz;Password=xyz').LMC.dbo.STATE
GO

It works fine if the userid is 'sa'

Could anyone please tell me the reason for this.

Thanks,
Shanthi

View 1 Replies View Related

Error 18456 - Cannot Connect - Database Engine