Connecting to Network Server

Hi All,
I have 2 computers, one has SQL2000 and the other has MSDE2000. I have the
SQL tools installed on both computers.
When I use the enterprise manager and try to connect remote server I cannot
get the user to authenticate. It is trying to access the remote server
using the guest account.
There is no domain. Both computer have mixed mode authentication, and are
on the same 192.168.1.x network range.
What am I missing here.
Thanks
Lee
hi Lee,
"Lee Trotter" <latrotter@.@.@.sympatico.ca> ha scritto nel messaggio
news:%23lstCrAaEHA.3112@.tk2msftngp13.phx.gbl...
> Hi All,
> I have 2 computers, one has SQL2000 and the other has MSDE2000. I have
the
> SQL tools installed on both computers.
> When I use the enterprise manager and try to connect remote server I
cannot
> get the user to authenticate. It is trying to access the remote server
> using the guest account.
> There is no domain. Both computer have mixed mode authentication, and are
> on the same 192.168.1.x network range.
I did not undertand if you, from both machines, can not connect remotely or
you can not remotely connect just to the MSDE instance...
if this is the case, MSDE installs by default disabling network protocols,
in order to prevent external malicius attacks, so that only local connection
using Shared Memory are allowed..
you can modify this behaviour bot at install time, specifying the
DISABLENETWORKPROTOCOLS=0 parameter to the setup.exe boostrat MSDE
installer, and later, using Server Network Utility (svrnetcn.exe), enabling
the desired network protocol(s)..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Connecting to a sql server from VB.

I have a VB application that connects to our sql server on one of our local servers. This application needs to be installed on a few computers at a different location.

My question is how do I connect to the sql server on our local server from a remote computer not on our network.??

Thanks in advance.Errrr, you shouldn't. You need to rewrite the application so you have an "application server". :) Now, since I'm sure you aren't going to do that, you will need to open up the SQL Server port to the world and access the database by IP from the remote servers. Alternatively, you can set up an entry to access it as sql.domain.com for example from the outside world.

I hope the data isn't too sensitive. This is just begging someone to hack you.

Connecting from sql 2000 to sql 6.5

