connect to server via intranet - how is it done (new to this)

Hi all!

I have msde2000 on one machine. want to connect to it from other machine. both machines are connected via a switch with integrated firewall.

Do I need to set up this firewall to enable connections? Like opening ports for msde in the virtual servers settings of the firewall?

If I do this, will that make my sql-server visible and accessible to the internet?

Or should I be able to find my sql server without such steps. And if so how?

networking is up and i can access folders of both machines via the intranet. Is that enough or do i need more settings here?

Let's say the machine and thus the server is called Alpha. What goes into my connectionstring from the other machine?

this wont be enough, right?
strconn = "Provider=SQLOLEDB;" & _
"Data Source="Alpha";"

Please shed some light on these questions.

tia

KumaFirst you will have to configure the ODBC settings in your machine. Make sure the datasource name is "alpha" , the same as the server name. You can then use "alpha" in the connection string. The code that is required is

'VB Code starts here

Set db = New ADODB.Connection

db.Properties("Data Source").Value = "alpha"
db.Properties("Initial Catalog").Value = "Northwind"
db.Properties("User ID").Value ="XXX"
db.Properties("Password").Value = "YYYYY"
db.Open

'ASP Code starts here
Set db = Server.CreateObject("ADODB.Connection")
db.Open "Provider=SQLOLEDB;Data Source=alpha;Initial Catalog=Northwind;User Id=XXX;Password=YYY"

'CODE ENDS HERE

Roshmi Choudhury

connect to MSSQL2005 via ODBC

Installed SQL2005, connect via (the new) SQL Nativ Client ODBC Vers. 2005.90.1399.00 works, just as (the old) SQL Server ODBC-Driver 2000.85.1117.00. Works fine.
But from an other machine -there is no client installed - using driver 2000.85.1117.00 I get the message "Server dosn't exist or access denied"
How I can connect ? It is due to the fact of .NET FRAMEWORK 2 ?
Thanks!Sounds like the 'other' machine is your first network client - check your enabled protocols with SQL Server Configuration Manager.

Also, check your connection details include the instance name if necessary.

Also, what are the OS levels and authentication method?|||Hi, Mulhall. Indeed, it's the first network client W2K, connections to other sql2000 servers are o.k., to SQL2005 tried using TCP/IP-Protocol, tried Named Pipes and all others. Using the standard instance, no named, using SQL-authentication such as win-authentication, tried connection by server-name and by IP-Adress. OS-Ping works normaly.|||Have you verified using the Surface Area Configuration tool that remote connections are enabled?

Thanks
Laurentiu|||Thanks Laurentiu, upon configuration Surface Area Conf.Tool the connection works. I did not know this feature

Connect to MSDE with Limited User (not using sql authentication)

