pivot information: remote

Showing posts with label remote. Show all posts

Friday, March 30, 2012

please help me

i connect to remote Integration Service. i configure server for remote connection( on component services and DCOM config , ... ) .and now i can connect to Integration Service remotely and correctly.

but when i expand Stored Package and then click to expand MSDB this error will hapen:

please help me

thanks in advance

anyone answer to me

i need it soon

thanks

Wednesday, March 28, 2012

Hello everyone...
plzz help me,im getting this error whenever i want to connect my pc with another remote pc which i've designated as Server and my database is saved there so i want to connect my pc with tht remote pc and save data entered by my pc to that remote pc's database...
but i get this error....PLEASE HELP IMMEDIATELY...

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (.Net SqlClient Data Provider)

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

-
Error Number: -2
Severity: 11
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 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(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()

Can you connect to the remote server through Management Studio?|||

No my pc didnt get connected to the remote server.....i simply open my SQL server management studio and locally connect my application to the DB and it works fine but whenever i connect my pc with rmeote system with "Connect" option then it gives this error...plzzz anyone can resolve my problem then i'll b higly obliged..im totally stuck here as im very new to SQL server :(

|||What do you mean by "remote pc"? Are you trying to access the server on the same network or across the Internet? If across the Internet, you will need to open a hole in the firewall for SQL or use a VPN client.

Please Help Immediately...

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (.Net SqlClient Data Provider)

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

-
Error Number: -2
Severity: 11
State: 0

-
Program Location:

Can you connect to the remote server through Management Studio?|||

Please help i can't connect....

Hi
I'm loged on Workstation as a user EUR\zzzz1 and i use different user
EUR\abc123 to map a drive on remote server SERVER2, SERVER2 is a domain
controler . It works.
On SERVER2 i have SQL Server 2000 with mixed mode authentication.
I have a user abc123 added in Active directory on SERVER2:
SERVER2\abc123. The same user is added in Sql Server with rights etc.
When i lounch Query Analyzer on my Workstation and select Sql
Authentication to use EUR\abc123 user i got message "[Microsoft][ODBC
SQL Server Driver][SQL Server]Login failed for user 'EUR\abc123'"
Why i have no access to sql server ?
regards
m
Hi
You must not use SQL Authentication, as it is a domain account, you need to
select NT Authentication when connecting.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"marta" <grupy_d@.go2.pl> wrote in message
news:1127985222.430902.144700@.o13g2000cwo.googlegr oups.com...
> Hi
> I'm loged on Workstation as a user EUR\zzzz1 and i use different user
> EUR\abc123 to map a drive on remote server SERVER2, SERVER2 is a domain
> controler . It works.
> On SERVER2 i have SQL Server 2000 with mixed mode authentication.
> I have a user abc123 added in Active directory on SERVER2:
> SERVER2\abc123. The same user is added in Sql Server with rights etc.
> When i lounch Query Analyzer on my Workstation and select Sql
> Authentication to use EUR\abc123 user i got message "[Microsoft][ODBC
> SQL Server Driver][SQL Server]Login failed for user 'EUR\abc123'"
> Why i have no access to sql server ?
>
> regards
> m
>
|||Ok now i use windows NT Authentication and i can log in but this way
i'm connected to SERVER2 with user EUR\zzzz1 not abc123... I need to
connect using user abc123. How to do that ?
M.
|||Hi Marta
If EUR\abc123 has been added to the server as a login, you will need SQL
authentication to connect as that login. Are you sure you're using the
right password?
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"marta" <grupy_d@.go2.pl> wrote in message
news:1127989262.660929.186550@.o13g2000cwo.googlegr oups.com...
> Ok now i use windows NT Authentication and i can log in but this way
> i'm connected to SERVER2 with user EUR\zzzz1 not abc123... I need to
> connect using user abc123. How to do that ?
> M.
>
|||Of course i can map a drive using that pass.
The problem is : how to connect to sql server on remote server with
windows authentication, when i am logged on local workstation with
different user.
M
|||You could probably use "Run As" (right-click the shortcut/executable,
and choose "Run as..." from the menu) to run Query Analyzer under the
context of another user, and therefore be able to pass that security
ticket to the SQL Server when you use Windows Authentication. Runas.exe
can also be called from the command line w/ switches. I believe this
functionality is only available from the right-click menu on Windows
2003 and XP - 2000 contains the command line version.
Good luck,
Tony Sebion
"marta" <grupy_d@.go2.pl> wrote in message
news:1128002474.807122.247970@.g14g2000cwa.googlegr oups.com:

> Of course i can map a drive using that pass.
> The problem is : how to connect to sql server on remote server with
> windows authentication, when i am logged on local workstation with
> different user.
> M
|||you can always connect to the ipc share of remote user with the login/pw of
the user you want
NET USE \\REMOTEPUTER\IPC$ /USER:MYUSERNAME "MYPASSWORD"
now event hough your are logged on as user LOCALUSER...any connection to
remote puter will be as MYUSERNAME
get it ?
"marta" <grupy_d@.go2.pl> wrote in message
news:1128002474.807122.247970@.g14g2000cwa.googlegr oups.com...
> Of course i can map a drive using that pass.
> The problem is : how to connect to sql server on remote server with
> windows authentication, when i am logged on local workstation with
> different user.
> M
>
sql

Please help i can't connect....

Hi
I'm loged on Workstation as a user EUR\zzzz1 and i use different user
EUR\abc123 to map a drive on remote server SERVER2, SERVER2 is a domain
controler . It works.
On SERVER2 i have SQL Server 2000 with mixed mode authentication.
I have a user abc123 added in Active directory on SERVER2:
SERVER2\abc123. The same user is added in Sql Server with rights etc.
When i lounch Query Analyzer on my Workstation and select Sql
Authentication to use EUR\abc123 user i got message "[Microsoft][ODB
C
SQL Server Driver][SQL Server]Login failed for user 'EUR\abc123'"
Why i have no access to sql server ?
regards
mHi
You must not use SQL Authentication, as it is a domain account, you need to
select NT Authentication when connecting.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"marta" <grupy_d@.go2.pl> wrote in message
news:1127985222.430902.144700@.o13g2000cwo.googlegroups.com...
> Hi
> I'm loged on Workstation as a user EUR\zzzz1 and i use different user
> EUR\abc123 to map a drive on remote server SERVER2, SERVER2 is a domain
> controler . It works.
> On SERVER2 i have SQL Server 2000 with mixed mode authentication.
> I have a user abc123 added in Active directory on SERVER2:
> SERVER2\abc123. The same user is added in Sql Server with rights etc.
> When i lounch Query Analyzer on my Workstation and select Sql
> Authentication to use EUR\abc123 user i got message "[Microsoft][O
DBC
> SQL Server Driver][SQL Server]Login failed for user 'EUR\abc123'"
> Why i have no access to sql server ?
>
> regards
> m
>|||Ok now i use windows NT Authentication and i can log in but this way
i'm connected to SERVER2 with user EUR\zzzz1 not abc123... I need to
connect using user abc123. How to do that ?
M.|||Hi Marta
If EUR\abc123 has been added to the server as a login, you will need SQL
authentication to connect as that login. Are you sure you're using the
right password?
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"marta" <grupy_d@.go2.pl> wrote in message
news:1127989262.660929.186550@.o13g2000cwo.googlegroups.com...
> Ok now i use windows NT Authentication and i can log in but this way
> i'm connected to SERVER2 with user EUR\zzzz1 not abc123... I need to
> connect using user abc123. How to do that ?
> M.
>|||Of course i can map a drive using that pass.
The problem is : how to connect to sql server on remote server with
windows authentication, when i am logged on local workstation with
different user.
M|||You could probably use "Run As" (right-click the shortcut/executable,
and choose "Run as..." from the menu) to run Query Analyzer under the
context of another user, and therefore be able to pass that security
ticket to the SQL Server when you use Windows Authentication. Runas.exe
can also be called from the command line w/ switches. I believe this
functionality is only available from the right-click menu on Windows
2003 and XP - 2000 contains the command line version.
Good luck,
Tony Sebion
"marta" <grupy_d@.go2.pl> wrote in message
news:1128002474.807122.247970@.g14g2000cwa.googlegroups.com:

> Of course i can map a drive using that pass.
> The problem is : how to connect to sql server on remote server with
> windows authentication, when i am logged on local workstation with
> different user.
> M|||you can always connect to the ipc share of remote user with the login/pw of
the user you want
NET USE \\REMOTEPUTER\IPC$ /USER:MYUSERNAME "MYPASSWORD"
now event hough your are logged on as user LOCALUSER...any connection to
remote puter will be as MYUSERNAME
get it ?
"marta" <grupy_d@.go2.pl> wrote in message
news:1128002474.807122.247970@.g14g2000cwa.googlegroups.com...
> Of course i can map a drive using that pass.
> The problem is : how to connect to sql server on remote server with
> windows authentication, when i am logged on local workstation with
> different user.
> M
>

Monday, March 26, 2012

PLEASE HELP - Remote connection to SQL Server 2005 fall over after 100 seconds

Hi,
I am remotely accessing SQL Server 2005 using an import manager,
through a windows authentication login.
I start the loading, it connects perfectly at first but at the 100
second mark I get the error
"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server d
oes
not exist or access denied" it then reconnects and continues to load
but really slowly. So it looks like a timeout is occuring at 100
seconds
I have tried to change the connection timeout, the execution timeout
and the remote login timeout, nothing stops this happening.
The version of sql I am using is a SQL Server 2005 Evaluation edition.
Can anyone help?
Thanks
ArchanaIs there some reason you're using the ODBC driver to access SQL Server
instead of a native provider?
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
<archanapatelwhite@.googlemail.com> wrote in message
news:1174608028.525589.151310@.e65g2000hsc.googlegroups.com...
> Hi,
> I am remotely accessing SQL Server 2005 using an import manager,
> through a windows authentication login.
> I start the loading, it connects perfectly at first but at the 100
> second mark I get the error
> "[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server
does
> not exist or access denied" it then reconnects and continues to load
> but really slowly. So it looks like a timeout is occuring at 100
> seconds
> I have tried to change the connection timeout, the execution timeout
> and the remote login timeout, nothing stops this happening.
> The version of sql I am using is a SQL Server 2005 Evaluation edition.
> Can anyone help?
> Thanks
> Archana
>|||Hi Bill
The loading is going through a third party import manager, they must
be setting the ODBC driver to access SQL Server.
However when the company who wrote the import manager test it in their
environment replicating what I do they have no problems and it loads
fine
Thanks
Archana

Wednesday, March 21, 2012

PLASE HELP - remote connectivity to named instance of 2005

Hi all,
I just installed version 2005, and it is co-existing with
an instance of 2000. I am trying to test the remote connection string from
an ASP .Net page which works fine already in 2000. However it does not work
in 2005.
In 2005, I went to configuration Manager/Protocols/TCP IP, and entered 7544
as the default port, and for port value in IP1, IP2, and IP3. Then, in my
connection string I just included the port number, and changed the
databasename to point to 'AdventureWorks' instead of the DB that I used for
2K. The connection could not be openned. I also configured the user id, and
password the same way as I have in 2K, and re-started the engine.
This is a sample of my connection string:
this.sqlConnection1.ConnectionString =
"Server=xxx.xx.xx.xx\\<myNamedServerInstance>,7544;Database=AdventureWorks;U
ser
ID=myUID;Password=myPWD;Trusted_Connecti
on=True";
I tested the local connection to this server/Database, and it works fine,
however, there is a problem with the remote connection.
Any help will be appreciated.
Thanks in advance,
CarlosNever mind.. I got it Thanks.
"Carlos" <chsanin@.earthlink.net> wrote in message
news:uaKDKFB5FHA.2560@.TK2MSFTNGP12.phx.gbl...
> Hi all,
> I just installed version 2005, and it is co-existing with
> an instance of 2000. I am trying to test the remote connection string from
> an ASP .Net page which works fine already in 2000. However it does not
> work in 2005.
> In 2005, I went to configuration Manager/Protocols/TCP IP, and entered
> 7544 as the default port, and for port value in IP1, IP2, and IP3. Then,
> in my connection string I just included the port number, and changed the
> databasename to point to 'AdventureWorks' instead of the DB that I used
> for 2K. The connection could not be openned. I also configured the user
> id, and password the same way as I have in 2K, and re-started the engine.
> This is a sample of my connection string:
> this.sqlConnection1.ConnectionString =
> "Server=xxx.xx.xx.xx\\<myNamedServerInstance>,7544;Database=AdventureWorks
;User
> ID=myUID;Password=myPWD;Trusted_Connecti
on=True";
> I tested the local connection to this server/Database, and it works fine,
> however, there is a problem with the remote connection.
> Any help will be appreciated.
> Thanks in advance,
> Carlos
>