**** Post for FREE via your newsreader at post.usenet.com ****
Hello.
I have two computers: one runing on SQL 6.5, other runing on SQL 2000. I
want to connect to SQL 6.5 server from computer running on SQL 2000, but I
can't see server runing on SQL 6.5. My SQL 6.5 is with sp5. How can I solve
this problem?
The real problem is that I have database on SQL6.5 and I want to transfer it
to SQL2000.
Thank you.
Darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.usenet.com
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=Hi Darius.
I'm not sure why you can't "see" your 6.5 server from your 2000 server, how
are you "looking"? There could be anything from networking issues through
netlib or permission problems..
However, transfer is fraught with danger from 6.5 to 2000 as there are a
variety of things that just don't transfer easily. There is an upgrade
wizard for this purpose - have you looked at it? You should be able to find
it on your 2000 server - Start->Programs->Microsoft SQL Server-Switch->SQL
Server Upgrade Wizard. This is definitely the professional approach, unless
your transfer is dead simple, using only basic table structures etc..
Regards,
Greg Linwood
SQL Server MVP
"Darius" <darius.ram@.takas.lt> wrote in message
news:4046f21c@.post.usenet.com...
> **** Post for FREE via your newsreader at post.usenet.com ****
> Hello.
> I have two computers: one runing on SQL 6.5, other runing on SQL 2000. I
> want to connect to SQL 6.5 server from computer running on SQL 2000, but I
> can't see server runing on SQL 6.5. My SQL 6.5 is with sp5. How can I
solve
> this problem?
> The real problem is that I have database on SQL6.5 and I want to transfer
it
> to SQL2000.
> Thank you.
> 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:
> The real problem is that I have database on SQL6.5 and I want to
> transfer it to SQL2000.
> Thank you.
SQL Server 6.5 internal data structure is very different from that in SQL
7.0 and 2000, that is why you have to migrate it. You need to script your
SQL 6.5 database and DTS/BCP (I suggest BCP) the data from 6.5 to a newly
created 2000 database. You may also consider using SQL Server Upgrade
Wizard.
Check out the section "SQL Server 6.5 upgrade" index entry in the SQL Server
2000 Books Online.
See the following articles:
INF: Frequently Asked Questions - SQL Server 2000 - Upgrade
http://support.microsoft.com/default.aspx?scid=kb;en-us;q261334
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 ****
> I'm not sure why you can't "see" your 6.5 server from your 2000 server,
how
> are you "looking"? There could be anything from networking issues through
> netlib or permission problems..
I am trying to register SQL 6.5 server on SQL 2000 with enterprise manager,
but it can't see 6.5 server. If I install SQL 2000 on both computers then
problems dissapear. i don't know why?
Darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.usenet.com
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||7.0 or 2000 EM cannot work against 6.5 or earlier. You need EM 6.5 for that.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Darius" <darius.ram@.takas.lt> wrote in message
news:40470958@.post.usenet.com...
> **** Post for FREE via your newsreader at post.usenet.com ****
> > I'm not sure why you can't "see" your 6.5 server from your 2000 server,
> how
> > are you "looking"? There could be anything from networking issues
through
> > netlib or permission problems..
> I am trying to register SQL 6.5 server on SQL 2000 with enterprise
manager,
> but it can't see 6.5 server. If I install SQL 2000 on both computers then
> problems dissapear. i don't know why?
> Darius
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=> *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.usenet.com
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||**** Post for FREE via your newsreader at post.usenet.com ****
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OU6DiedAEHA.1468@.tk2msftngp13.phx.gbl...
> 7.0 or 2000 EM cannot work against 6.5 or earlier. You need EM 6.5 for
that.
You want to say all i need is 6.5 enterprise manager? or i need all sql 6.5
installation?
Darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.usenet.com
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||If you want to administer a 6.5 machine from another machine, you only need
to do a client install on that machine.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Darius" <darius.ram@.takas.lt> wrote in message
news:404714cd$1@.post.usenet.com...
> **** Post for FREE via your newsreader at post.usenet.com ****
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:OU6DiedAEHA.1468@.tk2msftngp13.phx.gbl...
> > 7.0 or 2000 EM cannot work against 6.5 or earlier. You need EM 6.5 for
> that.
> You want to say all i need is 6.5 enterprise manager? or i need all sql
6.5
> installation?
> 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 Thu, 4 Mar 2004 11:09:45 +0100, "Darius" wrote:
>I have two computers: one runing on SQL 6.5, other runing on SQL 2000. I
>want to connect to SQL 6.5 server from computer running on SQL 2000, but I
>can't see server runing on SQL 6.5. My SQL 6.5 is with sp5. How can I solve
>this problem?
G'day Darius,
From reading the rest of the thread, you are trying to look at your 6.5
server from 2000 Enterprise Manager - which doesn't work.
Note, however, that you can use 2000's Query Analyser to connect to your
6.5 server, thus you can query, examine tables and stored procs and
views etc., and execute any admin tasks you need to via SQL.
>The real problem is that I have database on SQL6.5 and I want to transfer it
>to SQL2000.
You will find that DTS in SQL Server 2000 can help you do this. The
Enterprise Manager tools for managing databases aren't compatible with
SQL Server 6.5, but DTS is, and the wizards will allow you to copy
across the tables and data.
However, you should probably take a step back and examine the 6.5
database(s) first, to see whether you want to just copy them over, or
whether you might be better adjusting the design for 2000 better. As
Sebastian says, check out the "SQL Server 6.5 upgrade" topic in BOL.
For starters, you can use Query Analyser to examine your 6.5
database(s). Then you can work up a plan of how you will rebuild in
2000. If all you will be doing is replicating it without modification,
then you'd be best off using SQL Server 6.5 Enterprise Manager to script
out the tables, views and stored procedures, then running these scripts
on SQL Server 2000 to build the database.
regards,
Ross.
--
"There is more to life than simply increasing its speed." - Mahatma Gandhi

Connecting from sql 2000 to sql 6.5