I have an MSDE installation that I need to connect to within a C# .NET
project as a Limited User (from the same machine, not via the network)
The MSDE instance is not in sql authentication mode, only windows
authentication. Is this possible? I've used the
'Trusted_Connection=True;' in the connection string, but a login fails
for the user with an error like:
"Cannot open database in login 'testdatabase'. Login fails. Login
failed for wkstn\limiteduser"
Do I need to grant any (additional) rights to the database itself?
Thanks for your help,
Tom
You can=B4t mix up the keyword "USER ID" and Trusted_connection, if you
choose "User ID" (SQL Server auth.) SQL Server will use SQL Server
authentication regardless of the Trusted_connection settings, see more
details here:
http://msdn.microsoft.com/library/de...n-us/adminsql=
/ad_security_47u6.asp
But you can (as you are working with C#) create a impersonated context
and connect with this...
http://www.codeproject.com/csharp/cpimpersonation1.asp
..=2E.and connect with this.
HTH, jens Suessmeyer.

Connect to MSDE Instance via Internet.

I am trying to connect to a MSDE instance across the internet.
I installed it at my house and can connect from work no problem.
Installed it at a customers and I can not connect to it.
I can access their Linksys router and have the correct ports forwarded (I
tried setting the DMZ on, it made no difference) 1434 UPD and 3605 TCP
(although I have them set to BOTH at this time)
Netstat -an shows that both 3605 and 1434 are listening.
TELNET 72.XXX.XXX.50 3605
(I also tried TELNET 72.XXX.XXX.50\InstanceName 3605) didn't know if I
needed the instance name.
Does nothing. But if I telnet my computer at home it clears the screen like
it should.
I have turned off their windows firewall and disabled their McAfee firewall
but no change.
I also open port 79 (we do some communication before we open SQL Server) and
it communicates fine. So I think I have the router set up OK.
Does anyone have any ideas?
Thanks in advance,
Rob
PS. It was installed as follows:
setup SAPWD=XXXX DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL INSTANCENAME=RRRob,
Always difficult ones.
I found that TCP and UDP 1433-1434 open on both inbound and outbound solved
my problems. Also, I had problems if there were 2 NICS involved. Always
configure connections for the lowest IP in the range.
The other issues I've had with MSDE was that MSDE did not enable the TCp/IP
protocol by default. Use Enterprise manager, r-click the server, properties,
network config and check that tcp/ip and named pipes are enabled protocols.
Jamie.
"Rob" wrote:

> I am trying to connect to a MSDE instance across the internet.
> I installed it at my house and can connect from work no problem.
> Installed it at a customers and I can not connect to it.
> I can access their Linksys router and have the correct ports forwarded (I
> tried setting the DMZ on, it made no difference) 1434 UPD and 3605 TCP
> (although I have them set to BOTH at this time)
> Netstat -an shows that both 3605 and 1434 are listening.
> TELNET 72.XXX.XXX.50 3605
> (I also tried TELNET 72.XXX.XXX.50\InstanceName 3605) didn't know if I
> needed the instance name.
> Does nothing. But if I telnet my computer at home it clears the screen li
ke
> it should.
> I have turned off their windows firewall and disabled their McAfee firewal
l
> but no change.
> I also open port 79 (we do some communication before we open SQL Server) a
nd
> it communicates fine. So I think I have the router set up OK.
> Does anyone have any ideas?
> Thanks in advance,
> Rob
> PS. It was installed as follows:
> setup SAPWD=XXXX DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL INSTANCENAME=R
R
>
>

Connect to external DataBase Via SQLExpress?

Hi again... I guess this is yet another newbie question (Sorry if its been asked before!)

If I have an IP address for an external SQL DB with valid User & Pass... Can I connect to it using SQLExpress on my machine?

If so can anyone point me towards how to do it, or run through it below (In easy steps as I'm dumb )

Hi,

Yes, In the Server Name write your IP Address and Select Authenticaion Mode as SQL , supply your given credential and thats it!!! Once it let you in , right click on that IP Address in left corner and right click on it and select Register to Register the server.

Hemantgiri S. Goswami

|||

You can use Sql Server Management Studio (SSMS) to connect to other servers also. In Object Explorer window of SSMS, you have a Connect Combo in Top Left corner of Object Explorer window.

Steps are as follows

(a) Press on Connect

(b) Select Database Engine - You will get a "Connect To Server " window

(c) In this window Give IP Address in Server Name Text Box

(d) giver login name and passoward

(e) Press Connect Button

Madhu

|||Hi ... Many thanks for taking the time to reply, but I am getting this error message? Do I have to change any other settings?

TITLE: Connect to Server

Cannot connect to XX.XX.XX.XX

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: 53)

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

Can you get the DBA to run SQL Server Surfice Area Configuration tool to chech that Name Pipes is allowed.

Also, one thing worth check, have you confirmed the port on the IP address.
Finally please remember to check the firewall settings on the server as this could also be causing you problems.

hth

Barry Andrew

|||Thank you very much! All sorted and connected :o)... Thankssqlsql

connect to different SQL via SP

I have three locations: SQL1, SQL2 and SQL3. SQL1 is a Developers Edition on
my local workstation. SQL2 is out on the internet, remote from SQL3 which is
also out there on the internet. Currently, I have a DTS on SQL1 that copies
data from SQL3 over to SQL2. Problem: I would like to get this on a
schedule. I don't want to schedule it on my SQL1 machine and I'm not allowed
DTS packages on SQL2 and SQL3 because they are on shared plans. That leaves
me with scheduling SPs through the use of ASP pages.
Is it possible to transfer data between SQL2 and SQL3 in an SP?
thanks!shank
Have you looked at linked servers? For more details please refer to the BOL
"shank" <shank@.tampabay.rr.com> wrote in message
news:%230vAUpgIGHA.1124@.TK2MSFTNGP10.phx.gbl...
>I have three locations: SQL1, SQL2 and SQL3. SQL1 is a Developers Edition
>on my local workstation. SQL2 is out on the internet, remote from SQL3
>which is also out there on the internet. Currently, I have a DTS on SQL1
>that copies data from SQL3 over to SQL2. Problem: I would like to get this
>on a schedule. I don't want to schedule it on my SQL1 machine and I'm not
>allowed DTS packages on SQL2 and SQL3 because they are on shared plans.
>That leaves me with scheduling SPs through the use of ASP pages.
> Is it possible to transfer data between SQL2 and SQL3 in an SP?
> thanks!
>|||I have just been advised by our webhost that they do not allow Linked
Servers due to security issues.
Is there another way to connect through an SP?
In short, I need to automate transfer of data from SQL3 to SQL2 without
Linked Servers or DTS packages.
thanks!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uEltjujIGHA.3176@.TK2MSFTNGP12.phx.gbl...
> shank
> Have you looked at linked servers? For more details please refer to the
> BOL
> "shank" <shank@.tampabay.rr.com> wrote in message
> news:%230vAUpgIGHA.1124@.TK2MSFTNGP10.phx.gbl...
>

Connect to Analysis Manager via VB2005

Does anybody know how to use VB2005 or VB.NET to connect to analysis manager to extract the CUBE information?

Can I have a sample program? I'm very stuck.

Thanks in advance :)

Check out AMO for the cubes metadata
or ADOMD.net to query the cube

There are some examples on those pages, and there are more in the sql server samples.

C

connect to a sql via vpn

I need know how can i connect to a ms sql server via a vpn connection
thx and sorry for my bad english.
simarJust like you were connected to a regular network.|||but...don't work... :(

i use sql query analyzer and put this values:

SQL Server: 10.0.0.1
Login Name: pepe
Password: xxxx

Try connect and a dialog box appears with the follow text

--------
SQL Query Analyzer
--------
Unable to connect to server 10.0.0.1:

Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
--------
OK
--------

Notes:
The VPN connection assign to me a dynamic ip (ex: 10.0.0.4)

Please help me Thx!|||Can you ping the ip for the sql server ?|||Originally posted by rnealejr
Can you ping the ip for the sql server ?

C:\Documents and Settings\Administrator>ping 10.0.0.1

Pinging 10.0.0.1 with 32 bytes of data:

Request timed out.
Request timed out.
Request timed out.
Request timed out.

Ping statistics for 10.0.0.1:
Packets: Sent = 4, Received = 0, Lost = 4 (100% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Documents and Settings\Administrator>|||Talk to your network admin to find out why you are unable to ping this ip. Can you see other network devices when you are connected to the vpn ?|||Originally posted by rnealejr
Talk to your network admin to find out why you are unable to ping this ip. Can you see other network devices when you are connected to the vpn ?

I have w2000 server i make a new connection via "Connect to a private network throught the internet" i put my host, username and pass and i connect Good! . I see the icon in the tray to the connection.

But if i execute ipconfig i see...

PPP adapter NTZN:

Connection-specific DNS Suffix . :
IP Address. . . . . . . . . . . . : 10.0.0.4
Subnet Mask . . . . . . . . . . . : 255.255.255.255
Default Gateway . . . . . . . . . :

and if i try ping to the host... 10.0.0.1

C:\Documents and Settings\Administrator>ping 10.0.0.1

Pinging 10.0.0.1 with 32 bytes of data:

Request timed out.
Request timed out.
Request timed out.
Request timed out.

Ping statistics for 10.0.0.1:
Packets: Sent = 4, Received = 0, Lost = 4 (100% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

Note: In the connection Status i see a line with "Server IP address: 10.0.0.1"

Thx.|||Originally posted by rnealejr
...Can you see other network devices when you are connected to the vpn ?

How can i do this ?

thx.|||Sometimes you can't directly ping the pc. I also had this problem b4.
First you have to check and see if your Server (10.0.0.1) has port 1433 opened to the network.

Before you do this, make sure at your (10.0.0.1) server your SQL Server instance is using 1433 port from SQL-Server->Server Network Utility-> Enabled Protocols-> Click TCP/IP->Properties-> Make sure is 1433.

You can't directly connect from QA from your own PC by specifiying the IP only cause u can't ping it in the first place.

You need to make a Client Network connection first.

Alias->Add->set network libraries=TCP/IP->Server Alias=ServerABC
->ServerName=10.0.0.1->Uncheck Dynamically Determine Port->
Make sure it is 1433.

Go to QA and connect using the Server Alias Name =ServerABC.

Hope this help. But it could be different situation altogether.|||You can use telnet to connect to the appropriate sql port as a quick test.|||How can i do this ?
Either you can ping other area known devices or use network places or find/search computer/printers. Also, you have no default gateway ... What is the output from ipconfig /all ?sqlsql

Connect to a Novell NDS Datasoource via LDAP

Hi All,

Is there a connector in Connections Manager that can access a Novell NDS tree and help to pull data in an SSIS package?

Thanks,

BIG SYou might be able to use a script component (vb.net) as a source to get at your Novell tree.|||Can't. I run a component in CLR and it craps out.Would SSIS be any different?|||There is a Novell ODBC connector which allows you to do that. Check out Novell's website for "NDK:Novell

ODBC Driver for eDirectory".

You need to have rights to the NDS to get the information and you need to have the Novell CLIENT installed before you install the driver (which they don't tell you).|||Is that a connector that I can add to SSIS?|||

BIG S wrote:

Is that a connector that I can add to SSIS?

Once it's installed, you can use a datareader source against the ODBC driver.|||Would simply like to pull user object data back from eDirectory to MS SQL without having to implement the Novell Client, which I think is needed for the Novell ODBC driver. This can be done with a couple of lines of perl... Isn't there an easy way to make this connection and pull this data from within SQL Server? It's just an ldap query....sqlsql

Connect to a Novell NDS Datasoource via LDAP

Hi All,

Is there a connector in Connections Manager that can access a Novell NDS tree and help to pull data in an SSIS package?

Thanks,

BIG S
You might be able to use a script component (vb.net) as a source to get at your Novell tree.|||Can't. I run a component in CLR and it craps out.Would SSIS be any different?
|||There is a Novell ODBC connector which allows you to do that. Check out Novell's website for "NDK:Novell ODBC Driver for eDirectory".

You need to have rights to the NDS to get the information and you need to have the Novell CLIENT installed before you install the driver (which they don't tell you).

|||Is that a connector that I can add to SSIS?
|||

BIG S wrote:

Is that a connector that I can add to SSIS?

Once it's installed, you can use a datareader source against the ODBC driver.|||Would simply like to pull user object data back from eDirectory to MS SQL without having to implement the Novell Client, which I think is needed for the Novell ODBC driver. This can be done with a couple of lines of perl... Isn't there an easy way to make this connection and pull this data from within SQL Server? It's just an ldap query....

Connect SQL server from Remote PC via VB.Net

Hi Folks I have faced a problem during my application development... The application which is manipulating data in SQL sever 2005 which resides on server Named [Mserver1]... Now in the local netwrok there are 10 Client Pcs... My application will be running on all of them... What connection string will i use for that.. Client Pcs have not got SQL on them... I am using visual studio 2005, SQL server 2005.

Any help ??

Thanks in advancehttp://www.connectionstrings.com/?carrier=sqlserver2005

Connect Problems with Sql Server 05 Express

Hallo,
Maybe some hints are avialable.
System: Vista Business
SQL-Server: 2005 Express SP2
UserStatus: Admin
Connect via Management Studio 05
Error: 5120 bzw. 5123 - access declined.
Datenfile is local with full access
any ideas?
regards
akko
What does the connectstring look like? Is the instance running? Are you
accessing a local instance or one on the network?
____________________________________
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)
------
"akko" <info@.akko.at> wrote in message
news:B44FF7D8-BFA1-4556-965F-AB9E81DC7452@.microsoft.com...
> Hallo,
> Maybe some hints are avialable.
> System: Vista Business
> SQL-Server: 2005 Express SP2
> UserStatus: Admin
> Connect via Management Studio 05
> Error: 5120 bzw. 5123 - access declined.
> Datenfile is local with full access
> any ideas?
> regards akko
|||problem fixed, caused by sqlserver-service had not enaugh rights on folder.
"William (Bill) Vaughn" <billvaRemoveThis@.betav.com> schrieb im Newsbeitrag
news:uMHrs5EjHHA.392@.TK2MSFTNGP06.phx.gbl...
> What does the connectstring look like? Is the instance running? Are you
> accessing a local instance or one on the network?
> --
> ____________________________________
> 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)
> ------
> "akko" <info@.akko.at> wrote in message
> news:B44FF7D8-BFA1-4556-965F-AB9E81DC7452@.microsoft.com...
>

Connect Problems with Sql Server 05 Express

Hallo,
Maybe some hints are avialable.
System: Vista Business
SQL-Server: 2005 Express SP2
UserStatus: Admin
Connect via Management Studio 05
Error: 5120 bzw. 5123 - access declined.
Datenfile is local with full access
any ideas?
regards
akkoWhat does the connectstring look like? Is the instance running? Are you
accessing a local instance or one on the network?
____________________________________
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)
----
---
"akko" <info@.akko.at> wrote in message
news:B44FF7D8-BFA1-4556-965F-AB9E81DC7452@.microsoft.com...
> Hallo,
> Maybe some hints are avialable.
> System: Vista Business
> SQL-Server: 2005 Express SP2
> UserStatus: Admin
> Connect via Management Studio 05
> Error: 5120 bzw. 5123 - access declined.
> Datenfile is local with full access
> any ideas?
> regards akko|||problem fixed, caused by sqlserver-service had not enaugh rights on folder.
"William (Bill) Vaughn" <billvaRemoveThis@.betav.com> schrieb im Newsbeitrag
news:uMHrs5EjHHA.392@.TK2MSFTNGP06.phx.gbl...
> What does the connectstring look like? Is the instance running? Are you
> accessing a local instance or one on the network?
> --
> ____________________________________
> 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)
> ----
---
> "akko" <info@.akko.at> wrote in message
> news:B44FF7D8-BFA1-4556-965F-AB9E81DC7452@.microsoft.com...
>

