Connecting to SQL Server 2000 Via Internet

Hi guys,

I would like to know how to connect SQL Server-2000 via Internet. I have software developed by VB it is working under Intranet but I need to have it's database connected Via internet remotely.

Thanks

Quote:

Originally Posted by riyazrasheed1234

Hi guys,

I would like to know how to connect SQL Server-2000 via Internet. I have software developed by VB it is working under Intranet but I need to have it's database connected Via internet remotely.

Thanks

This should be the same process as before. Are you having an issue? What errors are you getting?|||

Quote:

Originally Posted by Motoma

This should be the same process as before. Are you having an issue? What errors are you getting?

Still I did not tried. I just trying to find code for the Connection!sqlsql

connecting to sql server

Dear Sirs,
I am working on my first sql server web application. I have read many documents and I have gone to many forums, but i have'nt found any answer. Can you help me please.
Here is my problem:
I can't connect to my database. I use windows authentication and i log in as administrator. I have installed home edition of sql server and IIS is installed in my computer. I use this scripts:

<%
dim objCon
set objCon = server.CreateObject("ADODB.Connection")
objCon.ConnectionString="DSN=dbna.dsn;uid=sa;pwd=;database=na2"
objCon.open
%>

Where dbna.dsn have been defined in "Data Sources (ODBC)" part of control panel.
When I open the my webpage i receive this error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'ALADDIN\IUSR_ALADDIN'.
/dbconnect.asp, line 5

My computer name is ALADDIN and my username is Omid.
Best regards,
Omid.SQL thinks that you are trying to connect using windows authentication. Check the settings on your DSN entry.

As an aside, I would avoid using a DSN entry if you can. Instead, use MS OLE DB for SQL Server.

Check out this web site for some good examples: www.connectionstrings.com.

Regards,

hmscott|||Also, Carl Prothman's Connection String Site (http://www.carlprothman.net/Default.aspx?tabid=81) is pretty handy.|||Thanks alot for your helps but I can't connect to my database yet. I tried OLE DB too but I received the same error. I think something is wrong in my sql server. Can you tell me please what are the main steps for preparing a sql server database.
Regards,
Omid.|||Also, Carl Prothman's Connection String Site (http://www.carlprothman.net/Default.aspx?tabid=81) is pretty handy.
Thanks alot for your helps but I can't connect to my database yet. I tried OLE DB too but I received the same error. I think something is wrong in my sql server. Can you tell me please what are the main steps for preparing a sql server database.
Regards,
Omid.|||Change SQL authentication mode to MIXED if you are trying to log on with sa/pwd mode.|||Change SQL authentication mode to MIXED if you are trying to log on with sa/pwd.|||I don't want to log on with sa/pwd. I want to use windows authentication.

Connecting to SQL in ASP.net 20

I have a database that is currently connected and working properly in My SQL Server Management Studio. The problem I am havings is when I open My ASP.net 20 and Look in my Server Solutions I can not find the database to connect to it . It seems to be trying to use SLQ Express and not my SLQ Server Management Studio. How do I get my database to connect in my application? All I can see from within the Server solutions in ASP is the database .bak file which is the backup of the database. I thank you in advance.

Are you saying that, when you are trying to connect to the Server in the Server Explorer, that the server does not show up in the list?

Is the server 2000 or 2005 or.....?

|||Yes and no . I think I dono have my SQL Server Manager Studio (Dev ed) is not set as my primary and the SQL Express is . I think I need to configure my SQL Server Manager Studioas primary but am not sure how to do this. and help would be get.|||My question was concerning inside Visual Web Developer - the Server Explorer window|||Inside the designer in the server explorer the sever shows up ok but the database does not|||Inside the designer in the server explorer the sever shows up ok but the database does not

Connecting to SQL 2005 from other machines

The April CTP was working well but both the June and Sept CTP seem to be having problems with connections outside the local machine. It does not seem to matter how the connection is to be established (from code, from SQL managment studio etc) the same error comes up repeatedly.