PLASE HELP - remote connectivity to named instance of 2005

Hi all,
I just installed version 2005, and it is co-existing with
an instance of 2000. I am trying to test the remote connection string from
an ASP .Net page which works fine already in 2000. However it does not work
in 2005.
In 2005, I went to configuration Manager/Protocols/TCP IP, and entered 7544
as the default port, and for port value in IP1, IP2, and IP3. Then, in my
connection string I just included the port number, and changed the
databasename to point to 'AdventureWorks' instead of the DB that I used for
2K. The connection could not be openned. I also configured the user id, and
password the same way as I have in 2K, and re-started the engine.
This is a sample of my connection string:
this.sqlConnection1.ConnectionString =
"Server=xxx.xx.xx.xx\\<myNamedServerInstance>,7544 ;Database=AdventureWorks;User
ID=myUID;Password=myPWD;Trusted_Connection=True";
I tested the local connection to this server/Database, and it works fine,
however, there is a problem with the remote connection.
Any help will be appreciated.
Thanks in advance,
Carlos
Never mind.. I got it Thanks.
"Carlos" <chsanin@.earthlink.net> wrote in message
news:uaKDKFB5FHA.2560@.TK2MSFTNGP12.phx.gbl...
> Hi all,
> I just installed version 2005, and it is co-existing with
> an instance of 2000. I am trying to test the remote connection string from
> an ASP .Net page which works fine already in 2000. However it does not
> work in 2005.
> In 2005, I went to configuration Manager/Protocols/TCP IP, and entered
> 7544 as the default port, and for port value in IP1, IP2, and IP3. Then,
> in my connection string I just included the port number, and changed the
> databasename to point to 'AdventureWorks' instead of the DB that I used
> for 2K. The connection could not be openned. I also configured the user
> id, and password the same way as I have in 2K, and re-started the engine.
> This is a sample of my connection string:
> this.sqlConnection1.ConnectionString =
> "Server=xxx.xx.xx.xx\\<myNamedServerInstance>,7544 ;Database=AdventureWorks;User
> ID=myUID;Password=myPWD;Trusted_Connection=True";
> I tested the local connection to this server/Database, and it works fine,
> however, there is a problem with the remote connection.
> Any help will be appreciated.
> Thanks in advance,
> Carlos
>

Tuesday, March 20, 2012

planning a replication

hallo
we have a sql2000 in the headquarter, and 3 new remote branches opening in few weeks with no sql servers installed yet.
We plan to setup a merge replica. The headquarter will have the highest activity on the replicated tables.
Shall we use all SQL2000 in the remote branches? Or could we use SQL2005, using a 2005 as a publisher and distributor?
TIA

If possible, upgrade all your nodes to SQL 2005. Merge replication performs and scales much better with the new pre-computed partitions. If this is not possible, then the only supported configuration is that the version of the distributor >= version of the publisher >= version of the subscriber. You can find more info about this in topic Using Multiple Versions of SQL Server in a Replication Topology".

|||ok thanks.
we're not going to upgrade the only sql2000 server we have, but i'd prefere to use sql2005 in the remote branches: in this scenario, i could set one of the 2005 as distributor and publisher.
This would be in contrast with the network topology, that centers everything in the main plant; BTW there will not be a big traffic of replicated data: a theoretical maximum of about 10 records/minute.

Friday, March 9, 2012

PL/SQL RPC call from Sql Server linked server (OraOLEDB)