Connect from VB6.0 via ODBCDirect to SQL Server

Hi All,
I have an existing application with frontend in VB 6.0 and backend in MS Access. I am trying to convert the application to SQL Server 2000 (standard) backend. At the moment the frontend uses ODBCDirect to communicate with MS Access backend. I upsized the MS Access database to SQL Server 2000 using MS Access upsizing wizard. (I know you need to use DTS, but I tried that and it did not copy the data across citing the error "The Server could not load DCOM", hence I used the upsizing wizard).
The backend now set up in SQL Server, I presume all I need to do is change the connection string in VB6.0, which I did, but I have not been able to make a successful connection yet. The following is the connection string I am using:

"ODBC;DSN=;Server=sql-server;Database=cabinetSQL;UID=dbo;PWD=;"

The SQL Server has been configured for windows authentication and the new database that I created due to upsizing, in the User section, it lists "dbo" as user name and login name is "domain/myloginname". So in the user ID I am using "dbo". I got some hints about how to connecte via ODBCDirect to SQL Server using the required workspace, as follows:

Set dbw = CreateWorkspace("pomsws", "admin", "", dbUseODBC)
Workspaces.Append dbw

Set pomsc = dbw.OpenConnection("pompom", dbDriverNoPrompt, _
true, con_string)

where con_string is the above mentioned connection string.

Can anybody let me know what I am doing wrong and provide any suggestions?

Thanks to all for your time and efforts.

Regards:
PrathmeshAn update on my question. I created a seperate small application just to test for the connectivity. The following is the code:

Dim strConnectionAdmin As String
Dim objConnAdmin As Connection
Dim CollegeRs As Recordset
Dim strsql As String
Dim i As Integer
Dim mdbodbcdirect As Database
Dim dbw As Workspace
Dim pomsc As Connection

