Hi
The following commands in Query Analyzer:
EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders'
Go
SELECT Convert(nvarchar(30), "urn:schemas:contacts:sn") LastName
FROM OpenQuery(Exchange, 'SELECT "urn:schemas:contacts:sn"
FROM ".\Public Folders\Company Contacts"')
produce the following results:
Server: Msg 7304, Level 16, State 2, Line 1
Could not create a new session on OLE DB provider 'exoledb.DataSource.1'.
OLE DB error trace [OLE/DB Provider 'exoledb.DataSource.1'
IDBCreateSession::CreateSession returned 0x80150804].
I am trying to access contacts in public folders.
Can anyone help with this?
Is this the best way to read/modify these records?
What about using this to check/modify tasks and emails?
When I browse the folder structure in the Exchange System Manager the
following shows:
Folders -> Public Folders -> Public Folders -> Company Contacts
When I go to the properties of the "Company Contacts" folder in Exchange
System Manager I get:
/Public Folders/Company Contacts/
When I look at the same structure in Outlook I see the breakdown as:
Public Folders -> All Public Folders -> Public Folders -> Company
Contacts
Thanks
Roger
Message posted via http://www.droptable.comLook at
http://support.microsoft.com/?kbid=887161
"Roger Ivy via droptable.com" wrote:
> Hi
> The following commands in Query Analyzer:
> EXEC sp_addlinkedserver 'exchange',
> 'Exchange OLE DB provider',
> 'exoledb.DataSource.1',
> 'file:\\.\backofficestorage\localhost\public folders'
> Go
> SELECT Convert(nvarchar(30), "urn:schemas:contacts:sn") LastName
> FROM OpenQuery(Exchange, 'SELECT "urn:schemas:contacts:sn"
> FROM ".\Public Folders\Company Contacts"')
> produce the following results:
> Server: Msg 7304, Level 16, State 2, Line 1
> Could not create a new session on OLE DB provider 'exoledb.DataSource.1'.
> OLE DB error trace [OLE/DB Provider 'exoledb.DataSource.1'
> IDBCreateSession::CreateSession returned 0x80150804].
> I am trying to access contacts in public folders.
> Can anyone help with this?
> Is this the best way to read/modify these records?
> What about using this to check/modify tasks and emails?
> When I browse the folder structure in the Exchange System Manager the
> following shows:
> Folders -> Public Folders -> Public Folders -> Company Contacts
> When I go to the properties of the "Company Contacts" folder in Exchange
> System Manager I get:
> /Public Folders/Company Contacts/
> When I look at the same structure in Outlook I see the breakdown as:
> Public Folders -> All Public Folders -> Public Folders -> Company
> Contacts
> Thanks
> Roger
> --
> Message posted via http://www.droptable.com
>
Showing posts with label sp_addlinkedserver. Show all posts
Showing posts with label sp_addlinkedserver. Show all posts
Friday, March 30, 2012
Linking Exchange Server 2003 to SQL Server 2000
Hi
The following commands in Query Analyzer:
EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders'
Go
SELECT Convert(nvarchar(30), "urn:schemas:contacts:sn") LastName
FROM OpenQuery(Exchange, 'SELECT "urn:schemas:contacts:sn"
FROM ".\Public Folders\Company Contacts"')
produce the following results:
Server: Msg 7304, Level 16, State 2, Line 1
Could not create a new session on OLE DB provider 'exoledb.DataSource.1'.
OLE DB error trace [OLE/DB Provider 'exoledb.DataSource.1'
IDBCreateSession::CreateSession returned 0x80150804].
I am trying to access contacts in public folders.
Can anyone help with this?
Is this the best way to read/modify these records?
What about using this to check/modify tasks and emails?
When I browse the folder structure in the Exchange System Manager the
following shows:
Folders -> Public Folders -> Public Folders -> Company Contacts
When I go to the properties of the "Company Contacts" folder in Exchange
System Manager I get:
/Public Folders/Company Contacts/
When I look at the same structure in Outlook I see the breakdown as:
Public Folders -> All Public Folders -> Public Folders -> Company
Contacts
Thanks
Roger
Message posted via http://www.sqlmonster.com
Look at
http://support.microsoft.com/?kbid=887161
"Roger Ivy via SQLMonster.com" wrote:
> Hi
> The following commands in Query Analyzer:
> EXEC sp_addlinkedserver 'exchange',
> 'Exchange OLE DB provider',
> 'exoledb.DataSource.1',
> 'file:\\.\backofficestorage\localhost\public folders'
> Go
> SELECT Convert(nvarchar(30), "urn:schemas:contacts:sn") LastName
> FROM OpenQuery(Exchange, 'SELECT "urn:schemas:contacts:sn"
> FROM ".\Public Folders\Company Contacts"')
> produce the following results:
> Server: Msg 7304, Level 16, State 2, Line 1
> Could not create a new session on OLE DB provider 'exoledb.DataSource.1'.
> OLE DB error trace [OLE/DB Provider 'exoledb.DataSource.1'
> IDBCreateSession::CreateSession returned 0x80150804].
> I am trying to access contacts in public folders.
> Can anyone help with this?
> Is this the best way to read/modify these records?
> What about using this to check/modify tasks and emails?
> When I browse the folder structure in the Exchange System Manager the
> following shows:
> Folders -> Public Folders -> Public Folders -> Company Contacts
> When I go to the properties of the "Company Contacts" folder in Exchange
> System Manager I get:
> /Public Folders/Company Contacts/
> When I look at the same structure in Outlook I see the breakdown as:
> Public Folders -> All Public Folders -> Public Folders -> Company
> Contacts
> Thanks
> Roger
> --
> Message posted via http://www.sqlmonster.com
>
The following commands in Query Analyzer:
EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders'
Go
SELECT Convert(nvarchar(30), "urn:schemas:contacts:sn") LastName
FROM OpenQuery(Exchange, 'SELECT "urn:schemas:contacts:sn"
FROM ".\Public Folders\Company Contacts"')
produce the following results:
Server: Msg 7304, Level 16, State 2, Line 1
Could not create a new session on OLE DB provider 'exoledb.DataSource.1'.
OLE DB error trace [OLE/DB Provider 'exoledb.DataSource.1'
IDBCreateSession::CreateSession returned 0x80150804].
I am trying to access contacts in public folders.
Can anyone help with this?
Is this the best way to read/modify these records?
What about using this to check/modify tasks and emails?
When I browse the folder structure in the Exchange System Manager the
following shows:
Folders -> Public Folders -> Public Folders -> Company Contacts
When I go to the properties of the "Company Contacts" folder in Exchange
System Manager I get:
/Public Folders/Company Contacts/
When I look at the same structure in Outlook I see the breakdown as:
Public Folders -> All Public Folders -> Public Folders -> Company
Contacts
Thanks
Roger
Message posted via http://www.sqlmonster.com
Look at
http://support.microsoft.com/?kbid=887161
"Roger Ivy via SQLMonster.com" wrote:
> Hi
> The following commands in Query Analyzer:
> EXEC sp_addlinkedserver 'exchange',
> 'Exchange OLE DB provider',
> 'exoledb.DataSource.1',
> 'file:\\.\backofficestorage\localhost\public folders'
> Go
> SELECT Convert(nvarchar(30), "urn:schemas:contacts:sn") LastName
> FROM OpenQuery(Exchange, 'SELECT "urn:schemas:contacts:sn"
> FROM ".\Public Folders\Company Contacts"')
> produce the following results:
> Server: Msg 7304, Level 16, State 2, Line 1
> Could not create a new session on OLE DB provider 'exoledb.DataSource.1'.
> OLE DB error trace [OLE/DB Provider 'exoledb.DataSource.1'
> IDBCreateSession::CreateSession returned 0x80150804].
> I am trying to access contacts in public folders.
> Can anyone help with this?
> Is this the best way to read/modify these records?
> What about using this to check/modify tasks and emails?
> When I browse the folder structure in the Exchange System Manager the
> following shows:
> Folders -> Public Folders -> Public Folders -> Company Contacts
> When I go to the properties of the "Company Contacts" folder in Exchange
> System Manager I get:
> /Public Folders/Company Contacts/
> When I look at the same structure in Outlook I see the breakdown as:
> Public Folders -> All Public Folders -> Public Folders -> Company
> Contacts
> Thanks
> Roger
> --
> Message posted via http://www.sqlmonster.com
>
Linking Exchange Server 2003 to SQL Server 2000
Hi
The following commands in Query Analyzer:
EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders'
Go
SELECT Convert(nvarchar(30), "urn:schemas:contacts:sn") LastName
FROM OpenQuery(Exchange, 'SELECT "urn:schemas:contacts:sn"
FROM ".\Public Folders\Company Contacts"')
produce the following results:
Server: Msg 7304, Level 16, State 2, Line 1
Could not create a new session on OLE DB provider 'exoledb.DataSource.1'.
OLE DB error trace [OLE/DB Provider 'exoledb.DataSource.1'
IDBCreateSession::CreateSession returned 0x80150804].
I am trying to access contacts in public folders.
Can anyone help with this?
Is this the best way to read/modify these records?
What about using this to check/modify tasks and emails?
When I browse the folder structure in the Exchange System Manager the
following shows:
Folders -> Public Folders -> Public Folders -> Company Contacts
When I go to the properties of the "Company Contacts" folder in Exchange
System Manager I get:
/Public Folders/Company Contacts/
When I look at the same structure in Outlook I see the breakdown as:
Public Folders -> All Public Folders -> Public Folders -> Company
Contacts
Thanks
Roger
--
Message posted via http://www.sqlmonster.comLook at
http://support.microsoft.com/?kbid=887161
"Roger Ivy via SQLMonster.com" wrote:
> Hi
> The following commands in Query Analyzer:
> EXEC sp_addlinkedserver 'exchange',
> 'Exchange OLE DB provider',
> 'exoledb.DataSource.1',
> 'file:\\.\backofficestorage\localhost\public folders'
> Go
> SELECT Convert(nvarchar(30), "urn:schemas:contacts:sn") LastName
> FROM OpenQuery(Exchange, 'SELECT "urn:schemas:contacts:sn"
> FROM ".\Public Folders\Company Contacts"')
> produce the following results:
> Server: Msg 7304, Level 16, State 2, Line 1
> Could not create a new session on OLE DB provider 'exoledb.DataSource.1'.
> OLE DB error trace [OLE/DB Provider 'exoledb.DataSource.1'
> IDBCreateSession::CreateSession returned 0x80150804].
> I am trying to access contacts in public folders.
> Can anyone help with this?
> Is this the best way to read/modify these records?
> What about using this to check/modify tasks and emails?
> When I browse the folder structure in the Exchange System Manager the
> following shows:
> Folders -> Public Folders -> Public Folders -> Company Contacts
> When I go to the properties of the "Company Contacts" folder in Exchange
> System Manager I get:
> /Public Folders/Company Contacts/
> When I look at the same structure in Outlook I see the breakdown as:
> Public Folders -> All Public Folders -> Public Folders -> Company
> Contacts
> Thanks
> Roger
> --
> Message posted via http://www.sqlmonster.com
>
The following commands in Query Analyzer:
EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders'
Go
SELECT Convert(nvarchar(30), "urn:schemas:contacts:sn") LastName
FROM OpenQuery(Exchange, 'SELECT "urn:schemas:contacts:sn"
FROM ".\Public Folders\Company Contacts"')
produce the following results:
Server: Msg 7304, Level 16, State 2, Line 1
Could not create a new session on OLE DB provider 'exoledb.DataSource.1'.
OLE DB error trace [OLE/DB Provider 'exoledb.DataSource.1'
IDBCreateSession::CreateSession returned 0x80150804].
I am trying to access contacts in public folders.
Can anyone help with this?
Is this the best way to read/modify these records?
What about using this to check/modify tasks and emails?
When I browse the folder structure in the Exchange System Manager the
following shows:
Folders -> Public Folders -> Public Folders -> Company Contacts
When I go to the properties of the "Company Contacts" folder in Exchange
System Manager I get:
/Public Folders/Company Contacts/
When I look at the same structure in Outlook I see the breakdown as:
Public Folders -> All Public Folders -> Public Folders -> Company
Contacts
Thanks
Roger
--
Message posted via http://www.sqlmonster.comLook at
http://support.microsoft.com/?kbid=887161
"Roger Ivy via SQLMonster.com" wrote:
> Hi
> The following commands in Query Analyzer:
> EXEC sp_addlinkedserver 'exchange',
> 'Exchange OLE DB provider',
> 'exoledb.DataSource.1',
> 'file:\\.\backofficestorage\localhost\public folders'
> Go
> SELECT Convert(nvarchar(30), "urn:schemas:contacts:sn") LastName
> FROM OpenQuery(Exchange, 'SELECT "urn:schemas:contacts:sn"
> FROM ".\Public Folders\Company Contacts"')
> produce the following results:
> Server: Msg 7304, Level 16, State 2, Line 1
> Could not create a new session on OLE DB provider 'exoledb.DataSource.1'.
> OLE DB error trace [OLE/DB Provider 'exoledb.DataSource.1'
> IDBCreateSession::CreateSession returned 0x80150804].
> I am trying to access contacts in public folders.
> Can anyone help with this?
> Is this the best way to read/modify these records?
> What about using this to check/modify tasks and emails?
> When I browse the folder structure in the Exchange System Manager the
> following shows:
> Folders -> Public Folders -> Public Folders -> Company Contacts
> When I go to the properties of the "Company Contacts" folder in Exchange
> System Manager I get:
> /Public Folders/Company Contacts/
> When I look at the same structure in Outlook I see the breakdown as:
> Public Folders -> All Public Folders -> Public Folders -> Company
> Contacts
> Thanks
> Roger
> --
> Message posted via http://www.sqlmonster.com
>
Friday, March 23, 2012
servers problem
Hi !!!
I have two computers with Windows XP, and each these is a SQL SERVER.
I execute sp_addlinkedserver for link both servers, but when I execute a
statement SELECT using my linked server, the following error is raised:
Msg 18452, Level 14, State 1, Line 1
Login failed for user '(sa)'. Reason: Not associated with a trusted SQL
Server connection.
In both servers the authentication mode is Mixed.
can anybody help me? thanks.My guess is that you mapped the login to a SQL Server login on the other machine, and that the other
machine doesn't allow SQL Server logins (it runs in "Windows Only" mode).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"German" <German@.discussions.microsoft.com> wrote in message
news:926B63EF-95E6-4680-BFD4-53AE09DB77D6@.microsoft.com...
> Hi !!!
> I have two computers with Windows XP, and each these is a SQL SERVER.
> I execute sp_addlinkedserver for link both servers, but when I execute a
> statement SELECT using my linked server, the following error is raised:
> Msg 18452, Level 14, State 1, Line 1
> Login failed for user '(sa)'. Reason: Not associated with a trusted SQL
> Server connection.
>
> In both servers the authentication mode is Mixed.
> can anybody help me? thanks.|||Thanks for you answer.
Both Servers are Mixed authentication.
At moment to create linked servers i did it with login map and without but
the result is the same.
"Tibor Karaszi" wrote:
> My guess is that you mapped the login to a SQL Server login on the other machine, and that the other
> machine doesn't allow SQL Server logins (it runs in "Windows Only" mode).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "German" <German@.discussions.microsoft.com> wrote in message
> news:926B63EF-95E6-4680-BFD4-53AE09DB77D6@.microsoft.com...
> > Hi !!!
> >
> > I have two computers with Windows XP, and each these is a SQL SERVER.
> > I execute sp_addlinkedserver for link both servers, but when I execute a
> > statement SELECT using my linked server, the following error is raised:
> >
> > Msg 18452, Level 14, State 1, Line 1
> > Login failed for user '(sa)'. Reason: Not associated with a trusted SQL
> > Server connection.
> >
> >
> > In both servers the authentication mode is Mixed.
> >
> > can anybody help me? thanks.
>
>
I have two computers with Windows XP, and each these is a SQL SERVER.
I execute sp_addlinkedserver for link both servers, but when I execute a
statement SELECT using my linked server, the following error is raised:
Msg 18452, Level 14, State 1, Line 1
Login failed for user '(sa)'. Reason: Not associated with a trusted SQL
Server connection.
In both servers the authentication mode is Mixed.
can anybody help me? thanks.My guess is that you mapped the login to a SQL Server login on the other machine, and that the other
machine doesn't allow SQL Server logins (it runs in "Windows Only" mode).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"German" <German@.discussions.microsoft.com> wrote in message
news:926B63EF-95E6-4680-BFD4-53AE09DB77D6@.microsoft.com...
> Hi !!!
> I have two computers with Windows XP, and each these is a SQL SERVER.
> I execute sp_addlinkedserver for link both servers, but when I execute a
> statement SELECT using my linked server, the following error is raised:
> Msg 18452, Level 14, State 1, Line 1
> Login failed for user '(sa)'. Reason: Not associated with a trusted SQL
> Server connection.
>
> In both servers the authentication mode is Mixed.
> can anybody help me? thanks.|||Thanks for you answer.
Both Servers are Mixed authentication.
At moment to create linked servers i did it with login map and without but
the result is the same.
"Tibor Karaszi" wrote:
> My guess is that you mapped the login to a SQL Server login on the other machine, and that the other
> machine doesn't allow SQL Server logins (it runs in "Windows Only" mode).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "German" <German@.discussions.microsoft.com> wrote in message
> news:926B63EF-95E6-4680-BFD4-53AE09DB77D6@.microsoft.com...
> > Hi !!!
> >
> > I have two computers with Windows XP, and each these is a SQL SERVER.
> > I execute sp_addlinkedserver for link both servers, but when I execute a
> > statement SELECT using my linked server, the following error is raised:
> >
> > Msg 18452, Level 14, State 1, Line 1
> > Login failed for user '(sa)'. Reason: Not associated with a trusted SQL
> > Server connection.
> >
> >
> > In both servers the authentication mode is Mixed.
> >
> > can anybody help me? thanks.
>
>
Wednesday, March 21, 2012
servers problem
Hi !!!
I have two computers with Windows XP, and each these is a SQL SERVER.
I execute sp_addlinkedserver for link both servers, but when I execute a
statement SELECT using my linked server, the following error is raised:
Msg 18452, Level 14, State 1, Line 1
Login failed for user '(sa)'. Reason: Not associated with a trusted SQL
Server connection.
In both servers the authentication mode is Mixed.
can anybody help me? thanks.
My guess is that you mapped the login to a SQL Server login on the other machine, and that the other
machine doesn't allow SQL Server logins (it runs in "Windows Only" mode).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"German" <German@.discussions.microsoft.com> wrote in message
news:926B63EF-95E6-4680-BFD4-53AE09DB77D6@.microsoft.com...
> Hi !!!
> I have two computers with Windows XP, and each these is a SQL SERVER.
> I execute sp_addlinkedserver for link both servers, but when I execute a
> statement SELECT using my linked server, the following error is raised:
> Msg 18452, Level 14, State 1, Line 1
> Login failed for user '(sa)'. Reason: Not associated with a trusted SQL
> Server connection.
>
> In both servers the authentication mode is Mixed.
> can anybody help me? thanks.
|||Thanks for you answer.
Both Servers are Mixed authentication.
At moment to create linked servers i did it with login map and without but
the result is the same.
"Tibor Karaszi" wrote:
> My guess is that you mapped the login to a SQL Server login on the other machine, and that the other
> machine doesn't allow SQL Server logins (it runs in "Windows Only" mode).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "German" <German@.discussions.microsoft.com> wrote in message
> news:926B63EF-95E6-4680-BFD4-53AE09DB77D6@.microsoft.com...
>
>
I have two computers with Windows XP, and each these is a SQL SERVER.
I execute sp_addlinkedserver for link both servers, but when I execute a
statement SELECT using my linked server, the following error is raised:
Msg 18452, Level 14, State 1, Line 1
Login failed for user '(sa)'. Reason: Not associated with a trusted SQL
Server connection.
In both servers the authentication mode is Mixed.
can anybody help me? thanks.
My guess is that you mapped the login to a SQL Server login on the other machine, and that the other
machine doesn't allow SQL Server logins (it runs in "Windows Only" mode).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"German" <German@.discussions.microsoft.com> wrote in message
news:926B63EF-95E6-4680-BFD4-53AE09DB77D6@.microsoft.com...
> Hi !!!
> I have two computers with Windows XP, and each these is a SQL SERVER.
> I execute sp_addlinkedserver for link both servers, but when I execute a
> statement SELECT using my linked server, the following error is raised:
> Msg 18452, Level 14, State 1, Line 1
> Login failed for user '(sa)'. Reason: Not associated with a trusted SQL
> Server connection.
>
> In both servers the authentication mode is Mixed.
> can anybody help me? thanks.
|||Thanks for you answer.
Both Servers are Mixed authentication.
At moment to create linked servers i did it with login map and without but
the result is the same.
"Tibor Karaszi" wrote:
> My guess is that you mapped the login to a SQL Server login on the other machine, and that the other
> machine doesn't allow SQL Server logins (it runs in "Windows Only" mode).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "German" <German@.discussions.microsoft.com> wrote in message
> news:926B63EF-95E6-4680-BFD4-53AE09DB77D6@.microsoft.com...
>
>
servers problem
Hi !!!
I have two computers with Windows XP, and each these is a SQL SERVER.
I execute sp_addlinkedserver for link both servers, but when I execute a
statement SELECT using my linked server, the following error is raised:
Msg 18452, Level 14, State 1, Line 1
Login failed for user '(sa)'. Reason: Not associated with a trusted SQL
Server connection.
In both servers the authentication mode is Mixed.
can anybody help me? thanks.My guess is that you mapped the login to a SQL Server login on the other mac
hine, and that the other
machine doesn't allow SQL Server logins (it runs in "Windows Only" mode).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"German" <German@.discussions.microsoft.com> wrote in message
news:926B63EF-95E6-4680-BFD4-53AE09DB77D6@.microsoft.com...
> Hi !!!
> I have two computers with Windows XP, and each these is a SQL SERVER.
> I execute sp_addlinkedserver for link both servers, but when I execute a
> statement SELECT using my linked server, the following error is raised:
> Msg 18452, Level 14, State 1, Line 1
> Login failed for user '(sa)'. Reason: Not associated with a trusted SQL
> Server connection.
>
> In both servers the authentication mode is Mixed.
> can anybody help me? thanks.|||Thanks for you answer.
Both Servers are Mixed authentication.
At moment to create linked servers i did it with login map and without but
the result is the same.
"Tibor Karaszi" wrote:
> My guess is that you mapped the login to a SQL Server login on the other m
achine, and that the other
> machine doesn't allow SQL Server logins (it runs in "Windows Only" mode).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "German" <German@.discussions.microsoft.com> wrote in message
> news:926B63EF-95E6-4680-BFD4-53AE09DB77D6@.microsoft.com...
>
>
I have two computers with Windows XP, and each these is a SQL SERVER.
I execute sp_addlinkedserver for link both servers, but when I execute a
statement SELECT using my linked server, the following error is raised:
Msg 18452, Level 14, State 1, Line 1
Login failed for user '(sa)'. Reason: Not associated with a trusted SQL
Server connection.
In both servers the authentication mode is Mixed.
can anybody help me? thanks.My guess is that you mapped the login to a SQL Server login on the other mac
hine, and that the other
machine doesn't allow SQL Server logins (it runs in "Windows Only" mode).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"German" <German@.discussions.microsoft.com> wrote in message
news:926B63EF-95E6-4680-BFD4-53AE09DB77D6@.microsoft.com...
> Hi !!!
> I have two computers with Windows XP, and each these is a SQL SERVER.
> I execute sp_addlinkedserver for link both servers, but when I execute a
> statement SELECT using my linked server, the following error is raised:
> Msg 18452, Level 14, State 1, Line 1
> Login failed for user '(sa)'. Reason: Not associated with a trusted SQL
> Server connection.
>
> In both servers the authentication mode is Mixed.
> can anybody help me? thanks.|||Thanks for you answer.
Both Servers are Mixed authentication.
At moment to create linked servers i did it with login map and without but
the result is the same.
"Tibor Karaszi" wrote:
> My guess is that you mapped the login to a SQL Server login on the other m
achine, and that the other
> machine doesn't allow SQL Server logins (it runs in "Windows Only" mode).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "German" <German@.discussions.microsoft.com> wrote in message
> news:926B63EF-95E6-4680-BFD4-53AE09DB77D6@.microsoft.com...
>
>
Monday, March 12, 2012
servers
I added a remote server using sp_addlinkedserver commandn succesfully.
But when i run Select count(*) from Servername.dbname.tablename
it give me this error
Server: Msg 7202, Level 11, State 2, Line 1
Could not find server 'Servername' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Any reasons why?Did you add a login to the linked server too? If you did, go to EM and see if you can see the table list.
Originally posted by vmlal
I added a remote server using sp_addlinkedserver commandn succesfully.
But when i run Select count(*) from Servername.dbname.tablename
it give me this error
Server: Msg 7202, Level 11, State 2, Line 1
Could not find server 'Servername' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Any reasons why?|||You need a 4 part name...you're missing the owner, and youalso need to do sp_addlinkedsrvlogin
Try this
Select count(*) from Servername.dbname..tablename|||nope tried the sp_addlinkedsrvlogin still i get the same error and a new one:
Server: Msg 15015, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 40
The server 'ServerName' does not exist. Use sp_helpserver to show available servers.
and exec sp_helpserver shows the ServerName but the networkname field is NULL|||Can you post the code that added the linked server?
And what name did you give the link? You need to use that, not the actual server name, unless it's the same...|||/* Remove any previous references to the linked server */
EXEC sp_dropserver 'Server_I_want_to_add'
EXEC sp_addlinkedserver
@.server='Server_I_want_to_add', /* local SQL name given to the linked server */
@.srvproduct='Existing_Server_Name', /* not used */
@.provider='SQLOLEDB', /* OLE DB provider */
@.datasrc='Existing_Server_Name', /* analysis server name (machine name) */
@.catalog='Barney' /* default catalog/database */
EXEC sp_addlinkedsrvlogin
@.rmtsrvname='Server_I_want_to_add',
@.useself='true',
@.rmtuser ='**User_Name**',
@.rmtpassword = '***Password***'
/* Two additional procedures obtain information about the
tables and columns available in the cube. It is not
necessary to use them to complete the link.*/
/* This provides schema rowset information about
the dimensions available from the linked server */
EXEC sp_tables_ex
@.table_server='Server_I_want_to_add'
/* This provides schema rowset information about the
measures and levels of the dimensions
available from the linked server */
EXEC sp_columns_ex
@.table_server='Server_I_want_to_add',
@.table_name='Table_Name'|||Does your select look like
SELECT COUNT(*)
FROM Server_I_want_to_add.dbname..table
Notice the 2 dots, and the reference is to the linked server name, not the actual server name...
I always use the method in bol
like
EXEC sp_addlinkedserver
'LONDON Payroll',
'',
'MSDASQL',
NULL,
NULL,
'DRIVER={SQL Server};SERVER=MyServer;UID=sa;PWD=;'
GO|||Yup i notice the 2 dots... last time it was a typo
thx for pointing that out
newayz i'll try ur code. thx|||Just curious...can you go in to Enterprise Manager and see the linked server?
It's in the Security folder for the server...|||yeah it works now, I see it in EM>security.
thx
But when i run Select count(*) from Servername.dbname.tablename
it give me this error
Server: Msg 7202, Level 11, State 2, Line 1
Could not find server 'Servername' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Any reasons why?Did you add a login to the linked server too? If you did, go to EM and see if you can see the table list.
Originally posted by vmlal
I added a remote server using sp_addlinkedserver commandn succesfully.
But when i run Select count(*) from Servername.dbname.tablename
it give me this error
Server: Msg 7202, Level 11, State 2, Line 1
Could not find server 'Servername' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Any reasons why?|||You need a 4 part name...you're missing the owner, and youalso need to do sp_addlinkedsrvlogin
Try this
Select count(*) from Servername.dbname..tablename|||nope tried the sp_addlinkedsrvlogin still i get the same error and a new one:
Server: Msg 15015, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 40
The server 'ServerName' does not exist. Use sp_helpserver to show available servers.
and exec sp_helpserver shows the ServerName but the networkname field is NULL|||Can you post the code that added the linked server?
And what name did you give the link? You need to use that, not the actual server name, unless it's the same...|||/* Remove any previous references to the linked server */
EXEC sp_dropserver 'Server_I_want_to_add'
EXEC sp_addlinkedserver
@.server='Server_I_want_to_add', /* local SQL name given to the linked server */
@.srvproduct='Existing_Server_Name', /* not used */
@.provider='SQLOLEDB', /* OLE DB provider */
@.datasrc='Existing_Server_Name', /* analysis server name (machine name) */
@.catalog='Barney' /* default catalog/database */
EXEC sp_addlinkedsrvlogin
@.rmtsrvname='Server_I_want_to_add',
@.useself='true',
@.rmtuser ='**User_Name**',
@.rmtpassword = '***Password***'
/* Two additional procedures obtain information about the
tables and columns available in the cube. It is not
necessary to use them to complete the link.*/
/* This provides schema rowset information about
the dimensions available from the linked server */
EXEC sp_tables_ex
@.table_server='Server_I_want_to_add'
/* This provides schema rowset information about the
measures and levels of the dimensions
available from the linked server */
EXEC sp_columns_ex
@.table_server='Server_I_want_to_add',
@.table_name='Table_Name'|||Does your select look like
SELECT COUNT(*)
FROM Server_I_want_to_add.dbname..table
Notice the 2 dots, and the reference is to the linked server name, not the actual server name...
I always use the method in bol
like
EXEC sp_addlinkedserver
'LONDON Payroll',
'',
'MSDASQL',
NULL,
NULL,
'DRIVER={SQL Server};SERVER=MyServer;UID=sa;PWD=;'
GO|||Yup i notice the 2 dots... last time it was a typo
thx for pointing that out
newayz i'll try ur code. thx|||Just curious...can you go in to Enterprise Manager and see the linked server?
It's in the Security folder for the server...|||yeah it works now, I see it in EM>security.
thx
servers
I used the stored procedures sp_addlinkedserver and sp_addlinkedserverlogin to add an Access db as a linked server. When I try and run SQL commands to this linked Access db I get the following error message:
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Unspecified error]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ]
Has anyone run into this before?This error message may indicate that the linked server does not have correct login mapping. You can execute the sp_helplinkedsrvlogin stored procedure to set the login information correctly. Also check to make sure you have the correct parameters specified for the linked server configuration.
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Unspecified error]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ]
Has anyone run into this before?This error message may indicate that the linked server does not have correct login mapping. You can execute the sp_helplinkedsrvlogin stored procedure to set the login information correctly. Also check to make sure you have the correct parameters specified for the linked server configuration.
Friday, March 9, 2012
server with SQL 2005
In SQL 2005 I have created a linked server with a DBF table.
I used the Stored Procedure SP_addlinkedserver.
With MS SQL Server Management Studio I used the "New Query" function and write: "select * from LKserver...LKserver " and used the "execute" command to view my DBF table on Results Window. It is fast!!
if I create a view with the same linked server and execute it with "Open View" I receive a "timeout exception error"
Why ?
thanksPerhaps you need to create the view on the linked server, not on the local server.|||?! It is not possible to create a view on a linked server, expecially if it is a DBF table!
If I use the View I have a problem of "time expired" then I must maximize the query time but I don't know where to do it?!
I used the Stored Procedure SP_addlinkedserver.
With MS SQL Server Management Studio I used the "New Query" function and write: "select * from LKserver...LKserver " and used the "execute" command to view my DBF table on Results Window. It is fast!!
if I create a view with the same linked server and execute it with "Open View" I receive a "timeout exception error"
Why ?
thanksPerhaps you need to create the view on the linked server, not on the local server.|||?! It is not possible to create a view on a linked server, expecially if it is a DBF table!
If I use the View I have a problem of "time expired" then I must maximize the query time but I don't know where to do it?!
server with DB2
Hello,
I create a Linked server to a DB2 Database with this command
EXECUTE sp_addlinkedserver
@.server = 'test',
@.provider = 'MSDASQL',
@.srvproduct = 'DB2',
I can see the new linked server and the tables in the enterprise manager.
But when I try to access a table of the db2 database (select * from test..xyz.tablename) , I get this error message:
Server: Msg 7313, Level 16, State 1, Line 1
Invalid schema or catalog specified for provider 'MSDASQL'
Any thoughts or suggestions are appreciated.
Thanks in advance.
BSAI would have expected the provider to be 'DB2OLEDB'.
An example is provided in Books Online for establishing a liked DB@. server:
I. Use the Microsoft OLE DB Provider for DB2
This example creates a linked server named DB2 that uses the Microsoft OLE DB Provider for DB2.
EXEC sp_addlinkedserver
@.server='DB2',
@.srvproduct='Microsoft OLE DB Provider for DB2',
@.catalog='DB2',
@.provider='DB2OLEDB',
@.provstr='Initial Catalog=PUBS;Data Source=DB2;HostCCSID=1252;Network Address=XYZ;Network Port=50000;Package Collection=admin;Default Schema=admin;'
Also, when I reference a table via a linked server I use the reference <server name>.<database name>.<owner name>.<table name>, does DB2 need this kind of reference?
I create a Linked server to a DB2 Database with this command
EXECUTE sp_addlinkedserver
@.server = 'test',
@.provider = 'MSDASQL',
@.srvproduct = 'DB2',
I can see the new linked server and the tables in the enterprise manager.
But when I try to access a table of the db2 database (select * from test..xyz.tablename) , I get this error message:
Server: Msg 7313, Level 16, State 1, Line 1
Invalid schema or catalog specified for provider 'MSDASQL'
Any thoughts or suggestions are appreciated.
Thanks in advance.
BSAI would have expected the provider to be 'DB2OLEDB'.
An example is provided in Books Online for establishing a liked DB@. server:
I. Use the Microsoft OLE DB Provider for DB2
This example creates a linked server named DB2 that uses the Microsoft OLE DB Provider for DB2.
EXEC sp_addlinkedserver
@.server='DB2',
@.srvproduct='Microsoft OLE DB Provider for DB2',
@.catalog='DB2',
@.provider='DB2OLEDB',
@.provstr='Initial Catalog=PUBS;Data Source=DB2;HostCCSID=1252;Network Address=XYZ;Network Port=50000;Package Collection=admin;Default Schema=admin;'
Also, when I reference a table via a linked server I use the reference <server name>.<database name>.<owner name>.<table name>, does DB2 need this kind of reference?
Wednesday, March 7, 2012
server to VFPOLEDB working in 2000 but not in 2005?
I have run the following command and opened a working linked server in SQL Server 2000 but it fails for 2005.
sp_addlinkedserver 'AZ','','VFPOLEDB','c:\comp01\company.dbc'
To test, I run: select * from openquery(AZ, 'select * from contact') and I ge
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "VFPOLEDB" for linked server "AZ" reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 2
Cannot get the column information from OLE DB provider "VFPOLEDB" for linked server "AZ".
The specs on the working machine: WinXP Pro, SQL Server 2000 Developer's Edition, SP4, latest VFPOLEDB from MS site.
The specs on the non-working machine: Windows Server 2003 (std), SQL Server 2005 Developer Edition SP4, latest VFPOLEDB from MS site.
Other things I have done and/or noticed:
- in the install notes, it says something about security through component services, MSDTC, having to check everything. Did that.
- if I don't use a SQL command from query analyzer and try to add the linked server by right clicking on Server Objects\Linked Servers, it demands a Product Name. Null (and ' ') is not a valid entry.
Looking for help on this.
Doug
Think I'm closer. Turns out that MDAC has not recognized VFPOLEDB despite having downloading and installed it on Windows Server 2003. I have now tried regsvr32 and it says it's registered but still not listed in MDAC (used the component checker). Thoughts?
|||Sorry, I don't have any suggestions for you. I just thought I'd sympathize because I am running into the same problem with MSDAORA instead of VFPOLEDB. I'd be interested to hear what progress you end up making.
server to VFPOLEDB working in 2000 but not in 2005?
I have run the following command and opened a working linked server in SQL Server 2000 but it fails for 2005.
sp_addlinkedserver 'AZ','','VFPOLEDB','c:\comp01\company.dbc'
To test, I run: select * from openquery(AZ, 'select * from contact') and I ge
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "VFPOLEDB" for linked server "AZ" reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 2
Cannot get the column information from OLE DB provider "VFPOLEDB" for linked server "AZ".
The specs on the working machine: WinXP Pro, SQL Server 2000 Developer's Edition, SP4, latest VFPOLEDB from MS site.
The specs on the non-working machine: Windows Server 2003 (std), SQL Server 2005 Developer Edition SP4, latest VFPOLEDB from MS site.
Other things I have done and/or noticed:
- in the install notes, it says something about security through component services, MSDTC, having to check everything. Did that.
- if I don't use a SQL command from query analyzer and try to add the linked server by right clicking on Server Objects\Linked Servers, it demands a Product Name. Null (and ' ') is not a valid entry.
Looking for help on this.
Doug
Think I'm closer. Turns out that MDAC has not recognized VFPOLEDB despite having downloading and installed it on Windows Server 2003. I have now tried regsvr32 and it says it's registered but still not listed in MDAC (used the component checker). Thoughts?
|||Sorry, I don't have any suggestions for you. I just thought I'd sympathize because I am running into the same problem with MSDAORA instead of VFPOLEDB. I'd be interested to hear what progress you end up making.
server to VFPOLEDB working in 2000 but not in 2005?
I have run the following command and opened a working linked server in SQL Server 2000 but it fails for 2005.
sp_addlinkedserver 'AZ','','VFPOLEDB','c:\comp01\company.dbc'
To test, I run: select * from openquery(AZ, 'select * from contact') and I ge
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "VFPOLEDB" for linked server "AZ" reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 2
Cannot get the column information from OLE DB provider "VFPOLEDB" for linked server "AZ".
The specs on the working machine: WinXP Pro, SQL Server 2000 Developer's Edition, SP4, latest VFPOLEDB from MS site.
The specs on the non-working machine: Windows Server 2003 (std), SQL Server 2005 Developer Edition SP4, latest VFPOLEDB from MS site.
Other things I have done and/or noticed:
- in the install notes, it says something about security through component services, MSDTC, having to check everything. Did that.
- if I don't use a SQL command from query analyzer and try to add the linked server by right clicking on Server Objects\Linked Servers, it demands a Product Name. Null (and ' ') is not a valid entry.
Looking for help on this.
Doug
Think I'm closer. Turns out that MDAC has not recognized VFPOLEDB despite having downloading and installed it on Windows Server 2003. I have now tried regsvr32 and it says it's registered but still not listed in MDAC (used the component checker). Thoughts?
|||Sorry, I don't have any suggestions for you. I just thought I'd sympathize because I am running into the same problem with MSDAORA instead of VFPOLEDB. I'd be interested to hear what progress you end up making.
server to secure Access Database
hi all,
This is my second try to get the answer..
I have created a linked server to a secure database with following query
EXEC sp_addlinkedserver
@.server = 'MYSERVER2',
@.provider = 'Microsoft.Jet.OLEDB.4.0',
@.srvproduct = 'ACCESS',
@.datasrc = 'C:\COSTING2.mdb'
GO
sp_addlinkedsrvlogin myserver2, false,sa, Admin, 'ansari'
when I run the query
SELECT * FROM Myserver2...Material
I get the following error
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication
failed.
[OLE/DB provider returned message: Not a valid account name or password.]
any idea?
AnsariRemove the so-called "security" from the Access database. Anyone
capable of doing a google search can easily bypass Jet security,
accessing the mdb as an administrator with full priviledges. It's not
worth the trouble, and it can't be made to work reliably with linked
servers.
--Mary
On Thu, 24 Jun 2004 10:59:36 +0600, "M.M Ansari"
<mudasar_ansari@.hotmail.com> wrote:
>hi all,
>This is my second try to get the answer..
>I have created a linked server to a secure database with following query
>EXEC sp_addlinkedserver
> @.server = 'MYSERVER2',
> @.provider = 'Microsoft.Jet.OLEDB.4.0',
> @.srvproduct = 'ACCESS',
> @.datasrc = 'C:\COSTING2.mdb'
>GO
>sp_addlinkedsrvlogin myserver2, false,sa, Admin, 'ansari'
>when I run the query
> SELECT * FROM Myserver2...Material
>I get the following error
>OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication
>failed.
>[OLE/DB provider returned message: Not a valid account name or password.]
>
>any idea?
>Ansari
>
This is my second try to get the answer..
I have created a linked server to a secure database with following query
EXEC sp_addlinkedserver
@.server = 'MYSERVER2',
@.provider = 'Microsoft.Jet.OLEDB.4.0',
@.srvproduct = 'ACCESS',
@.datasrc = 'C:\COSTING2.mdb'
GO
sp_addlinkedsrvlogin myserver2, false,sa, Admin, 'ansari'
when I run the query
SELECT * FROM Myserver2...Material
I get the following error
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication
failed.
[OLE/DB provider returned message: Not a valid account name or password.]
any idea?
AnsariRemove the so-called "security" from the Access database. Anyone
capable of doing a google search can easily bypass Jet security,
accessing the mdb as an administrator with full priviledges. It's not
worth the trouble, and it can't be made to work reliably with linked
servers.
--Mary
On Thu, 24 Jun 2004 10:59:36 +0600, "M.M Ansari"
<mudasar_ansari@.hotmail.com> wrote:
>hi all,
>This is my second try to get the answer..
>I have created a linked server to a secure database with following query
>EXEC sp_addlinkedserver
> @.server = 'MYSERVER2',
> @.provider = 'Microsoft.Jet.OLEDB.4.0',
> @.srvproduct = 'ACCESS',
> @.datasrc = 'C:\COSTING2.mdb'
>GO
>sp_addlinkedsrvlogin myserver2, false,sa, Admin, 'ansari'
>when I run the query
> SELECT * FROM Myserver2...Material
>I get the following error
>OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication
>failed.
>[OLE/DB provider returned message: Not a valid account name or password.]
>
>any idea?
>Ansari
>
Subscribe to:
Posts (Atom)