Cannot connect to SEPTCTP.

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

Any suggestions besides rolling back to the April CTP (our current solution)?

Is the Named Pipes protocol enabled on server?
On server machine, run SQL Server configuration manager,
open SQL Server Network Configurations and enable Named Pipes.
Or switch client to use TCP/IP protocol rather than Named Pipes.

Thanks,
Michael.

P.S. This seems to be general SQL question, you might
get better response in SQL Server Database Engine group,
rather than in this SSIS-specific group.|||I'm not sure why, but we needed to access remote servers with their IP address AND a specific non-standard port once we upgraded to the newest CTP. This seemed fine for our test applications (we're not releasing anything until the final version is released).

Josh|||

This should be fine, provided that client is also configured

to use TCP/IP protocol and appropriate port. But the error

indicates the connection is using Named Pipes protocol.

It seems like the connection or SQL Client defaults is not

configured properly.

I'm not really a pro in SQL Client configuration, forum
SQL Server Database Engine might have people more
knowlegable in this area.

The answer may depend on whether you are using OLEDB or
ADO.NET connection managed, and in former case - SQL Native
OLEDB provider or Microsoft OLEDB provider for SQL Server.

Connecting to multiple SQLserver

Hello,

I am working on to design SSIS package which need to run scripts against multiple sqlserver and need help.

Basically I need to connect several SQLserver machine to get a data and insert to our central respository.

Any help or tip appreciated.

Thanks

--

Farhan

Farhan H Soomro wrote:

Hello,

I am working on to design SSIS package which need to run scripts against multiple sqlserver and need help.

Basically I need to connect several SQLserver machine to get a data and insert to our central respository.

Any help or tip appreciated.

Thanks

--

Farhan

Use multiple connection managers.

-Jamie

|||Is there any way I can read from text file salserver name and connect to particular server and run the scripts?|||

Farhan H Soomro wrote:

Is there any way I can read from text file salserver name and connect to particular server and run the scripts?

Yes. SSIS Configurations are provided to help you do exactly this.