strConnectionAdmin = "driver={SQL Server};Server=sql-server;Database=cabinetSQL;uid=;pwd=;"

Set dbw = CreateWorkspace("pomsws", "", "", dbUseODBC)
Workspaces.Append dbw

'On Error GoTo handler
Set pomsc = dbw.OpenConnection("pompom", dbDriverNoPrompt, _
False, strConnectionAdmin)

MsgBox "Connection success"

End Sub

This gives me an error "Invalid Argument" and points to the "Set pomsc" statement.

If I change the connection string to:
strConnectionAdmin = "ODBC;DSN=' ';driver={SQL Server};Server=sql-server;Database=cabinetSQL;uid=;pwd=;"

then it gives me an error for "ODBC-Call failed".

I am not sure where I am going wrong. Please help.

Regards:
Prathmesh

Connect from sql query via IP adress - is i possible?

Does anybody really know is it possible? We don't want to create a linked
database, but we need to make some steps on the remote database, gather some
data and then send this data to our main server via IP connection, setting
the connection every time when the remote server wants to transfer the data.
Is it possible at all if we don't create a linked database or whatever, just
from sql script? If yes, then how?
Dmitri.You can do ad-hoc/pass through query via openrowset or opendatasource.
http://msdn.microsoft.com/library/e..._oa-oz_78z8.asp
http://msdn.microsoft.com/library/e...asp?frame=true
"Just D." <no@.spam.please> wrote in message
news:FkSOc.18891$1o.215@.fed1read06...
> Does anybody really know is it possible? We don't want to create a linked
> database, but we need to make some steps on the remote database, gather so
me
> data and then send this data to our main server via IP connection, setting
> the connection every time when the remote server wants to transfer the dat
a.
> Is it possible at all if we don't create a linked database or whatever, ju
st
> from sql script? If yes, then how?
> Dmitri.
>|||Thanks for the answer.
"oj" <nospam_ojngo@.home.com> wrote in message
news:ui9sqkzdEHA.4048@.TK2MSFTNGP12.phx.gbl...
> You can do ad-hoc/pass through query via openrowset or opendatasource.
> http://msdn.microsoft.com/library/e..._oa-oz_78z8.asp
>
http://msdn.microsoft.com/library/e...asp?frame=true[vbcol=seagreen]
linked[vbcol=seagreen]
some[vbcol=seagreen]
setting[vbcol=seagreen]
data.[vbcol=seagreen]
just[vbcol=seagreen]
Another one idea - if I create ODBC and it's tested and works fine is it
possible to use that for the same purpose setting a remote database name via
ODBC? In other words, is it possible to use a database alias that works via
ODBC to set a connection from sql query without a linked database?
Maybe it's easier...
Dmitri.|||Thanks for the answer.
"oj" <nospam_ojngo@.home.com> wrote in message
news:ui9sqkzdEHA.4048@.TK2MSFTNGP12.phx.gbl...
> You can do ad-hoc/pass through query via openrowset or opendatasource.
> http://msdn.microsoft.com/library/e..._oa-oz_78z8.asp
>
http://msdn.microsoft.com/library/e...asp?frame=true[vbcol=seagreen]
linked[vbcol=seagreen]
some[vbcol=seagreen]
setting[vbcol=seagreen]
data.[vbcol=seagreen]
just[vbcol=seagreen]
Another one idea - if I create ODBC and it's tested and works fine is it
possible to use that for the same purpose setting a remote database name via
ODBC? In other words, is it possible to use a database alias that works via
ODBC to set a connection from sql query without a linked database?
Maybe it's easier...
Dmitri.|||Look at Appendix F of the Analysis Services Operations Guide
http://www.microsoft.com/technet/pr...n/anservog.mspx
It has a nice example of how you do this.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Just D." <no@.spam.please> wrote in message
news:xpTOc.19314$1o.15882@.fed1read06...
> Thanks for the answer.
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:ui9sqkzdEHA.4048@.TK2MSFTNGP12.phx.gbl...
>
http://msdn.microsoft.com/library/e...asp?frame=true
> linked
gather[vbcol=seagreen]
> some
> setting
> data.
whatever,[vbcol=seagreen]
> just
> Another one idea - if I create ODBC and it's tested and works fine is it
> possible to use that for the same purpose setting a remote database name
via
> ODBC? In other words, is it possible to use a database alias that works
via
> ODBC to set a connection from sql query without a linked database?
> Maybe it's easier...
> Dmitri.
>

Connect from sql query via IP adress - is i possible?