I'ma having trouble calling a remote pl/sql proc from SQL server 2000 using
a
linked server provider=OraOLEDB.Oracle
Here's the call:
EXEC PS..TESTDTA.esp_F0101Z2_EDSP_set
'C',
'MCHAMBERS',
'23577',
'107399',
2000.0
This is the proc, straight forward...
CREATE PROCEDURE TESTDTA.esp_F0101Z2_EDSP_set (
flag in varchar2,
p_szedus in nchar,
p_szedbt in nchar,
p_szedtn nchar,
p_szedln number
)
AS
BEGIN
UPDATE TESTDTA.F0101Z2 SET
SZEDSP = flag
WHERE
szedus = p_szedus AND
szedbt = p_szedbt AND
szedtn = p_szedtn AND
szedln = p_szedln;
END;
Linked Server Properties:
Collation Compatible = true
Data Access = true
RPC = true
RPC Out = true
Use Remote Collation = true
Provider Properties:
AllowInProcess = 1
DisallowAdhocAccess = 0
DynamicParameters = 1
IndexAsAccessPath = 0
LevelZeroOnly = 0
NestedQueries = 0
NonTransactedUpdates = 0"Alien2_51" <dan.billow.remove@.monacocoach.removeme.com> wrote in message
news:A0EB9CA3-F18A-4777-8F5B-46CE8F1856B4@.microsoft.com...
> I'ma having trouble calling a remote pl/sql proc from SQL server 2000
> using a
> linked server provider=OraOLEDB.Oracle
> Here's the call:
> EXEC PS..TESTDTA.esp_F0101Z2_EDSP_set
> 'C',
> 'MCHAMBERS',
> '23577',
> '107399',
> 2000.0
>
> This is the proc, straight forward...
> CREATE PROCEDURE TESTDTA.esp_F0101Z2_EDSP_set (
> flag in varchar2,
> p_szedus in nchar,
> p_szedbt in nchar,
> p_szedtn nchar,
> p_szedln number
> )
> AS
> BEGIN
> UPDATE TESTDTA.F0101Z2 SET
> SZEDSP = flag
> WHERE
> szedus = p_szedus AND
> szedbt = p_szedbt AND
> szedtn = p_szedtn AND
> szedln = p_szedln;
> END;
>
In SQL 2000 you have to use OPENQUERY and jump through hoops:
http://groups.google.com/group/micr.../>
ce8a?hl=en&
SQL 2005 makes this much easier a couple of enhancements to the EXEC
statement, you can specify a linked server to run remotely, and you can pass
parameters in and out of a dynamic SQL query.
--Oracle SQL---
CREATE OR REPLACE PROCEDURE scott.esp_F0101Z2_EDSP_set (
flag in varchar2,
p_szedus in nchar,
p_szedbt in nchar,
p_szedtn nchar,
p_szedln number,
p_result out varchar2
)
AS
BEGIN
p_result := 'it worked';
END;
--end Oracle SQL---
EXEC sp_addlinkedserver @.server = 'ORACLE',
@.srvproduct='Oracle',
@.provider='OraOLEDB.Oracle',
@.datasrc='//localhost/xe'
EXEC sp_serveroption @.server='ORACLE', @.optname='rpc out', @.optvalue='true'
EXEC sp_addlinkedsrvlogin 'ORACLE', 'false', NULL, 'Scott', 'tiger'
GO
EXEC (
'
BEGIN
SCOTT.esp_F0101Z2_EDSP_set(
:p_flag,
:p_szedus,
:p_szedbt,
:p_szedtn,
:p_szedln,
:p_result);
END;
',
'C',
'MCHAMBERS',
'23577',
'107399',
2000.0,
@.result output
) at ORACLE
print @.result

Friday, March 30, 2012

please help me

Wednesday, March 28, 2012

Please Help Immediately...

Please Help Immediately...

Please help i can't connect....

Please help i can't connect....

Monday, March 26, 2012

PLEASE HELP - Remote connection to SQL Server 2005 fall over after 100 seconds

Wednesday, March 21, 2012

PLASE HELP - remote connectivity to named instance of 2005

PLASE HELP - remote connectivity to named instance of 2005

Tuesday, March 20, 2012

planning a replication

Friday, March 9, 2012

PL/SQL RPC call from Sql Server linked server (OraOLEDB)

pivot information

Blog Archive

About Me