Creating Package Configurations
(http://msdn2.microsoft.com/en-us/library/ms141132.aspx)

-Jamie

|||

If you have a list of servers that you want to run some SQL against, you can create two packages.

The simplest way to do this is create a SQL Server configuration table.
In the first package create a ForEach loop that processes each server in a resultset (I'd stick the list of servers in a SQL table so you can use it in reports).
In the ForEach loop
execute a SQL task to update the connection for the second package (the source server connection).
Then execute the second Package

In the Second package just create two connections, the source server to run the scripts against and the destination server to put the results in. Just use a data flow task to move the data.

|||

Thanks for the help. Just wondering how to setup SQL task to update the connection for the second package ?

TIA

--

Farhan

connecting to external DB

hi,
am working with my friend so we need to use the same DB ..how can i get him DB and insert it in mine to use it.
i 've try to copy it and paste in C:\Program Files\Microsoft SQL Server\MSSQL\Data then try to connect it by New connection bt it doesn't work
Note:am working n Web Matrix Project
Regards,You use the backup and restore wizard to backup the database and take the .bak file and put it in the Backup subfolder in the same Microsoft SQL Server folder and then go to Enterprise Manager and use the backup and restore wizard and use the restore from device option. BTW I think you can only delete from the Data subfolder and not add to it because that is where SQL Server stores the MDF and LDF data files. Post again if you need more help. Hope this helps.|||hello,
thank u very much for ur effort, but please can u explain how to Backup the Database with Extention .mdf .ldf
and there is no folder inside (Microsoft SQL Server) should i create it?
thanx for giving my Q ur valuable time,|||The database is not backed up with mdf and ldf files backup creates .bak file and it is found in this directory. You get mdf and ldf files when you execute a create database statement or you use Enterprise manager to create a database. The next step is you put the .bak file you created in the other computer in this directory and go to Enterprise manager and use the backup and restore wizard and choose the restore from device option. Run a search for backup and restore in the BOL (books online). Hope this helps.
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP

Connecting to Analysis Services

Hello,
I have analysis services running on a server in our internet datacentre
(servers are colocated at an ISP). It is working fine with no problems
whatsoever. I can also manage it fine when I terminal onto the box.
However, the problems start when I try to mange the server from my local
machine at work. There is a VPN setup between my work and the datacentre.
All the servers are on a different subnet at the datacenter.
This works fine for managing SQL server on the same machine with enterprise
manager. However, when I try to connect to analysis services using Analysis
Manager, I get the following error when trying to register:
Errors occurred while trying to connect to 10.2.1.2
Cannot open connection to Analsysis Server '10.2.1.2'
Error in data [Possible data corruption]"
Do you still want to register this server?
What in the world is going on? Maybe it has something to do with the fact
that Analsysis Server doesn't have 'SQL Authentication' and thus its a
security issue since my Windows cridentials aren't being passed/accepted
since those servers are all standalone?
Please help!
thanks in advance,
-ZD
hello.
i have the same problem and have no idea what happens.i have reinstalled analyis services, service pack 3, mdac 2.8 ... nothings happens. always the same error message. can't find anything in the web about this only on this board.
would be very happy if someone can help me about this problem
mario
"Z D" wrote:

> Hello,
> I have analysis services running on a server in our internet datacentre
> (servers are colocated at an ISP). It is working fine with no problems
> whatsoever. I can also manage it fine when I terminal onto the box.
> However, the problems start when I try to mange the server from my local
> machine at work. There is a VPN setup between my work and the datacentre.
> All the servers are on a different subnet at the datacenter.
> This works fine for managing SQL server on the same machine with enterprise
> manager. However, when I try to connect to analysis services using Analysis
> Manager, I get the following error when trying to register:
>
> Errors occurred while trying to connect to 10.2.1.2
> Cannot open connection to Analsysis Server '10.2.1.2'
> Error in data [Possible data corruption]"
> Do you still want to register this server?
>
> What in the world is going on? Maybe it has something to do with the fact
> that Analsysis Server doesn't have 'SQL Authentication' and thus its a
> security issue since my Windows cridentials aren't being passed/accepted
> since those servers are all standalone?
> Please help!
> thanks in advance,
> -ZD
>
>

Connecting to Analysis Services

Hello,
I have analysis services running on a server in our internet datacentre
(servers are colocated at an ISP). It is working fine with no problems
whatsoever. I can also manage it fine when I terminal onto the box.
However, the problems start when I try to mange the server from my local
machine at work. There is a VPN setup between my work and the datacentre.
All the servers are on a different subnet at the datacenter.
This works fine for managing SQL server on the same machine with enterprise
manager. However, when I try to connect to analysis services using Analysis
Manager, I get the following error when trying to register:
Errors occurred while trying to connect to 10.2.1.2
Cannot open connection to Analsysis Server '10.2.1.2'
Error in data [Possible data corruption]"
Do you still want to register this server?
What in the world is going on? Maybe it has something to do with the fact
that Analsysis Server doesn't have 'SQL Authentication' and thus its a
security issue since my Windows cridentials aren't being passed/accepted
since those servers are all standalone?
Please help!
thanks in advance,
-ZDhello.
i have the same problem and have no idea what happens.i have reinstalled analyis services, service pack 3, mdac 2.8 ... nothings happens. always the same error message. can't find anything in the web about this only on this board.
would be very happy if someone can help me about this problem
mario
"Z D" wrote:
> Hello,
> I have analysis services running on a server in our internet datacentre
> (servers are colocated at an ISP). It is working fine with no problems
> whatsoever. I can also manage it fine when I terminal onto the box.
> However, the problems start when I try to mange the server from my local
> machine at work. There is a VPN setup between my work and the datacentre.
> All the servers are on a different subnet at the datacenter.
> This works fine for managing SQL server on the same machine with enterprise
> manager. However, when I try to connect to analysis services using Analysis
> Manager, I get the following error when trying to register:
>
> Errors occurred while trying to connect to 10.2.1.2
> Cannot open connection to Analsysis Server '10.2.1.2'
> Error in data [Possible data corruption]"
> Do you still want to register this server?
>
> What in the world is going on? Maybe it has something to do with the fact
> that Analsysis Server doesn't have 'SQL Authentication' and thus its a
> security issue since my Windows cridentials aren't being passed/accepted
> since those servers are all standalone?
> Please help!
> thanks in advance,
> -ZD
>
>

Connecting to Analysis Services

Hello,
I have analysis services running on a server in our internet datacentre
(servers are colocated at an ISP). It is working fine with no problems
whatsoever. I can also manage it fine when I terminal onto the box.
However, the problems start when I try to mange the server from my local
machine at work. There is a VPN setup between my work and the datacentre.
All the servers are on a different subnet at the datacenter.
This works fine for managing SQL server on the same machine with enterprise
manager. However, when I try to connect to analysis services using Analysis
Manager, I get the following error when trying to register:
Errors occurred while trying to connect to 10.2.1.2
Cannot open connection to Analsysis Server '10.2.1.2'
Error in data [Possible data corruption]"
Do you still want to register this server?
What in the world is going on? Maybe it has something to do with the fact
that Analsysis Server doesn't have 'SQL Authentication' and thus its a
security issue since my Windows cridentials aren't being passed/accepted
since those servers are all standalone?
Please help!
thanks in advance,
-ZDhello.
i have the same problem and have no idea what happens.i have reinstalled ana
lyis services, service pack 3, mdac 2.8 ... nothings happens. always the sa
me error message. can't find anything in the web about this only on this boa
rd.
would be very happy if someone can help me about this problem
mario
"Z D" wrote:

> Hello,
> I have analysis services running on a server in our internet datacentre
> (servers are colocated at an ISP). It is working fine with no problems
> whatsoever. I can also manage it fine when I terminal onto the box.
> However, the problems start when I try to mange the server from my local
> machine at work. There is a VPN setup between my work and the datacentre.
> All the servers are on a different subnet at the datacenter.
> This works fine for managing SQL server on the same machine with enterpris
e
> manager. However, when I try to connect to analysis services using Analys
is
> Manager, I get the following error when trying to register:
>
> Errors occurred while trying to connect to 10.2.1.2
> Cannot open connection to Analsysis Server '10.2.1.2'
> Error in data [Possible data corruption]"
> Do you still want to register this server?
>
> What in the world is going on? Maybe it has something to do with the fact
> that Analsysis Server doesn't have 'SQL Authentication' and thus its a
> security issue since my Windows cridentials aren't being passed/accepted
> since those servers are all standalone?
> Please help!
> thanks in advance,
> -ZD
>
>

Connecting to an Oracle Databse Server using SQL Express

Hello everyone,

I am working on a project for a professor. The project entails

designing and creating a database.We

were given individual space on the schools database server and we were given

SSH secure shell to connect and manage our respective databases.I took it upon myself to try out SQL Server

Express.Using the management studio I

am trying to connect to my school database and can’t seem to figure it

out.Can someone please give a noob some

simple and quick instructions on how to achieve this?

Thank you,

Your Friendly Neighborhood Programmer,

This is the SSH product in case any one was interested, ftp://ftp.ssh.com/pub/ssh/SSHSecureShellClient-3.2.9.exe

The title of your post is a little confusing. SQL Server Express Management tools don't connect to Oracle directly, unless you use an OPENQUERY statement or create a linked server. You can read more about those topics in Books Online. For more basic information on connecting to a database, check here:

http://msdn2.microsoft.com/en-us/library/ms345332.aspx

Microsoft also puts out a complete training series for free on Express:

http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx

Buck Woody

Connecting to an Oracle Databse Server using SQL Express

Hello everyone,

I am working on a project for a professor. The project entails

designing and creating a database.We

were given individual space on the schools database server and we were given

SSH secure shell to connect and manage our respective databases.I took it upon myself to try out SQL Server

Express.Using the management studio I

am trying to connect to my school database and can’t seem to figure it

out.Can someone please give a noob some

simple and quick instructions on how to achieve this?

Thank you,

Your Friendly Neighborhood Programmer,

This is the SSH product in case any one was interested, ftp://ftp.ssh.com/pub/ssh/SSHSecureShellClient-3.2.9.exe

The title of your post is a little confusing. SQL Server Express Management tools don't connect to Oracle directly, unless you use an OPENQUERY statement or create a linked server. You can read more about those topics in Books Online. For more basic information on connecting to a database, check here:

http://msdn2.microsoft.com/en-us/library/ms345332.aspx

Microsoft also puts out a complete training series for free on Express:

http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx

Buck Woody

Connecting to a remote OLE DB

Hey, all. I've mainly worked with MySQL databases before. I'm working on an (old) ASP page that uses this connection string:

strConnect ="Provider=SQLOLEDB; Data Source=SQL1.MYDBSERVER.NET; Initial Catalog=...; User ID=...; Password=..."

It works fine on the production server, but the local copy fails if I try to access the Products page (which uses the database), with this error:

Microsoft OLE DB Providerfor SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/html/products.asp, line 19

Similarly, if I plug the connection info into Tools/Connect to Database in Visual Studio, I get:

Connection failed:
SQLState:'08001'SQL Server Error: 17[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.

Am I doing something wrong? Do I need more info from the hosting provider to connect remotely? Or is the database not accepting remote connections at all?

Thanks in advance for your help!

It might be that you do not have permission to access it or it might be that database is old (version 7.0) and that you cannot connect from Management studio. Check it with hosting provider.

Connecting SQL2005 from older C++ client - the solution was ...

After setting up
SQL2005express server with
mixed authentification I got the problem

1. I couldnt find a working ConnectionString
2. Studio2005 didnt connect to SQL any more

In the meantime I found that at least the following OLEDB-ConnectionString is working, when Im logged in as admin and can use Windows Autentication:

Provider='sqloledb'
Data Source='.' - without '/SQLEXPRESS' !!
Initial Catalog='MyDatabaseName'
Integrated Security='SSPI'

For details of SQL setup and code to test possible connetion strings
please see my homepage.
Martin
text of my question from 02 Dec 2005
I want to feed data of a C++ 6.0 project into SQL server and hoped that StudioExpress would give me the correct connection string in detail.
But my StudioExpress doesnt conntect to a SQL server configured for SQL-Authentication.
I made screenshote of the details an put them in subfolders of my homepage
http://home.arcor.SQL2005.
Does anybody know what exact connection string has to be used and which changes in StudioExpress AdvancedConnectionProperties are necessary to establish a working connection?

The above link contains a collection of screenshots with details of the problem.
In the meantime I did a standard setup of the whole StudioExpress2005 C# paket and put screenshots on my homepage where you can see the difference between standard setup and single SQLExpress setup in SQL-Authentication mode.
Martin

Connecting from a remote Enterprise Manager

I have installed MSDE2000A and it is working perfectly on the local machine,
but how do I connect from a remote Enterprise Manager? I keep on getting the
message that either sql does not exist or access denied. How do I fix this?
PLEASE HELP
Hi,
Using client network utility (cliconfg.exe) create a new Alias Specifying IP
Address and port number in machine which has Enterprise manager.
use this ALIAS name to register.
Thanks
Hari
SQL Server MVP
"cwsjnr" <cwsjnr@.discussions.microsoft.com> wrote in message
news:443CB7EF-4F5B-4309-9E85-96D6B7347D62@.microsoft.com...
>I have installed MSDE2000A and it is working perfectly on the local
>machine,
> but how do I connect from a remote Enterprise Manager? I keep on getting
> the
> message that either sql does not exist or access denied. How do I fix
> this?
> PLEASE HELP
|||cwsjnr wrote:
> I have installed MSDE2000A and it is working perfectly on the local machine,
> but how do I connect from a remote Enterprise Manager? I keep on getting the
> message that either sql does not exist or access denied. How do I fix this?
> PLEASE HELP
Use SVRNETCN.exe, and by default it's located in C:\Program
Files\Microsoft SQL Server\80\Tools\Binn. Set the network protocol (I
enable TCP/IP) that you require. Restart MSDE and you should be able to
connect.

Connecting a Cube from Excel 2007

Hi,

i am working with a XP-Client and try to connect to a WinServer2003, (SP2, AS2005) to access an AS2005-cube by Excel 2007. Creating a new connection, i can choose either connect via windows authentification or by entering a user/PW.

The first way (windows authentification) always works fine, but when i try to connect through an sql user, i run on an error at last. The connection works fine, i can select the desired cube but after the last "OK"-Button i get an error message like "Initialization of Data source failed".

the sql user should have admin right on the server.

Do i make sth. wrong?

SQL Server 2005 Analyisis Services Supports only Windows Authentication. (SQL Authentication is only possible if you connect to the SQL Server 2005 Database Engine)

So the username and password you want to enter must be a valid windows nt user with permission on the analysis services database. (check save password otherwise you get errors in excel)

HANNES

Connect to SQL Server through VPN

Hi
I've recently configured a VPN between 2 locations, using 3Com Internet Firewall 25.
It seems to be working fine, but i can't connect to a remote sql server. I've tried to do this from the managemente console, the query analyzer and a VB Application (ODBC) and i always get the same message: "The server does not exist or access denied". I'm trying to reach the server using its ip address, wich i can succesfully ping, and SQL authentication method.

If anyone has any idea, i will be really thankfull!You need to verify that port TCP 1433 and port UDP 1434 are open.

Also check for port TCP 135, that should be open if you need to make distributed queries|||Can you help us!!!!

connect to SQL Server Express remotly

Hi,

I'm planning to develop asoftware working over SQL Server Express Edition, And I was wondering how would different users connect to sql server xe remotly from their machines? and is there a limitation to the number of users who could connect at same time? Is there a client app to installed on their machines, or its just the main db on the server?

Note: all users should be connected using LAN

thanks in advance

hi,

SQLExpress grant you the ability to connect from remote clients as long as you enable network protocols..

remote clients will connect to the desired server as specified in the connection string, where you can pass the "SERVER=ServerInstanceName;" setting (see some connection string samples at http://www.connectionstrings.com/)..

there's no built in limit in the number of concurrent users but 32767, the overall limit of SQL Server... obviously this only is a theoretical limit, as each connection consumes resources on the server, and SQLExpress only allow you to address up to 1gb of ram and only 1 physical processor... depending on the actual database design, data load, access method, concurrency on data and the like, you'll get out of resources with very fewer users... it has been usualy sayd you can serve up to 25 concurrent users with MSDE, the predecessor of SQLExpress (which has a physical limitation, a "Governor Workload" that kicks in when 8 specified batches are running simultaneusly, slowing down all workloads)... SQLExpress does not present the same "scaling-down" technology, but this kind of magic number, based on detached database access (default with Ado.Net, but not with the older ADO data access model), with short queries and transactions can probably be still correct.. perhaps something more then this is eventually possible as well... anyway, remember to spare on resources :D

remote clients only need to install database connectivity binaries... MDAC if you use ADO/Ado.Net using the the OLE DB provider (which now is usually installed and upgraded by Windows Update as well), the SQL Native Client in current develop mode, as everyone is passing to this provider, which offers lots of new interesting features...

regards

|||

In Addition to the above post...

Have a look at the following article that will show you how to enable the remote connections to the Database Engine.