Does anybody really know is it possible? We don't want to create a linked
database, but we need to make some steps on the remote database, gather some
data and then send this data to our main server via IP connection, setting
the connection every time when the remote server wants to transfer the data.
Is it possible at all if we don't create a linked database or whatever, just
from sql script? If yes, then how?
Dmitri.
You can do ad-hoc/pass through query via openrowset or opendatasource.
http://msdn.microsoft.com/library/en...oa-oz_78z8.asp
http://msdn.microsoft.com/library/en...asp?frame=true
"Just D." <no@.spam.please> wrote in message
news:FkSOc.18891$1o.215@.fed1read06...
> Does anybody really know is it possible? We don't want to create a linked
> database, but we need to make some steps on the remote database, gather some
> data and then send this data to our main server via IP connection, setting
> the connection every time when the remote server wants to transfer the data.
> Is it possible at all if we don't create a linked database or whatever, just
> from sql script? If yes, then how?
> Dmitri.
>
|||Thanks for the answer.
"oj" <nospam_ojngo@.home.com> wrote in message
news:ui9sqkzdEHA.4048@.TK2MSFTNGP12.phx.gbl...
> You can do ad-hoc/pass through query via openrowset or opendatasource.
> http://msdn.microsoft.com/library/en...oa-oz_78z8.asp
>
http://msdn.microsoft.com/library/en...asp?frame=true[vbcol=seagreen]
linked[vbcol=seagreen]
some[vbcol=seagreen]
setting[vbcol=seagreen]
data.[vbcol=seagreen]
just[vbcol=seagreen]
Another one idea - if I create ODBC and it's tested and works fine is it
possible to use that for the same purpose setting a remote database name via
ODBC? In other words, is it possible to use a database alias that works via
ODBC to set a connection from sql query without a linked database?
Maybe it's easier...
Dmitri.
|||Thanks for the answer.
"oj" <nospam_ojngo@.home.com> wrote in message
news:ui9sqkzdEHA.4048@.TK2MSFTNGP12.phx.gbl...
> You can do ad-hoc/pass through query via openrowset or opendatasource.
> http://msdn.microsoft.com/library/en...oa-oz_78z8.asp
>
http://msdn.microsoft.com/library/en...asp?frame=true[vbcol=seagreen]
linked[vbcol=seagreen]
some[vbcol=seagreen]
setting[vbcol=seagreen]
data.[vbcol=seagreen]
just[vbcol=seagreen]
Another one idea - if I create ODBC and it's tested and works fine is it
possible to use that for the same purpose setting a remote database name via
ODBC? In other words, is it possible to use a database alias that works via
ODBC to set a connection from sql query without a linked database?
Maybe it's easier...
Dmitri.
|||Look at Appendix F of the Analysis Services Operations Guide
http://www.microsoft.com/technet/pro.../anservog.mspx
It has a nice example of how you do this.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Just D." <no@.spam.please> wrote in message
news:xpTOc.19314$1o.15882@.fed1read06...
> Thanks for the answer.
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:ui9sqkzdEHA.4048@.TK2MSFTNGP12.phx.gbl...
>
http://msdn.microsoft.com/library/en...asp?frame=true[vbcol=seagreen]
> linked
gather[vbcol=seagreen]
> some
> setting
> data.
whatever,
> just
> Another one idea - if I create ODBC and it's tested and works fine is it
> possible to use that for the same purpose setting a remote database name
via
> ODBC? In other words, is it possible to use a database alias that works
via
> ODBC to set a connection from sql query without a linked database?
> Maybe it's easier...
> Dmitri.
>

Connect from sql query via IP adress - is i possible?

Does anybody really know is it possible? We don't want to create a linked
database, but we need to make some steps on the remote database, gather some
data and then send this data to our main server via IP connection, setting
the connection every time when the remote server wants to transfer the data.
Is it possible at all if we don't create a linked database or whatever, just
from sql script? If yes, then how?
Dmitri.
You can do ad-hoc/pass through query via openrowset or opendatasource.
http://msdn.microsoft.com/library/en...oa-oz_78z8.asp
http://msdn.microsoft.com/library/en...asp?frame=true
"Just D." <no@.spam.please> wrote in message
news:FkSOc.18891$1o.215@.fed1read06...
> Does anybody really know is it possible? We don't want to create a linked
> database, but we need to make some steps on the remote database, gather some
> data and then send this data to our main server via IP connection, setting
> the connection every time when the remote server wants to transfer the data.
> Is it possible at all if we don't create a linked database or whatever, just
> from sql script? If yes, then how?
> Dmitri.
>
|||Thanks for the answer.
"oj" <nospam_ojngo@.home.com> wrote in message
news:ui9sqkzdEHA.4048@.TK2MSFTNGP12.phx.gbl...
> You can do ad-hoc/pass through query via openrowset or opendatasource.
> http://msdn.microsoft.com/library/en...oa-oz_78z8.asp
>
http://msdn.microsoft.com/library/en...asp?frame=true[vbcol=seagreen]
linked[vbcol=seagreen]
some[vbcol=seagreen]
setting[vbcol=seagreen]
data.[vbcol=seagreen]
just[vbcol=seagreen]
Another one idea - if I create ODBC and it's tested and works fine is it
possible to use that for the same purpose setting a remote database name via
ODBC? In other words, is it possible to use a database alias that works via
ODBC to set a connection from sql query without a linked database?
Maybe it's easier...
Dmitri.
|||Thanks for the answer.
"oj" <nospam_ojngo@.home.com> wrote in message
news:ui9sqkzdEHA.4048@.TK2MSFTNGP12.phx.gbl...
> You can do ad-hoc/pass through query via openrowset or opendatasource.
> http://msdn.microsoft.com/library/en...oa-oz_78z8.asp
>
http://msdn.microsoft.com/library/en...asp?frame=true[vbcol=seagreen]
linked[vbcol=seagreen]
some[vbcol=seagreen]
setting[vbcol=seagreen]
data.[vbcol=seagreen]
just[vbcol=seagreen]
Another one idea - if I create ODBC and it's tested and works fine is it
possible to use that for the same purpose setting a remote database name via
ODBC? In other words, is it possible to use a database alias that works via
ODBC to set a connection from sql query without a linked database?
Maybe it's easier...
Dmitri.
|||Look at Appendix F of the Analysis Services Operations Guide
http://www.microsoft.com/technet/pro.../anservog.mspx
It has a nice example of how you do this.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Just D." <no@.spam.please> wrote in message
news:xpTOc.19314$1o.15882@.fed1read06...
> Thanks for the answer.
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:ui9sqkzdEHA.4048@.TK2MSFTNGP12.phx.gbl...
>
http://msdn.microsoft.com/library/en...asp?frame=true[vbcol=seagreen]
> linked
gather[vbcol=seagreen]
> some
> setting
> data.
whatever,
> just
> Another one idea - if I create ODBC and it's tested and works fine is it
> possible to use that for the same purpose setting a remote database name
via
> ODBC? In other words, is it possible to use a database alias that works
via
> ODBC to set a connection from sql query without a linked database?
> Maybe it's easier...
> Dmitri.
>