**** Post for FREE via your newsreader at post.mcse.ms ****
Hello.
I have two computers: one runing on SQL 6.5, other runing on SQL 2000. I
want to connect to SQL 6.5 server from computer running on SQL 2000, but I
can't see server runing on SQL 6.5. My SQL 6.5 is with sp5. How can I solve
this problem?
The real problem is that I have database on SQL6.5 and I want to transfer it
to SQL2000.
Thank you.
Darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=Hi Darius.
I'm not sure why you can't "see" your 6.5 server from your 2000 server, how
are you "looking"? There could be anything from networking issues through
netlib or permission problems..
However, transfer is fraught with danger from 6.5 to 2000 as there are a
variety of things that just don't transfer easily. There is an upgrade
wizard for this purpose - have you looked at it? You should be able to find
it on your 2000 server - Start->Programs->Microsoft SQL Server-Switch->SQL
Server Upgrade Wizard. This is definitely the professional approach, unless
your transfer is dead simple, using only basic table structures etc..
Regards,
Greg Linwood
SQL Server MVP
"Darius" <darius.ram@.takas.lt> wrote in message
news:4046f21c@.post.mcse.ms...
> **** Post for FREE via your newsreader at post.mcse.ms ****
> Hello.
> I have two computers: one runing on SQL 6.5, other runing on SQL 2000. I
> want to connect to SQL 6.5 server from computer running on SQL 2000, but I
> can't see server runing on SQL 6.5. My SQL 6.5 is with sp5. How can I
solve
> this problem?
> The real problem is that I have database on SQL6.5 and I want to transfer
it
> to SQL2000.
> Thank you.
> Darius
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> *** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.mcse.ms
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||Darius wrote:

> The real problem is that I have database on SQL6.5 and I want to
> transfer it to SQL2000.
> Thank you.
SQL Server 6.5 internal data structure is very different from that in SQL
7.0 and 2000, that is why you have to migrate it. You need to script your
SQL 6.5 database and DTS/BCP (I suggest BCP) the data from 6.5 to a newly
created 2000 database. You may also consider using SQL Server Upgrade
Wizard.
Check out the section "SQL Server 6.5 upgrade" index entry in the SQL Server
2000 Books Online.
See the following articles:
INF: Frequently Asked Questions - SQL Server 2000 - Upgrade
http://support.microsoft.com/defaul...b;en-us;q261334
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.mcse.ms ****

> I'm not sure why you can't "see" your 6.5 server from your 2000 server,
how
> are you "looking"? There could be anything from networking issues through
> netlib or permission problems..
I am trying to register SQL 6.5 server on SQL 2000 with enterprise manager,
but it can't see 6.5 server. If I install SQL 2000 on both computers then
problems dissapear. i don't know why?
Darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||7.0 or 2000 EM cannot work against 6.5 or earlier. You need EM 6.5 for that.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Darius" <darius.ram@.takas.lt> wrote in message
news:40470958@.post.mcse.ms...
> **** Post for FREE via your newsreader at post.mcse.ms ****
>
> how
through
> I am trying to register SQL 6.5 server on SQL 2000 with enterprise
manager,
> but it can't see 6.5 server. If I install SQL 2000 on both computers then
> problems dissapear. i don't know why?
> Darius
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> *** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.mcse.ms
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||**** Post for FREE via your newsreader at post.mcse.ms ****
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OU6DiedAEHA.1468@.tk2msftngp13.phx.gbl...
> 7.0 or 2000 EM cannot work against 6.5 or earlier. You need EM 6.5 for
that.
You want to say all i need is 6.5 enterprise manager? or i need all sql 6.5
installation?
Darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||If you want to administer a 6.5 machine from another machine, you only need
to do a client install on that machine.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Darius" <darius.ram@.takas.lt> wrote in message
news:404714cd$1@.post.mcse.ms...
> **** Post for FREE via your newsreader at post.mcse.ms ****
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:OU6DiedAEHA.1468@.tk2msftngp13.phx.gbl...
> that.
> You want to say all i need is 6.5 enterprise manager? or i need all sql
6.5
> installation?
> Darius
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> *** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.mcse.ms
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||On Thu, 4 Mar 2004 11:09:45 +0100, "Darius" wrote:

>I have two computers: one runing on SQL 6.5, other runing on SQL 2000. I
>want to connect to SQL 6.5 server from computer running on SQL 2000, but I
>can't see server runing on SQL 6.5. My SQL 6.5 is with sp5. How can I solve
>this problem?
G'day Darius,
From reading the rest of the thread, you are trying to look at your 6.5
server from 2000 Enterprise Manager - which doesn't work.
Note, however, that you can use 2000's Query Analyser to connect to your
6.5 server, thus you can query, examine tables and stored procs and
views etc., and execute any admin tasks you need to via SQL.