Connect from sql query via IP adress - is i possible?

Does anybody really know is it possible? We don't want to create a linked
database, but we need to make some steps on the remote database, gather some
data and then send this data to our main server via IP connection, setting
the connection every time when the remote server wants to transfer the data.
Is it possible at all if we don't create a linked database or whatever, just
from sql script? If yes, then how?
Dmitri.
You can do ad-hoc/pass through query via openrowset or opendatasource.
http://msdn.microsoft.com/library/en...oa-oz_78z8.asp
http://msdn.microsoft.com/library/en...asp?frame=true
"Just D." <no@.spam.please> wrote in message
news:FkSOc.18891$1o.215@.fed1read06...
> Does anybody really know is it possible? We don't want to create a linked
> database, but we need to make some steps on the remote database, gather some
> data and then send this data to our main server via IP connection, setting
> the connection every time when the remote server wants to transfer the data.
> Is it possible at all if we don't create a linked database or whatever, just
> from sql script? If yes, then how?
> Dmitri.
>
|||Thanks for the answer.
"oj" <nospam_ojngo@.home.com> wrote in message
news:ui9sqkzdEHA.4048@.TK2MSFTNGP12.phx.gbl...
> You can do ad-hoc/pass through query via openrowset or opendatasource.
> http://msdn.microsoft.com/library/en...oa-oz_78z8.asp
>
http://msdn.microsoft.com/library/en...asp?frame=true[vbcol=seagreen]
linked[vbcol=seagreen]
some[vbcol=seagreen]
setting[vbcol=seagreen]
data.[vbcol=seagreen]
just[vbcol=seagreen]
Another one idea - if I create ODBC and it's tested and works fine is it
possible to use that for the same purpose setting a remote database name via
ODBC? In other words, is it possible to use a database alias that works via
ODBC to set a connection from sql query without a linked database?
Maybe it's easier...
Dmitri.
|||Thanks for the answer.
"oj" <nospam_ojngo@.home.com> wrote in message
news:ui9sqkzdEHA.4048@.TK2MSFTNGP12.phx.gbl...
> You can do ad-hoc/pass through query via openrowset or opendatasource.
> http://msdn.microsoft.com/library/en...oa-oz_78z8.asp
>
http://msdn.microsoft.com/library/en...asp?frame=true[vbcol=seagreen]
linked[vbcol=seagreen]
some[vbcol=seagreen]
setting[vbcol=seagreen]
data.[vbcol=seagreen]
just[vbcol=seagreen]
Another one idea - if I create ODBC and it's tested and works fine is it
possible to use that for the same purpose setting a remote database name via
ODBC? In other words, is it possible to use a database alias that works via
ODBC to set a connection from sql query without a linked database?
Maybe it's easier...
Dmitri.
|||Look at Appendix F of the Analysis Services Operations Guide
http://www.microsoft.com/technet/pro.../anservog.mspx
It has a nice example of how you do this.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Just D." <no@.spam.please> wrote in message
news:xpTOc.19314$1o.15882@.fed1read06...
> Thanks for the answer.
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:ui9sqkzdEHA.4048@.TK2MSFTNGP12.phx.gbl...
>
http://msdn.microsoft.com/library/en...asp?frame=true[vbcol=seagreen]
> linked
gather[vbcol=seagreen]
> some
> setting
> data.
whatever,
> just
> Another one idea - if I create ODBC and it's tested and works fine is it
> possible to use that for the same purpose setting a remote database name
via
> ODBC? In other words, is it possible to use a database alias that works
via
> ODBC to set a connection from sql query without a linked database?
> Maybe it's easier...
> Dmitri.
>

connect