>The real problem is that I have database on SQL6.5 and I want to transfer i
t
>to SQL2000.
You will find that DTS in SQL Server 2000 can help you do this. The
Enterprise Manager tools for managing databases aren't compatible with
SQL Server 6.5, but DTS is, and the wizards will allow you to copy
across the tables and data.
However, you should probably take a step back and examine the 6.5
database(s) first, to see whether you want to just copy them over, or
whether you might be better adjusting the design for 2000 better. As
Sebastian says, check out the "SQL Server 6.5 upgrade" topic in BOL.
For starters, you can use Query Analyser to examine your 6.5
database(s). Then you can work up a plan of how you will rebuild in
2000. If all you will be doing is replicating it without modification,
then you'd be best off using SQL Server 6.5 Enterprise Manager to script
out the tables, views and stored procedures, then running these scripts
on SQL Server 2000 to build the database.
regards,
Ross.
--
"There is more to life than simply increasing its speed." - Mahatma Gandhi

Connect to SQL Server over the internet

Hi,
Computer A is where is installed SQL server 2000 and the BE. Computer B, I
have the FE (ADP in access 2003). The both computers are connected the
internet.
So, how can I connect to SQL Server over the internet? I mean, I want
connect my FE Computer B) to BE (computer A).
I listen something, we can do this connection trough IP address, but I don't
have idea how can I do.
Any Ideas?
Thanks,
Jos Perdigoif you truly have got your server completely exposed over the internet,
I wouldn't bother connecting to them, everyone else will be doing that
for you.
you can put an ip address in a connection string just as you can a
server name, so if you're currently connecting saying
server=MyExposedServer;database=db1 you can instead connect with
server=1.1.1.1 etc. where 1.1.1.1 is your server ip.
I doubt you have exposed your SQL server like this as it's not a good
idea, so you'll have to consider configuring firewalls, creating VPN
connections, etc.
Cheers
Will|||And if I protected my database with login and password? Is it security?
Thanks
jos perdigao
"Will" <william_pegg@.yahoo.co.uk> wrote in message
news:1145373393.799617.84180@.z34g2000cwc.googlegroups.com...
> if you truly have got your server completely exposed over the internet,
> I wouldn't bother connecting to them, everyone else will be doing that
> for you.
> you can put an ip address in a connection string just as you can a
> server name, so if you're currently connecting saying
> server=MyExposedServer;database=db1 you can instead connect with
> server=1.1.1.1 etc. where 1.1.1.1 is your server ip.
> I doubt you have exposed your SQL server like this as it's not a good
> idea, so you'll have to consider configuring firewalls, creating VPN
> connections, etc.
> Cheers
> Will
>|||It's a bit like saying, if I put a lock on my door, is my house safe?
Yes to a casual intruder, but there are different levels of security.
Why do you need to connect to your SQL server over the internet? As I
see it you're writing a client based application, so you will have some
kind of an installation process, at which point you could set up a vpn
connection to your SQL server. This means that you could put you SQL
server behind a firewall and configure a much more secure setup.
I'm nothing more than familiar with server security, but the idea of
just exposing a sql server to the internet without anything more than a
password on the database strikes me as being a very bad idea.
I would suggest posting a question on this to the sqlserver.security
group. As for the programming side, all I can say is that you can
replace your server name with an I.P. address and your client
connection should work just as though you're on a LAN.
Cheers
Will

connect to sql server from other computer

hi

i have 2 computers named pc1 , pc2 .

i have lan connect between this computers.

in pc1 i have server named center , in this server data base named library.

how i can connect to this database from pc2 .

note: i am working with visual basic 2005 .

please help me ,

Do you get any exception ? You just have to setup a sqlconnection via .NET and connect to the server, the simplest statement would be in C# something like:

new SqlConnection("Data Source=YourServerName;Initial catalog=library").Open()

The conenction string uses integrated authentication, I don′t know if that applies to you.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

are you programming a windows application

or ASp.net?

|||thanks alot .|||i am using windows application|||

Are these two servers in the same domain? If not, you'd better first configure the authentication mode of the SQL Server to Mixed Authentication and change the password of the sa account, which by default is blank.

After this, you can specify a connection string for the SqlConnection class in VB.NET, specifying the machine name of the sql and username and password. After this, you should be able to connect to the remote server. It is not much different from connecting to a local sql.

|||

thanks for reply .

best regards