Hello,
I'm having the strangest problem.
SQL 2000 on a Win 2003 server.
I'm trying to connect via the query analyzer to the sql server on
another box. It was working all fine yesterday. Actually, it didn't
work initially. But I restarted the service MSSQLSERVER and I was able
to connect.
I can ping the SQL server IP. I can even ping it by the computer name,
WINBOX. The SQLServer is named WINBOX too.
Any ideas?BTW I looked at this KB article http://support.microsoft.com/?id=328306
and none of that seems to be my situation.|||Interesting find today.
If I log in or map a drive on the win 2003k machine I'm fine.
But if I don't I get an connection error.
This is beyond the my access rights to the SQL server itself.
Won Lee wrote:
> Hello,
> I'm having the strangest problem.
> SQL 2000 on a Win 2003 server.
> I'm trying to connect via the query analyzer to the sql server on
> another box. It was working all fine yesterday. Actually, it didn't
> work initially. But I restarted the service MSSQLSERVER and I was able
> to connect.
> I can ping the SQL server IP. I can even ping it by the computer name,
> WINBOX. The SQLServer is named WINBOX too.
> Any ideas?
>

configuring sql 6.5

**** Post for FREE via your newsreader at post.usenet.com ****
Hi,
I can't see SQL 6.5 server installed on other computer. I am trying to
connect to it using SQL 2000, ODBC, ADO and none of this is helping. I
haven't experienced the same problems with SQL2000 installation. I have
installed it and all went ok. I do not change anyu network setting on this
computer and install SQL 6.5 and then i can't see this server. Maybe there
is some quick guide how to set SQL 6.5 as it seems to me that default
configuration do not work.
darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.usenet.com
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=Darius wrote:
> I can't see SQL 6.5 server installed on other computer. I am trying to
> connect to it using SQL 2000, ODBC, ADO and none of this is helping. I
> haven't experienced the same problems with SQL2000 installation. I
> have installed it and all went ok. I do not change anyu network
> setting on this computer and install SQL 6.5 and then i can't see
> this server. Maybe there is some quick guide how to set SQL 6.5 as it
> seems to me that default configuration do not work.
Tibor already answered the EM question in your previous thread (please do
not create new threads if it is not needed). 7.0 or 2000 EM cannot work
against 6.5 or earlier. You need EM 6.5 for that.
Please post the connection string for ODBC/ADO approach.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||**** Post for FREE via your newsreader at post.usenet.com ****
> Tibor already answered the EM question in your previous thread (please do
> not create new threads if it is not needed). 7.0 or 2000 EM cannot work
> against 6.5 or earlier. You need EM 6.5 for that.
I know. I have asked one more question in last thread but I didnt get any
answers, so I created new thred. I've asked what do you mean EM 6.5? do you
mean new SQL 6.5 installation or only enterprise manager 6.5?
darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.usenet.com
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||Darius wrote:
>> Tibor already answered the EM question in your previous thread
>> (please do not create new threads if it is not needed). 7.0 or 2000
>> EM cannot work against 6.5 or earlier. You need EM 6.5 for that.
> I know. I have asked one more question in last thread but I didnt get
> any answers, so I created new thred. I've asked what do you mean EM
> 6.5? do you mean new SQL 6.5 installation or only enterprise manager
> 6.5?
Tibor answered that:
If you want to administer a 6.5 machine from another machine, you only need
to do a client install on that machine.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||**** Post for FREE via your newsreader at post.usenet.com ****
Hello,
> If you want to administer a 6.5 machine from another machine, you only
need
> to do a client install on that machine.
I still have some problems and I will be very thankful for any help. I can't
see my SQL 6.5 servers from any computer. I'm stuck I don't know where the
problem is. Intergrated WinNT security setting is ok. Please help.
Darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.usenet.com
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||On Fri, 5 Mar 2004 08:54:34 +0100, "Darius" wrote:
>I still have some problems and I will be very thankful for any help. I can't
>see my SQL 6.5 servers from any computer. I'm stuck I don't know where the
>problem is. Intergrated WinNT security setting is ok. Please help.
G'day Darius,
How can't you see them? Or put another way, with what can't you see
them?
Can you ping the server that SQL 6.5 is on?
Can you connect to that server with SQL Query Analyser?
Can you create an ODBC DSN for this server and test it successfully?
cheers,
Ross.
--
"It's not the right time to be sober,
Now that the idiots have taken over" - NOFX|||In Integrated Security, a 6.5 server can only listen to Named Pipes. And on
MDAC 2.6 and later, a client that work against a pre-2000 server will only
connect using the top most protocol in Client Network Utility, which is IP
by default. On the client, using Client Network Utility: Either move IP to
the top or create an alias for the 6.5 server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Darius" <darius.ram@.takas.lt> wrote in message
news:404823e8@.post.usenet.com...
> **** Post for FREE via your newsreader at post.usenet.com ****
> Hello,
> > If you want to administer a 6.5 machine from another machine, you only
> need
> > to do a client install on that machine.
> I still have some problems and I will be very thankful for any help. I
can't
> see my SQL 6.5 servers from any computer. I'm stuck I don't know where the
> problem is. Intergrated WinNT security setting is ok. Please help.
> Darius
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=> *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.usenet.com
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=